// Delete given admin accounts
function adminsDeleteAdminAccount ($postData) {
// Check if this account is the last one which cannot be deleted...
// Delete given admin accounts
function adminsDeleteAdminAccount ($postData) {
// Check if this account is the last one which cannot be deleted...
- $result_main = SQL_QUERY("SELECT `id` FROM `{?_MYSQL_PREFIX?}_admins`", __FUNCTION__, __LINE__);
- $accounts = SQL_NUMROWS($result_main);
- SQL_FREERESULT($result_main);
- if ($accounts > 1) {
+ if (countSumTotalData('', 'admins', 'id', '', true) > 1) {
- $result = SQL_QUERY_ESC("SELECT login, email, default_acl AS mode, la_mode FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `login`, `email`, `default_acl` AS `mode`, `la_mode` FROM `{?_MYSQL_PREFIX?}_admins` WHERE `id`=%s LIMIT 1",
$content['mode'] = '{--ADMINS_' . strtoupper($content['mode']) . '_MODE--}';
$content['la_mode'] = '{--ADMINS_' . strtoupper($content['la_mode']) . '_LA_SETTING--}';
$content['mode'] = '{--ADMINS_' . strtoupper($content['mode']) . '_MODE--}';
$content['la_mode'] = '{--ADMINS_' . strtoupper($content['la_mode']) . '_LA_SETTING--}';
// Load row template and switch color
$OUT .= loadTemplate('admin_del_admins_row', true, $content);
} // END - if
// Load row template and switch color
$OUT .= loadTemplate('admin_del_admins_row', true, $content);
} // END - if
}
// List all admin accounts
function adminsListAdminAccounts() {
// Select all admin accounts
}
// List all admin accounts
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__);
+ $result = SQL_QUERY('SELECT `id`, `login`, `email`, `default_acl` AS mode, `la_mode` FROM `{?_MYSQL_PREFIX?}_admins` ORDER BY `login` ASC', __FUNCTION__, __LINE__);
$OUT = '';
while ($content = SQL_FETCHARRAY($result)) {
// Compile some variables
$content['mode'] = '{--ADMINS_' . strtoupper($content['mode']) . '_MODE--}';
$content['la_mode'] = '{--ADMINS_' . strtoupper($content['la_mode']) . '_LA_SETTING--}';
$OUT = '';
while ($content = SQL_FETCHARRAY($result)) {
// Compile some variables
$content['mode'] = '{--ADMINS_' . strtoupper($content['mode']) . '_MODE--}';
$content['la_mode'] = '{--ADMINS_' . strtoupper($content['la_mode']) . '_LA_SETTING--}';
// Load row template and switch color
$OUT .= loadTemplate('admin_list_admins_row', true, $content);
} // END - while
// Load row template and switch color
$OUT .= loadTemplate('admin_list_admins_row', true, $content);
} // END - while
- $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__);
- $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__);
- if (empty($adminLogin)) {
- debug_report_bug(__FUNCTION__, __LINE__, 'adminLogin is empty.');
+ if (empty($adminId)) {
+ debug_report_bug(__FUNCTION__, __LINE__, 'adminId is empty.');
- $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__);
- if (empty($adminLogin)) {
- debug_report_bug(__FUNCTION__, __LINE__, 'adminLogin is empty.');
+ if (empty($adminId)) {
+ debug_report_bug(__FUNCTION__, __LINE__, 'adminId is empty.');
- $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__);
-//*****************************************************************************
-// Below only filter functions
-//*****************************************************************************
+//-----------------------------------------------------------------------------
+// Filter Functions
+//-----------------------------------------------------------------------------
- setSession('mailer_admin_failures' , getAdminLoginFailures($data['login']));
- setSession('mailer_admin_last_failure', getAdminLastFailure($data['login']));
+ setSession('mailer_admin_failures' , getAdminLoginFailures($data['id']));
+ setSession('mailer_admin_last_failure', getAdminLastFailure($data['id']));