Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.89 KB | None | 0 0
  1.     public static function loadMailSchedules()
  2.     {
  3.         // sendon's value is 01:15:00
  4.  
  5.         // (`interval` + `lastmail`) <= '".time()."' equals FALSE for some reason
  6.  
  7.         self::$SCHEDULES = array();
  8.         $select = "SELECT * FROM
  9.                                 `mail_schedules`
  10.                         WHERE
  11.                                 UNIX_TIMESTAMP(CONCAT('".date("Y-m-d")."', ' ', `sendon`)) <= ".strtotime(date("Y-m-d H:i:s"))."
  12.                             AND
  13.                                 (`interval` + `lastmail`) <= '".time()."'
  14.                             AND
  15.                                 `is_active` = 1";
  16.         echo $select;
  17.         DatabaseR::query($select);
  18.         while($row = DatabaseR::fetchObject())
  19.         {
  20.             $TIME = date("H:i:s");
  21.  
  22.             // this equals TRUE
  23.             var_dump(strtotime("01:15:00") < strtotime($TIME));
  24.  
  25.             if(strtotime($row->sendon) < strtotime($TIME)) self::$SCHEDULES[$row->id] = $row;
  26.         }
  27.         Database::query("UPDATE `mail_schedules` SET `lastmail`='".time()."' WHERE `id` IN ('".implode("','", array_keys(self::$SCHEDULES))."') ");
  28.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement