X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_holiday.php;h=c68de78391ea255a2ff13b5ba0befe0aede69141;hb=30986f637cd3c03951bdbfc880b9a420f7724ce0;hp=13d1203a7980b007bfb04896c0edf7a3991bce09;hpb=a090e351c49fe021fb3064325694da03402332e0;p=mailer.git diff --git a/inc/reset/reset_holiday.php b/inc/reset/reset_holiday.php index 13d1203a79..c68de78391 100644 --- a/inc/reset/reset_holiday.php +++ b/inc/reset/reset_holiday.php @@ -38,7 +38,7 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } elseif (!EXT_IS_ACTIVE('holiday')) { return; @@ -51,9 +51,9 @@ if (($GLOBALS['output_mode'] == 1) || ((!isResetModeEnabled()) && (getConfig('ho // 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' +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) { @@ -67,28 +67,28 @@ if (SQL_NUMROWS($result_main) > 0) { 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); + sendEmail($content['userid'], getMessage('HOLIDAY_MEMBER_ACTIVATED_SUBJ'), $msg); // Update account ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` -SET holiday_active='Y' +SET `holiday_active`='Y' WHERE userid=%s LIMIT 1", - array(bigintval($content['userid'])), __FILE__, __LINE__, false)); + array(bigintval($content['userid'])), __FILE__, __LINE__, false)); } // END - if // Free memory