X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_holiday.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=08a9a052ddd67568fa7bcc98c4300ce0cc6bfdc0;hp=3fc5f67995d10727724bb3e5a496133f7fc3ca81;hpb=30ca796470b999b169640dcac82abf5dc8693334;p=mailer.git diff --git a/inc/reset/reset_holiday.php b/inc/reset/reset_holiday.php index 3fc5f67995..f551ef47b7 100644 --- a/inc/reset/reset_holiday.php +++ b/inc/reset/reset_holiday.php @@ -1,90 +1,3 @@ 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 <= UNIX_TIMESTAMP() AND holiday_end > UNIX_TIMESTAMP() LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); - if (SQL_NUMROWS($result_holiday) == 1) - { - // Okay, this user can be send away to holiday... - list($start, $end) = SQL_FETCHROW($result_holiday); - - // Prepare all data for the template - $content = array( - 'activated' => MAKE_DATETIME($activated, "1"), - 'start' => MAKE_DATETIME($start , "1"), - 'end' => MAKE_DATETIME($end , "1") - ); - - // Send email to user - $msg = LOAD_EMAIL_TEMPLATE("member_holiday_activated", $content, $uid); - SEND_EMAIL($uid, HOLIDAY_MEMBER_ACTIVATED, $msg); - - // Update account - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET holiday_active='Y' -WHERE userid=%s LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__); - } - - // Free memory - SQL_FREERESULT($result_holiday); - } -} - -// Free memory -SQL_FREERESULT($result_main); - -// Stop currently activated holidays -HOLIDAY_STOP_HOLIDAYS(); - -// +// @DEPRECATED ?>