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

however the query l ran was:

(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

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.

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

I kind of made an error in the syntax.

actually 2 errors :p

this is how the query should look

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.