Default email notification

[Spartan]

I run two board that get a greta deal of traffic. Many of the posters post a couple dozen messages a day. They are complaining about the number of email notifications they get.

How can I turn off email notification for messages and alerts as the default?

Thank you.

 

[Rigo]

I was afraid of that @Brogan . I wouldn't have the slightest idea to know how to do a revert from a backup or run another query without knowing the query code.

 

[Paul B]

What queries did you run?

In general, you should always take a backup of the database before doing anything to it, in case you need to revert.

 

[Rigo]

So how do I change (overide this query) to enable it back?

UPDATE xf_user_option
SET default_watch_state = 'watch_no_email'
WHERE default_watch_state = 'watch_email';

 

[Paul B]

You can do this but it will affect everyone with the watch_no_email state set.

UPDATE xf_user_option
SET default_watch_state = 'watch_email'
WHERE default_watch_state = 'watch_no_email';

As I said earlier, there is no way to restore each individual user record to what it was prior to running the query.

 

[Ogreman]

I meant for all members at once. I have too many to do that individually. Recently had some issues with email and although this was not the exact reason for it, it certainly did not help. I know this because I starting getting all the emails that were being sent out for thread updates. It basically put up email walls in my inbox. That said, it would be nice to turn that off completely when needed. The other problem has been sorted, but still would like to be safe going forward.

 

[ibrian]

UPDATE xf_user_option SET default_watch_state = 'watch_no_email' WHERE default_watch_state = 'watch_email';

Does this work with XF2 as well?

EDIT: My bad, it's answered here: https://xenforo.com/community/threa...d-watched-threads-email-notifications.147634/