X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_holiday.php;h=37662440bf62c5a087b32d8a50084a725a5be654;hb=566cbcf381d60410b4c5b3a2fc4cd7bfdf49b8fc;hp=86e97220ad337179227bb551a5598d63b33629be;hpb=4001187f22197f55e5a1f211fc8defcc180f7c32;p=mailer.git diff --git a/inc/reset/reset_holiday.php b/inc/reset/reset_holiday.php index 86e97220ad..37662440bf 100644 --- a/inc/reset/reset_holiday.php +++ b/inc/reset/reset_holiday.php @@ -1,7 +1,7 @@ \n"; +if ((getOutputMode() != 0) || ((!isResetModeEnabled()) && (getConfig('holiday_mode') == 'RESET'))) return; +//* DEBUG: */ outputHtml(basename(__FILE__)."
"); // 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' +FROM `{?_MYSQL_PREFIX?}_user_data` +WHERE holiday_activated > 0 AND holiday_activated < UNIX_TIMESTAMP() AND `holiday_active`='N' ORDER BY holiday_activated", - __FILE__, __LINE__); +__FILE__, __LINE__); // Entries found? if (SQL_NUMROWS($result_main) > 0) { // Init SQLs - 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() +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__); + 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") + 'activated' => generateDateTime($content['holiday_activated'], 1), + 'start' => generateDateTime($content['holiday_start'] , 1), + 'end' => generateDateTime($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); + $message = loadEmailTemplate('member_holiday_activated', $content, $content['userid']); + sendEmail($content['userid'], getMessage('HOLIDAY_MEMBER_ACTIVATED_SUBJ'), $message); // Update account - ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` -SET holiday_active='Y' -WHERE userid=%s + 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 @@ -98,7 +102,7 @@ LIMIT 1", SQL_FREERESULT($result_main); // Stop currently activated holidays -HOLIDAY_STOP_HOLIDAYS(); +stopHolidays(); -// +// [EOF] ?>