MyBB Community Forums

My site forum was inundated with a bunch of unwelcomed users. Luckily they are awaiting activation. There are about 3 thousand of these unwanted users and to remove it 20 at a time is very tedious. I am little savvy with MySQL. Not knowing the complete data structure how can I remove ALL users awaiting activation using PHPMyadmin and a SQL script that can do this. Can you help provide the script? Thanks.

Run this query through PHPMyAdmin :

DELETE FROM mybb_users WHERE usergroup = 5

Note: 5 is the default group ID of Awaiting Activation

(2013-05-20, 01:58 PM)effone Wrote: [ -> ]Run this query through PHPMyAdmin :

DELETE FROM mybb_users WHERE usergroup = 5

Note: 5 is the default group ID of Awaiting Activation

Great! The script works flawlessly. Thanks.