Go to most recent revision |
Blame |
Last modification |
View Log
| RSS feed
<?php
if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.');
// 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))))");
// if (db_affected_rows() > 0)
// {
// db_query("OPTIMIZE TABLE `".$WBConfig->getMySQLPrefix()."calendar`");
// }
db_query("DELETE FROM `".$WBConfig->getMySQLPrefix()."calendar` WHERE `start_date` <= DATE_SUB(NOW(), INTERVAL 7 DAY)");
if (db_affected_rows() > 0)
{
db_query("OPTIMIZE TABLE `".$WBConfig->getMySQLPrefix()."calendar`");
}
?>