Search options (Page 97 of 106)

SELECT id, username, num_posts, registered, location FROM ".$db->prefix."users WHERE username!='Guest' ORDER BY RAND() LIMIT 1

$query = "SELECT id, username, num_posts, registered, location FROM ".$db->prefix."users WHERE username!='Guest' ORDER BY RAND() LIMIT 1";
$result = $db->query($query) or die(mysql_error());

$data = $db->fetch_assoc($result);

if ($pun_config['o_avatars'] == '1' && $pun_user['show_avatars'] != '0')
        {
            if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$data['id'].'.gif'))
                $user_avatar = '<img src="'.$pun_config['o_avatars_dir'].'/'.$data['id'].'.gif" '.$img_size[3].' alt="" />';
            else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$data['id'].'.jpg'))
                $user_avatar = '<img src="'.$pun_config['o_avatars_dir'].'/'.$data['id'].'.jpg" '.$img_size[3].' alt="" />';
            else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$data['id'].'.png'))
                $user_avatar = '<img src="'.$pun_config['o_avatars_dir'].'/'.$data['id'].'.png" '.$img_size[3].' alt="" />';
        }
        else
            $user_avatar = '';

// echo "<br />",$query,"<br /><b>Id: </b>",$data['id'],"<br /><b>Username: </b>",$data['username'],"<br />","<br />";
echo "<br />";
echo "<b>Id:</b> " . $data['id'];
echo "<br />";
echo "<b>Username:</b> " . $data['username'];
echo "<br />";
echo "<b>Posts:</b> " . $data['num_posts'];
echo "<br />";
echo "<b>Registered on:</b> " . $data['registered'];
echo "<br />";
echo "<b>Location:</b> " . $data['location'];
echo "<br />";
// echo "<b>Avatar:</b> <img src=\"img/avatars/" . $data['avatar'] . "\" alt=\"" . $data['avatar'] . "\" />";
echo "<b>Avatar: </b> " . $user_avatar;
echo "<br />";
echo "<br />";
?>