Details | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
1 | daniel-mar | 1 | <?php |
2 | |||
3 | if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.'); |
||
4 | |||
5 | // db_query("DELETE FROM `".$WBConfig->getMySQLPrefix()."calendar` WHERE (((`end_date` >= `start_date`) AND (`end_date` <= DATE_SUB(NOW(), INTERVAL 7 DAY))) OR ((`end_date` > `start_date`) AND (`start_date` <= DATE_SUB(NOW(), INTERVAL 7 DAY))))"); |
||
6 | // if (db_affected_rows() > 0) |
||
7 | // { |
||
8 | // db_query("OPTIMIZE TABLE `".$WBConfig->getMySQLPrefix()."calendar`"); |
||
9 | // } |
||
10 | |||
11 | db_query("DELETE FROM `".$WBConfig->getMySQLPrefix()."calendar` WHERE `start_date` <= DATE_SUB(NOW(), INTERVAL 7 DAY)"); |
||
12 | if (db_affected_rows() > 0) |
||
13 | { |
||
14 | db_query("OPTIMIZE TABLE `".$WBConfig->getMySQLPrefix()."calendar`"); |
||
15 | } |
||
16 | |||
17 | ?> |