Module development and code questions

I've searched the forums for several hours with no luck - so here goes:

Is there a way to make the most wonderful taxonomy_context menu block persistent or always visible?

Currently the menu is only visible when a node with taxonomy is actually being viewed. It disappears when you go to any navigation menu item. The menu even disappears when you are editing the node in question!

Thanks,

Theo

I believe I have support for PostgreSQL in the CVS version of Amazon Associate Tools...but I don't have PostgreSQL set up anywhere, so I'm hoping someone will help shake it out (Arto?).

http://drupal.org/files/projects/amazontools-cvs.tar.gz

Hello, I'm studying profile.module and I have these lines of code:

I am working on a module that needs to delete an extended node after 30 days. I have the cron job set up fine and I am correctly calling the hook_cron. I have debug messages going into watchdog letting me know that I am getting the proper nids of nodes that are old from an sql statement. Now I am just wondering the best way to actually delete these nodes. I looked at node_delete and it seemed to be the cleanest way to delete the node and all accompanying data.

Currently I am calling:

I need to create a listing of users by role.

The query to do this is simple:

SELECT users.*
FROM (users INNER JOIN users_roles ON users.uid = users_roles.uid) INNER JOIN role ON users_roles.rid = role.rid
WHERE role.name = 'authenticated user'

or

SELECT users.*
FROM (users INNER JOIN users_roles ON users.uid = users_roles.uid) INNER JOIN role ON users_roles.rid = role.rid
WHERE role.rid = 2

Hi, I'm wondering if someone can answer a quick question: I've created a new module and if I manually navigate to its settings in the admin area (for example, localhost/admin/settings/mymodule), I get the settings form fine. But in the admin menu, under modules/settings, my module's name isn't being listed. I thought that having the mymodule_settings() function would be enough for the admin to find it and display it, but apparently not? What else is needed for it to be shown in the menu?

Thanks very much...