XF 1.3 After Import - Clean-up

[PrettyPixels]

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.

 

[Paul B]

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.

 

[PrettyPixels]

Thanks, Brogan!