[bira]

Essam with so many, I would actually recommend you delete them, because there are bound to be a lot of duplicate people who tried several times, or people who tried a long time ago and forgot about it.

If, however, you want to send them a password anyway and don't mind about "dead" registrations, then you could just do the following two steps IN THAT ORDER:

1) email password to all the users in the "Users Awaiting Email
Confirmation"

2) AFTER sending the e-mail, run a MySQL query via phpMyAdmin:

UPDATE user SET usergroupid='2' WHERE usergroupid='3' AND posts='0'

Personally, I would recommend you delete all those accounts who are, say, one month old. If you want to do this, then run the following command BEFORE you do steps 1 and 2 mentioned above:

DELETE FROM user WHERE usergroupid='3' AND posts='0' AND joindate<'986500000'