root/usersearch.php

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

$userdata = session_pagestart($user_ip);
init_userprefs($userdata);
loggedinorreturn();</span>
<span class="code-lang">
if ($userdata['class'] < UC_MODERATOR) {
        trigger_error($lang['access_denied']);
}

function generate_select ($name, $type) {
    global $lang;
    if ($type == 1) {
        $opt = array($lang['in'], $lang['before'], $lang['after'], $lang['between']);
    }
    elseif ($type == 2) {
        $opt = array($lang['choose'], $lang['yes'], $lang['no']);
    }
    elseif ($type == 3) {
        $opt = array($lang['equal'], $lang['above'], $lang['below'], $lang['between']);
    }
    elseif ($type == 4) {
        $opt = array($lang['choose'], $lang['confirmed'], $lang['not_confirmed']);
    }
    elseif ($type == 5) {
        $opt = array($lang['choose'], $lang['enabled'], $lang['disabled']);
    }
    $s = '<select name="' . $name . '">';
    for ($i = 0; $i < sizeof($opt); $i++){
        $s .= '<option value="' . ( $opt[$i] == $lang['choose'] ? '--' : $i ) . '" '.((@$_GET[$name]==$i)?'selected="selected"':'').'>'.$opt[$i].'</option>';
    }
    $s .= '</select>';
    return $s;
}

// Validates date in the form [yy]yy-mm-dd;</span>
<span class="code-comment">// Returns date if valid, 0 otherwise.
function mkdate($date) {</span>
<span class="code-keyword">    if (strpos($date,'-')) {
        $a = explode('-', $date);
    }
    else {
        return 0;
    }
    for ($i=0;$i<3;$i++) {
        if (!is_numeric($a[$i])) {
            return 0;
        }
        if (checkdate($a[1], $a[2], $a[0])) {
            return  date ("Y-m-d", mktime (0,0,0,$a[1],$a[2],$a[0]));
        }
        else {
            return 0;
        }
    }
}

// checks for the usual wildcards *, ? plus mySQL ones
function haswildcard($text) {</span>
<span class="code-keyword">    if (strpos($text,'*') === False && strpos($text,'?') === False && strpos($text,'%') === False && strpos($text,'_') === False) {
        return False;
    }
    else {
        return True;
    }
}

$input_vars = array('d', 'd2', 'icq', 'dip', 'ls', 'ls2', 'skype', 'ma', 'dl', 'dl2', 'aim', 'em', 'r', 'r2', 'msn', 'ip', 'ul', 'ul2', 'yahoo', 'age', 'ac', 'passkey', 'client', 'c', 'gender', 'speed_up', 'speed_down', 'username');</span>
<span class="code-lang">
foreach ( $input_vars AS $_null => $var_name ) {
    $$var_name = request_var($var_name, '');
}

//start cleints select
$sql = 'SELECT peer_id, useragent FROM ' . PEERS_TABLE . ' WHERE peer_id <> \'\'  GROUP BY SUBSTR(useragent, 1, 15)';
$result = $db->sql_query($sql, 24 * 60 * 60);
$agents = array();</span>
<span class="code-lang">while ( $row = $db->sql_fetchrow($result) ) {
    $agent = getagent($row['useragent'], $row['peer_id']);
    if ( !isset($agents[$agent]) ) {
        $agents[$agent] = $row['useragent'];
    }
}
ksort ($agents);
$client_select = '<select name="client" id="client"><option value="">' . $lang['choose'] . '</option>';</span>
<span class="code-lang">foreach ( $agents AS $agent => $useragent ) {
        $client_select .= '<option value="' . urlencode($useragent) . '" ' . ( urldecode($client) == $agent ? 'selected="selected"' : '' ).'>'.$agent.'</option>';
}
$client_select .= '</select>';
//end cleints select</span>
<span class="code-comment">
//begin class select
$class_select = '<select name="c"><option value="0">' . $lang['choose'] . '</option>';</span>
<span class="code-lang">for ($i = 3;;++$i) {
        if ($class = get_user_class_name($i-3)) {
                $class_select .= '<option value="' . $i . '"' . ($c && $c == $i? 'selected="selected"' : '') . '>' . $class . '</option>';
        }
        else {
                break;
        }
}
$class_select .= '</select>';
//end class select</span>
<span class="code-comment">
//start gender select
$gender_select = '<select name="gender" id="gender"><option value="--">' . $lang['choose'] . '</option>';
$gender_select .= '<option value="0"' . ( $gender === 0 ? ' selected="selected"':''). '>' . $lang['gender_male'] . '</option>';
$gender_select .= '<option value="1"' . ( $gender === 1 ? ' selected="selected"':''). '>' . $lang['gender_female'] . '</option>';
$gender_select .= '</select>';
//end gender select

