X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=0.2.1%2Finc%2Freset%2Freset_holiday.php;fp=0.2.1%2Finc%2Freset%2Freset_holiday.php;h=0000000000000000000000000000000000000000;hp=68604f82897690dc8e14d04a08eb27c3a531052c;hb=ab9c0550b44bdb6bbb930b4553f687702963801e;hpb=50646cc7b05cf5ff93e9b1e36ab03047cc0cd6bf diff --git a/0.2.1/inc/reset/reset_holiday.php b/0.2.1/inc/reset/reset_holiday.php deleted file mode 100644 index 68604f8289..0000000000 --- a/0.2.1/inc/reset/reset_holiday.php +++ /dev/null @@ -1,95 +0,0 @@ - 0 AND holiday_activated < ".time()." 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=%d AND holiday_start <= ".time()." AND holiday_end > ".time()." 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=%d 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(); - -// -?>