how to set e-mail alert for all users ?

[erich37]

how to activate the setting for all my members, so that they will receive an e-mail when they create or reply to a thread?

------------------------------------------
Automatically watch threads that you create or when you reply...

• and receive email notifications of replies

--------------------------------------------

 

[Coop1979]

How can I use this query to update only users who don't already have a Default Watch State set?

 UPDATE xf_user_option
SET default_watch_state = 'watch_no_email'

I'm guessing I just need a 'WHERE default_watch_state IS NULL' or something to that effect, but I don't want to foobar my database on a guess.

 

[Jake Bunce]

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

 

[Shelley Hitz]

How exactly do you run this query in Cpanel?

And will this ensure that future members have this options by default?

Thank you!

 

[Breixo]

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

Hi @Jake Bunce
I'm having this problem here:
https://xenforo.com/community/threads/bd-mails.59229/page-34#post-1045550
Is it possible to create a query to remove all emails to specific users based on their email?

I tried to remove manually from User > Preferences and User > Privacy; but Xenforo still tries to send emails to watched threads and/or old conversations.
Yours is the closest solution I found.
Hope you can help with this.

 

[Jake Bunce]

Hi @Jake Bunce
I'm having this problem here:
https://xenforo.com/community/threads/bd-mails.59229/page-34#post-1045550
Is it possible to create a query to remove all emails to specific users based on their email?

I tried to remove manually from User > Preferences and User > Privacy; but Xenforo still tries to send emails to watched threads and/or old conversations.
Yours is the closest solution I found.
Hope you can help with this.

https://xenforo.com/community/threads/email-notifications-on-alerts.54661/#post-583347

 

[Breixo]

https://xenforo.com/community/threads/email-notifications-on-alerts.54661/#post-583347

Thanks for your fast reply.
I already saw that.
I wanted to disable watched emails only for certain users, not for all of them.
Is it possible?

 

[Jake Bunce]

Thanks for your fast reply.
I already saw that.
I wanted to disable watched emails only for certain users, not for all of them.
Is it possible?

Both of those tables have user_id columns which you can query. Just add WHERE user_id = 123 to the end of the query to limit it, or WHERE user_id IN (123,456,789) for a list of ids.

 

[Breixo]

Both of those tables have user_id columns which you can query. Just add WHERE user_id = 123 to the end of the query to limit it, or WHERE user_id IN (123,456,789) for a list of ids.

Great, that will help.
It's a hard work but I prefer that option.
Thanks!

 

[hibiskus]

That is for new registrations only.

Not a bug.

For existing members you will need to run this query:

UPDATE xf_user_option
SET default_watch_state = 'watch_email'

Is that query still compatible with, latest version of XF (for history XF 2.1.9 )

 

[hibiskus]

@Brogan is that query in my quoted post still still up to date for XF 2.1.10?