From cf60a775f4072cf6019f55d650b7336abcac70c7 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Mon, 29 Jul 2002 18:08:58 +0000 Subject: Prelim administrators management layout ... git-svn-id: file:///svn/phpbb/trunk@2789 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/admin/admin_permissions.php | 82 +++++++++++++++++---------------------- 1 file changed, 36 insertions(+), 46 deletions(-) (limited to 'phpBB/admin/admin_permissions.php') diff --git a/phpBB/admin/admin_permissions.php b/phpBB/admin/admin_permissions.php index a78f5aff98..f7c1a42c8c 100644 --- a/phpBB/admin/admin_permissions.php +++ b/phpBB/admin/admin_permissions.php @@ -258,42 +258,14 @@ if ( !empty($forum_id) || $mode == 'administrators' ) case 'administrators': - $where_user_sql = ''; - if ( !empty($HTTP_POST_VARS['users']) ) - { - if ( is_array($HTTP_POST_VARS['users']) ) - { - foreach ($HTTP_POST_VARS['users'] as $user_id) - { - $where_user_sql .= ( ( $where_user_sql != '' ) ? ', ' : '' ) . intval($user_id); - } - } - else - { - $where_user_sql = intval($HTTP_POST_VARS['users']); - } - - $where_user_sql = " AND u.user_id IN ($where_user_sql)"; - } - - $discrete_user_sql = ( empty($HTTP_POST_VARS['discrete']) || empty($HTTP_POST_VARS['users']) || is_array($HTTP_POST_VARS['users']) ) ? ' DISTINCT ' : 'ao.auth_option, '; + $sql = "SELECT group_id, group_name + FROM " . GROUPS_TABLE; + $result = $db->sql_query($sql); - $where_groups_sql = ''; - if ( !empty($HTTP_POST_VARS['groups']) ) + $group_list = ''; + while ( $row = $db->sql_fetchrow($result) ) { - if ( is_array($HTTP_POST_VARS['groups']) ) - { - foreach ($HTTP_POST_VARS['groups'] as $group_id) - { - $where_groups_sql .= ( ( $where_groups_sql != '' ) ? ', ' : '' ) . intval($group_idf); - } - } - else - { - $where_groups_sql = intval($HTTP_POST_VARS['groups']); - } - - $where_groups_sql = " AND g.group_id IN ($where_groups_sql)"; + $group_list .= ''; } ?> @@ -335,6 +307,17 @@ if ( !empty($forum_id) || $mode == 'administrators' ) } else { + $where_user_sql = ''; + if ( !empty($HTTP_POST_VARS['users']) ) + { + foreach ($HTTP_POST_VARS['users'] as $user_id) + { + $where_user_sql .= ( ( $where_user_sql != '' ) ? ', ' : '' ) . intval($user_id); + } + + $where_user_sql = " AND u.user_id IN ($where_user_sql)"; + } + $sql = "SELECT auth_option FROM " . ACL_OPTIONS_TABLE . " WHERE auth_type LIKE 'admin'"; @@ -414,17 +397,6 @@ if ( !empty($forum_id) || $mode == 'administrators' ) - - - - - - - - - - -

"> @@ -462,6 +434,24 @@ if ( !empty($forum_id) || $mode == 'administrators' ) } else { + $where_groups_sql = ''; + if ( !empty($HTTP_POST_VARS['groups']) ) + { + if ( is_array($HTTP_POST_VARS['groups']) ) + { + foreach ($HTTP_POST_VARS['groups'] as $group_id) + { + $where_groups_sql .= ( ( $where_groups_sql != '' ) ? ', ' : '' ) . intval($group_id); + } + } + else + { + $where_groups_sql = intval($HTTP_POST_VARS['groups']); + } + + $where_groups_sql = " AND g.group_id IN ($where_groups_sql)"; + } + $sql = "SELECT auth_option FROM " . ACL_OPTIONS_TABLE . " WHERE auth_type LIKE 'admin'"; @@ -534,7 +524,7 @@ if ( !empty($forum_id) || $mode == 'administrators' ) - + -- cgit v1.2.1