erstelle eine datei mit dem namen top10.php füge folgenden code dort ein:
<?
@require_once ('lib/functions.lib.php');
$kontostand = mysql_fetch_array(db_query("SELECT `kontostand` FROM ".$db_prefix."_kontodaten WHERE uid=".$_SESSION['uid']." and passwort = '".$_SESSION['passwort']."' LIMIT 1"));
$guthaben = round($kontostand['kontostand'],0);
?>
<?head("$seitenname - Top 10 Liste");?>
<center><br><b>Hier findest Du unsere Aktuelle User Top 10 Liste.<br><br>
<?foot();?>
<?head("Top 10 - Rangliste ( Nach Klicks )");?>
<br><table width="100%" cellpadding="1" cellspacing="1" border="0" bgcolor="#f6d288">
<tr bgcolor="#4169E1">
<td align="center"><font color="white"><b>Rang</b></font></td>
<td align="center"><font color="white"><b>Klamm ID</b></font></td>
<td align="center"><font color="white"><b>Klicks</b></font></td>
</tr>
<?
$rang = 1;
$klicksrang = db_query("SELECT * FROM ".$db_prefix."_kontodaten ORDER BY klicks DESC LIMIT 10");
while ($klickliste=mysql_fetch_array($klicksrang)) {
echo '
<tr bgcolor="#FAEBD7">
<td align="center">'. $rang++ .'</td>
<td align="center">'.$klickliste[uid].'</td>
<td align="center">'.number_format($klickliste[klicks],0,",",".").'</td>
</tr>
';
}
?>
</table>
<?foot();?>
<?head("Top 10 - Rangliste ( Nach Loseguthaben )");?>
<br>
<table width="100%" cellpadding="1" cellspacing="1" border="0" bgcolor="#f6d288">
<tr bgcolor="#4169E1">
<td align="center"><font color="white"><b>Rang</b></font></td>
<td align="center"><font color="white"><b>Klamm ID</b></font></td>
<td align="center"><font color="white"><b>Lose</b></font></td>
</tr>
<?
$rang = 1;
$guthabenrang = db_query("SELECT * FROM ".$db_prefix."_kontodaten ORDER BY kontostand DESC LIMIT 10");
while ($guthabenliste=mysql_fetch_array($guthabenrang)) {
echo '
<tr bgcolor="#FAEBD7">
<td align="center">'. $rang++ .'</td>
<td align="center">'.$guthabenliste[uid].'</td>
<td align="center">'.number_format($guthabenliste[kontostand],0,",",".").'</td>
</tr>
';
}
?>
</table>
<?foot();?>
<?head("Top 10 - BannerJackpots");?>
<table cellpadding="5" cellspacing="1" width="100%" class=menue border="1" bordercolor="#640002">
<tr>
<td align="center" width="25%"><b>Rang</b></td>
<td align="center" width="25%"><b>User</b></td>
<td align="center" width="25%"><b>Jackpothöhe</b></td>
<td align="center" width="25%"><b>Zeit</b></td>
</tr>
<?
$rang = 1;
$potdaten = db_query("SELECT * FROM ".$db_prefix."_check_jackpots WHERE beendet = 1 ORDER BY banner_jackpot DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr>
<td align="center" width="25%">'. $rang++ .'</td>
<td align="center" width="25%">'.$potliste[uid].'</td>
<td align="center" width="25%">'.number_format($potliste[banner_jackpot],0,",",".").'</td>
<td align="center" width="25%" nowrap>'.date("d.m.Y H:i:s",$potliste[zeit]).'</td>
</tr>
';
}
?>
</table>
<?foot();?>
<?head("BannerJackpot Gewinner");?>
<table cellpadding="5" cellspacing="1" width="100%" class=menue border="1" bordercolor="#640002">
<tr>
<td align="center" width="33%"><b>Zeit</b></td>
<td align="center" width="33%"><b>User</b></td>
<td align="center" width="33%"><b>Jackpothöhe</b></td>
</tr>
<?
$potdaten = db_query("SELECT * FROM ".$db_prefix."_check_jackpots WHERE beendet = 1 ORDER BY Zeit DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr>
<td align="center" width="33%" nowrap>'.date("d.m.Y H:i:s",$potliste[zeit]).'</td>
<td align="center" width="33%">'.$potliste[uid].'</td>
<td align="center" width="33%">'.number_format($potliste[banner_jackpot],0,",",".").'</td>
</tr>
';
}
?>
</table>
<?foot();?>
<?head("BannerJackpot");?>
<table cellpadding="5" cellspacing="1" width="100%" class=menue border="1" bordercolor="#640002">
<tr>
<td align="center"><b>Jackpothöhe</b></td>
</tr>
<?
$banner_jackpotdaten = mysql_fetch_array(db_query("SELECT * FROM ".$db_prefix."_check_jackpots WHERE beendet = 0"));
echo '
<tr>
<td align="center">'.number_format($banner_jackpotdaten[banner_jackpot],0,",",".").'</td>
</tr>
';
?>
</table>
<?foot();?>
<?head("Top 10 - MailJackpots");?>
<table cellpadding="5" cellspacing="1" width="100%" class=menue border="1" bordercolor="#640002">
<tr>
<td align="center" width="25%"><b>Rang</b></td>
<td align="center" width="25%"><b>User</b></td>
<td align="center" width="25%"><b>Jackpothöhe</b></td>
<td align="center" width="25%"><b>Zeit</b></td>
</tr>
<?
$rang = 1;
$potdaten = db_query("SELECT * FROM ".$db_prefix."_mail_check_jackpots WHERE beendet = 1 ORDER BY mail_jackpot DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr>
<td align="center" width="25%">'. $rang++ .'</td>
<td align="center" width="25%">'.$potliste[uid].'</td>
<td align="center" width="25%">'.number_format($potliste[mail_jackpot],0,",",".").'</td>
<td align="center" width="25%" nowrap>'.date("d.m.Y H:i:s",$potliste[zeit]).'</td>
</tr>
';
}
?>
</table>
<?foot();?>
<?head("MailJackpot Gewinner");?>
<table cellpadding="5" cellspacing="1" width="100%" class=menue border="1" bordercolor="#640002">
<tr>
<td align="center" width="33%"><b>Zeit</b></td>
<td align="center" width="33%"><b>User</b></td>
<td align="center" width="33%"><b>Jackpothöhe</b></td>
</tr>
<?
$potdaten = db_query("SELECT * FROM ".$db_prefix."_mail_check_jackpots WHERE beendet = 1 ORDER BY Zeit DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr>
<td align="center" width="33%" nowrap>'.date("d.m.Y H:i:s",$potliste[zeit]).'</td>
<td align="center" width="33%">'.$potliste[uid].'</td>
<td align="center" width="33%">'.number_format($potliste[mail_jackpot],0,",",".").'</td>
</tr>
';
}
?>
</table>
<?foot();?>
<?head("MailJackpot");?>
<table cellpadding="5" cellspacing="1" width="100%" class=menue border="1" bordercolor="#640002">
<tr>
<td align="center"><b>Jackpothöhe</b></td>
</tr>
<?
$mail_jackpotdaten = mysql_fetch_array(db_query("SELECT * FROM ".$db_prefix."_mail_check_jackpots WHERE beendet = 0"));
echo '
<tr>
<td align="center">'.number_format($mail_jackpotdaten[mail_jackpot],0,",",".").'</td>
</tr>
';
?>
</table>
<?foot();?>
lade sie hoch in content/intern/top10.php
verlinke sie <a href="?content/intern/top10">Top 10</a><br>