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=68604f82897690dc8e14d04a08eb27c3a531052c;hp=59072f42189f00724ee6086e976cfdb340da74d9;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hpb=157ee010917df5ca07e6d31b42f67417b2516d74 diff --git a/0.2.1/inc/reset/reset_holiday.php b/0.2.1/inc/reset/reset_holiday.php index 59072f4218..68604f8289 100644 --- a/0.2.1/inc/reset/reset_holiday.php +++ b/0.2.1/inc/reset/reset_holiday.php @@ -1,95 +1,95 @@ - 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(); - -// -?> + 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(); + +// +?>