// Edit ACLs
$OUT = ''; $SW = 2;
foreach (postRequestElement('sel') as $id => $selected) {
- // Load data for the ID
+ // Load data for the id
$result = SQL_QUERY_ESC("SELECT admin_id, action_menu, what_menu, access_mode FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
list($adminId, $action, $what, $mode) = SQL_FETCHROW($result);
} elseif ((isPostRequestElementSet('change')) && ($SEL > 0)) {
// Change entries
foreach (postRequestElement('sel') as $id => $selected) {
- // Secure ID
+ // Secure id
$id = bigintval($id);
// Update entries
// Update cache when installed
if (isExtensionActive('cache')) {
- if ($GLOBALS['cache_instance']->loadCacheFile('admins_acls')) $GLOBALS['cache_instance']->removeCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile('admin_acls')) $GLOBALS['cache_instance']->removeCacheFile();
} // END - if
// Entries changed
// Delete ACLs
$OUT = ''; $SW = 2;
foreach (postRequestElement('sel') as $id => $selected) {
- // Load data for the ID
+ // Load data for the id
$result = SQL_QUERY_ESC("SELECT admin_id, action_menu, what_menu, access_mode FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
list($admin, $action, $what, $mode) = SQL_FETCHROW($result);
// Update cache when installed
if (isExtensionActive('cache')) {
- if ($GLOBALS['cache_instance']->loadCacheFile('admins_acls')) $GLOBALS['cache_instance']->removeCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile('admin_acls')) $GLOBALS['cache_instance']->removeCacheFile();
} // END - if
// Entries deleted
// Update cache when installed
if (isExtensionActive('cache')) {
- if ($GLOBALS['cache_instance']->loadCacheFile('admins_acls')) $GLOBALS['cache_instance']->removeCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile('admin_acls')) $GLOBALS['cache_instance']->removeCacheFile();
} // END - if
} else {
// ACL does already exist!
loadTemplate('admin_settings_saved', false, $content);
} else {
// List all ACLs
- $result_acls = SQL_QUERY("SELECT id, admin_id, action_menu, what_menu, access_mode FROM `{?_MYSQL_PREFIX?}_admins_acls` ORDER BY admin_id, id", __FILE__, __LINE__);
+ $result_acls = SQL_QUERY('SELECT `id`, `admin_id`, `action_menu`, `what_menu`, `access_mode` FROM `{?_MYSQL_PREFIX?}_admins_acls` ORDER BY `admin_id` ASC, `id` ASC', __FILE__, __LINE__);
// Entries found?
if (SQL_NUMROWS($result_acls) > 0) {