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

XF 2.0 Turnoff Subscribed Email by Default for Registered Users

#1
Is there a way to batch update all registered users to disable the "and receive email notification" option for the Automatically watch content preferences?

I've updated the default so that new user registrations still get content added to watch list but no emails by default but there are still hundreds of users that I would like to batch update to uncheck the receive email notifications option from.

Also, is there a way to remove current email subscriptions from threads? If not, disabaling new ones will work itself out over time.

Thanks
 

Chris D

XenForo developer
Staff member
#2
These two queries should do it.

SQL:
UPDATE xf_user_option
SET
    creation_watch_state = 'watch_no_email',
    interaction_watch_state = 'watch_no_email'
SQL:
UPDATE xf_thread_watch
SET
    email_subscribe = '0'