I let my forum be overrun by spam but now want to resurrect it. I want to delete all users, except a handful. How can I select all users at one time in the admin panel? When I click select all it only selects the users for that page and I have over 400 pages of users to delete, but I want to check them all first and then uncheck the few I want to keep?
You could run this sql query:
DELETE FROM mybb_users where postnum = '0' and lastvisit < '1293861600';
This will delete all users that have a post number of 0 and have not been active since Jan 1st 2011. Use this tool to create a timestamp, depending on how far back you want to delete users from:
http://www.scriptalicious.com/tools/convert-datetime/
Also, If your using a different prefix in your database. Change the prefix in the query from "
mybb_users" to your own prefix