How to delete ALL users with 0 message ?

[Saiy]

Hi guys!

Is there a way or a SQL command to delete (or at least ban) ALL users with 0 message, please? I'm not talking about "inactive users". Just users with 0 message.

I explain why: Between 2015 and 2019, a lot of account have been created. They were completly inactive until recently, and (surprise!) they appear to be russian bots posting X spams. It's like trojans, hiding since 5 years in the house... So I'm pretty sure that if I delete ALL users with 0 message, the problem will be solved.

[CRM 114]

Is there a way or a SQL command to delete (or at least ban) ALL users with 0 message, please?

This is not recommended. Better delete them in the Administration Center.

[Saiy]

I can not manually delete +1000 account.
There exists a function to massively delete all inactive members (forum maintenance > members > delete inactive members)... So there's certainly a way to do the same to delete users with 0 message. 

[Bugo]

https://custom.simplemachines.org/index.php?mod=2569

[Saiy]

It worked perfectly !

In the meantime, I also found another solution for those who don't want to install a plugin :

- The native "delete inactive user" function (in admin panel) allows you delete inactive member per member group (that's very important).
- So I created a member group "0 message users" with 0 messages.
- Then I created a member group "+1 message users" with minimum 1 messages.
- And finally, I just had to delete ALL inactive users from the group "0 message users" ! It worked like a charm.

Thanks a lot !

[Arantor]

Did you make that a post count group? More importantly: do you still have a post count group for 0-or-more posts?

[Saiy]

I just created a group named "Human" with 0 message required, and another group named "Saiyan" (it's a Dragon Ball forum) with 1 message :

Group Name   | Number of message required
Human        | 0   
Saiyan       | 1
Super Saiyan | 200

And then I purged all the users from the group "Human".

[Arantor]

As long as you haven't deleted the group Human in the process, that's cool.

The system will get very upset if you have users whose post count doesn't fit any of the post count groups.