Rev 9 |
Blame |
Compare with Previous |
Last modification |
View Log
| RSS feed
<?php
if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.');
// 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))))");
// if (db_affected_rows() > 0)
// db_query("OPTIMIZE TABLE `".$mysql_zugangsdaten['praefix']."kalender`");
db_query("DELETE FROM `".$mysql_zugangsdaten['praefix']."kalender` WHERE `start_date` <= DATE_SUB(NOW(), INTERVAL 7 DAY)");
if (db_affected_rows() > 0)
db_query("OPTIMIZE TABLE `".$mysql_zugangsdaten['praefix']."kalender`");
?>