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 BamaStangGuy, Mar 18, 2013.

  1. BamaStangGuy

    BamaStangGuy 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. The Forum Heroes

    The Forum Heroes 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