X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_holiday.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=596c8ab32594401ca84abfbfe35513ddfff31bec;hp=6e7116e2c1c9bd23e6bbbe1ca64d830a60757e97;hpb=c72268213d4d4829d845d39c101bb08fbe4ed79a;p=mailer.git diff --git a/inc/reset/reset_holiday.php b/inc/reset/reset_holiday.php index 6e7116e2c1..f551ef47b7 100644 --- a/inc/reset/reset_holiday.php +++ b/inc/reset/reset_holiday.php @@ -1,125 +1,3 @@ 0 AND - `holiday_activated` < UNIX_TIMESTAMP() AND - `holiday_active`='N' -ORDER BY - `holiday_activated` ASC", -__FILE__, __LINE__); - -// Entries found? -if (SQL_NUMROWS($result_main) > 0) { - // Init SQLs - initSqls(); - - // We have found at least one useraccount so let's check it... - while ($content = SQL_FETCHARRAY($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` <= UNIX_TIMESTAMP() AND - `holiday_end` > UNIX_TIMESTAMP() -LIMIT 1", - array(bigintval($content['userid'])), __FILE__, __LINE__); - - // Do we have an entry? - if (SQL_NUMROWS($result_holiday) == 1) { - // Okay, this user can be send away to holiday... - $content = merge_array($content, SQL_FETCHARRAY($result_holiday)); - - // Prepare all data for the template - $content = merge_array($content, array( - 'activated' => generateDateTime($content['holiday_activated'], 1), - 'start' => generateDateTime($content['holiday_start'] , 1), - 'end' => generateDateTime($content['holiday_end'] , 1) - )); - - // Send email to user - $message = loadEmailTemplate('member_holiday_activated', $content, $content['userid']); - sendEmail($content['userid'], '{--HOLIDAY_MEMBER_ACTIVATED_SUBJECT--}', $message); - - // Update account - addSql(SQL_QUERY_ESC("UPDATE - `{?_MYSQL_PREFIX?}_user_data` -SET - `holiday_active`='Y' -WHERE - `userid`=%s -LIMIT 1", - array(bigintval($content['userid'])), __FILE__, __LINE__, false)); - } // END - if - - // Free memory - SQL_FREERESULT($result_holiday); - } // END - while - - // Run all SQLs - runFilterChain('run_sqls'); -} // END - if - -// Free memory -SQL_FREERESULT($result_main); - -// Stop currently activated holidays -stopHolidays(); - -// [EOF] +// @DEPRECATED ?>