This module is for sites that allow users to create an account, but require administrator approval for account activation. This module creates a block that shows a list of unactivated user accounts, with links to their account pages. This block is visible for anyone with 'administer users' permission, and will not be shown to any other users.
Drupal 7 version
After enabling the module, go to Structure -> blocks (Drupal 6: Administer -> Site building -> blocks) and place the block in the region of your choice. The block is not enabled by default.
There isn't actually anything in the database (that I know of) that specifically says a user has registered but not had their account approved. Their account status is just set to 'blocked' when they register, and the administrator has to set it to active. As such, in creating this module, I determined that a user is awaiting administrator approval when the following conditions are met in the 'users' table:
- The user's status is zero (blocked)
- The account creation date is greater than zero
- Login is zero (never logged in)
What this means is that there is a 'bug', in that if a user's account is activated, and then blocked again before they have logged in, they will show up on the list as awaiting activation. This could probably be worked around by creating a new table in the database whereby any users who have their account activated are added to this table, and when rendering the block, a check is run against this new table to see if the above circumstance has occurred. However, this would add an extra query to the database each time the block is rendered, for a situation that I don't see occurring with enough frequency to make it worth adding the performance drag it would cause.
Drupal 6 Note