Hallo!

Wer gerne noch mehr angezeigt bekommen möchte, kann sich gerne diesen Code nehmen.
Danke auch hierfür an den User VMS1!
Hier der Code:
Code:
<?
@require_once ('lib/functions.lib.php');
?>

<?head("Unsere Top 10 Klick4Banner Klicker");?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="10%"><b>Rang</b></td>
<td align="center" width="30%"><b>Klamm ID</b></td>
<td align="center" width="30%"><b>Nickname</b></td>
<td align="center" width="30%"><b>Klicks</b></td>
</tr>
<?
$rang = 1;
$klicksrang = db_query("SELECT t1.uid, t1.klicks, t2.nickname FROM ".$db_prefix."_kontodaten AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid ORDER BY t1.klicks DESC LIMIT 10");
while ($klickliste=mysql_fetch_array($klicksrang)) {

echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="10%">'. $rang++ .'</td>
<td align="center" width="30%"><a href="http://www.klamm.de/?nickpage='.$klickliste['uid'].'" target="_blank">'.$klickliste['uid'].'</a></td>
<td align="center" width="30%"><a href="'.$domain.'/?content=/nickpage&id='.$klickliste['uid'].'" target="_self">'.$klickliste['nickname'].'</a></td>
<td align="center" width="30%">'.number_format($klickliste['klicks'],0,",",".").'</td>
</tr>
';
}
?>
</table>
<?foot();?>

<?head("Unsere Top 10 Klick4Text Klicker");?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="10%"><b>Rang</b></td>
<td align="center" width="30%"><b>Klamm ID</b></td>
<td align="center" width="30%"><b>Nickname</b></td>
<td align="center" width="30%"><b>Klicks</b></td>
</tr>
<?
$rang = 1;
$klicksrang = db_query("SELECT t1.uid, t1.textlinks, t2.nickname FROM ".$db_prefix."_kontodaten AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid ORDER BY t1.textlinks DESC LIMIT 10");
while ($klickliste=mysql_fetch_array($klicksrang)) {

echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="10%">'. $rang++ .'</td>
<td align="center" width="30%"><a href="http://www.klamm.de/?nickpage='.$klickliste['uid'].'" target="_blank">'.$klickliste['uid'].'</a></td>
<td align="center" width="30%"><a href="'.$domain.'/?content=/nickpage&id='.$klickliste['uid'].'" target="_self">'.$klickliste['nickname'].'</a></td>
<td align="center" width="30%">'.number_format($klickliste['textlinks'],0,",",".").'</td>
</tr>
';
}
?>
</table>
<?foot();?>

<? head("Unsere Top 10 Bettler"); ?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="10%"><b>Rang</b></td>
<td align="center" width="30%"><b>Klamm ID</b></td>
<td align="center" width="30%"><b>Nickname</b></td>
<td align="center" width="30%"><b>Aufrufe</b></td>
</tr>
<?
$rang = 1;
$klicksrang = db_query("SELECT t1.uid, t1.angebettelt, t2.nickname FROM ".$db_prefix."_kontodaten AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid ORDER BY t1.angebettelt DESC LIMIT 10");
while ($klickliste=mysql_fetch_array($klicksrang)) {

echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="10%">'. $rang++ .'</td>
<td align="center" width="30%"><a href="http://www.klamm.de/?nickpage='.$klickliste['uid'].'" target="_blank">'.$klickliste['uid'].'</a></td>
<td align="center" width="30%"><a href="'.$domain.'/?content=/nickpage&id='.$klickliste['uid'].'" target="_self">'.$klickliste['nickname'].'</a></td>
<td align="center" width="30%">'.number_format($klickliste['angebettelt'],0,",",".").'</td>
</tr>
';
}
?>
</table>
<? foot(); ?>

<?head("Unsere Top 10 Startseitenaufrufer");?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="10%"><b>Rang</b></td>
<td align="center" width="30%"><b>Klamm ID</b></td>
<td align="center" width="30%"><b>Nickname</b></td>
<td align="center" width="30%"><b>Aufrufe</b></td>
</tr>
<?
$rang = 1;
$klicksrang = db_query("SELECT t1.uid, t1.s_aufrufe, t2.nickname FROM ".$db_prefix."_kontodaten AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid ORDER BY t1.s_aufrufe DESC LIMIT 10");
while ($klickliste=mysql_fetch_array($klicksrang)) {

echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="10%">'. $rang++ .'</td>
<td align="center" width="30%"><a href="http://www.klamm.de/?nickpage='.$klickliste['uid'].'" target="_blank">'.$klickliste['uid'].'</a></td>
<td align="center" width="30%"><a href="'.$domain.'/?content=/nickpage&id='.$klickliste['uid'].'" target="_self">'.$klickliste['nickname'].'</a></td>
<td align="center" width="30%">'.number_format($klickliste['s_aufrufe'],0,",",".").'</td>
</tr>
';
}
?>
</table>
<?foot();?>

