The Arcive of vBulletin Modifications Site.

SQL query to set forum options (globally) · **Released**: 09-01-2002

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 · #2 09-01-2002, 01:24 PM

Ok I got the id's set:

Code:

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 · #3 09-01-2002, 01:25 PM

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

Code:

UPDATE forum SET styleoverride='0';

Dean C · #4 09-01-2002, 01:46 PM

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

- Mist

Tim Wheatley · #5 09-01-2002, 02:08 PM

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

Dean C · #6 09-01-2002, 05:02 PM

thank buddy

- Mist