X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_holiday.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=596c8ab32594401ca84abfbfe35513ddfff31bec;hp=f7752968ece7ae4412747f21b3e7caf7bdee8621;hpb=f97a999e0737c0007ae9c3c26dfef49f75a175ac;p=mailer.git diff --git a/inc/reset/reset_holiday.php b/inc/reset/reset_holiday.php index f7752968ec..f551ef47b7 100644 --- a/inc/reset/reset_holiday.php +++ b/inc/reset/reset_holiday.php @@ -1,109 +1,3 @@ \n"; - -// 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 < UNIX_TIMESTAMP() AND holiday_active='N' -ORDER BY holiday_activated", - __FILE__, __LINE__); - -// Entries found? -if (SQL_NUMROWS($result_main) > 0) { - // Init SQLs - INIT_SQLS(); - - // 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__); - 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 = array( - 'activated' => MAKE_DATETIME($content['holiday_activated'], "1"), - 'start' => MAKE_DATETIME($content['holiday_start'] , "1"), - 'end' => MAKE_DATETIME($content['holiday_end'] , "1") - ); - - // Send email to user - $msg = LOAD_EMAIL_TEMPLATE("member_holiday_activated", $content, $content['userid']); - SEND_EMAIL($content['userid'], getMessage('HOLIDAY_MEMBER_ACTIVATED_SUBJ'), $msg); - - // Update account - ADD_SQL(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'); -} - -// Free memory -SQL_FREERESULT($result_main); - -// Stop currently activated holidays -HOLIDAY_STOP_HOLIDAYS(); - -// +// @DEPRECATED ?>