MyBB Community Forums

Full Version: Delete all users in Banned group with 0 post counts?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
They're 99% spambots from before we had anti-spambots protection and I'd like to delete them but I have thousands of them.

SQL query I assume? If so, which? Thanks!

Also do I need to rebuild after that?
AdminCP>Users & Groups>Find Users
Is member of one or more of these user groups: Banned
Post count is: Exactly: 0

Click 'Find users' at the bottom.

Click the select all box at the top, go to the bottom and click the dropdown and click 'Delete users', and click 'Go'.
Select all only selects the 20 ones on the page currently.
Increase the number per page to about 50 or so. 50 at once is better than one at once.
Is there no SQL query that would do it for me? I literally have thousands.
Back up your database just in case.

DELETE FROM mybb_users WHERE usergroup = 7 AND postnum = 0
That is gonna maybe delete "real" members who have not yet posted. I think you need to include the usergroup as well.
(2014-04-03, 06:48 AM)Leefish Wrote: [ -> ]That is gonna maybe delete "real" members who have not yet posted. I think you need to include the usergroup as well.

Woops, that might be a good idea, updated post. Toungue
You can specify a date criteria in your SQL query to delete old False users.