I am not sure how to change it for "Existing users"
UPDATE xf_user_option
SET default_watch_state = 'watch_no_email'
WHERE default_watch_state = 'watch_email';
UPDATE xf_thread_watch
SET email_subscribe = 0;
UPDATE xf_user_option
SET alert_optout = 'post_insert';
UPDATE xf_user_option
SET default_watch_state = '';
Code:UPDATE xf_thread_watch SET email_subscribe = 0;
You have to run queries on the database to update the prefs of existing users. Here they are...
Run this query on your database to disable automatic email notifications:
Code:UPDATE xf_user_option SET default_watch_state = 'watch_no_email' WHERE default_watch_state = 'watch_email';
Run this query to disable email notifications for all currently watched threads:
Code:UPDATE xf_thread_watch SET email_subscribe = 0;
For alerts you can either disable alerts for watched threads:
Code:UPDATE xf_user_option SET alert_optout = 'post_insert';
...or disable automatic watching of threads:
Code:UPDATE xf_user_option SET default_watch_state = '';
Is there a query to delete all watched threads from all users?
We had 'watch threads' checked by default but now we'd like to clear that and let people choose to watch threads after running the above queries
Thanks
DELETE
FROM xf_thread_watch
You have to run queries on the database to update the prefs of existing users. Here they are...
Run this query on your database to disable automatic email notifications:
Code:UPDATE xf_user_option SET default_watch_state = 'watch_no_email' WHERE default_watch_state = 'watch_email';
Run this query to disable email notifications for all currently watched threads:
Code:UPDATE xf_thread_watch SET email_subscribe = 0;
For alerts you can either disable alerts for watched threads:
Code:UPDATE xf_user_option SET alert_optout = 'post_insert';
...or disable automatic watching of threads:
Code:UPDATE xf_user_option SET default_watch_state = '';
We use essential cookies to make this site work, and optional cookies to enhance your experience.