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

XF 1.4 Batch update privacy

Discussion in 'Installation, Upgrade, and Import Support' started by Mr Lucky, Dec 8, 2014.

  1. Mr Lucky

    Mr Lucky Well-Known Member

    After importing from phpbb, I find that all users have their profile set to show full date of birth (presumably this was a default setting I should have changed before importing)

    Is there an easy way to change these profile settings for all users privacy retrospectively?

    ie so that in the existing profiles of all users:

    Show day and month of birth
    Show year of birth

    become unticked

  2. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_user_option SET show_dob_year = 0;
    UPDATE xf_user_option SET show_dob_date = 0;
    Take a backup first.
    maszd and Mr Lucky like this.
  3. Mr Lucky

    Mr Lucky Well-Known Member

  4. adwade

    adwade Active Member

    However, I also tripped across this post saying...
    and wondered, are the 'single quotes' required or not?

    On a sidenote, if these two fields are un-checked in the User Registration default values when a data import is performed from vB, will ALL imported users have them unchecked as a result?
    Last edited: Nov 26, 2015

Share This Page