+// "Getter" for current admin's expert settings
+function getAminsExpertSettings () {
+ // Default is has not the right
+ $data['expert_settings'] = 'N';
+
+ // Get current admin login
+ $admin = getAdminLogin(getCurrentAdminId());
+
+ // Lookup settings in cache
+ if (isset($GLOBALS['cache_array']['admin']['expert_settings'][$admin])) {
+ // Use cache
+ $data['expert_settings'] = $GLOBALS['cache_array']['admin']['expert_settings'][$admin];
+
+ // Update cache hits
+ incrementStatsEntry('cache_hits');
+ } elseif (!isExtensionInstalled('cache')) {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT `expert_settings` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `login`='%s' LIMIT 1",
+ array($admin), __FUNCTION__, __LINE__);
+
+ // Entry found?
+ if (SQL_NUMROWS($result) == 1) {
+ // Fetch data
+ $data = SQL_FETCHARRAY($result);
+
+ // Set cache
+ $GLOBALS['cache_array']['admin']['expert_settings'][$admin] = $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 login
+ $admin = getAdminLogin(getCurrentAdminId());
+
+ // Lookup warning in cache
+ if (isset($GLOBALS['cache_array']['admin']['expert_warning'][$admin])) {
+ // Use cache
+ $data['expert_warning'] = $GLOBALS['cache_array']['admin']['expert_warning'][$admin];
+
+ // Update cache hits
+ incrementStatsEntry('cache_hits');
+ } elseif (!isExtensionInstalled('cache')) {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT `expert_warning` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `login`='%s' LIMIT 1",
+ array($admin), __FUNCTION__, __LINE__);
+
+ // Entry found?
+ if (SQL_NUMROWS($result) == 1) {
+ // Fetch data
+ $data = SQL_FETCHARRAY($result);
+
+ // Set cache
+ $GLOBALS['cache_array']['admin']['expert_warning'][$admin] = $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 ($adminLogin) {
+ // Admin login should not be empty
+ if (empty($adminLogin)) {
+ debug_report_bug('adminLogin is empty.');
+ } // END - if
+
+ // By default no admin is found
+ $data['login_failures'] = '-1';
+
+ // Check cache
+ if (isset($GLOBALS['cache_array']['admin']['login_failures'][$adminLogin])) {
+ // Use it if found to save SQL queries
+ $data['login_failures'] = $GLOBALS['cache_array']['admin']['login_failures'][$adminLogin];
+
+ // Update cache hits
+ incrementStatsEntry('cache_hits');
+ } elseif (!isExtensionActive('cache')) {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT `login_failures` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `login`='%s' LIMIT 1",
+ array($adminLogin), __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 ($adminLogin) {
+ // Admin login should not be empty
+ if (empty($adminLogin)) {
+ debug_report_bug('adminLogin is empty.');
+ } // END - if
+
+ // By default no admin is found
+ $data['last_failure'] = '-1';
+
+ // Check cache
+ if (isset($GLOBALS['cache_array']['admin']['last_failure'][$adminLogin])) {
+ // Use it if found to save SQL queries
+ $data['last_failure'] = $GLOBALS['cache_array']['admin']['last_failure'][$adminLogin];
+
+ // 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 `login`='%s' LIMIT 1",
+ array($adminLogin), __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
+//*****************************************************************************
+
+// Filter for adding extra data to the query
+function FILTER_ADD_EXTRA_SQL_DATA ($add = '') {
+ // Is the admins extension updated? (should be!)
+ if (isExtensionInstalledAndNewer('admins', '0.3.0')) $add .= ', `default_acl` AS def_acl';
+ if (isExtensionInstalledAndNewer('admins', '0.6.7')) $add .= ', `la_mode`';
+ if (isExtensionInstalledAndNewer('admins', '0.7.2')) $add .= ', `login_failures`, UNIX_TIMESTAMP(`last_failure`) AS last_failure';
+ if (isExtensionInstalledAndNewer('admins', '0.7.3')) $add .= ', `expert_settings`, `expert_warning`';
+
+ // Return it
+ return $add;
+}
+
+// Reset the login failures
+function FILTER_RESET_ADMINS_LOGIN_FAILURES ($data) {
+ // Store it in session
+ setSession('mailer_admin_failures' , getAdminLoginFailures($data['login']));
+ setSession('mailer_admin_last_failure', getAdminLastFailure($data['login']));
+
+ // Prepare update data
+ $postData['login'][getCurrentAdminId()] = $data['login'];
+ $postData['login_failures'][getCurrentAdminId()] = '0';
+ $postData['last_failure'][getCurrentAdminId()] = '0000-00-00 00:00:00';
+
+ // Change it in the admin
+ adminsChangeAdminAccount($postData);
+
+ // Always make sure the cache is destroyed
+ rebuildCache('admin');
+
+ // Return the data for further processing
+ return $data;
+}
+
+// Count the login failure
+function FILTER_COUNT_ADMINS_LOGIN_FAILURE ($data) {
+ // Prepare update data
+ $postData['login'][getCurrentAdminId()] = $data['login'];
+ $postData['login_failures'][getCurrentAdminId()] = '`login_failures`+1';
+ $postData['last_failure'][getCurrentAdminId()] = 'NOW()';
+
+ // Change it in the admin
+ adminsChangeAdminAccount($postData);
+
+ // Always make sure the cache is destroyed
+ rebuildCache('admin');
+
+ // Return the data for further processing
+ return $data;
+}
+
+// Rehashes the given plain admin password and stores it the database
+function FILTER_REHASH_ADMINS_PASSWORD ($data) {
+ // Generate new hash
+ $newHash = generateHash($data['plain_pass']);
+
+ // Prepare update data
+ $postData['login'][getCurrentAdminId()] = $data['login'];
+ $postData['password'][getCurrentAdminId()] = $newHash;
+
+ // Change it in the admin
+ adminsChangeAdminAccount($postData);
+
+ // Update cookie/session and data array
+ setSession('admin_md5', encodeHashForCookie($newHash));
+ $data['pass_hash'] = $newHash;
+
+ // Always make sure the cache is destroyed
+ rebuildCache('admin');
+
+ // Return the data for further processing
+ return $data;
+}
+