Code Forge

<?php

/**

*

* @package phpBB3

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

*

*/

/**

* @ignore

*/

define('IN_PHPBB', true);

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

include($phpbb_root_path . 'common.' . $phpEx);

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

// Start session management

$user->session_begin();

$auth->acl($user->data);

$user->setup(array('memberlist', 'groups'));

// Grab data

$mode                = request_var('mode', '');

$action                = request_var('action', '');

$user_id        = request_var('u', ANONYMOUS);

$username        = request_var('un', '', true);

$group_id        = request_var('g', 0);

$topic_id        = request_var('t', 0);

// Check our mode...

if (!in_array($mode, array('', 'group', 'viewprofile', 'email', 'contact', 'searchuser', 'leaders')))

{

        trigger_error('NO_MODE');

}

switch ($mode)

{

        case 'email':

        break;

        default:

                // Can this user view profiles/memberlist?

                if (!$auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel'))

                {

                        if ($user->data['user_id'] != ANONYMOUS)

                        {

                                trigger_error('NO_VIEW_USERS');

                        }

                        login_box('', ((isset($user->lang['LOGIN_EXPLAIN_' . strtoupper($mode)])) ? $user->lang['LOGIN_EXPLAIN_' . strtoupper($mode)] : $user->lang['LOGIN_EXPLAIN_MEMBERLIST']));

                }

        break;

}

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

$submit = (isset($_POST['submit'])) ? true : false;

$default_key = 'c';

$sort_key = request_var('sk', $default_key);

$sort_dir = request_var('sd', 'a');

// Grab rank information for later

$ranks = $cache->obtain_ranks();

// What do you want to do today? ... oops, I think that line is taken ...

switch ($mode)

{

        case 'leaders':

                // Display a listing of board admins, moderators

                include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

                $page_title = $user->lang['THE_TEAM'];

                $template_html = 'memberlist_leaders.html';

                $sql_ary = array(

                        'SELECT'        => 'g.group_id, g.group_name, g.group_colour, g.group_type, g.group_teampage, ug.user_id as ug_user_id',

                        'FROM'                => array(GROUPS_TABLE => 'g'),

                        'LEFT_JOIN'        => array(

                                array(

                                        'FROM'        => array(USER_GROUP_TABLE => 'ug'),

                                        'ON'        => 'ug.group_id = g.group_id AND ug.user_pending = 0 AND ug.user_id = ' . (int) $user->data['user_id'],

                                ),

                        ),

                        'WHERE'                => '',

                        'ORDER_BY'        => 'g.group_teampage ASC',

                );

                $result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));

                $group_ids = $groups_ary = array();

                while ($row = $db->sql_fetchrow($result))

                {

                        if ($row['group_type'] == GROUP_HIDDEN && !$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel') && $row['ug_user_id'] != $user->data['user_id'])

                        {

                                $row['group_name'] = $user->lang['GROUP_UNDISCLOSED'];

                                $row['u_group'] = '';

                        }

                        else

                        {

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

                                $row['u_group'] = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']);

                        }

                        if ($row['group_teampage'])

                        {

                                // Only put groups into the array we want to display.

                                // We are fetching all groups, to ensure we got all data for default groups.

                                $group_ids[] = (int) $row['group_id'];

                        }

                        $groups_ary[(int) $row['group_id']] = $row;

                }

                $db->sql_freeresult($result);

                $sql_ary = array(

                        'SELECT'        => 'u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id',

                        'FROM'                => array(

                                USER_GROUP_TABLE => 'ug',

                        ),

                        'LEFT_JOIN'        => array(

                                array(

                                        'FROM'        => array(USERS_TABLE => 'u'),

                                        'ON'        => 'ug.user_id = u.user_id AND ug.user_pending = 0',

                                ),

                                array(

                                        'FROM'        => array(GROUPS_TABLE => 'g'),

                                        'ON'        => 'ug.group_id = g.group_id',

                                ),

                        ),

                        'WHERE'                => $db->sql_in_set('g.group_id', $group_ids, false, true),

                        'ORDER_BY'        => 'u.username_clean ASC',

                );

                $result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));

                $user_ary = array();

                while ($row = $db->sql_fetchrow($result))

                {

                        $row['forums'] = '';

                        $row['forums_ary'] = array();

                        $user_ary[(int) $row['user_id']] = $row;

                        $user_ids[] = (int) $row['user_id'];

                        $group_users[(int) $row['group_id']][] = (int) $row['user_id'];

                }

                $db->sql_freeresult($result);

                if ($config['teampage_forums'])

                {

                        $template->assign_var('S_DISPLAY_MODERATOR_FORUMS', true);

                        // Get all moderators

                        $perm_ary = $auth->acl_get_list(array_unique($user_ids), array('m_'), false);

                        foreach ($perm_ary as $forum_id => $forum_ary)

                        {

                                foreach ($forum_ary as $auth_option => $id_ary)

                                {

                                        foreach ($id_ary as $id)

                                        {

                                                if (!$forum_id)

                                                {

                                                        $user_ary[$id]['forums'] = $user->lang['ALL_FORUMS'];

                                                }

                                                else

                                                {

                                                        $user_ary[$id]['forums_ary'][] = $forum_id;

                                                }

                                        }

                                }

                        }

                        $sql = 'SELECT forum_id, forum_name

                                FROM ' . FORUMS_TABLE;

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

                        $forums = array();

                        while ($row = $db->sql_fetchrow($result))

                        {

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

                        }

                        $db->sql_freeresult($result);

                        foreach ($user_ary as $user_id => $user_data)

                        {

                                if (!$user_data['forums'])

                                {

                                        foreach ($user_data['forums_ary'] as $forum_id)

                                        {

                                                $user_ary[$user_id]['forums_options'] = true;

                                                if (isset($forums[$forum_id]))

                                                {

                                                        if ($auth->acl_get('f_list', $forum_id))

                                                        {

                                                                $user_ary[$user_id]['forums'] .= '<option value="">' . $forums[$forum_id] . '</option>';

                                                        }

                                                }

                                        }

                                }

                        }

                }

                foreach ($groups_ary as $group_id => $group_data)

                {

                        if ($group_data['group_teampage'])

                        {

                                $template->assign_block_vars('group', array(

                                        'GROUP_NAME'        => $group_data['group_name'],

                                        'GROUP_COLOR'        => $group_data['group_colour'],

                                        'U_GROUP'                => $group_data['u_group'],

                                ));

                        }

                        // Display group members.

                        if (!empty($group_users[$group_id]))

                        {

                                foreach ($group_users[$group_id] as $user_id)

                                {

                                        if (isset($user_ary[$user_id]))

                                        {

                                                $row = $user_ary[$user_id];

                                                if ($config['teampage_memberships'] == 1 && ($group_id != $groups_ary[$row['default_group']]['group_id']) && $groups_ary[$row['default_group']]['group_teampage'])

                                                {

                                                        // Display users in their primary group, instead of the first group, when it is displayed on the teampage.

                                                        continue;

                                                }

                                                $rank_title = $rank_img = $rank_img_src = '';

                                                get_user_rank($row['user_rank'], (($row['user_id'] == ANONYMOUS) ? false : $row['user_posts']), $rank_title, $rank_img, $rank_img_src);

                                                $template->assign_block_vars('group.user', array(

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

                                                        'FORUMS'                => $row['forums'],

                                                        'FORUM_OPTIONS'        => (isset($row['forums_options'])) ? true : false,

                                                        'RANK_TITLE'        => $rank_title,

                                                        'GROUP_NAME'        => $groups_ary[$row['default_group']]['group_name'],

                                                        'GROUP_COLOR'        => $groups_ary[$row['default_group']]['group_colour'],

                                                        'U_GROUP'                => $groups_ary[$row['default_group']]['u_group'],

                                                        'RANK_IMG'                => $rank_img,

                                                        'RANK_IMG_SRC'        => $rank_img_src,

                                                        'U_PM'                        => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($row['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&u=' . $row['user_id']) : '',

                                                        'USERNAME_FULL'                => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),

                                                        'USERNAME'                        => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),

                                                        'USER_COLOR'                => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),

                                                        'U_VIEW_PROFILE'        => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),

                                                ));

                                                if ($config['teampage_memberships'] != 2)

                                                {

                                                        unset($user_ary[$user_id]);

                                                }

                                        }

                                }

                        }

                }

                $template->assign_vars(array(

                        'PM_IMG'                => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']))

                );

        break;

        case 'contact':

                $page_title = $user->lang['IM_USER'];

                $template_html = 'memberlist_im.html';

                if (!$auth->acl_get('u_sendim'))

                {

                        trigger_error('NOT_AUTHORISED');

                }

                $presence_img = '';

                switch ($action)

                {

                        case 'aim':

                                $lang = 'AIM';

                                $sql_field = 'user_aim';

                                $s_select = 'S_SEND_AIM';

                                $s_action = '';

                        break;

                        case 'msnm':

                                $lang = 'MSNM';

                                $sql_field = 'user_msnm';

                                $s_select = 'S_SEND_MSNM';

                                $s_action = '';

                        break;

                        case 'jabber':

                                $lang = 'JABBER';

                                $sql_field = 'user_jabber';

                                $s_select = (@extension_loaded('xml') && $config['jab_enable']) ? 'S_SEND_JABBER' : 'S_NO_SEND_JABBER';

                                $s_action = append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=$action&u=$user_id");

                        break;

                        default:

                                trigger_error('NO_MODE', E_USER_ERROR);

                        break;

                }

                // Grab relevant data

                $sql = "SELECT user_id, username, user_email, user_lang, $sql_field

                        FROM " . USERS_TABLE . "

                        WHERE user_id = $user_id

                                AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';

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

                $row = $db->sql_fetchrow($result);

                $db->sql_freeresult($result);

                if (!$row)

                {

                        trigger_error('NO_USER');

                }

                else if (empty($row[$sql_field]))

                {

                        trigger_error('IM_NO_DATA');

                }

                // Post data grab actions

                switch ($action)

                {

                        case 'jabber':

                                add_form_key('memberlist_messaging');

                                if ($submit && @extension_loaded('xml') && $config['jab_enable'])

                                {

                                        if (check_form_key('memberlist_messaging'))

                                        {

                                                include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

                                                $subject = sprintf($user->lang['IM_JABBER_SUBJECT'], $user->data['username'], $config['server_name']);

                                                $message = utf8_normalize_nfc(request_var('message', '', true));

                                                if (empty($message))

                                                {

                                                        trigger_error('EMPTY_MESSAGE_IM');

                                                }

                                                $messenger = new messenger(false);

                                                $messenger->template('profile_send_im', $row['user_lang']);

                                                $messenger->subject(htmlspecialchars_decode($subject));

                                                $messenger->replyto($user->data['user_email']);

                                                $messenger->im($row['user_jabber'], $row['username']);

                                                $messenger->assign_vars(array(

                                                        'BOARD_CONTACT'        => $config['board_contact'],

                                                        'FROM_USERNAME'        => htmlspecialchars_decode($user->data['username']),

                                                        'TO_USERNAME'        => htmlspecialchars_decode($row['username']),

                                                        'MESSAGE'                => htmlspecialchars_decode($message))

                                                );

                                                $messenger->send(NOTIFY_IM);

                                                $s_select = 'S_SENT_JABBER';

                                        }

                                        else

                                        {

                                                trigger_error('FORM_INVALID');

                                        }

                                }

                        break;

                }

                // Send vars to the template

                $template->assign_vars(array(

                        'IM_CONTACT'        => $row[$sql_field],

                        'A_IM_CONTACT'        => addslashes($row[$sql_field]),

                        'U_AIM_CONTACT'        => ($action == 'aim') ? 'aim:addbuddy?screenname=' . urlencode($row[$sql_field]) : '',

                        'U_AIM_MESSAGE'        => ($action == 'aim') ? 'aim:goim?screenname=' . urlencode($row[$sql_field]) . '&message=' . urlencode($config['sitename']) : '',

                        'USERNAME'                => $row['username'],

                        'CONTACT_NAME'        => $row[$sql_field],

                        'SITENAME'                => $config['sitename'],

                        'PRESENCE_IMG'                => $presence_img,

                        'L_SEND_IM_EXPLAIN'        => $user->lang['IM_' . $lang],

                        'L_IM_SENT_JABBER'        => sprintf($user->lang['IM_SENT_JABBER'], $row['username']),

                        $s_select                        => true,

                        'S_IM_ACTION'                => $s_action)

                );

        break;

        case 'viewprofile':

                // Display a profile

                if ($user_id == ANONYMOUS && !$username)

                {

                        trigger_error('NO_USER');

                }

                // Get user...

                $sql = 'SELECT *

                        FROM ' . USERS_TABLE . '

                        WHERE ' . (($username) ? "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "user_id = $user_id");

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

                $member = $db->sql_fetchrow($result);

                $db->sql_freeresult($result);

                if (!$member)

                {

                        trigger_error('NO_USER');

                }

                // a_user admins and founder are able to view inactive users and bots to be able to manage them more easily

                // Normal users are able to see at least users having only changed their profile settings but not yet reactivated.

                if (!$auth->acl_get('a_user') && $user->data['user_type'] != USER_FOUNDER)

                {

                        if ($member['user_type'] == USER_IGNORE)

                        {

                                trigger_error('NO_USER');

                        }

                        else if ($member['user_type'] == USER_INACTIVE && $member['user_inactive_reason'] != INACTIVE_PROFILE)

                        {

                                trigger_error('NO_USER');

                        }

                }

                $user_id = (int) $member['user_id'];

                // Get group memberships

                // Also get visiting user's groups to determine hidden group memberships if necessary.

                $auth_hidden_groups = ($user_id === (int) $user->data['user_id'] || $auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? true : false;

                $sql_uid_ary = ($auth_hidden_groups) ? array($user_id) : array($user_id, (int) $user->data['user_id']);

                // Do the SQL thang

                $sql = 'SELECT g.group_id, g.group_name, g.group_type, ug.user_id

                        FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . ' ug

                        WHERE ' . $db->sql_in_set('ug.user_id', $sql_uid_ary) . '

                                AND g.group_id = ug.group_id

                                AND ug.user_pending = 0';

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

                // Divide data into profile data and current user data

                $profile_groups = $user_groups = array();

                while ($row = $db->sql_fetchrow($result))

                {

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

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

                        if ($row['user_id'] == $user_id)

                        {

                                $profile_groups[] = $row;

                        }

                        else

                        {

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

                        }

                }

                $db->sql_freeresult($result);

                // Filter out hidden groups and sort groups by name

                $group_data = $group_sort = array();

                foreach ($profile_groups as $row)

                {

                        if ($row['group_type'] == GROUP_SPECIAL)

                        {

                                // Lookup group name in language dictionary

                                if (isset($user->lang['G_' . $row['group_name']]))

                                {

                                        $row['group_name'] = $user->lang['G_' . $row['group_name']];

                                }

                        }

                        else if (!$auth_hidden_groups && $row['group_type'] == GROUP_HIDDEN && !isset($user_groups[$row['group_id']]))

                        {

                                // Skip over hidden groups the user cannot see

                                continue;

                        }

                        $group_sort[$row['group_id']] = utf8_clean_string($row['group_name']);

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

                }

                unset($profile_groups);

                unset($user_groups);

                asort($group_sort);

                $group_options = '';

                foreach ($group_sort as $group_id => $null)

                {

                        $row = $group_data[$group_id];

                        $group_options .= '<option value="' . $row['group_id'] . '"' . (($row['group_id'] == $member['group_id']) ? ' selected="selected"' : '') . '>' . $row['group_name'] . '</option>';

                }

                unset($group_data);

                unset($group_sort);

                // What colour is the zebra

                $sql = 'SELECT friend, foe

                        FROM ' . ZEBRA_TABLE . "

                        WHERE zebra_id = $user_id

                                AND user_id = {$user->data['user_id']}";

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

                $row = $db->sql_fetchrow($result);

                $foe = ($row['foe']) ? true : false;

                $friend = ($row['friend']) ? true : false;

                $db->sql_freeresult($result);

                if ($config['load_onlinetrack'])

                {

                        $sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline

                                FROM ' . SESSIONS_TABLE . "

                                WHERE session_user_id = $user_id";

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

                        $row = $db->sql_fetchrow($result);

                        $db->sql_freeresult($result);

                        $member['session_time'] = (isset($row['session_time'])) ? $row['session_time'] : 0;

                        $member['session_viewonline'] = (isset($row['session_viewonline'])) ? $row['session_viewonline'] :        0;

                        unset($row);

                }

                if ($config['load_user_activity'])

                {

                        display_user_activity($member);

                }

                // Do the relevant calculations

                $memberdays = max(1, round((time() - $member['user_regdate']) / 86400));

                $posts_per_day = $member['user_posts'] / $memberdays;

                $percentage = ($config['num_posts']) ? min(100, ($member['user_posts'] / $config['num_posts']) * 100) : 0;

                if ($member['user_sig'])

                {

                        $member['user_sig'] = censor_text($member['user_sig']);

                        if ($member['user_sig_bbcode_bitfield'])

                        {

                                include_once($phpbb_root_path . 'includes/bbcode.' . $phpEx);

                                $bbcode = new bbcode();

                                $bbcode->bbcode_second_pass($member['user_sig'], $member['user_sig_bbcode_uid'], $member['user_sig_bbcode_bitfield']);

                        }

                        $member['user_sig'] = bbcode_nl2br($member['user_sig']);

                        $member['user_sig'] = smiley_text($member['user_sig']);

                }

                $poster_avatar = get_user_avatar($member['user_avatar'], $member['user_avatar_type'], $member['user_avatar_width'], $member['user_avatar_height']);

                // We need to check if the modules 'zebra' ('friends' & 'foes' mode),  'notes' ('user_notes' mode) and  'warn' ('warn_user' mode) are accessible to decide if we can display appropriate links

                $zebra_enabled = $friends_enabled = $foes_enabled = $user_notes_enabled = $warn_user_enabled = false;

                // Only check if the user is logged in

                if ($user->data['is_registered'])

                {

                        if (!class_exists('p_master'))

                        {

                                include($phpbb_root_path . 'includes/functions_module.' . $phpEx);

                        }

                        $module = new p_master();

                        $module->list_modules('ucp');

                        $module->list_modules('mcp');

                        $user_notes_enabled = ($module->loaded('mcp_notes', 'user_notes')) ? true : false;

                        $warn_user_enabled = ($module->loaded('mcp_warn', 'warn_user')) ? true : false;

                        $zebra_enabled = ($module->loaded('ucp_zebra')) ? true : false;

                        $friends_enabled = ($module->loaded('ucp_zebra', 'friends')) ? true : false;

                        $foes_enabled = ($module->loaded('ucp_zebra', 'foes')) ? true : false;

                        unset($module);

                }

                $template->assign_vars(show_profile($member, $user_notes_enabled, $warn_user_enabled));

                // Custom Profile Fields

                $profile_fields = array();

                if ($config['load_cpf_viewprofile'])

                {

                        include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);

                        $cp = new custom_profile();

                        $profile_fields = $cp->generate_profile_fields_template('grab', $user_id);

                        $profile_fields = (isset($profile_fields[$user_id])) ? $cp->generate_profile_fields_template('show', false, $profile_fields[$user_id]) : array();

                }

                // If the user has m_approve permission or a_user permission, then list then display unapproved posts

                if ($auth->acl_getf_global('m_approve') || $auth->acl_get('a_user'))

                {

                        $sql = 'SELECT COUNT(post_id) as posts_in_queue

                                FROM ' . POSTS_TABLE . '

                                WHERE poster_id = ' . $user_id . '

                                        AND post_approved = 0';

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

                        $member['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

                        $db->sql_freeresult($result);

                }

                else

                {

                        $member['posts_in_queue'] = 0;

                }

                $template->assign_vars(array(

                        'L_POSTS_IN_QUEUE'        => $user->lang('NUM_POSTS_IN_QUEUE', $member['posts_in_queue']),

                        'POSTS_DAY'                        => $user->lang('POST_DAY', $posts_per_day),

                        'POSTS_PCT'                        => $user->lang('POST_PCT', $percentage),

                        'OCCUPATION'        => (!empty($member['user_occ'])) ? censor_text($member['user_occ']) : '',

                        'INTERESTS'                => (!empty($member['user_interests'])) ? censor_text($member['user_interests']) : '',

                        'SIGNATURE'                => $member['user_sig'],

                        'POSTS_IN_QUEUE'=> $member['posts_in_queue'],

                        'AVATAR_IMG'        => $poster_avatar,

                        'PM_IMG'                => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),

                        'EMAIL_IMG'                => $user->img('icon_contact_email', $user->lang['EMAIL']),

                        'WWW_IMG'                => $user->img('icon_contact_www', $user->lang['WWW']),

                        'ICQ_IMG'                => $user->img('icon_contact_icq', $user->lang['ICQ']),

                        'AIM_IMG'                => $user->img('icon_contact_aim', $user->lang['AIM']),

                        'MSN_IMG'                => $user->img('icon_contact_msnm', $user->lang['MSNM']),

                        'YIM_IMG'                => $user->img('icon_contact_yahoo', $user->lang['YIM']),

                        'JABBER_IMG'        => $user->img('icon_contact_jabber', $user->lang['JABBER']),

                        'SEARCH_IMG'        => $user->img('icon_user_search', $user->lang['SEARCH']),

                        'S_PROFILE_ACTION'        => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group'),

                        'S_GROUP_OPTIONS'        => $group_options,

                        'S_CUSTOM_FIELDS'        => (isset($profile_fields['row']) && sizeof($profile_fields['row'])) ? true : false,

                        'U_USER_ADMIN'                        => ($auth->acl_get('a_user')) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", 'i=users&mode=overview&u=' . $user_id, true, $user->session_id) : '',

                        'U_USER_BAN'                        => ($auth->acl_get('m_ban') && $user_id != $user->data['user_id']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=ban&mode=user&u=' . $user_id, true, $user->session_id) : '',

                        'U_MCP_QUEUE'                        => ($auth->acl_getf_global('m_approve')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue', true, $user->session_id) : '',

                        'U_SWITCH_PERMISSIONS'        => ($auth->acl_get('a_switchperm') && $user->data['user_id'] != $user_id) ? append_sid("{$phpbb_root_path}ucp.$phpEx", "mode=switch_perm&u={$user_id}&hash=" . generate_link_hash('switchperm')) : '',