[How To?] delete all my users

[laurenltd]

Hi,

I have been heavily attacked on my forum, ive managed to delete all the spam posts.

Is there any way i can delete all the users that have joint? Im doing it normally where you delete 20 at a time but its taking to long?

Help me!

Thanks

[effone]

Run this query through PHPMyAdmin :

DELETE FROM mybb_users WHERE uid NOT IN ( 1 )

or

DELETE FROM mybb_users WHERE uid <>  1

This will delete all the users leaving only you.
Change the table prefix if it is different.