make existing users display age by default

[michelle86]

I want all my users to have their age displayed on the forum. So I've gone ahead and already removed "hide age and date of birth" as a privacy option by editing the modifyprofile_birthday template.

New users have to select 1 of the 3 remaining options that will display their age at registration. Great!

But now, all the previously registered users who had selected "hide age and DOB" at registration still have their ages hidden. How do I unhide all their ages and change their privacy setting to "display only age" (without editing each individual profile)? Is there any way to do this?

--------------- Added [DATE]1374088727[/DATE] at [TIME]1374088727[/TIME] ---------------

Nevermind, figured it out!

Go to Maintenance > Execute SQL Query

UPDATE user SET showbirthday=1

Everyone's age is now displayed on the forum.