+// Sends out mail to all administrators
+// IMPORTANT: Please use sendAdminNotification() instead of calling this function directly
+function sendAdminsEmails ($subj, $template, $content, $userid) {
+ // Trim template name
+ $template = trim($template);
+
+ // Load email template
+ $message = loadEmailTemplate($template, $content, $userid);
+
+ // Check which admin shall receive this mail
+ $result = SQL_QUERY_ESC("SELECT `admin_id` FROM `{?_MYSQL_PREFIX?}_admins_mails` WHERE `mail_template`='%s' ORDER BY `admin_id` ASC",
+ array($template), __FUNCTION__, __LINE__);
+ if (SQL_HASZERONUMS($result)) {
+ // Create new entry (to all admins)
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_admins_mails` (`admin_id`, `mail_template`) VALUES (0, '%s')",
+ array($template), __FUNCTION__, __LINE__);
+ } else {
+ // Load admin ids...
+ // @TODO This can be, somehow, rewritten
+ $adminIds = array();
+ while ($content = SQL_FETCHARRAY($result)) {
+ $adminIds[] = $content['admin_id'];
+ } // END - while
+
+ // Free memory
+ SQL_FREERESULT($result);
+
+ // Init result
+ $result = false;
+
+ // "implode" ids and query string
+ $adminId = implode(',', $adminIds);
+ if ($adminId == '-1') {
+ if (isExtensionActive('events')) {
+ // Add line to user events
+ EVENTS_ADD_LINE($subj, $message, $userid);
+ } else {
+ // Log error for debug
+ logDebugMessage(__FUNCTION__, __LINE__, sprintf("Extension 'events' missing: tpl=%s,subj=%s,userid=%s",
+ $template,
+ $subj,
+ $userid
+ ));
+ }
+ } elseif (($adminId == '0') || (empty($adminId))) {
+ // Select all email adresses
+ $result = SQL_QUERY("SELECT `email` FROM `{?_MYSQL_PREFIX?}_admins` ORDER BY `id` ASC",
+ __FUNCTION__, __LINE__);
+ } else {
+ // If Admin-Id is not "to-all" select
+ $result = SQL_QUERY_ESC("SELECT `email` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id` IN (%s) ORDER BY `id` ASC",
+ array($adminId), __FUNCTION__, __LINE__);
+ }
+ }
+
+ // Load email addresses and send away
+ while ($content = SQL_FETCHARRAY($result)) {
+ sendEmail($content['email'], $subj, $message);
+ } // END - while
+
+ // Free memory
+ SQL_FREERESULT($result);
+}
+
+// "Getter" for current admin's expert settings
+function getAminsExpertSettings () {
+ // Default is has not the right
+ $data['expert_settings'] = 'N';
+
+ // Get current admin Id
+ $adminId = getCurrentAdminId();
+
+ // Lookup settings in cache
+ if (isset($GLOBALS['cache_array']['admin']['expert_settings'][$adminId])) {
+ // Use cache
+ $data['expert_settings'] = $GLOBALS['cache_array']['admin']['expert_settings'][$adminId];
+
+ // Update cache hits
+ incrementStatsEntry('cache_hits');
+ } elseif (!isExtensionInstalled('cache')) {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT `expert_settings` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1",
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Entry found?
+ if (SQL_NUMROWS($result) == 1) {
+ // Fetch data
+ $data = SQL_FETCHARRAY($result);
+
+ // Set cache
+ $GLOBALS['cache_array']['admin']['expert_settings'][$adminId] = $data['expert_settings'];
+ } // END - if
+
+ // Free memory
+ SQL_FREERESULT($result);
+ }
+
+ // Return the result
+ return $data['expert_settings'];
+}
+
+// "Getter" for current admin's expert warning (if he wants to see them or not
+function getAminsExpertWarning () {
+ // Default is has not the right
+ $data['expert_warning'] = 'N';
+
+ // Get current admin id
+ $adminId = getCurrentAdminId();
+
+ // Lookup warning in cache
+ if (isset($GLOBALS['cache_array']['admin']['expert_warning'][$adminId])) {
+ // Use cache
+ $data['expert_warning'] = $GLOBALS['cache_array']['admin']['expert_warning'][$adminId];
+
+ // Update cache hits
+ incrementStatsEntry('cache_hits');
+ } elseif (!isExtensionInstalled('cache')) {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT `expert_warning` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1",
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Entry found?
+ if (SQL_NUMROWS($result) == 1) {
+ // Fetch data
+ $data = SQL_FETCHARRAY($result);
+
+ // Set cache
+ $GLOBALS['cache_array']['admin']['expert_warning'][$adminId] = $data['expert_warning'];
+ } // END - if
+
+ // Free memory
+ SQL_FREERESULT($result);
+ }
+
+ // Return the result
+ return $data['expert_warning'];
+}
+
+// Get login_failures number from administrator's login name
+function getAdminLoginFailures ($adminId) {
+ // Admin login should not be empty
+ if (empty($adminId)) {
+ debug_report_bug(__FUNCTION__, __LINE__, 'adminId is empty.');
+ } // END - if
+
+ // By default no admin is found
+ $data['login_failures'] = '-1';
+
+ // Check cache
+ if (isset($GLOBALS['cache_array']['admin']['login_failures'][$adminId])) {
+ // Use it if found to save SQL queries
+ $data['login_failures'] = $GLOBALS['cache_array']['admin']['login_failures'][$adminId];
+
+ // Update cache hits
+ incrementStatsEntry('cache_hits');
+ } elseif (!isExtensionActive('cache')) {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT `login_failures` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1",
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result) == 1) {
+ // Get it
+ $data = SQL_FETCHARRAY($result);
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result);
+ }
+
+ // Return the login_failures
+ return $data['login_failures'];
+}
+
+// Get last_failure number from administrator's login name
+function getAdminLastFailure ($adminId) {
+ // Admin login should not be empty
+ if (empty($adminId)) {
+ debug_report_bug(__FUNCTION__, __LINE__, 'adminId is empty.');
+ } // END - if
+
+ // By default no admin is found
+ $data['last_failure'] = '-1';
+
+ // Check cache
+ if (isset($GLOBALS['cache_array']['admin']['last_failure'][$adminId])) {
+ // Use it if found to save SQL queries
+ $data['last_failure'] = $GLOBALS['cache_array']['admin']['last_failure'][$adminId];
+
+ // Update cache hits
+ incrementStatsEntry('cache_hits');
+ } elseif (!isExtensionActive('cache')) {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT UNIX_TIMESTAMP(`last_failure`) AS `last_failure` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1",
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result) == 1) {
+ // Get it
+ $data = SQL_FETCHARRAY($result);
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result);
+ }
+
+ // Return the last_failure
+ return $data['last_failure'];
+}
+
+//*****************************************************************************
+// Below only filter functions
+//*****************************************************************************
+