How do I automatically turn on/off specific forums at a set time?

[Lynne]

No, I am not ReCom. I just thought I would put out some comments to try to help because it looked like there was a path wrong somewhere along the lines. But, if you think the paths are all correct, then fine.

[ReCom]

Originally Posted by SemperFideles

I did a test run and get this error:

PHP Code:

Turn off Forum

Warning: include_once([path]/./includes/cron/forumswitch.php?enable=0) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/forumswitch.php?enable=0' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

Done 


Hmmm, seels like Scheduled Tasks don't accept filenames with query string attached ...

Two alternatives:

1. Either forget about scheduled tasks and simply invoke the forumswitch.php manually at specified time
2. Or wrap the forumswitch.php code into a function that takes the $enable value (true/false), and then create two separate files that include the forumswitch.php and call the function with either true or false respectively. Use these separate files in the scheduled tasks.

[SemperFideles]

I ended up simplifying this:

forumswitchoff.php looks like this:

PHP Code:

<?php
$vbulletin->db->query_read("UPDATE ".TABLE_PREFIX."forum SET options=options - 2 WHERE (options & 2) AND `forumid` IN ('111','81','33','39','105','125','84','52','75','86','51','76')");
build_forum_permissions();
?>

forumswitchon.php looks like this:

PHP Code:

<?php
$vbulletin->db->query_read("UPDATE ".TABLE_PREFIX."forum SET options=options + 2 WHERE NOT (options & 2) AND `forumid` IN ('111','81','33','39','105','125','84','52','75','86','51','76')");
build_forum_permissions();
?>

[ReCom]

Cool. I didn't know we can do math in SQL queries

[SemperFideles]

The format you gave me was critical for the IN command as well as how to put a db query inside a PHP file. The format for the actual SQL query to turn a forum on or off was in the VBulletin 3.7 tricks forum at vbulletin.com. I really appreciate your help or I wouldn't have been able to do it.