HELP! How can I mass delete users who have...

[brookelyn]

HELP! How can I mass delete users who have never verified their registration - i have like.. oh 2,000 or more that never validated their registration and I'd like to delete them but how?

thanks,
brooke

[Kier]

grab a copy of phpMyAdmin, then open the 'usergroup' table and make a note of the usergroupid for Users Awaiting Email Confirmation, then use the query text box to run the following query:

DELETE FROM user WHERE usergroupid=x

where x is the usergroupid you noted (by default, it's 3)

you will probably want to back-up your user table before you run this though, just in case...