need help with a Query

[Auron]

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 :p

however the query l ran was:

UPDATE `user` SET options='1175'; (l think the option code was 1175 anyways hehe not looking at the code right now)

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

[baronvonwalz]

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.

UPDATE user SET showvbcode = 2

[Auron]

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

[baronvonwalz]

I kind of made an error in the syntax.


UPDATE `user` SET showvbcode = 2;

[Auron]

actually 2 errors :p

this is how the query should look

UPDATE `user` SET showvbcode='2';

lve later found out that the only account it didnt seem to update was my own for some weird reason it didnt update a couple of others as they were logged in, kinda strange but oh well.