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

Discussion in 'XenForo Questions and Support' started by Brent W, Mar 18, 2013.

  1. Brent W

    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?
  2. Digital Doctor

    Digital Doctor Well-Known Member

  3. Da Bookie Mon

    Da Bookie Mon Well-Known Member

    What about

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

    DELETE FROM `xf_user` where `message_count`=0;
  4. borbole

    borbole 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.
  5. RobParker

    RobParker Well-Known Member

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

Share This Page