$OUT = '';
foreach (postRequestParameter('sel') as $id => $selected) {
// 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",
+ $result = SQL_QUERY_ESC("SELECT `id`, `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);
+ $content = SQL_FETCHARRAY($result);
+
+ // Free result
SQL_FREERESULT($result);
// Prepare data for the row template
$content = array(
- 'id' => $id,
- 'admins_selection' => generateOptionList('admins', 'id', 'login', $adminId, 'default_acl'),
- 'action_selection' => adminMenuSelectionBox_DEPRECATED('action', $action, $id),
- 'what_selection' => adminMenuSelectionBox_DEPRECATED('what', $what, $id),
+ 'id' => $content['id'],
+ 'admins_selection' => generateOptionList('admins', 'id', 'login', $content['admin_id'], 'default_acl'),
+ 'action_selection' => adminMenuSelectionBox_DEPRECATED('action', $content['action_menu'], $content['id']),
+ 'what_selection' => adminMenuSelectionBox_DEPRECATED('what', $content['what_menu'], $content['id']),
'mode_options' => generateOptionList(
'/ARRAY/',
array('allow', 'deny'),
'{--ADMINS_ALLOW_MODE--}',
'{--ADMINS_DENY_MODE--}'
),
- $mode
+ $content['access_mode']
),
);
$BOTH = ((isPostRequestParameterSet('action_menu')) && (isPostRequestParameterSet('what_menu')));
if (((isPostRequestParameterSet('action_menu')) || (isPostRequestParameterSet('what_menu'))) && ($BOTH === false)) {
// Main or sub menu selected
- $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE admin_id=%s AND action_menu='%s' AND what_menu='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_admins_acls` WHERE `admin_id`=%s AND `action_menu`='%s' AND `what_menu`='%s' LIMIT 1",
array(bigintval(postRequestParameter('admin_id')), postRequestParameter('action_menu'), postRequestParameter('what_menu')), __FILE__, __LINE__);
if (SQL_HASZERONUMS($result)) {
// Finally add the new ACL
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_admins_acls` (admin_id, action_menu, what_menu, access_mode)
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_admins_acls` (`admin_id`, `action_menu`, `what_menu`, `access_mode`)
VALUES ('%s','%s','%s','%s')",
array(
bigintval(postRequestParameter('admin_id')),
'/ARRAY/',
array('allow', 'deny'),
array(
- 'ADMINS_ALLOW_MODE--}',
- 'ADMINS_DENY_MODE--}'
+ '{--ADMINS_ALLOW_MODE--}',
+ '{--ADMINS_DENY_MODE--}'
)
);
// Load template for adding new ACL
- loadTemplate('admin_admins_add_acl', false, $content);
+ loadTemplate('admin_add_admins_acl', false, $content);
}
// [EOF]