Rangliste

echo'<h2><u>Rangiste</u></h2>';


$anzeigen=10;


if($_GET['vor']){$start=$_GET['limit']+$anzeigen;}
if($_GET['back']){$start=$_GET['limit']-$anzeigen;}
if(!$start){ $start=0; }


echo'<center><table width="400" border="1" cellpadding="1">
<tr>
    <th scope="col">Platz</th>
    <th scope="col">Punkte</th>
    <th scope="col">Name</th>
    <th scope="col">Firma</th>
    <th scope="col"><span style="color:green">Online</span>/<span style="color:red">Offline</span></th>
  </tr>
<tr><td>';


$platz = '1'; 


$sql = mysql_query("SELECT * FROM users ORDER BY points DESC LIMIT $start,$anzeigen");
while($data = mysql_fetch_assoc($sql)) {
echo $platz."</td><td>";echo $data['points']."</td><td><a href=?page=showprof&userid=";echo $data['id'].">";echo $data['user']."</a></td><td>";echo $data['firma']."</td><td>";echo $data['onoff']."</td></tr>
<tr><td>";
$platz = $platz+1; 
} 
echo'</table>';


echo'<table border="1" width="400"><tr><td align="left">';
echo '[url='?page=rang&limit='.$start.'&back=1']Zurück[/url]';
echo'</td><td align="right">';
echo '[url='?page=rang&limit='.$start.'&vor=1']Weiter[/url]';
echo "</td></tr></table>";


echo '










<form action=index2.php?page=showprof&username='.$username.' method=post>
User suchen: <input type="text" name="username"><input type="submit" value="Ok">
</form>
</center>';

echo'<h2><u>Rangiste</u></h2>';


$anzeigen=10;


if($_GET['vor']){$start=$_GET['limit']+$anzeigen;}
if($_GET['back']){$start=$_GET['limit']-$anzeigen;}
if(!$start){ $start=0; }


echo'<center><table width="400" border="1" cellpadding="1">
<tr>
    <th scope="col">Platz</th>
    <th scope="col">Punkte</th>
    <th scope="col">Name</th>
    <th scope="col">Firma</th>
    <th scope="col"><span style="color:green">Online</span>/<span style="color:red">Offline</span></th>
  </tr>
<tr><td>';


if(!$_GET['platz'])
{ $platz = '1'; } 


$sql = mysql_query("SELECT * FROM users ORDER BY points DESC LIMIT $start,$anzeigen");
while($data = mysql_fetch_assoc($sql)) {
echo $platz."</td><td>";echo $data['points']."</td><td><a class=link href=?page=showprof&userid=";echo $data['id'].">";echo $data['user']."</a></td><td>";echo $data['firma']."</td><td align=center>";echo $data['online']."</td></tr>
<tr><td>";
$platz = $platz+1; 
$zurueck = $platz-$anzeigen-$anzeigen;


} 
echo'</table>';


echo'<table border="1" width="400"><tr><td align="left">';
echo '[url='?page=rang&limit='.$start.'&back=1&platz='.$zurueck.'']Zurück[/url]';
echo'</td><td align="right">';
echo '[url='?page=rang&limit='.$start.'&vor=1&platz='.$platz.'']Weiter[/url]';
echo "</td></tr></table>";
echo '










<form action=index2.php?page=showprof&username='.$username.' method=post>
User suchen: <input type="text" name="username"><input type="submit" value="Ok">
</form>


</center>';