Default email notification

Spartan

Well-known member
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.
 
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.
 
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:

Code:
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:

Code:
UPDATE xf_thread_watch
SET email_subscribe = 0;

For alerts you can either disable alerts for watched threads:

Code:
UPDATE xf_user_option
SET alert_optout = 'post_insert';

...or disable automatic watching of threads:

Code:
UPDATE xf_user_option
SET default_watch_state = '';
 
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:

Code:
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:

Code:
UPDATE xf_thread_watch
SET email_subscribe = 0;

For alerts you can either disable alerts for watched threads:

Code:
UPDATE xf_user_option
SET alert_optout = 'post_insert';

...or disable automatic watching of threads:

Code:
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
 
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?
 
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?
 
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
 
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:

Code:
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:

Code:
UPDATE xf_thread_watch
SET email_subscribe = 0;

For alerts you can either disable alerts for watched threads:

Code:
UPDATE xf_user_option
SET alert_optout = 'post_insert';

...or disable automatic watching of threads:

Code:
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?
 
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).
 
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.
 
Top Bottom