XF 1.1 query to set all to receive notifications

[greenchicken]

Want to reset it for my whole forum, anyone know the query? TIA

 

[Chris D]

To set it for all existing users, run this query:

UPDATE xf_user_option SET default_watch_state = 'watch_email'

To set that as the default for new user registrtions... Let me check

EDIT: Yep: Admin CP > Options > User Registration

Set "Watch threads when creating or replying" to "Yes, with email"

 

[greenchicken]

Thanks so
UPDATE xf_user_option SET default_watch_state = 'watch_email'
will reset all users to receive emails by default?

 

[Chris D]

Yes.

And if you set default_watch_state to 'watch_no_email' that will set it to watch all threads but without emails.

 

[greenchicken]

Done, Appreciate the help