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

Mass-change user privacy settings

Discussion in 'XenForo Questions and Support' started by fist34, Apr 22, 2013.

  1. fist34

    fist34 Member

    I've imported a previous vBulletin form into XenForo. All is well but I'd like to change everyone's setting for birth day visibility so that it's hidden. They can turn it back on themselves if they want. I did not see a way to do this.

  2. Jeremy

    Jeremy Well-Known Member

    Run the following query:
    UPDATE xf_user_option SET show_dob_year = 0;
    UPDATE xf_user_option SET show_dob_date = 0;
    I didn't run these, but I know that is the correct table / field. If you get an error, try wrapping 0 in single quotes (0 => '0')
    fist34 likes this.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Also don't forget to set the options for new registrations in the ACP.
    Jeremy likes this.
  4. fist34

    fist34 Member

    That did the trick, thanks.

    Yuep, did that before I imported.

  5. Jeremy

    Jeremy Well-Known Member

    Any time. Glad it worked for you.

Share This Page