The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
need help with a Query
hi, basically lm doing some work on a friends forum which has a solid member base however l converted to vb and certian settings have changed, however l worked out that by running the right query l could update all members options at once (was easy when l noticed the options table within users number change) however because my member base arent so internet inclined, personally l dont see why the guy baught a licence if he doesnt know how to use it
however the query l ran was: Code:
UPDATE `user` SET options='1175'; basically the sql code l want help with is basically to also update the editor members use to the enhanced wysywig(sp?) along with all the other options set as well as l noticed even when l change the option on the test account l had the number in the options coloumb didnt change unless l edited an option before that section in "Edit Options". would be very greatful if someone knew the right query to run or tell me what l could be missing TIA Auron |
#2
|
|||
|
|||
If you're using vB 3.5 there's an option to do that for you. Just go to:
AdminCP >> Maintenance >> Execute SQL Query Then scroll down the list until you find "Show Enhanced (WYSIWYG) Editor Toolbar". Or if that doesn't work, this is what that query does. Code:
UPDATE user SET showvbcode = 2 |
#3
|
|||
|
|||
sweet exactly what l was looking for however the query didnt work out as planed maybe that could be down to the admins accounts not been changed as l havent tested my test account. many thx for the prompt reply..
|
#4
|
|||
|
|||
I kind of made an error in the syntax.
Code:
UPDATE `user` SET showvbcode = 2; |
#5
|
|||
|
|||
actually 2 errors
this is how the query should look Code:
UPDATE `user` SET showvbcode='2'; |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|