The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Update Admin Email Option
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.
|
#2
|
|||
|
|||
You can use this:
Code:
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). |
Благодарность от: | ||
Lynne |
#3
|
|||
|
|||
Quote:
Code:
UPDATE user SET options = options + 16 WHERE NOT (options & 16) |
#4
|
|||
|
|||
Yes, unless you have a table prefix defined, then you need to add that to 'user'.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|