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 BamaStangGuy, Aug 11, 2013.

  1. BamaStangGuy

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

    BamaStangGuy Well-Known Member

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

    BamaStangGuy 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

    Code:
    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, BamaStangGuy, Chris D and 2 others like this.

Share This Page