The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
[SOLVED] Where are stored "Browsing Options" on database
Hello ,
I Look for the table name that stores the Browsing Options values inside database and i ask is there a way to grant specific moderator authority to change/edit this option only "Receive Admin Emails?" for users Without the appearance of the rest of the other options . thnx alot , |
#2
|
||||
|
||||
okay i found it , all options user stored on options filed on user table
now , how i can update only option Receive Admin Emails [adminemail] for specific user by php code ? |
#4
|
|||
|
|||
Quote:
Code:
UPDATE user SET options = options + 16 WHERE (NOT (options & 16)) AND userid = ID Code:
UPDATE user SET options = options - 16 WHERE options & 16 AND userid=ID As Lynne says, this can be done from the admincp without writing php, but since you said in the first post that you want moderators to be able to do it without giving them permission to change any other settings, I'm guessing that you've decided to write your own code to allow them to do it. |
Благодарность от: | ||
tbworld |
#5
|
||||
|
||||
Becouse , i want gave grant to specific moderator authority to change/edit this option only "Receive Admin Emails?" for users Without the appearance of the rest of the other options .
thnx , |
#6
|
||||
|
||||
Quote:
now everything is good Thank you for your understanding of my request kh99 PHP Code:
|
#7
|
|||
|
|||
@all
@kh99; How do i get the mapping of the user options fields, couldnt find anywhere online. I want to enable "Receive Email from Other Users" for all the users by using sql query This needs to be done so that people start receiving mention emails. |
#8
|
||||
|
||||
According to this thread, it would be:
Code:
UPDATE user SET options = options - 256 WHERE options & 256 |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|