+// Sends out mail to all administrators
+// IMPORTANT: Please use sendAdminNotification() instead of calling this function directly
+function sendAdminsEmails ($subject, $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 = sqlQueryEscaped("SELECT `admin_id` FROM `{?_MYSQL_PREFIX?}_admins_mails` WHERE `mail_template`='%s' ORDER BY `admin_id` ASC",
+ array($template), __FUNCTION__, __LINE__);
+
+ // No entries found?
+ if (ifSqlHasZeroNums($result)) {
+ // Is ext-admins' version at least 0.7.9?
+ if (isExtensionInstalledAndNewer('admins', '0.7.9')) {
+ // Create new entry (to all admins)
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_admins_mails` (`admin_id`, `mail_template`) VALUES (NULL, '%s')",
+ array($template), __FUNCTION__, __LINE__);
+ } // END - if
+
+ // Select all email adresses (default)
+ $result = sqlQuery('SELECT `email` FROM `{?_MYSQL_PREFIX?}_admins` ORDER BY `id` ASC',
+ __FUNCTION__, __LINE__);
+ } else {
+ // Load admin ids...
+ // @TODO This can be, somehow, rewritten
+ $adminIds = array();
+ while ($content = sqlFetchArray($result)) {
+ array_push($adminIds, $content['admin_id']);
+ } // END - while
+
+ // Free memory
+ sqlFreeResult($result);
+
+ // Init result
+ $result = FALSE;
+
+ // "implode" ids and query string
+ $adminId = implode(',', $adminIds);
+
+ // To which admin shall we sent it?
+ if ($adminId == '-1') {
+ // Is an "event"
+ if (isExtensionActive('events')) {
+ // Add line to user events
+ EVENTS_ADD_LINE($subject, $message, $userid);
+ } else {
+ // Log error for debug
+ logDebugMessage(__FUNCTION__, __LINE__, sprintf('Extension ext-events missing: template=%s,subj=%s,userid=%s',
+ $template,
+ $subject,
+ $userid
+ ));
+ }
+
+ // Abort here as below while() loop will cause problems
+ return;
+ } elseif (($adminId == '0') || (empty($adminId))) {
+ // Select all email adresses
+ $result = sqlQuery('SELECT `email` FROM `{?_MYSQL_PREFIX?}_admins` ORDER BY `id` ASC',
+ __FUNCTION__, __LINE__);
+ } else {
+ // If Admin-Id is not "to-all" select
+ $result = sqlQueryEscaped('SELECT `email` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id` IN (%s) ORDER BY `id` ASC',
+ array($adminId), __FUNCTION__, __LINE__);
+ }
+ }
+
+ // Default is no special mail header
+ $mailHeader = '';
+
+ // Is the template a bug report?
+ if ($template == 'admin_report_bug') {
+ // Then set 'Reply-To:' again
+ $mailHeader = 'Reply-To: webmaster@mxchange.org' . PHP_EOL;
+ } // END - if
+
+ // Load email addresses and send away
+ while ($content = sqlFetchArray($result)) {
+ sendEmail($content['email'], $subject, $message, 'N', $mailHeader);
+ } // END - while
+
+ // Free memory
+ sqlFreeResult($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 = sqlQueryEscaped('SELECT `expert_settings` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1',
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Entry found?
+ if (sqlNumRows($result) == 1) {
+ // Fetch data
+ $data = sqlFetchArray($result);
+
+ // Set cache
+ $GLOBALS['cache_array']['admin']['expert_settings'][$adminId] = $data['expert_settings'];
+ } // END - if
+
+ // Free memory
+ sqlFreeResult($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 = sqlQueryEscaped('SELECT `expert_warning` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1',
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Entry found?
+ if (sqlNumRows($result) == 1) {
+ // Fetch data
+ $data = sqlFetchArray($result);
+
+ // Set cache
+ $GLOBALS['cache_array']['admin']['expert_warning'][$adminId] = $data['expert_warning'];
+ } // END - if
+
+ // Free memory
+ sqlFreeResult($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)) {
+ reportBug(__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 = sqlQueryEscaped('SELECT `login_failures` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1',
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Is there an entry?
+ if (sqlNumRows($result) == 1) {
+ // Get it
+ $data = sqlFetchArray($result);
+ } // END - if
+
+ // Free result
+ sqlFreeResult($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)) {
+ reportBug(__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 = sqlQueryEscaped('SELECT UNIX_TIMESTAMP(`last_failure`) AS `last_failure` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1',
+ array($adminId), __FUNCTION__, __LINE__);
+
+ // Is there an entry?
+ if (sqlNumRows($result) == 1) {
+ // Get it
+ $data = sqlFetchArray($result);
+ } // END - if
+
+ // Free result
+ sqlFreeResult($result);
+ }
+
+ // Return the last_failure
+ return $data['last_failure'];
+}
+
+//-----------------------------------------------------------------------------
+// Wrapper functions
+//-----------------------------------------------------------------------------
+
+// Wrapper function to check whether expert setting warning is enabled
+function isAdminsExpertWarningEnabled () {
+ return (getAminsExpertWarning() == 'Y');
+}