1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
$fetch = mysql_query("SELECT * FROM `members`");
while ($user = mysql_fetch_array($fetch))
{
if ($user[userlevel] == 6)
{
echo ("<font face='Verdana' size='1' color='#FF0000'>$user[username]</font>");
}
elseif ($user[userlevel] == 4)
{
echo ("<font face='Verdana' size='1' color='#0000FF'>$user[username]</font>");
}
else
{
echo ("<font face='Verdana' size='1' color='#000000'>$user[username]</font>");
}
}
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
<?php
session_start(); //allows session
require_once "config.php";
include('header.php') ; ?>
<div class="left">
<div class="divheader">Medlemmer
</div>
<?php
if(isset($_GET['user'])){ //if there trying to view a profile
//gets the user name and makes it safe
$username = addslashes($_GET[user]);
//querys the db to find the username
$getuser = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'");
//checks see if the username exists in the db
$usernum = mysql_num_rows($getuser);
//if it don't exist
if ($usernum == 0)
{
//don't exist
echo ("Bruker ble ikke funnet");
//if it does exist then show there profile
}
else
{
$user = mysql_fetch_array($getuser);
$user_rank = change_levels($user[userlevel]);
echo "<fieldset style='width: 350'>
<b>$user[username]'s Profil</b><br><br><br>
<img src='$user[avatar]'></a><br>
Brukerlevel: $user_rank
Email: $user[email]<br>
Sted: $user[location]<br>
Kjønn: $user[sex]<br>
Alder: $user[age]
</fieldset>";
}
}
else
{
//gets all the members from the database
$getusers = mysql_query("SELECT * FROM `members` ORDER BY `id` ASC") or die(mysql_error());
//loops their names out
while ($user = mysql_fetch_array($getusers))
{
if ($user[userlevel] == 6)
{
echo ("<font face='Verdana' color='#FF0000'>$user[username]</font><br>");
}
elseif ($user[userlevel] == 4)
{
echo ("<font face='Verdana' color='#0000FF'>$user[username]</font><br>");
}
else
{
echo ("<font face='Verdana' color='#000000'>$user[username]</font><br>");
}
}
{
echo "<a href='members.php?user=$user[username]'>$user[username]</a><br>";
}
}
?></div>
<?php include('footer.php'); ?>