X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Freset%2Freset_holiday.php;h=3fc5f67995d10727724bb3e5a496133f7fc3ca81;hp=45e8b9fd48e6096ac296d35beeb19f3af68e2b40;hb=30ca796470b999b169640dcac82abf5dc8693334;hpb=4ef4c88fc481335dc0631b223111c15a84cccb51 diff --git a/inc/reset/reset_holiday.php b/inc/reset/reset_holiday.php index 45e8b9fd48..3fc5f67995 100644 --- a/inc/reset/reset_holiday.php +++ b/inc/reset/reset_holiday.php @@ -45,14 +45,14 @@ if (($CSS == 1) || ((!isBooleanConstantAndTrue('__DAILY_RESET')) && ($_CONFIG['h // Check for holidays we need to enable and send email to user $result_main = SQL_QUERY("SELECT userid, holiday_activated FROM "._MYSQL_PREFIX."_user_data -WHERE holiday_activated > 0 AND holiday_activated < ".time()." AND holiday_active='N' +WHERE holiday_activated > 0 AND holiday_activated < UNIX_TIMESTAMP() AND holiday_active='N' ORDER BY holiday_activated", __FILE__, __LINE__); if (SQL_NUMROWS($result_main) > 0) { // We have found at least one useraccount so let's check it... while(list($uid, $activated) = SQL_FETCHROW($result_main)) { // Check if his holiday can be activated $result_holiday = SQL_QUERY_ESC("SELECT holiday_start, holiday_end FROM "._MYSQL_PREFIX."_user_holidays -WHERE userid=%s AND holiday_start <= ".time()." AND holiday_end > ".time()." LIMIT 1", +WHERE userid=%s AND holiday_start <= UNIX_TIMESTAMP() AND holiday_end > UNIX_TIMESTAMP() LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__); if (SQL_NUMROWS($result_holiday) == 1) {