XF 1.2 Hide date of birth - Update all users

[Skylined]

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?

 

[Amaury]

http://xenforo.com/community/threads/hide-date-of-birth-from-profile.64255/

Although I think you should inform your members of this so those that don't mind their birth date being shown to the public can set their preferences accordingly.

 

[Skylined]

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.

 

[Liam W]

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.

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

 

[Skylined]

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

 

[Liam W]

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

Yup

 

[Skylined]

Great, thanks!