You'll need more than a SQL command to do it.
First, the SQL command you are looking for is
UPDATE (TABLE_PREFIX) settings SET value= (0 or 1, I'm sure you can figure out which is which here) WHERE varname='bbactive';
HOWEVER, this is not sufficient. vBulletin actually has a datastore for options, which is actually what it uses when applying the results for any options you've configured. Using a SQL command to alter that won't work, since the actual datastore field contains every single option in the Options section of the ACP. Instead, your plugin would need to pull in the adminfunctions.php file and run the build_options() function within that.
And of course, you'd want to ensure to secure it so that only proper users could access it, but hopefully that's common sense :P.
|