XF 1.1 Ban Every Member With 0 Posts

[Brent W]

I have a forum that was run over with spam before I bought it. I'd like to ban all members that have 0 posts. Can I run a query for this?

 

[Digital Doctor]

Maybe with the new improvements.
http://xenforo.com/community/threads/user-management-improvements.46217/

 

[Mike Edge]

What about

update `xf_user` set `is_banned`=1 where `message_count`=0; or

DELETE FROM `xf_user` where `message_count`=0;

 

[borbole]

If you do that you will ban legit users too. Personally I think it would be better if you added an extra conditional to check for users registered for a certain amount of time as well in the equation.

 

[RobParker]

DELETE FROM `xf_user` where `message_count`=0;

Will that not leave a load of orphaned posts and a big mess?