<?head("Unsere Top 10 Bannerjackpots");?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="10%"><b>Rang</b></td>
<td align="center" width="14%"><b>Klamm ID</b></td>
<td align="center" width="24%"><b>Nickname</b></td>
<td align="center" width="24%"><b>Jackpothöhe</b></td>
<td align="center" width="28%"><b>Zeit</b></td>
</tr>
<?
$rang = 1;
$potdaten = db_query("SELECT t1.uid, t1.zeit, t1.banner_jackpot, t2.nickname FROM ".$db_prefix."_check_jackpots AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid WHERE t1.beendet = 1 ORDER BY t1.banner_jackpot DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="10%">'. $rang++ .'</td>
<td align="center" width="14%"><a href="http://www.klamm.de/?nickpage='.$potliste['uid'].'" target="_blank">'.$potliste['uid'].'</a></td>
<td align="center" width="24%"><a href="'.$domain.'/?content=/nickpage&id='.$potliste['uid'].'" target="_self">'.$potliste['nickname'].'</td>
<td align="center" width="24%">'.number_format($potliste['banner_jackpot'],0,",",".").'</td>
<td align="center" width="28%">'.date("d.m.Y H:i:s",$potliste['zeit']).'</td>
</tr>
';
}
?>
</table>
<?foot();?>

<?head("Unsere letzten Bannerjackpot Gewinner");?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="25%"><b>Klamm ID</b></td>
<td align="center" width="25%"><b>Nickname</b></td>
<td align="center" width="25%"><b>Jackpothöhe</b></td>
<td align="center" width="25%"><b>Zeit</b></td>
</tr>
<?
$potdaten = db_query("SELECT t1.uid, t1.zeit, t1.banner_jackpot, t2.nickname FROM ".$db_prefix."_check_jackpots AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid WHERE t1.beendet = 1 ORDER BY t1.zeit DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="25%"><a href="http://www.klamm.de/?nickpage='.$potliste['uid'].'" target="_blank">'.$potliste['uid'].'</a></td>
<td align="center" width="25%"><a href="'.$domain.'/?content=/nickpage&id='.$potliste[uid].'" target="_self">'.$potliste['nickname'].'</td>
<td align="center" width="25%">'.number_format($potliste['banner_jackpot'],0,",",".").'</td>
<td align="center" width="25%">'.date("d.m.Y H:i:s",$potliste['zeit']).'</td>
</tr>
';
}
?>
</table>
<?foot();?>

<?head("Unsere Top 10 Mailjackpots");?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="10%"><b>Rang</b></td>
<td align="center" width="14%"><b>Klamm ID</b></td>
<td align="center" width="24%"><b>Nickname</b></td>
<td align="center" width="24%"><b>Jackpothöhe</b></td>
<td align="center" width="28%"><b>Zeit</b></td>
</tr>
<?
$rang = 1;
$potdaten = db_query("SELECT t1.uid, t1.zeit, t1.mail_jackpot, t2.nickname FROM ".$db_prefix."_check_mailjackpots AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid WHERE t1.beendet = 1 ORDER BY t1.mail_jackpot DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="10%">'. $rang++ .'</td>
<td align="center" width="14%"><a href="http://www.klamm.de/?nickpage='.$potliste['uid'].'" target="_blank">'.$potliste['uid'].'</a></td>
<td align="center" width="24%"><a href="'.$domain.'/?content=/nickpage&id='.$potliste['uid'].'" target="_self">'.$potliste['nickname'].'</td>
<td align="center" width="24%">'.number_format($potliste['mail_jackpot'],0,",",".").'</td>
<td align="center" width="28%">'.date("d.m.Y H:i:s",$potliste['zeit']).'</td>
</tr>
';
}
?>
</table>
<?foot();?>

<?head("Unsere letzten Mailjackpot Gewinner");?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr class="tr_head">
<td align="center" width="25%"><b>Klamm ID</b></td>
<td align="center" width="25%"><b>Nickname</b></td>
<td align="center" width="25%"><b>Jackpothöhe</b></td>
<td align="center" width="25%"><b>Zeit</b></td>
</tr>
<?
$potdaten = db_query("SELECT t1.uid, t1.zeit, t1.mail_jackpot, t2.nickname FROM ".$db_prefix."_check_mailjackpots AS t1 LEFT JOIN ".$db_prefix."_userdaten AS t2 ON t2.uid = t1.uid WHERE t1.beendet = 1 ORDER BY t1.zeit DESC LIMIT 10");
while ($potliste=mysql_fetch_array($potdaten)) {
echo '
<tr bgcolor="#E2E2E2">
<td align="center" width="25%"><a href="http://www.klamm.de/?nickpage='.$potliste['uid'].'" target="_blank">'.$potliste['uid'].'</a></td>
<td align="center" width="25%"><a href="'.$domain.'/?content=/nickpage&id='.$potliste[uid].'" target="_self">'.$potliste['nickname'].'</td>
<td align="center" width="25%">'.number_format($potliste['mail_jackpot'],0,",",".").'</td>
<td align="center" width="25%">'.date("d.m.Y H:i:s",$potliste['zeit']).'</td>
</tr>
';
}
?>
</table>
<?foot();?>