$reg_date_select = generate_select('dt', 1);
$last_access_select = generate_select('lst', 1);
$donor_select = generate_select('do', 2);
$warn_select = generate_select('w', 2);
$downloaded_select = generate_select('dlt', 3);
$status_select = generate_select('st', 4);
$ratio_select = generate_select('rt', 3);
$hidden_torrent_select =  generate_select('ht', 2);
$parked_selected = generate_select('parked', 2);
$uploaded_select = generate_select('ult', 3);
$enabled_select = generate_select('as', 5);

//speeds selects
$speed_up_select = generate_internet_speed($speed_up, 'speed_up');
$speed_down_select = generate_internet_speed($speed_down, 'speed_down');

$template->assign_vars(array(</span>
<span class="code-lang">        'S_FORM_ACTION' => append_sid('usersearch.php'),
        'USERNAME_VALUE' => $username,
        'CLIENT_SELECT' => $client_select,
        'REG_DATE_SELECT' => $reg_date_select,
        'REG_DATE_INPUT1' => $d,
        'REG_DATE_INPUT2' => $d2,
        'ICQ_INPUT' => $icq,
        'DISABLED_IP_CHECKED' => ( $dip ? 'checked="checked"' : '' ),
        'CLASS_SELECT' => $class_select,
        'LAST_ACCESS_SELECT' => $last_access_select,
        'LAST_ACCESS_INPUT1' => $ls,
        'LAST_ACCESS_INPUT2' => $ls2,
        'SKYPE_INPUT' => $skype,
        'DONOR_SELECT' => $donor_select,
        'MASK_INPUT' => $ma,
        'WARN_SELECT' => $warn_select,
        'DOWNLOADED_SELECT' => $downloaded_select,
        'DOWNLOADED_INPUT1' => $dl,
        'DOWNLOADED_INPUT2' => $dl2,
        'AIM_INPUT' => $aim,
        'STATUS_SELECT' => $status_select,
        'EMAIL_INPUT' => $em,
        'GENDER_SELECT' => $gender_select,
        'RATIO_SELECT' => $ratio_select,
        'RATIO_INPUT1' => $r,
        'RATIO_INPUT2' => $r2,
        'MSN_INPUT' => $msn,
        'HIDDEN_TORRENT_SELECT' => $hidden_torrent_select,
        'IP_INPUT' => $ip,
        'PARKED_SELECT' => $parked_selected,
        'UPLOADED_SELECT' => $uploaded_select,
        'UPLOADED_INPUT1' => $ul,
        'UPLOADED_INPUT2' => $ul2,
        'YAHOO_INPUT' => $yahoo,
        'AGE_INPUT' => $age,
        'ENABLED_SELECT' => $enabled_select,
        'ONLY_ACTIVE_CHECKED' => ( $ac ? 'checked="checked"' : '' ),
        'SPEED_DOWN_SELECT' => $speed_down_select,
        'SPEED_UP_SELECT' => $speed_up_select,
        'PASSKEY_INPUT' =>  $passkey

        )
);

