Mass-change user privacy settings

[fist34]

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]

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')

 

[Paul B]

Also don't forget to set the options for new registrations in the ACP.

 

[fist34]

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')

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!

 

[Jeremy]

Any time. Glad it worked for you.