root/users.php

<?php</span>
<span class="code-lang">$root_path = './';
require ($root_path . 'include/config.php');

$userdata = session_pagestart($user_ip);
init_userprefs($userdata);
loggedinorreturn();

$search = request_var('username', '');
$class = request_var('class', '-');
$country = request_var('country', 0);
$letter = request_var('letter', '-');

$sql_query = $query = array();</span>
<span class="code-lang">
if ( $search ) {
     $sql_query[] = 'u.name LIKE ' . "'" . $db->sql_escape('%' . $search . '%') . "'" ;
    $query['search'] = $search;
}
$letter = substr($letter, 0, 1);</span>
<span class="code-lang">if ( $letter != '-' ) {
    $sql_query[] = 'u.name LIKE \'' . $db->sql_escape($letter) . '%\'';
    $query['letter'] = $letter;
}

if ( $class != '-' ) {
    $class = (int) $class;
    $sql_query[] = 'u.class = ' . ( $class - 2 );
    $query['class'] = $class;
}

if ( $country ) {
        $sql_query[] = 'u.country = ' . $country;
        $query['country'] = $country;
}

$countries_select = '<option value="0">(' . $lang['country'] . ')</option>';
$sql = 'SELECT id, name FROM ' . COUNTRIES_TABLE . ' ORDER BY name';
$result = $db->sql_query($sql);</span>
<span class="code-lang">while ($row = $db->sql_fetchrow($result)) {
    $countries_select .= '<option value="' . $row['id'] . '"' . ($country == $row['id'] ? ' selected="selected"' : '') . '>' . $row['name'] . '</option>';
 }
$countries_select .= '</select>';

$class_select = '<option value="-"' . ( $class == '-' ? ' selected="selected"':'' ) . '>(' . $lang['class'] . ')</option>';
$i = 0;</span>
<span class="code-lang">while ($c = get_user_class_name($i)) {
    $class_select .= '<option value="' . ( $i + 2 ) . '"' . ( ( $i + 2 )  == $class ? ' selected="selected"':'' ) . '>' . $c . '</option>';
    ++$i;
}
$class_select .= '</select>';

$q = $q_letter = $sql_ext = '';

$letters = ( $letter == '-' ? '<b>' . $lang['all'] . '</b>' : '<a href="' . append_sid('users.php') . '"><b>' . $lang['all'] . '</b></a>');</span>
<span class="code-lang">
if ( sizeof($sql_query) ) {
    $sql_ext = implode(' AND ', $sql_query );
}
if ( sizeof($query) ) {
    foreach ( $query AS $key => $value ) {
        $q .= ( $q ? '&amp;' : '');
        $q .= $key . '=' . $value;

        if ( $key <> 'letter' ) {
            $q_letter .= ( $q_letter ? '&amp;' : '');
            $q_letter .= $key . '=' . $value;
        }
    }
}

for ($i = 48; $i < 58; ++$i) {
        $L = chr($i);
        $letters .= ($L == $letter ?' <b>' . $L . '</b>':' <a href="' . append_sid('users.php?letter=' . $L . ( !empty($q_letter) ? '&amp;' . $q_letter : '' ) ) . '"><b> ' . $L . '</b></a>');
}

for ($i = 65; $i < 91; ++$i) {
        $L = chr($i);
        $letters .= ($L == $letter ?' <b>' . $L . '</b>':' <a href="' . append_sid('users.php?letter=' . $L . ( !empty($q_letter) ? '&amp;' . $q_letter : '' ) ) . '"><b> ' . $L . '</b></a>');
}

$sql = 'SELECT COUNT(*) AS count FROM ' . USERS_TABLE . ' u WHERE status = 1 AND uid <> ' . ANONYMOUS .  ( $sql_ext ? ' AND ' . $sql_ext : '' );
$result = $db->sql_query($sql);
$count = ( $row = $db->sql_fetchrow($result) ) ? intval($row['count']) : 0 ;</span>
<span class="code-lang">list($pagertop, $pagerbottom, $offset, $limit) = pager(100, $count, 'users.php?' . ( !empty($q) ? '&amp;' . $q . '&amp;' : '' ));

$sql = 'SELECT u.uid, u.name, u.class, u.enabled, u.donor, u.warneduntil, u.parked, u.country, u.added, u.user_session_time, c.flagpic, c.name AS country_name</span>
<span class="code-lang">        FROM ' . USERS_TABLE . ' u, ' . COUNTRIES_TABLE . ' c
        WHERE u.country = c.id' .  ( $sql_ext ? ' AND ' . $sql_ext : '' ) . ' AND status = 1
        ORDER BY u.name ASC';
$result = $db->sql_query_limit($sql, $limit, $offset);

$template->assign_vars(array(</span>
<span class="code-lang">        'S_FORM_ACTION' => append_sid('users.php'),
        'USERNAME' => $search,
        'LETTERS' => $letters,
        'COUNTRIES_SELECT' => $countries_select,
        'CLASS_SELECT' => $class_select,
        'PAGERTOP' => $pagertop,
        'PAGERBOTTOM' => $pagerbottom)
);

while ($row = $db->sql_fetchrow($result)) {
    $date_added = create_date($row['added']);
    $last_access = create_date($row['user_session_time']);

    // www.phpBB-SEO.com SEO TOOLKIT BEGIN
    $seo->set_user_url($row['name'], $row['uid']);
    // www.phpBB-SEO.com SEO TOOLKIT END

    $template->assign_block_vars('users_row', array(
            'U_USERDETAILS' => append_sid($root_path . 'userdetails.php?id=' . $row['uid']),
            'USERNAME' => get_user_class_color ($row['class'], $row['name']),
            'USER_ICONS' =>  get_user_icons($row),
            'ADDED' => $date_added,
            'LAST_ACCESS' => $last_access,
            'CLASS' => get_user_class_name($row['class']),
            'COUNTRY_NAME' => $row['country_name'],
            'COUNTRY_FLAG' => $row['flagpic'] )
    );
}

stdhead($lang['users']);
$template->set_filenames(array(</span>
<span class="code-lang">        'body' => 'users.html')
);
stdfoot();
?>