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]

Originally Posted by 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).

Do I run this exactly how you have it?

UPDATE user SET options = options + 16 WHERE NOT (options & 16)

[kh99]

Originally Posted by Black Snow

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'.