{

$sql = 'SELECT auth_option_id, auth_option

FROM ' . ACL_OPTIONS_TABLE . "

AND auth_option <> '{$permission_type}'

ORDER BY auth_option_id";

$result = $db->sql_query($sql);

// We need to fill the auth options array with ACL_NO options ;)

$sql = 'SELECT auth_option_id, auth_option

FROM ' . ACL_OPTIONS_TABLE . "

AND auth_option <> '{$permission_type}'

ORDER BY auth_option_id";

$result = $db->sql_query($sql);

// Get complete auth array

$sql = 'SELECT auth_option, auth_option_id

FROM ' . ACL_OPTIONS_TABLE . "

$result = $db->sql_query($sql);

$auth_settings = array();

global $db, $user;

$sql_forum_id = ($permission_scope == 'global') ? 'AND a.forum_id = 0' : ((sizeof($forum_id)) ? 'AND ' . $db->sql_in_set('a.forum_id', $forum_id) : 'AND a.forum_id <> 0');

$sql = $db->sql_build_query('SELECT_DISTINCT', array(

'SELECT' => 'u.username, u.username_clean, u.user_regdate, u.user_id',

$sort_by_types = array('username', 'user_email', 'user_posts', 'user_regdate', 'user_lastvisit');

$where_sql = '';

$where_sql .= (sizeof($joined)) ? " AND user_regdate " . $key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, (int) $joined[1], (int) $joined[2], (int) $joined[0]) : '';

$where_sql .= ($count !== '') ? " AND user_posts " . $key_match[$count_select] . ' ' . (int) $count . ' ' : '';

$where_sql .= (sizeof($active)) ? " AND user_lastvisit " . $key_match[$active_select] . " " . gmmktime(0, 0, 0, (int) $active[1], (int) $active[2], (int) $active[0]) : '';

// Select auth options

$sql = 'SELECT auth_option, is_local, is_global

FROM ' . ACL_OPTIONS_TABLE . '

AND is_global = 1

ORDER BY auth_option';

$result = $db->sql_query($sql);

{

$sql = 'SELECT auth_option, is_local, is_global

FROM ' . ACL_OPTIONS_TABLE . "

AND is_local = 1

ORDER BY is_global DESC, auth_option";

$result = $db->sql_query($sql);

// Get permission type

$sql = 'SELECT auth_option, auth_option_id

FROM ' . ACL_OPTIONS_TABLE . "

$result = $db->sql_query($sql);

$auth_id_ary = array();