• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Update all users that are watching threads with email

MMAcomm

Active member
#1
I have a large number of users that signed up early on with "watch all threads created and replied to" selected WITH E-MAIL.

This was of course annoying and I then changed it to with alerts only.

I want to change all users that are watching with email to watch with alerts only.

Almost none of my users want email, but many don't know how to turn it off.

Thank you for any assistance.
 

Jake Bunce

XenForo moderator
Staff member
#2
Run this query to disable email notifications for all currently watched threads:

Code:
UPDATE xf_thread_watch
SET email_subscribe = 0;