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

XF 1.2 Query TO Clear About Me For Users With Less Than x Posts

Discussion in 'XenForo Questions and Support' started by Brent W, Aug 11, 2013.

  1. Brent W

    Brent W Well-Known Member

    Cleaning up a spammed forum and want to clear the About Me field for everyone with less than say 30 posts.
  2. Brent W

    Brent W Well-Known Member

    Would be nice to ban these users at the same time as well.
  3. Brent W

    Brent W Well-Known Member

    Bump. I'll take just a query that clears the About field for users with less than 1 post.
  4. Mike

    Mike XenForo Developer Staff Member

    UPDATE xf_user_profile AS p
    INNER JOIN xf_user AS u ON (u.user_id = p.user_id)
    SET p.about = ''
    WHERE u.message_count < 1;
    ProCom, Brent W, Chris D and 2 others like this.

Share This Page