Update Admin Email Option

[Black Snow]

I'm looking for a query to update the user table so all members who disabled receiving emails from admins is changed so they will receive them.

[kh99]

You can use this:
UPDATE user SET options = options + 16 WHERE NOT (options & 16)


You can also execute that same query from Maintenance > Execute SQL Query by finding it in the "Automatic Query" list. (To do that you need to be in the config.php file as a user who is allowed to execute queries).

[Black Snow]

You can use this:
UPDATE user SET options = options + 16 WHERE NOT (options & 16)


You can also execute that same query from Maintenance > Execute SQL Query by finding it in the "Automatic Query" list. (To do that you need to be in the config.php file as a user who is allowed to execute queries).
Do I run this exactly how you have it?
UPDATE user SET options = options + 16 WHERE NOT (options & 16)

[kh99]

Do I run this exactly how you have it?
UPDATE user SET options = options + 16 WHERE NOT (options & 16)

Yes, unless you have a table prefix defined, then you need to add that to 'user'.