Delete all users in Banned group with 0 post counts?

[Monkeys]

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?

[Boonie]

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'.

[Monkeys]

Select all only selects the 20 ones on the page currently.

[Leefish]

Increase the number per page to about 50 or so. 50 at once is better than one at once.

[Monkeys]

Is there no SQL query that would do it for me? I literally have thousands.

[Boonie]

Back up your database just in case.

DELETE FROM mybb_users WHERE usergroup = 7 AND postnum = 0

[Leefish]

That is gonna maybe delete "real" members who have not yet posted. I think you need to include the usergroup as well.

[Boonie]

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.

[Cedric]

This user has been denied support.

You can specify a date criteria in your SQL query to delete old False users.