Subversion Repositories personal-webbase

Rev

Go to most recent revision | Blame | Last modification | View Log | RSS feed

  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. ?>