X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fholiday_functions.php;h=b231b060468049186cc6d33be1874b75934139e0;hb=4cf6094cc3cbebfda691fa797e00fe674bbb329c;hp=e23f772dd42fda387cad593560c43d5627de682f;hpb=f928ad2bed60fa256d0641eaf6d2c027a2944688;p=mailer.git diff --git a/inc/libs/holiday_functions.php b/inc/libs/holiday_functions.php index e23f772dd4..b231b06046 100644 --- a/inc/libs/holiday_functions.php +++ b/inc/libs/holiday_functions.php @@ -1,7 +1,7 @@ 0) { + if (!SQL_HASZERONUMS($result_stop)) { // We foud at least one $admin = ''; + // Init SQLs - INIT_SQLS(); + initSqls(); // Process all found entries while ($content = SQL_FETCHARRAY($result_stop)) { // Stop holiday - ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_holidays` WHERE `userid`=%s LIMIT 1", + addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_holidays` WHERE `userid`=%s LIMIT 1", array(bigintval($content['userid'])), __FUNCTION__, __LINE__, false)); // Unlock account - ADD_SQL(SQL_QUERY_ESC("UPDATE - `{!_MYSQL_PREFIX!}_user_data` + addSql(SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_user_data` SET `holiday_active`='N', `holiday_activated`=0 WHERE @@ -76,22 +75,22 @@ LIMIT 1", array(bigintval($content['userid'])), __FUNCTION__, __LINE__, false)); // Prepare array - $content = array( - 'holiday_end' => generateDateTime($content['holiday_end'] , '3'), - 'holiday_start' => generateDateTime($content['holiday_start'], '3'), + $content = merge_array($content, array( + 'holiday_end' => generateDateTime($content['holiday_end'] , 3), + 'holiday_start' => generateDateTime($content['holiday_start'], 3), 'holiday_comments' => $content['comments'] - ); + )); // Send mail to user - $message = LOAD_EMAIL_TEMPLATE('member_holiday_unlock', $content, $content['userid']); - sendEmail($content['userid'], getMessage('HOLIDAY_MEMBER_UNLOCK_SUBJ'), $message); + $message = loadEmailTemplate('member_holiday_unlock', $content, $content['userid']); + sendEmail($content['userid'], '{--MEMBER_HOLIDAY_UNLOCK_SUBJECT--}', $message); // Remember userid for admin $admin .= $content['userid']."\n"; } // END - if // Send mail to admins - sendAdminNotification(getMessage('HOLIDAY_ADMIN_UNLOCK_SUBJ'), 'admin_holiday_unlock', $admin, '0'); + sendAdminNotification('{--ADMIN_HOLIDAY_UNLOCK_SUBJECT--}', 'admin_holiday_unlock', $admin); // Run all SQLs runFilterChain('run_sqls'); @@ -101,5 +100,5 @@ LIMIT 1", SQL_FREERESULT($result_stop); } -// +// [EOF] ?>