• 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

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.


Chris D

XenForo developer
Staff member
These two queries should do it.

UPDATE xf_user_option
    creation_watch_state = 'watch_no_email',
    interaction_watch_state = 'watch_no_email'
UPDATE xf_thread_watch
    email_subscribe = '0'