SQL query to set forum options (globally)

[Tim Wheatley]

I need to set all my forums to use style id 1 as default, but not force them to do that.

I've removed some styles and some of my forums still have style id 17 forced on their settings - just want to clean it up. :)

[Tim Wheatley]

Ok I got the id's set:UPDATE forum SET styleid='1'

But how do I force them all to 'no' under the options for the 'force this forum to use this style'?

[Tim Wheatley]

Got the other too (quite easy when you think it through - see I'm learning!!) ;)

UPDATE forum SET styleoverride='0';

[Dean C]

whats the one above do ... does styleoverride='0' set it to no... or is that the style id ?

- Mist

[Tim Wheatley]

0 = no, I checked in the cp after I'd done one of them to see.
1 = yes.

[Dean C]

thank buddy :D

- Mist