Technical Question about Newsletter Option (table?)

[sbartelski]

In the member profile Notifications section, there is an option to get Newsletters, etc. In which table is this option stored. I need to know how many and who have not selected this option.

TIA

Stefan

[shawnb61]

Note that the key part of "Receive forum newsletters, announcements and important notifications by email." is the "by email" part...

This is where users can opt in to receiving emails from the forum - at all.  If it's checked, you can send them email.  If it's not, you can't.  Be mindful of that; you really shouldn't override their opt-in decision. 

Don't be surprised if very few have opted in.  How often do you check the "SURE! SEND ME EMAILS!" boxes?

The field is in the smf_user_alerts_prefs table, the alert_pref is 'announcements', the alert_value is 1 or 0. 

Code Select Expand

SELECT count(*) from smf_user_alerts_prefs
WHERE alert_pref = 'announcements'
AND alert_value = 1;


[sbartelski]

Thnaks so much for that quick answer. The information you give is excellent, special thanks for the SQL. I am not sure how I missed that table, I thought I had looked everywhere, however my wife always tells me it is good that I never became a detective, as I never can find things.

We are making some major changes to the access of our forums and the club board wants to know if the prior emails that we distributed have been seen by all current users. If the number opted-in is low, we may do the unthinkable and override that selection for this one critical message. I will take a backup copy of the table that I can restore afterwards.

Thnaks again

[Aleksi "Lex" Kilpinen]

You can simply check the "Override notification settings" option in the advanced section when sending a newsletter. That's what it's for, so you can send out an email to everyone if it's actually required for a reason.

[sbartelski]

You can simply check the "Override notification settings" option in the advanced section when sending a newsletter. That's what it's for, so you can send out an email to everyone if it's actually required for a reason.

THANKS, that is really good news, exactly what I need. So much to learn about this software, makes my head spin sometimes.

[Steve]

makes my head spin sometimes

But it's the best and most secure on the market.