Closing the forums with a query

[filburt1]

IIRC this alone doesn't do it:

UPDATE setting SET value = "0" WHERE varname = "bbactive"

What's the other query?

[Dean C]

Whats IIRC?

[filburt1]

If I recall correctly.

[DrkFusion]

UPDATE setting SET value='0' WHERE varname='bbactive'
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:

$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...:confused:

[Xenon]

hmm, i think it's faster to preparse the values into the optionstemplate instead of readem out one by one from the settingtable...

[filburt1]

Yeah but aren't all variables in setting actually instantiated into real variables?

[Xenon]

no, they are initialized in globa.php with this piece of code:

$optionstemp=$DB_site->query_first("SELECT template FROM template WHERE title='options'");
eval($optionstemp['template']);