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

XF 1.2 Hide date of birth - Update all users

Discussion in 'XenForo Questions and Support' started by Skylined, Jan 12, 2014.

  1. Skylined

    Skylined Active Member

    I'm importing from SMF, where most users have set their date of birth.

    Those dates have been imported to xF, but now they're public.

    Is there any way to update registered user's Date of Birth Privacy so their day, month and year of birth is hidden?
  2. Amaury

    Amaury Well-Known Member

  3. Skylined

    Skylined Active Member

    I saw that thread before posting mine.

    I just want to change the setting for all users, so their date isn't public, but they can change this setting afterwards.
    I don't want to hide the field.

    Maybe my first post wasn't clear. :)
  4. Liam W

    Liam W Well-Known Member

    You can use a query, this will change all users to not show year of birth (most people are fine with showing day and month):

    UPDATE `xf_user_option` SET `show_dob_year`='0';
    adwade and Skylined like this.
  5. Skylined

    Skylined Active Member

    Thanks. :)

    I would also like to do that with day and month.
    Will this do it?

    UPDATE `xf_user_option` SET `show_dob_date`='0';
    adwade likes this.
  6. Liam W

    Liam W Well-Known Member

    Yup :)
    adwade likes this.
  7. Skylined

    Skylined Active Member

    Great, thanks! :)

Share This Page