Mass-change user privacy settings

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.

Thanks.
 

Jeremy

Well-known member
Run the following query:
Code:
UPDATE xf_user_option SET show_dob_year = 0;
Code:
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

Member
Run the following query:
Code:
UPDATE xf_user_option SET show_dob_year = 0;
Code:
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')
That did the trick, thanks.

Also don't forget to set the options for new registrations in the ACP.
Yuep, did that before I imported.

Thanks!
 
Top