XF 1.2 Automatically Watch Thread

[majesty95]

Another XF site that I use has it set to have the thread automatically watched anytime the users replies, likes, etc. I thought I saw this option somewhere before but I cannot find it for the life of me now...

 

[Paul B]

It's in your account preferences.

 

[majesty95]

It's in your account preferences.

What I'm asking is, how do I set it in admin controls so that is the default? I know the user can set it themselves, but by default I want that box to be checked.

 

[Andrej]

Admin CP -> Options -> User Registration -> Default Registration Values -> Watch threads when creating or replying

 

[majesty95]

Admin CP -> Options -> User Registration -> Default Registration Values -> Watch threads when creating or replying

Hmm. I have that checked but the box is not automatically checked when creating or replying like it is on here...

 

[TPerry]

Hmm. I have that checked but the box is not automatically checked when creating or replying like it is on here...

If you go into your profile and uncheck that option - that is what applies. The ACP setting is for new users.

 

[loplo]

Is there a way that changes the default

Watch this thread...
and receive email notifications

from ticked to unticked, while replying to a thread?

I've changed the option for the new members.

 

[Paul B]

In your account preferences.

 

[loplo]

I know that each member can alter the setting, but can't I do it globally, from the backend?

 

[Paul B]

It would require an SQL query to change all members.

 

[loplo]

Is is public somewhere, or could you help me with that? I don't dare making experiments on my database without knowing what I'm doing.
Thanks.

 

[Paul B]

You shouldn't really be changing existing member settings without their permission.
I would be extremely annoyed if a site owner did that to my account.

 

[loplo]

The issue is, that most of them started to complain regarding the tons of mails they're receiving.
For me it would be a much nicer move to be able to have the "Watch this thread... and receive email notifications" unticked by default. This way noone is automatically subscribed to a thread.
If someone wants to follow a thread, discussion he can tick it, but by default should be unticked.

LE
I've found this from @Jake Bunce, posted in 2011. Is this going to work on the latest database?

UPDATE xf_user_option
SET default_watch_state = '';

 

[Paul B]

UPDATE xf_user_option SET default_watch_state = ''

or

UPDATE xf_user_option SET default_watch_state = 'watch_no_email'

Depending on whether you want them to still watch or not.

Take a backup first.

 

[loplo]

Wired things happen.
Did the query with the result "271 rows affected. (Query took 0.2835 sec)", but the "Watch this thread... and receive email notifications" is still ticked by default and in /account/alert-preferences is everything ticked too.
Am I missing something?