Closing the forums with a query

[filburt1]

IIRC this alone doesn't do it:
[sql]
UPDATE setting SET value = "0" WHERE varname = "bbactive"
[/sql]
What's the other query?

[Dean C]

Whats IIRC?

[filburt1]

If I recall correctly.

[DrkFusion]

[sql]UPDATE setting SET value='0' WHERE varname='bbactive'[/sql]
Try that with single quotes./

[filburt1]

No there's some completely different query I thought.

[Dean C]

Lmfao i thought it was a technical term...

[NTLDR]

You need to update the options template with the values stored in the settings table for this to take effect.

vB looks at the options template and not at the setting table for all the vBulletin Options.

[filburt1]

Ah yes. Remember the query?

[Xenon]

in admin/options.php you can find this:

PHP Code:

$optionstemplate=generateoptions();
  $DB_site->query("UPDATE template SET template='$optionstemplate' WHERE title='options'"); 


i think the easiest way is a replace query, this one i think is the right one:

UPDATE template REPLACE(template, '$bbactive=1', '$bbactive=0') WHERE title='options'

[filburt1]

Thanks, it looks like that'll work.

I don't understand why vB doesn't just read from the setting table...