Rev 9 | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
9 | daniel-mar | 1 | <?php |
2 | |||
14 | daniel-mar | 3 | if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.'); |
9 | daniel-mar | 4 | |
5 | // db_query("DELETE FROM `".$mysql_zugangsdaten['praefix']."kalender` 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 | // db_query("OPTIMIZE TABLE `".$mysql_zugangsdaten['praefix']."kalender`"); |
||
8 | |||
9 | db_query("DELETE FROM `".$mysql_zugangsdaten['praefix']."kalender` WHERE `start_date` <= DATE_SUB(NOW(), INTERVAL 7 DAY)"); |
||
10 | if (db_affected_rows() > 0) |
||
11 | db_query("OPTIMIZE TABLE `".$mysql_zugangsdaten['praefix']."kalender`"); |
||
12 | |||
13 | ?> |