$sql = 'SELECT auth_option_id, auth_option, is_global, is_local

FROM ' . ACL_OPTIONS_TABLE . '

ORDER BY auth_option_id';

$global = $local = 0;

$this->acl_options = array();

{

if ($row['is_global'])

{

$this->acl_options['id'][$row['auth_option']] = (int) $row['auth_option_id'];

$this->acl_options['option'][(int) $row['auth_option_id']] = $row['auth_option'];

}

phpbb::$acm->put('acl_options', $this->acl_options);

}

{

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE;

{

$forum_ids[] = (int) $row['forum_id'];

}

}

if ($view_user_mask)

$sql = 'SELECT user_id, user_permissions, user_type

FROM ' . USERS_TABLE . '

{

if (phpbb::$user->data['user_id'] != $userdata['user_id'])

{

}

}

}

unset($userdata);

unset($auth2);

FROM ' . ACL_USERS_TABLE . '

WHERE auth_role_id = ' . $role_id . '

ORDER BY forum_id';

{

$hold_ary[$row['forum_id']]['users'][] = $row['user_id'];

}

// Now grab groups...

$sql = 'SELECT group_id, forum_id

FROM ' . ACL_GROUPS_TABLE . '

WHERE auth_role_id = ' . $role_id . '

ORDER BY forum_id';

{

$hold_ary[$row['forum_id']]['groups'][] = $row['group_id'];

}

return $hold_ary;

}

{

$sql = 'SELECT user_id as ug_id, username as ug_name

FROM ' . USERS_TABLE . '

ORDER BY username_clean ASC';

}

else

{

$sql = 'SELECT group_id as ug_id, group_name as ug_name, group_type

FROM ' . GROUPS_TABLE . '

ORDER BY group_type DESC, group_name ASC';

}

$ug_names_ary = array();

{

$ug_names_ary[$row['ug_id']] = ($user_mode == 'user') ? $row['ug_name'] : (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['ug_name']] : $row['ug_name']);

}

// Get used forums

$forum_ids = array();

// Get available roles

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . "

ORDER BY role_order ASC";

$roles = array();

{

$roles[$row['role_id']] = $row;

}

$cur_roles = $this->acl_role_data($user_mode, $permission_type, array_keys($hold_ary));

$sql = 'SELECT r.role_id, o.auth_option, r.auth_setting

FROM ' . ACL_ROLES_DATA_TABLE . ' r, ' . ACL_OPTIONS_TABLE . ' o

WHERE o.auth_option_id = r.auth_option_id

{

$flag = substr($row['auth_option'], 0, strpos($row['auth_option'], '_') + 1);

if ($flag == $row['auth_option'])

$s_role_js_array[$row['role_id']] .= 'role_options[' . $row['role_id'] . '][\'' . addslashes($row['auth_option']) . '\'] = ' . $row['auth_setting'] . '; ';

}

$s_role_js_array = implode('', $s_role_js_array);

}

$sql = 'SELECT group_id, group_name, group_type

FROM ' . GROUPS_TABLE . '

ORDER BY group_type DESC, group_name ASC';

$groups = array();

{

$groups[$row['group_id']] = $row;

}

$memberships = group_memberships(false, array_keys($hold_ary), false);

// Get forum names

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE . '

ORDER BY left_id';

// If the role is used globally, then reflect that

$forum_names = (isset($hold_ary[0])) ? array(0 => '') : array();

{

$forum_names[$row['forum_id']] = $row['forum_name'];

}

foreach ($forum_names as $forum_id => $forum_name)

{

{

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

ORDER BY username_clean ASC';

{

$template->assign_block_vars('role_mask.users', array(

'USER_ID' => $row['user_id'],

'U_PROFILE' => append_sid('memberlist', "mode=viewprofile&u={$row['user_id']}"))

);

}

}

if (isset($auth_ary['groups']) && sizeof($auth_ary['groups']))

{

$sql = 'SELECT group_id, group_name, group_type

FROM ' . GROUPS_TABLE . '

ORDER BY group_type ASC, group_name';

{

$template->assign_block_vars('role_mask.groups', array(

'GROUP_ID' => $row['group_id'],

'U_PROFILE' => append_sid('memberlist', "mode=group&g={$row['group_id']}"))

);

}

}

}

}

$sql = 'SELECT auth_option, is_global, is_local

FROM ' . ACL_OPTIONS_TABLE . '

ORDER BY auth_option_id';

{

if ($row['is_global'])

{

$cur_options['local'][] = $row['auth_option'];

}

}

// Here we need to insert new options ... this requires discovering whether

// an options is global, local or both and whether we need to add an permission

}

}

phpbb::$acm->destroy('acl_options');

$this->acl_clear_prefetch();

$ug_id = array($ug_id);

}

// Instead of updating, inserting, removing we just remove all current settings and re-set everything...

$table = ($ug_type == 'user') ? ACL_USERS_TABLE : ACL_GROUPS_TABLE;

$sql = "DELETE FROM $table

WHERE $forum_sql

AND $ug_id_sql

// Remove those having a role assigned... the correct type of course...

$sql = 'SELECT role_id

FROM ' . ACL_ROLES_TABLE . "

$role_ids = array();

{

$role_ids[] = $row['role_id'];

}

if (sizeof($role_ids))

{

WHERE $forum_sql

AND $ug_id_sql

AND auth_option_id = 0

}

// Ok, include the any-flag if one or more auth options are set to yes...

}

}

if ($clear_prefetch)

{

// Remove current auth options...

$sql = 'DELETE FROM ' . ACL_ROLES_DATA_TABLE . '

WHERE role_id = ' . $role_id;

// Now insert the new values

$this->acl_clear_prefetch();

}

if ($forum_id !== false)

{

}

if ($ug_id !== false)

{

}

// There seem to be auth options involved, therefore we need to go through the list and make sure we capture roles correctly

// Get permission type

$sql = 'SELECT auth_option, auth_option_id

FROM ' . ACL_OPTIONS_TABLE . "

$auth_id_ary = array();

{

$option_id_ary[] = $row['auth_option_id'];

$auth_id_ary[$row['auth_option']] = phpbb::ACL_NO;

}

// First of all, lets grab the items having roles with the specified auth options assigned

$sql = "SELECT auth_role_id, $id_field, forum_id

AND r.role_type = '{$permission_type}'

AND " . implode(' AND ', $where_sql) . '

ORDER BY auth_role_id';

$cur_role_auth = array();

{

$cur_role_auth[$row['auth_role_id']][$row['forum_id']][] = $row[$id_field];

}

// Get role data for resetting data

if (sizeof($cur_role_auth))

$sql = 'SELECT ao.auth_option, rd.role_id, rd.auth_setting

FROM ' . ACL_OPTIONS_TABLE . ' ao, ' . ACL_ROLES_DATA_TABLE . ' rd

WHERE ao.auth_option_id = rd.auth_option_id

$auth_settings = array();

{

// We need to fill all auth_options, else setting it will fail...

if (!isset($auth_settings[$row['role_id']]))

}

$auth_settings[$row['role_id']][$row['auth_option']] = $row['auth_setting'];

}

// Set the options

foreach ($cur_role_auth as $role_id => $auth_row)

// Now, normally remove permissions...

if ($permission_type !== false)

{

}

$sql = "DELETE FROM $table

WHERE " . implode(' AND ', $where_sql);

$this->acl_clear_prefetch();

}

}

$sql = 'UPDATE ' . USERS_TABLE . "

user_perm_from = $from_user_id

WHERE user_id = " . $to_user_id;

return true;

}