XF 1.3 After Import - Clean-up

I just did an import to xenForo and need to universally set a couple of options for users. Can someone please tell me if there's a way to do the following (either through the admin panel or by running a MySQL query):

- Hide the birth year/age of all existing members

- Set the default subscription notification (for all existing members) to email

- Set all existing topic subscriptions to email

I appreciate any info or assistance you can offer.


XenForo moderator
Staff member
UPDATE xf_user_option SET show_dob_year = 0;
UPDATE xf_user_option SET default_watch_state = 'watch_email'
The last one can't be done with a simple query.