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