Deactivating email sending in database

[squishi]

I noticed that about 2/3 of my membership has never posted on the board.
When I send out emails, about 1/2 of them come right back.

So I want to turn off the email reception settings for inactive users.
I can select all the users with an SQL query.

But I think the email options are encoded in the options database column?
Could you please explain to what setting I would need to set this so that inactive users no longer receive an notifications from my forum (except admin emails)?

[Digital Jedi]

Originally Posted by squishi

I noticed that about 2/3 of my membership has never posted on the board.
When I send out emails, about 1/2 of them come right back.

So I want to turn off the email reception settings for inactive users.
I can select all the users with an SQL query.

But I think the email options are encoded in the options database column?
Could you please explain to what setting I would need to set this so that inactive users no longer receive an notifications from my forum (except admin emails)?

There's an option in each User's settings to opt out of receiving Admin Emails. You can tick that option for each of those Users yourself when editing them in the Admin CP. It's under Browsing Options.

[kh99]

If you still want to do it with a query (like if there are too many to do manually), you could probably figure it out by getting the value of "options" from the db for your userid, then change the option you're interested in and get it again and see which bit changed. I did that for "Receive email from Admins" or whatever it's called, but I just read your post again and I see now that's the one you want leave on.

[squishi]

Originally Posted by Digital Jedi

There's an option in each User's settings to opt out of receiving Admin Emails. You can tick that option for each of those Users yourself when editing them in the Admin CP. It's under Browsing Options.

If you like to click that option for 30,000+ users on your forum - fine.
I have better things to do and will need to edit the database.

--------------- Added [DATE]1293179002[/DATE] at [TIME]1293179002[/TIME] ---------------

So what options are included in that database field?
I want to make sure that I don't accidentally overwrite something.

[Digital Jedi]

Originally Posted by squishi

If you like to click that option for 30,000+ users on your forum - fine.
I have better things to do and will need to edit the database.

Being that I have no idea how many members you were referring to, since you never mentioned it, I was giving you an option you may or may not have been aware of. I was trying to be helpful. The sarcasm wasn't really necessary.

[BirdOPrey5]

Originally Posted by squishi

I noticed that about 2/3 of my membership has never posted on the board.
When I send out emails, about 1/2 of them come right back.

So I want to turn off the email reception settings for inactive users.
I can select all the users with an SQL query.

But I think the email options are encoded in the options database column?
Could you please explain to what setting I would need to set this so that inactive users no longer receive an notifications from my forum (except admin emails)?

You should probably require a valid email address on registration (email confirmation) so you don't get to the point of having so many bad email addresses to begin with.

[kh99]

Originally Posted by squishi

So what options are included in that database field?
I want to make sure that I don't accidentally overwrite something.

I don't know, but I was thinking it doesn't matter if you find the bit of interest (as I mentioned above) and only change that one bit, like with a bitwise OR or AND.