XF 1.5 Turnoff Subscribed Email by Default for Registered Users

[Amin Sabet]

From this XF 2.0 thread: https://xenforo.com/community/threa...email-by-default-for-registered-users.137214/

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

These two queries should do it.

UPDATE xf_user_option
SET
    creation_watch_state = 'watch_no_email',
    interaction_watch_state = 'watch_no_email'

UPDATE xf_thread_watch
SET
    email_subscribe = '0'

Will those queries also work for XenForo 1.5?

 

[Ozzy47]

Back up your database then try it.

 

[Amin Sabet]

@Chris D - can you please advise if those same queries should work for XenForo 1.5?

 

[Mouth]

Will those queries also work for XenForo 1.5?

UPDATE xf_user_option
SET default_watch_state = 'watch_no_email';

UPDATE xf_thread_watch
SET email_subscribe = '0';

 

[Amin Sabet]

Thanks, @Mouth

 

[Amin Sabet]

UPDATE xf_user_option
SET default_watch_state = 'watch_no_email';

UPDATE xf_thread_watch
SET email_subscribe = '0';

Thanks, Mouth. Would you happen to know the queries to disable these for all existing users?

• Receive news and update emails
• Receive email when a new conversation message is received

 

[Mouth]

Would you happen to know the queries to disable these for all existing users?

UPDATE xf_user_option
SET receive_admin_email = 0, email_on_conversation = 0;

 

[Amin Sabet]

Thank you so much