///////////////////////////////////////////////////////////////////////////////
$where_is = $q = array();
$join_is = '';</span>
<span class="code-lang">if ( isset($_GET['submit']) ) {
    $q[] = "submit=1";
    $names_exc = array();
    $names_inc = array();
    $names = explode(' ', $username);
    if ($names[0] !== '') {
        foreach($names as $name) {
            if (substr($name,0,1) == '~') {
                if ($name == '~') {
                    continue;
                }
                $names_exc[] = substr($name,1);
            }
            else {
                $names_inc[] = $name;
            }
        }
        $name_is = '';
        if (sizeof($names_inc)) {
            foreach($names_inc as $name) {
                if (!haswildcard($name)) {
                    $name_is .= ( $name_is ?" OR ":"")."u.name = ". "'" . $db->sql_escape($name) . "'";
                }
                else {
                    $name = str_replace(array('?','*'), array('_','%'), $name);
                    $name_is .= ( $name_is ?" OR ":"")."u.name LIKE "."'" . $db->sql_escape($name) . "'";
                }
            }
            $where_is[] = $name_is;
            unset($name_is);
        }
        if (sizeof($names_exc)) {
            $where_is .= isset($where_is)?" AND NOT (":" NOT (";
            foreach($names_exc as $name) {
                if (!haswildcard($name)) {
                    $name_is .= (isset($name_is)?" OR ":"")."u.name = "."'" . $db->sql_escape($name) . "'";
                }
                else {
                    $name = str_replace(array('?','*'), array('_','%'), $name);
                    $name_is .= (isset($name_is)?" OR ":"")."u.name LIKE "."'" . $db->sql_escape($name) . "'";
                }
            }
            $where_is[] = '(' . $name_is . ')';
        }
        $q[] = 'username=' . urlencode($username);
    }

    $em = ( isset($_GET['em']) ? trim($_GET['em']) : '' );
    $emaila = explode(' ', $em);
    if ($emaila[0] !== "") {
        foreach($emaila as $email) {
            if (strpos($email,'*') === False && strpos($email,'?') === False && strpos($email,'%') === False) {
                if ( !preg_match('/^[a-z0-9&\'\.\-_\+]+@[a-z0-9\-]+\.([a-z0-9\-]+\.)*?[a-z]+$/is', $email) ) {
                    trigger_error($lang['email_invalid']);
                }
                $email_is .= (isset($email_is)?" OR ":"")."u.email ="."'" . $db->sql_escape($email) . "'";
            }
            else {
                $sql_email = str_replace(array('?','*'), array('_','%'), $email);
                $email_is .= (isset($email_is)?" OR ":"")."u.email LIKE "."'" . $db->sql_escape($sql_email) . "'";
            }
        }
        $where_is[] = $email_is;
        $q[] = 'em='.urlencode($em);
    }


    if ($c > 0) {
        $where_is[] = 'u.class=' . ($c - 3);
        $q[] = 'c='.($c);
    }

    if ($ip) {
        $regex = '/(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|\*)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|\*)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|\*)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|\*)/';
        if (!preg_match($regex, $ip)) {
            trigger_error($lang['bad_ip']);
        }
        $mask = trim($_GET['ma']);
        if ($mask == '' || $mask == '255.255.255.255') {
            $where_is[] = ( strpos($ip, '*') ? "u.ip LIKE '" . str_replace('*', '%', $ip) . "'" : 'u.ip = \'' . $ip . '\'' );
        }
        else {
            if (substr($mask,0,1) == "/") {
                $n = substr($mask, 1, strlen($mask) - 1);
                if (!is_numeric($n) or $n < 0 or $n > 32) {
                    trigger_error($lang['bad_subnet_mask']);
                }
                else {
                    $mask = long2ip(pow(2,32) - pow(2,32-$n));
                }
            }
            elseif (!preg_match($regex, $mask)) {
                trigger_error($lang['bad_subnet_mask']);
            }
            $where_is[] = "INET_ATON(u.ip) & INET_ATON('$mask') = INET_ATON('" .  $ip . "') & INET_ATON('$mask')";
            $q[] = "ma=$mask";
        }
        $q[] = 'ip= ' . $ip;
    }



    $ratio = ( isset($_GET['r']) ? trim($_GET['r']) : '' );
    if ($ratio) {
        if ($ratio == '---') {
            $ratio2 = '';
            $where_is[] = "u.uploaded = 0 and u.downloaded = 0";
        }
        elseif (strtolower(substr($ratio,0,3)) == 'inf') {
            $ratio2 = '';
            $where_is[] = "u.uploaded > 0 and u.downloaded = 0";
        }
        else {
            if (!is_numeric($ratio) || $ratio < 0) {
                trigger_error($lang['bad_ratio']);
            }
            $ratiotype = $_GET['rt'];
            $q[] = "rt=$ratiotype";
            if ($ratiotype == "3") {
                $ratio2 = trim($_GET['r2']);
                if(!$ratio2) {
                    trigger_error($lang['two_ratio_fields_must_be_filled']);
                }
                if (!is_numeric($ratio2) || $ratio2 < $ratio) {
                    trigger_error($lang['bad_second_ratio_field']);
                }
                $where_is[] = "(u.uploaded/u.downloaded) BETWEEN $ratio and $ratio2";
                $q[] = "r2=$ratio2";
            }
            elseif ($ratiotype == "2") {
                $where_is[] = "(u.uploaded/u.downloaded) < $ratio";
            }
            elseif ($ratiotype == "1") {
                $where_is[] = "(u.uploaded/u.downloaded) > $ratio";
            }
            else {
                $where_is[] = "(u.uploaded/u.downloaded) BETWEEN ($ratio - 0.004) and ($ratio + 0.004)";
            }
        }
        $q[] = "r=$ratio";
    }

    $ul = ( isset($_GET['ul']) ? trim($_GET['ul']) : '' );
    if ($ul) {
        if (!is_numeric($ul) || $ul < 0) {
            trigger_error($lang['bad_uploaded']);
        }
        $ultype = intval($_GET['ult']);
        $q[] = "ult=$ultype";
        if ($ultype == 3) {
            $ul2 = trim($_GET['ul2']);
            if(!$ul2) {
                trigger_error($lang['two_uploaded_fields_must_be_filled']);
            }

            if (!is_numeric($ul2) || $ul2 < $ul) {
                trigger_error($lang['bad_second_uploaded_field']);
            }
            $where_is[] = "u.uploaded BETWEEN ". ($ul*1024*1024*1024) ." AND ". ($ul2*1024*1024*1024);
            $q[] = "ul2=$ul2";
        }
        elseif ($ultype == 2) {
            $where_is[] = "u.uploaded < ".$ul*1024*1024*1024;
        }
        elseif ($ultype == 1) {
            $where_is[] = "u.uploaded >". $ul*1024*1024*1024;
        }
        else {
            $where_is[] = "u.uploaded BETWEEN ".(($ul - 0.004)*1024*1024*1024)." AND ".(($ul + 0.004)*1024*1024*1024);
        }
        $q[] = "ul=$ul";
    }


    $dl = ( isset($_GET['dl']) ? trim($_GET['dl']) : '' );
    if ($dl) {
        if (!is_numeric($dl) || $dl < 0) {
            trigger_error($lang['bad_downloaded']);
        }
        $dltype = intval($_GET['dlt']);
        $q[] = "dlt=$dltype";
        if ($dltype == 3) {
            $dl2 = trim($_GET['dl2']);
            if(!$dl2) {
                trigger_error($lang['two_downloaded_fields_must_be_filled']);
            }
            if (!is_numeric($dl2) or $dl2 < $dl) {
                trigger_error($lang['bad_second_downloaded_field']);
            }
            $where_is[] = 'u.downloaded BETWEEN '.($dl*1024*1024*1024)." and ".($dl2*1024*1024*1024);
            $q[] = "dl2=$dl2";
        }
        elseif ($dltype == 2) {
            $where_is[] = "u.downloaded < ".$dl*1024*1024*1024;
        }
        elseif ($dltype == 1) {
            $where_is[] = "u.downloaded > ".$dl*1024*1024*1024;
        }
        else {
            $where_is[] = "u.downloaded BETWEEN ".(($dl - 0.004)*1024*1024*1024)." and ".(($dl + 0.004)*1024*1024*1024);
        }
        $q[] = "dl=$dl";
    }

    // date joined
    $date = ( isset($_GET['d']) ? trim($_GET['d']) : '' );
    if ($date) {
        if (!$date = mkdate($date)) {
            trigger_error($lang['bad_date']);
        }
        $q[] = "d=$date";
        $xz = explode('-', $date);
        $date = mktime(0,0,0,$xz[1], $xz[2], $xz[0]);
        $datetype = intval($_GET['dt']);
        $q[] = "dt=$datetype";
        if ($datetype == 0) {
            $where_is[] = "u.added BETWEEN " . ($date - 86400) . " AND " . ($date + 86400);
        }
        if ($datetype == 3) {
            $date2 = trim($_GET['d2']);
            if (!$date2 = mkdate($date2)) {
                trigger_error($lang['bad_second_date_field']);
            }
            if ($date2) {
                $q[] = "d2=$date2";
                $xz = explode('-', $date2);
                $date2 = mktime(0,0,0,$xz[1], $xz[2], $xz[0]);
                $where_is[] = "u.added BETWEEN $date AND $date2";
            }
            else {
                trigger_error($lang['two_date_fields_must_be_filled']);
            }
        }
        elseif ($datetype == 1) {
            $where_is[] = "u.added < $date";
        }
        elseif ($datetype == 2) {
            $where_is[] = "u.added > $date";
        }
    }

    // date last seen
        $last = ( isset($_GET['ls']) ? trim($_GET['ls']) : '' );
        if ($last) {
            if (!$last = mkdate($last)) {
                trigger_error($lang['bad_date']);
            }
            $q[] = "ls=$last";
        $xz = explode('-', $last);
        $last = mktime(0,0,0,$xz[1], $xz[2], $xz[0]);
            $lasttype = intval($_GET['lst']);
            $q[] = "lst=$lasttype";
            if ($lasttype == 0) {
                $where_is[] = "u.user_session_time BETWEEN " . ($last - 86400) . " AND " . ($last + 86400);
            }
            else {
                if ($lasttype == 3) {
                    $last2 = trim($_GET['ls2']);
                    if (!$last2 = mkdate($last2)) {
                        trigger_error($lang['bad_second_date_field']);
                    }
                        if ($last2) {
                            $q[] = "ls=$last2";
                            $xz = explode('-', $last2);
                            $last2 = mktime(0,0,0,$xz[1], $xz[2], $xz[0]);
                            $where_is[] = "u.user_session_time BETWEEN $last AND $last2";
                        }
                        else {
                            trigger_error($lang['two_date_fields_must_be_filled']);
                        }
                }
                elseif ($lasttype == 1) {
                    $where_is[] = "u.user_session_time < $last";
                }
                elseif ($lasttype == 2) {
                    $where_is[] = "u.user_session_time > $last";
                }
            }
        }

        // disabled IP

        $disabled = ( isset($_GET['dip']) ? intval($_GET['dip']) : 0 );
        if ($disabled) {
            $distinct = 1;
            if ( !$config['allow_clons'] ) {
                $join_is .= ' LEFT JOIN ' . BANLIST_TABLE . ' pb ON u.ip = pb.ban_ip';
                $join_is .= ', ' . USERS_TABLE . ' u2';
                $where_is[] = 'u.ip = u2.ip';
                $where_is[] = '( pb.ban_ip IS NOT NULL OR u2.enabled = 0)';
            }
            else {
                $join_is .= ', ' . BANLIST_TABLE . ' pb';
                $where_is[] = 'u.ip = pb.ban_ip';
            }
            $q[] = "dip=$disabled";
        }

        // active
        $active = ( isset($_GET['ac']) ? intval($_GET['ac']) : 0 );
        if ($active == "1") {
            $join_is .= ', ' . PEERS_TABLE . ' p';
            $distinct = 1;
            $where_is[] = '(p.uploaded > 0 OR p.downloaded > 0)';
            $where_is[] = 'u.uid = p.uid';
            $q[] = "ac=$active";
        }

       //age
       $age = ( isset($_GET['age']) ? trim($_GET['age']) : '' );
       if ($age) {
               $current_y = gmdate("Y", time() + $userdata['tzoffset'] * 60);
               $current_m = gmdate("m", time() + $userdata['tzoffset'] * 60);
               $current_d = gmdate("d", time() + $userdata['tzoffset'] * 60);
               $search_date1 = ($current_y - $age) . '-' . $current_m . '-' . $current_d;
               $search_date2 = ($current_y - $age - 1) . '-' . $current_m . '-' . $current_d;
               $where_is[] = "u.birthday BETWEEN '$search_date2' AND '$search_date1'";
               $q[] = "age=$age";
       }

        // active
        $warned = ( isset($_GET['w']) ? $_GET['w'] : 0 );
        if ( $warned != '--') {
            $where_is[] = 'u.warneduntil ' . ( $warned == 2 ? ' = 0' : ' <> 0' );
            $q[] = "w=$warned";
        }

        $simple_fields1 = array(
                'as' => 'enabled',
                'do' => 'donor',
                'ht' => 'hiddentorrents',
                'parked' => 'parked',
                'st' => 'status',
                'gender' => 'gender'
        );

        foreach ( $simple_fields1 AS $get_name => $table_name ) {
            if ( isset($_GET[$get_name]) && $_GET[$get_name] != '--' ) {
                $x = intval($_GET[$get_name]);
                if ( $x == 1 ) {
                    $where_is[] = 'u.' . $table_name . ' = 1';
                }
                else {
                    $where_is[] = 'u.' . $table_name . ' = 0';
                }
                $q[] = $get_name . '=' . $x;
            }
        }

        $simple_fields2 = array(
                'icq' => 'icq',
                'msn' => 'msn',
                'aim' => 'aim',
                'yahoo' => 'yahoo',
                'skype' => 'skype',
                'speed_up' => 'upload',
                'speed_down' => 'download',
                'passkey' => 'torrent_pass'
        );

        foreach ( $simple_fields2 AS $get_name => $table_name ) {
            if ( !empty($_GET[$get_name]) ) {
                $where_is[] = 'u.' . $table_name . ' = ' . "'" . $db->sql_escape(urldecode($$get_name)) . "'";
                $q[] = $get_name . '=' . $_GET[$get_name];
            }
        }

        if ( $client ) {
           $join_is .= ', ' . PEERS_TABLE . ' p';
           $distinct = 1;
           $where_is[] = "p.useragent LIKE '%" . $db->sql_escape(urldecode($client)) . "%'";
           $where_is[] = 'u.uid = p.uid';
         $q[] = "client=$client";
        }

       $where_is[] = 'u.uid <> ' . ANONYMOUS;


       $where_is = ( $where_is ? implode(' AND ', $where_is) : '' );
       $where = ( $where_is ? ' WHERE ' . $where_is : '' );
       $q = ( $q ? implode("&amp;", $q) : '' );
       $join_is = ( $join_is ? $join_is : '' );
       $from_is = ' FROM ' . USERS_TABLE . ' u' . $join_is;
       $distinct = isset($distinct) ? ' DISTINCT ' : '';


       $count_sql = 'SELECT COUNT(' . $distinct . 'u.uid) AS count ' . $from_is . $where;
       $result = $db->sql_query($count_sql);


       $count = ( $arr = $db->sql_fetchrow($result) ) ? intval($arr['count']) : 0 ;
       $perpage = 30;
       list($pagertop, $pagerbottom, $offset, $limit) = pager($perpage, $count, 'usersearch.php?' . $q . '&amp;');

       $select = ' u.uid, u.name, u.email, u.ip, u.class, u.uploaded, u.downloaded, u.donor, u.enabled, u.warneduntil, u.parked';
       $sql = 'SELECT' . $distinct . $select . $from_is . $where;

       $result = $db->sql_query_limit($sql, $limit, $offset);

       if ( !($user = $db->sql_fetchrow($result)) ) {
              $template->assign_block_vars('switch_no_count', array());
       }
       else {
              $template->assign_block_vars('switch_count', array(
                 'PAGERTOP' => $pagertop,
                 'PAGERBOTTOM' => $pagerbottom, )
              );

              do {
                      $seo->set_user_url($user['name'], $user['uid']);

                     $template->assign_block_vars('switch_count.results_row', array(
                            'U_USERDETAILS' => append_sid($root_path . 'userdetails.php?id=' . $user['uid']),
                            'ID' => $user['uid'],
                            'USERNAME' => get_user_class_color($user['class'], $user['name']),
                            'USER_ICONS' => get_user_icons($user),
                            'RATIO' => get_ratio($user['uploaded'], $user['downloaded']),
                            'UPLOADED' => mksize($user['uploaded']),
                            'DOWNLOADED' => mksize($user['downloaded']),
                            'IP' => '<a href="http://ripe.net/fcgi-bin/whois?form_type=simple&amp;full_query_string=&amp;searchtext=' . $user['ip'] . '" target="_blank">' . $user['ip'] . '</a>',
                            'EMAIL' => $user['email'])
                     );
              }
              while ($user = $db->sql_fetchrow($result));

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