"Panic Button" needed to turn forum off!

[RedWingFan]

I could probably write this mod myself, but I'm wondering what is involved to create a PHP script that my moderators could use to turn the forum on and off. The problem is that when we're under heavy load, it can take about five minutes to load a page. Log in, acknowledgement, main AdminCP page, vB options, etc. all take awhile to load, too long when you want to turn the forum off for a few minutes so the database can relieve itself.

All I need to know is, which database entries do I need to hit to turn the forum off? In the "setting" table, I tried turning the "bbactive" value to zero (0), but it did not appear to work. I'm wondering if there is another database entry that is being modified that I'm missing, or maybe I just need to try changing "bbactive" again.

[poolking]

Originally Posted by RedWingFan

I could probably write this mod myself, but I'm wondering what is involved to create a PHP script that my moderators could use to turn the forum on and off. The problem is that when we're under heavy load, it can take about five minutes to load a page. Log in, acknowledgement, main AdminCP page, vB options, etc. all take awhile to load, too long when you want to turn the forum off for a few minutes so the database can relieve itself.

All I need to know is, which database entries do I need to hit to turn the forum off? In the "setting" table, I tried turning the "bbactive" value to zero (0), but it did not appear to work. I'm wondering if there is another database entry that is being modified that I'm missing, or maybe I just need to try changing "bbactive" again.

I thought there was already an option that will prevent any more users accessing the forum under heavy load?

[Paul M]

There is, in vb options (Server Settings and Optimization Options) - it's OS dependant though.

[Marco van Herwaarden]

To turn the board of with a query you can run the following SQL's:
[sql]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';
[/sql]
But like mentioned before vB already have means of controlling this.

[RedWingFan]

Originally Posted by poolking

I thought there was already an option that will prevent any more users accessing the forum under heavy load?

Only server load, and that doesn't even work properly either. (I am about to open a ticket with vB support due to this problem.) Thing is, MySQL can get bogged down and the server load can still be under 2.00 on our server, over an extended period.

Originally Posted by MarcoH64

To turn the board of with a query you can run the following SQL's:

That's what I needed. Thanks! Had one of the queries but not the "datastore" table query.

[aussiev8]

upgrade your serve r