XF 1.1 query to set all to receive notifications

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

Code:

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"

 

Yes.

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