Query to Shutdown forums

[telc]

I just went in with phpMyAdmin and updated the value and it didn't disable the forum.

[Deaths]

Ok, this *might* work, but it is untested:

PHP Code:

build_datastore('bbactive', serialize('1')); 


Or maybe:

PHP Code:

$DB_site->query("UPDATE " . TABLE_PREFIX . "datastore SET ('bbactive', 's:1:"1"')"); 


I haven't tested them, but they should work... atleast one of them ^^.

Do test on a test board though, they can screw up your board bad if they don't work like supposed to :ermm:

[telc]

Originally Posted by Deaths

Ok, this *might* work, but it is untested:

PHP Code:

build_datastore('bbactive', serialize('1')); 


Or maybe:

PHP Code:

$DB_site->query("UPDATE " . TABLE_PREFIX . "datastore SET ('bbactive', 's:1:"1"')"); 


I haven't tested them, but they should work... atleast one of them ^^.

Do test on a test board though, they can screw up your board bad if they don't work like supposed to :ermm:

That query scares me, I am afraid to write back to that field. Other fields dont bother me.

[Zachery]

Its two querys and try searching at vB.com I believe Steve M posted it on the forums.

[telc]

Originally Posted by Zachery

Its two querys and try searching at vB.com I believe Steve M posted it on the forums.

Thanks! I found it:

http://www.vbulletin.com/forum/showp...82&postcount=4

PHP Code:

Run these queries to turn off your forums in vB3:

UPDATE datastore SET data=REPLACE(data,'"bbactive";s:1:"1"','"bbactive";s:1:"0"') WHERE title='options';

UPDATE setting SET value=0 WHERE varname='bbactive';