Ik heb een ledenlijst pagina gemaakt.
Heeft iemand nog iets toe te voegen, of een opmerking, alles is welkom.
Ook kritiek is welkom :cheer:
PHP
<?php
include ("includes/config.php");
Login();
echo "<html>
<head>
<title>Crimini</title>
<link href=\"static/layout/css/menu.css\" rel=\"stylesheet\" type=\"text/css\">
</head>
<body>";
if ($_GET['sort'] == "alive")
{
$sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='alive'");
}
elseif ($_GET['sort'] == "dead")
{
$sQuery = mysql_query("SELECT * FROM `Members` WHERE `status`='dead'");
}
elseif ($_GET['sort'] == "nickname")
{
$sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `nickname` ASC");
}
elseif ($_GET['sort'] == "xp")
{
$sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `xp` ASC");
}
else {
$sQuery = mysql_query("SELECT * FROM `Members` ORDER BY `regtime` ASC");
}
$iRow = mysql_num_rows($sQuery);
if ($iRow == 0)
{
echo "Geen gebruikers";
}
else
{
echo "<table>
<tr>
<td>Nicknaam</td>
<td>Familie</td>
<td>Rang</td>
</tr>";
while($sResult = mysql_fetch_assoc($sQuery))
{
$sQueryUser = mysql_query("SELECT * FROM `Members` WHERE `nickname`='" .$sResult['nickname']. "'");
$sUser = mysql_fetch_assoc($sQueryUser);
if (empty($sResult['family']))
{
$sFamily = "Geen";
}
else
{
$sQueryFam = mysql_query("SELECT * FROM `Family` WHERE `name`='" .$sResult['family']. "'");
$sFam = mysql_fetch_assoc($sQueryFam);
$sFamily = "<a href=\"family-profile.php?id=" .$sFam['id']. "\">" .$sResult['family']. "</a>";
}
if ($sResult['xp'] < 10)
{
$sRang = "Empty-suit";
}
elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "male")
{
$sRang = "Deliveryboy";
}
elseif ($sResult['xp'] < 20 AND $sResult['sex'] == "female")
{
$sRang = "Delivery Girl";
}
elseif ($sResult['xp'] < 50)
{
$sRang = "Picciotto";
}
// komen nog meer rangen erbij
$sNickname = "<a href=\"user-profile.php?id=" .$sUser['id']. "\">" .$sResult['nickname']. "</a>";
echo " <tr>
<td>" .$sNickname. "</td>
<td>" .$sFamily. "</td>
<td>" .$sRang. "</td>
</tr>";
}
}
echo "</body>
</html>";
mysql_close();
?>
Toon Meer