XF 2.0 Remove all Subscribed/Watched threads & email notifications

[Paul]

I'd like to be able to Remove all Subscriptions/Watches to forums/Threads (Anything that sends an email - Basically like a global "unsubscribe" - Is there any way to be able to "reset" these under Xf2 please??

(if people want to be able to re-enable these afterwards, then they should be able to themselves...)

Many thanks
Paul

 

[Ozzy47]

You can do it with SQL queries if you're comfortable doing that and have access to e.g. phpMyAdmin.

UPDATE xf_user_option SET email_on_conversation = 0;
UPDATE xf_user_option SET default_watch_state = '';
truncate table xf_thread_watch;

Those still should work for XF2, remember to backup first.

 

[ibrian]

Hm, I just tried this in phpmyadmin and got:

#1054 - Unknown column 'default_watch_state' in 'field list'

A simulation seems to prefer the following:
https://xenforo.com/community/threads/disable-receive-email-notifications.144362/#post-1232589

but I'm hesitant to use it without confirming it's correct first.