X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fadmins_functions.php;h=344b5909ffa60d37fa9f034c5454e8328797ef36;hb=46aeda7c31aefbe313f5c4bcf7cdbef4f1826fcc;hp=8c692aa43b70c0b986b5edc1c4b3f814cd50479f;hpb=4b32c7be676d4a191c869a5745f2890240852fb0;p=mailer.git diff --git a/inc/libs/admins_functions.php b/inc/libs/admins_functions.php index 8c692aa43b..344b5909ff 100644 --- a/inc/libs/admins_functions.php +++ b/inc/libs/admins_functions.php @@ -110,14 +110,14 @@ function adminsCheckAdminAcl ($action, $what) { } // Check ACL and (maybe) allow - //* DEBUG: */ print 'default='.$default.',acl_mode='.$acl_mode.',parent='.intval($parent).'
'; + //* DEBUG: */ debugOutput('default='.$default.',acl_mode='.$acl_mode.',parent='.intval($parent)); if (($default == 'allow') || (($default == 'deny') && ($acl_mode == 'allow')) || ($parent === true) || (($default == '***') && ($acl_mode == 'failed') && ($parent === false))) { // Access is granted $ret = true; } // END - if // Return value - //* DEBUG: */ outputHtml(__FUNCTION__."[".__LINE__."]:act={$action},wht={$whatOR},default={$default},acl_mode={$acl_mode}
"); + //* DEBUG: */ debugOutput(__FUNCTION__.'['.__LINE__.']:act='.$action.',wht='.$what.',default='.$default.',acl_mode='.$acl_mode); return $ret; } @@ -166,10 +166,10 @@ function adminsChangeAdminAccount ($postData, $element = '') { if ((!empty($element)) && (isset($postData[$element]))) { // Save this setting SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admins` SET `%s`='%s' WHERE `id`=%s LIMIT 1", - array($element, $postData[$element][$id], $id), __FILE__, __LINE__); + array($element, $postData[$element][$id], $id), __FUNCTION__, __LINE__); // Admin account saved - $message = getMessage('ADMIN_ACCOUNT_SAVED'); + $message = '{--ADMIN_ACCOUNT_SAVED--}'; } elseif ((isset($postData['pass1'])) && (isset($postData['pass2']))) { // Update only if both passwords match if (($postData['pass1'][$id] == $postData['pass2'][$id])) { @@ -191,9 +191,9 @@ function adminsChangeAdminAccount ($postData, $element = '') { // Set timeout cookie setSession('admin_last', time()); - if ($login != getSession('admin_login')) { + if ($adminId != getSession('admin_id')) { // Update login cookie - setSession('admin_login', $login); + setSession('admin_id', $adminId); // Update password cookie as well? if (!empty($add)) setSession('admin_md5', $hash); @@ -212,7 +212,7 @@ function adminsChangeAdminAccount ($postData, $element = '') { SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admins` SET - `login`='%s'".$add.", + `login`='%s'" . $add . ", `email`='%s', `default_acl`='%s', `la_mode`='%s' @@ -231,7 +231,7 @@ LIMIT 1", SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_admins` SET - `login`='%s'".$add.", + `login`='%s'" . $add . ", `email`='%s', `la_mode`='%s' WHERE @@ -246,10 +246,10 @@ LIMIT 1", } // Admin account saved - $message = getMessage('ADMIN_ACCOUNT_SAVED'); + $message = '{--ADMIN_ACCOUNT_SAVED--}'; } else { // Passwords did not match - $message = getMessage('ADMINS_ERROR_PASS_MISMATCH'); + $message = '{--ADMINS_ERROR_PASS_MISMATCH--}'; } } else { // Update whole array @@ -291,7 +291,7 @@ function adminsEditAdminAccount ($postData) { $currMode = getAdminDefaultAcl(getCurrentAdminId()); // Begin the edit loop - $OUT = ''; $SW = 2; + $OUT = ''; foreach ($postData['sel'] as $id => $selected) { // Secure id number $id = bigintval($id); @@ -305,24 +305,22 @@ function adminsEditAdminAccount ($postData) { SQL_FREERESULT($result); // Prepare some more data for the template - $content['sw'] = $SW; $content['id'] = $id; // Shall we allow changing default ACL? if ($currMode == 'allow') { // Allow chaning it - $content['mode'] = generateOptionList('/ARRAY/', array('allow', 'deny'), array(getMessage('ADMINS_ALLOW_MODE'), getMessage('ADMINS_DENY_MODE')), $content['mode']); + $content['mode'] = generateOptionList('/ARRAY/', array('allow', 'deny'), array('{--ADMINS_ALLOW_MODE--}', '{--ADMINS_DENY_MODE--}'), $content['mode']); } else { // Don't allow it $content['mode'] = ' '; } - $content['la_mode'] = generateOptionList('/ARRAY/', array('global', 'OLD', 'NEW'), array(getMessage('ADMINS_GLOBAL_LA_SETTING'), getMessage('ADMINS_OLD_LA_SETTING'), getMessage('ADMINS_NEW_LA_SETTING')), $content['la_mode']); + $content['la_mode'] = generateOptionList('/ARRAY/', array('global', 'OLD', 'NEW'), array('{--ADMINS_GLOBAL_LA_SETTING--}', '{--ADMINS_OLD_LA_SETTING--}', '{--ADMINS_NEW_LA_SETTING--}'), $content['la_mode']); // Load row template and switch color $OUT .= loadTemplate('admin_edit_admins_row', true, $content); - $SW = 3 - $SW; - } - } + } // END - if + } // END - foreach // Load template loadTemplate('admin_edit_admins', false, $OUT); @@ -336,7 +334,7 @@ function adminsDeleteAdminAccount ($postData) { SQL_FREERESULT($result_main); if ($accounts > 1) { // Delete accounts - $OUT = ''; $SW = 2; + $OUT = ''; foreach ($postData['sel'] as $id => $selected) { // Secure id number $id = bigintval($id); @@ -348,24 +346,22 @@ function adminsDeleteAdminAccount ($postData) { // Entry found $content = SQL_FETCHARRAY($result); SQL_FREERESULT($result); - $content['mode'] = getMessage('ADMINS_'.strtoupper($content['mode']).'_MODE'); - $content['la_mode'] = getMessage('ADMINS_'.strtoupper($content['la_mode']).'_LA_SETTING'); + $content['mode'] = '{--ADMINS_' . strtoupper($content['mode']) . '_MODE--}'; + $content['la_mode'] = '{--ADMINS_' . strtoupper($content['la_mode']) . '_LA_SETTING--}'; // Prepare some more data - $content['sw'] = $SW; $content['id'] = $id; // Load row template and switch color $OUT .= loadTemplate('admin_del_admins_row', true, $content); - $SW = 3 - $SW; - } - } + } // END - if + } // END - foreach // Load template loadTemplate('admin_del_admins', false, $OUT); } else { // Cannot delete last account! - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_ADMINS_CANNOT_DELETE_LAST')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_ADMINS_CANNOT_DELETE_LAST--}'); } } @@ -397,20 +393,18 @@ function adminsRemoveAdminAccount ($postData) { function adminsListAdminAccounts() { // Select all admin accounts $result = SQL_QUERY("SELECT `id`, `login`, `email`, `default_acl` AS mode, `la_mode` FROM `{?_MYSQL_PREFIX?}_admins` ORDER BY `login` ASC", __FUNCTION__, __LINE__); - $OUT = ''; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { // Compile some variables - $content['mode'] = getMessage('ADMINS_'.strtoupper($content['mode']).'_MODE'); - $content['la_mode'] = getMessage('ADMINS_'.strtoupper($content['la_mode']).'_LA_SETTING'); + $content['mode'] = '{--ADMINS_' . strtoupper($content['mode']) . '_MODE--}'; + $content['la_mode'] = '{--ADMINS_' . strtoupper($content['la_mode']) . '_LA_SETTING--}'; // Prepare some more data - $content['sw'] = $SW; $content['email_link'] = generateEmailLink($content['id'], 'admins'); // Load row template and switch color $OUT .= loadTemplate('admin_list_admins_row', true, $content); - $SW = 3 - $SW; - } + } // END - while // Free memory SQL_FREERESULT($result); @@ -488,20 +482,20 @@ function getAminsExpertSettings () { // Default is has not the right $data['expert_settings'] = 'N'; - // Get current admin login - $admin = getAdminLogin(getCurrentAdminId()); + // Get current admin Id + $adminId = getCurrentAdminId(); // Lookup settings in cache - if (isset($GLOBALS['cache_array']['admin']['expert_settings'][$admin])) { + if (isset($GLOBALS['cache_array']['admin']['expert_settings'][$adminId])) { // Use cache - $data['expert_settings'] = $GLOBALS['cache_array']['admin']['expert_settings'][$admin]; + $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 `login`='%s' LIMIT 1", - array($admin), __FUNCTION__, __LINE__); + $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) { @@ -509,7 +503,7 @@ function getAminsExpertSettings () { $data = SQL_FETCHARRAY($result); // Set cache - $GLOBALS['cache_array']['admin']['expert_settings'][$admin] = $data['expert_settings']; + $GLOBALS['cache_array']['admin']['expert_settings'][$adminId] = $data['expert_settings']; } // END - if // Free memory @@ -525,20 +519,20 @@ function getAminsExpertWarning () { // Default is has not the right $data['expert_warning'] = 'N'; - // Get current admin login - $admin = getAdminLogin(getCurrentAdminId()); + // Get current admin id + $adminId = getCurrentAdminId(); // Lookup warning in cache - if (isset($GLOBALS['cache_array']['admin']['expert_warning'][$admin])) { + if (isset($GLOBALS['cache_array']['admin']['expert_warning'][$adminId])) { // Use cache - $data['expert_warning'] = $GLOBALS['cache_array']['admin']['expert_warning'][$admin]; + $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 `login`='%s' LIMIT 1", - array($admin), __FUNCTION__, __LINE__); + $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) { @@ -546,7 +540,7 @@ function getAminsExpertWarning () { $data = SQL_FETCHARRAY($result); // Set cache - $GLOBALS['cache_array']['admin']['expert_warning'][$admin] = $data['expert_warning']; + $GLOBALS['cache_array']['admin']['expert_warning'][$adminId] = $data['expert_warning']; } // END - if // Free memory @@ -558,26 +552,26 @@ function getAminsExpertWarning () { } // Get login_failures number from administrator's login name -function getAdminLoginFailures ($adminLogin) { +function getAdminLoginFailures ($adminId) { // Admin login should not be empty - if (empty($adminLogin)) { - debug_report_bug('adminLogin is 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'][$adminLogin])) { + 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'][$adminLogin]; + $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 `login`='%s' LIMIT 1", - array($adminLogin), __FUNCTION__, __LINE__); + $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) { @@ -594,26 +588,26 @@ function getAdminLoginFailures ($adminLogin) { } // Get last_failure number from administrator's login name -function getAdminLastFailure ($adminLogin) { +function getAdminLastFailure ($adminId) { // Admin login should not be empty - if (empty($adminLogin)) { - debug_report_bug('adminLogin is 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'][$adminLogin])) { + 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'][$adminLogin]; + $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 `login`='%s' LIMIT 1", - array($adminLogin), __FUNCTION__, __LINE__); + $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) { @@ -636,10 +630,10 @@ function getAdminLastFailure ($adminLogin) { // Filter for adding extra data to the query function FILTER_ADD_EXTRA_SQL_DATA ($add = '') { // Is the admins extension updated? (should be!) - if (getExtensionVersion('admins') >= '0.3.0') $add .= ', `default_acl` AS def_acl'; - if (getExtensionVersion('admins') >= '0.6.7') $add .= ', `la_mode`'; - if (getExtensionVersion('admins') >= '0.7.2') $add .= ', `login_failures`, UNIX_TIMESTAMP(`last_failure`) AS last_failure'; - if (getExtensionVersion('admins') >= '0.7.3') $add .= ', `expert_settings`, `expert_warning`'; + 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; @@ -648,8 +642,8 @@ function FILTER_ADD_EXTRA_SQL_DATA ($add = '') { // Reset the login failures function FILTER_RESET_ADMINS_LOGIN_FAILURES ($data) { // Store it in session - setSession('mxchange_admin_failures' , getAdminLoginFailures($data['login'])); - setSession('mxchange_admin_last_failure', getAdminLastFailure($data['login'])); + setSession('mailer_admin_failures' , getAdminLoginFailures($data['id'])); + setSession('mailer_admin_last_failure', getAdminLastFailure($data['id'])); // Prepare update data $postData['login'][getCurrentAdminId()] = $data['login'];