FROM ' . GROUPS_TABLE . '

WHERE group_type = ' . GROUP_SPECIAL . "

$sql_and";

{

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

}

}

// Map usernames to ids and vice versa

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . '

ORDER BY left_id';

$forum_id = array();

{

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

}

}

else if ($subforum_id)

{

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

$forum_names = array();

{

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

}

$template->assign_vars(array(

'S_FORUM_NAMES' => (sizeof($forum_names)) ? true : false,

{

$sql = "SELECT $sql_id

FROM $table

$ids = array();

{

$ids[] = (int) $row[$sql_id];

}

}

if (!sizeof($ids))

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

WHERE o.auth_option_id = r.auth_option_id

AND r.role_id = ' . $role_id;

$test_auth_settings = array();

{

$test_auth_settings[$row['auth_option']] = $row['auth_setting'];

}

// We need to add any ACL_NO setting from auth_settings to compare correctly

foreach ($auth_settings as $option => $setting)

// Logging ... first grab user or groupnames ...

$sql = ($ug_type == 'group') ? 'SELECT group_name as name, group_type FROM ' . GROUPS_TABLE . ' WHERE ' : 'SELECT username as name FROM ' . USERS_TABLE . ' WHERE ';

$l_ug_list = '';

{

$l_ug_list .= (($l_ug_list != '') ? ', ' : '') . ((isset($row['group_type']) && $row['group_type'] == GROUP_SPECIAL) ? '<span class="sep">' . phpbb::$user->lang['G_' . $row['name']] . '</span>' : $row['name']);

}

$mode = str_replace('setting_', '', $mode);

// Grab the forum details if non-zero forum_id

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

$l_forum_list = '';

{

$l_forum_list .= (($l_forum_list != '') ? ', ' : '') . $row['forum_name'];

}

add_log('admin', 'LOG_ACL_' . strtoupper($action) . '_' . strtoupper($mode) . '_' . strtoupper($permission_type), $l_forum_list, $l_ug_list);

}

$sql = 'SELECT user_id, username, user_permissions, user_type

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

else

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

}

$back = request_var('back', 0);

WHERE ug.user_id = ' . $user_id . '

AND ug.user_pending = 0

ORDER BY g.group_type DESC, g.group_id DESC';

$groups = array();

{

$groups[$row['group_id']] = array(

'auth_setting' => phpbb::ACL_NO,

'group_name' => ($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']

);

}

$total = phpbb::ACL_NO;

$add_key = (($forum_id) ? '_LOCAL' : '');

*/

function retrieve_defined_user_groups($permission_scope, $forum_id, $permission_type)

{

// Permission options are only able to be a permission set... therefore we will pre-fetch the possible options and also the possible roles

$option_ids = $role_ids = array();

$sql = 'SELECT auth_option_id

FROM ' . ACL_OPTIONS_TABLE . '

{

$option_ids[] = (int) $row['auth_option_id'];

}

if (sizeof($option_ids))

{

$sql = 'SELECT DISTINCT role_id

FROM ' . ACL_ROLES_DATA_TABLE . '

{

$role_ids[] = (int) $row['role_id'];

}

}

if (sizeof($option_ids) && sizeof($role_ids))

{

}

else

{

}

// Not ideal, due to the filesort, non-use of indexes, etc.

$sql_forum_id

$sql_where

ORDER BY u.username_clean, u.user_regdate ASC";

$s_defined_user_options = '';

$defined_user_ids = array();

{

$s_defined_user_options .= '<option value="' . $row['user_id'] . '">' . $row['username'] . '</option>';

$defined_user_ids[] = $row['user_id'];

}

$sql = 'SELECT DISTINCT g.group_type, g.group_name, g.group_id

FROM ' . GROUPS_TABLE . ' g, ' . ACL_GROUPS_TABLE . " a

$sql_forum_id

$sql_where

ORDER BY g.group_type DESC, g.group_name ASC";

$s_defined_group_options = '';

$defined_group_ids = array();

{

$s_defined_group_options .= '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '') . ' value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

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

}

return array(

'group_ids' => $defined_group_ids,