• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 Ban Every Member With 0 Posts

Brent W

Well-known member
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?

Mike Edge

Formerly Da Bookie Mon
What about

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

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


Well-known member
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.