Default email notification

[Pepe2012]

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.

 

[faeronsayn]

I am new to this as well, I am not sure how to change it for "Existing users"

but for the new registered users you can change the default values like this

Options > User Registrations

You can set it up there.

 

[Jake Bunce]

I am not sure how to change it for "Existing users"

You have to run queries on the database to update the prefs of existing users. Here they are...

Run this query on your database to disable automatic email notifications:

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

Run this query to disable email notifications for all currently watched threads:

UPDATE xf_thread_watch
SET email_subscribe = 0;

For alerts you can either disable alerts for watched threads:

UPDATE xf_user_option
SET alert_optout = 'post_insert';

...or disable automatic watching of threads:

UPDATE xf_user_option
SET default_watch_state = '';

 

[Paul B]

It would require SQL queries to mass change users, but it would affect all users.

I would just post advising them to set their preferences in their account settings:
http://xenforo.com/community/account/contact-details
http://xenforo.com/community/account/preferences
http://xenforo.com/community/account/privacy

Edit: Ninja'ed!

 

[Big Dan]

UPDATE xf_thread_watch
SET email_subscribe = 0;

How would I run this query for just one user?

Thanks.

Edit: Found the answer: http://xenforo.com/community/threads/how-to-set-e-mail-alert-for-all-users.25167/page-2#post-367717

 

[davespanzer]

You have to run queries on the database to update the prefs of existing users. Here they are...

Run this query on your database to disable automatic email notifications:

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

Run this query to disable email notifications for all currently watched threads:

UPDATE xf_thread_watch
SET email_subscribe = 0;

For alerts you can either disable alerts for watched threads:

UPDATE xf_user_option
SET alert_optout = 'post_insert';

...or disable automatic watching of threads:

UPDATE xf_user_option
SET default_watch_state = '';

Any idea how I could do this with the XenMedio settings in preferences Jake, thanks

• Automatically watch media that you create or when you reply...
  • and receive email notifications of replies

 

[cbertozz]

Is there somewhere in the admin section that I can change the default notification for:

Watch this thread
and
Receive email communications

So they are NOT checked by default?

 

[cbertozz]

Sorry I found it in the Options under User Registration (would have been better elsewhere but at least I found it!)

 

[Deepmartini]

How about a daily digest once a day option? Combine all alerts into one?

 

[StonePilot]

On the flip side for this, if I had an underperforming website that I just converted to XF and I want to boost traffic now ... how can I turn on email notifications for all threads for all users who have ever posted to that thread? That way, old users who posted a year or two ago will get notified that the site is active once again?

 

[melbo]

Is there a query to delete all watched threads from all users?
We had 'watch threads' checked by default but now we'd like to clear that and let people choose to watch threads after running the above queries

Thanks

 

[Jake Bunce]

Is there a query to delete all watched threads from all users?
We had 'watch threads' checked by default but now we'd like to clear that and let people choose to watch threads after running the above queries

Thanks

DELETE
FROM xf_thread_watch

 

[Will mangles]

I know this is an old thread but it took me a good 30 mins to find it. So a little bump for people wanting to turn off email alerts via sql for pre-existing set email alerts.

 

[blueshare]

You have to run queries on the database to update the prefs of existing users. Here they are...

Run this query on your database to disable automatic email notifications:

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

Run this query to disable email notifications for all currently watched threads:

UPDATE xf_thread_watch
SET email_subscribe = 0;

For alerts you can either disable alerts for watched threads:

UPDATE xf_user_option
SET alert_optout = 'post_insert';

...or disable automatic watching of threads:

UPDATE xf_user_option
SET default_watch_state = '';

Sorry this is a very basic question, but how do I run these queries on my database?

 

[Paul B]

Use phpMyAdmin.

 

[ShawnT]

Is there another way to do this?

How do I turn them off by default for new users? Not for watched threads, but for any thread that have replied to.

 

[Ogreman]

Is there any chance for an update that allows for the complete turn off of thread update emails without going in the DB? Or is there a plugin that does this?

 

[Mike]

If you're referring to an individual user, this can be controlled by editing the user in the control panel. There is a "manage watched threads" action (and you can change their default watch status).

 

[Rigo]

How do you "undo" a query?
I ran the query to disable automatic email notification but does this disable it even if a member marks a thread as "watch this thread" @Jake Bunce ?

 

[Paul B]

You can't 'undo' a query.

You can revert from a backup or run another query to change fields again.
It won't be possible to restore each individual user record to what it was prior to running the query though.