X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fholiday_functions.php;h=01a28020d324cde3d3f02c7367945fdafedafd61;hp=61ce6ab20470f0e7bb54218fd44d28eebe3deb94;hb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86;hpb=7f104f6fe558bb56b4205241435a2357c2feece1 diff --git a/inc/libs/holiday_functions.php b/inc/libs/holiday_functions.php index 61ce6ab204..01a28020d3 100644 --- a/inc/libs/holiday_functions.php +++ b/inc/libs/holiday_functions.php @@ -1,7 +1,7 @@ 0) - { + $result_stop = SQL_QUERY("SELECT + `userid`, + `holiday_start`, + `holiday_end`, + `comments` +FROM + `{?_MYSQL_PREFIX?}_user_holidays` +WHERE + `holiday_end` <= UNIX_TIMESTAMP() +ORDER BY + `userid` ASC", __FUNCTION__, __LINE__); + if (!SQL_HASZERONUMS($result_stop)) { // We foud at least one - $admin = ""; - while (list($uid, $start, $end, $comments) = SQL_FETCHROW($result_stop)) - { + $admin = ''; + + // Init SQLs + initSqls(); + + // Process all found entries + while ($content = SQL_FETCHARRAY($result_stop)) { // Stop holiday - $result_del = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_holidays WHERE userid=%s LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); + 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 - $result_del = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data -SET holiday_active='N', holiday_activated='0' -WHERE userid=%s LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__); + addSql(SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_user_data` +SET + `holiday_active`='N', + `holiday_activated`=0 +WHERE + `userid`=%s +LIMIT 1", + array(bigintval($content['userid'])), __FUNCTION__, __LINE__, FALSE)); // Prepare array - $content = array( - 'holiday_end' => MAKE_DATETIME($end , "3"), - 'holiday_start' => MAKE_DATETIME($start, "3"), - 'holiday_comments' => $comments - ); + $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 - $msg = LOAD_EMAIL_TEMPLATE("member_holiday_unlock", $content, $uid); - SEND_EMAIL($uid, HOLIDAY_MEMBER_UNLOCK_SUBJ, $msg); + $message = loadEmailTemplate('member_holiday_unlock', $content, $content['userid']); + sendEmail($content['userid'], '{--MEMBER_HOLIDAY_UNLOCK_SUBJECT--}', $message); // Remember userid for admin - $admin .= $uid."\n"; - } + $admin .= $content['userid'] . PHP_EOL; + } // END - if // Send mail to admins - SEND_ADMIN_NOTIFICATION(HOLIDAY_ADMIN_UNLOCK_SUBJ, "admin_holiday_unlock", $admin, "0"); - } + sendAdminNotification('{--ADMIN_HOLIDAY_UNLOCK_SUBJECT--}', 'admin_holiday_unlock', $admin); + + // Run all SQLs + runFilterChain('run_sqls'); + } // END - if // Free memory SQL_FREERESULT($result_stop); } -// +// ---------------------------------------------------------------------------- +// Wrapper functions for configuration entries +// ---------------------------------------------------------------------------- + +// Getter for user_alpha +function getHolidayLock () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('holiday_lock'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// [EOF] ?>