Subversion Repositories personal-webbase

Rev

Go to most recent revision | 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&uuml;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 
?>