Module development and code questions

Using d_4.5,

I have come up with google_api.module mostly derived from the original version of geoff peters
http://www.googleduel.com/apiexample.php

but i have used NuSoap library.

i have tried to post the code here but i was always getting ''Suspicious input data''. But i can send you the attachment if you can get in touch with me through the contact form.
You may then post the same here.

I am currently trying to get taxonomy_context, site_map, taxonomy_menu, and site_menu to provide meaningful and user friendly navigation of a hierarchal government website. So far my efforts have been thwarted. I am using Drupal 4.6.

Ultimately, I would like to navigate my site using a menu based on taxonomy: click on a vocabulary, you arrive at a list of terms for that vocabulary-- click on a term, you arrive at a list of node titles for that term-- click on the title and you arrive at the node itself.

I've created a film review module by playing around with the bookreview.module developed by Jeremy Andrews. This is my first module and I'm not sure how to go about releasing it.

You can see it working at:

http://www.cloudsoup.com/films/goodbye_lenin

If anyone would like a copy, or help release it officially, drop me a message.

Just noticed after upgrading to 4.6.0 that many links are not working anymore. This was because I used the title module input format filter. However, a similiar module seems available now called freelinking.

*URL FORMAT*
Title module:
site.com/title/red+apple
Freelinking module:
site.com/freelinking/red+apple

*USAGE*
Title module:
[title|url], one-bracket use
Freelinking module:
[[title]], ability to use text to describe link is gone

I'm having this error when creating new images

warning: opendir(/tmp//mc-alex): failed to open dir: Permission denied in /var/www/drupal/modules/image/image.module on line 1202.
warning: Cannot modify header information - headers already sent by (output started at /var/www/drupal/includes/common.inc:344) in /var/www/drupal/includes/common.inc on line 155.

The tmp folders are set up right, or at least they seem to be, because the images get uploaded correct.

Has anybody the same problem. I'm Using Drupal 4.5.

I suck at SQL and especially at INNER JOIN, so maybe someone can que me on how to accomplish the following:

*** find all the users in database matching profile query *** :
q=profile/first_name/first_value/second_name/second_value

Current code inside profile_browse does the following (only for the first_name)
$query = "v.value = '". db_escape_string('first_name') ."'";