• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 After Import - Clean-up

#1
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.
 

Brogan

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