Open & Close Forums Using MySQL Code

[tmod]

I know I have seen this somehwere but I can't for the life of me find it again.

I would like to know what MySQL code I would need to use to open and close my forums.

Tmod

[Steve Machol]

See this:

http://www.vbulletin.com/forum/showthread.php?p=1016921#post1016921

[tmod]

That doesn't have what I am looking for.

I am looking for the code to turn the forums on and off like you do from the vbulletin options Turn your vbulletin on and off.

No code for that there.

Unless I am totally blind.

Tmod

[Steve Machol]

Darn, I could have sworn those queires were there. Sorry but I don't know the exact queries. I'll let you know if I find them.

[Steve Machol]

I could only find the queries for 3.0.x and 3.5.x and they didn't work for 3.6.

[tmod]

Where are the ones for v3.5?

I will take a look at those and see if I can do anything with them.

Thanks

Tmod

[Marco van Herwaarden]

The queries have changed to these, as the setting is now an integer and not a string:

(to turn off)

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

(to turn on)

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

[zodehala]

Thanks but

i want to know what s:8 in quey means ? or other text ?

[Marco van Herwaarden]

That is part of how PHP stores a serialized array. In this case it means that the next entry is a 8-byte characterstring.

For more info http://nl3.php.net/manual/en/function.serialize.php

[tmod]

Thanks Marco!

Tmod

[feldon23]

I tried
UPDATE setting SET value=0 WHERE varname='bbactive';
but couldn't figure out why my forum was still running. Then it occured to me that maybe I have to do something in the datastore too. But I have no clue how to poke around in the datastore.

I'm more of a concept man than an implementation man.

If I need to close my forum, I set an .htaccess password.