XF 2.0 Turnoff Subscribed Email by Default for Registered Users

[Kangy]

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]

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'

 

[Kangy]

awesome, that seems to of done the trick.

 

[Mr Lucky]

there are still hundreds of users that I would like to batch update to uncheck the receive email notifications option from.

They will hate you for that.

If they are currently getting notifications, and then siuddenly they get turned off, then they will wonder what's going on and why the notifications stopped.