Top10 suche

[tuker1965]

Hi@all,
bin auf der suche nach dem top10 schnipsel oder addon fürs vms1,
kann da jemand helfen?
Finde hier nichts über suchfunktion:-(


bzw.kann hier noch jemand den Code posten,weil bin der meinung war ein kostenlosaddon im alten forum.

gruss
tuker1965

[dude32]

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>

[tuker1965]

hi dude super danke für die schnelle hilfe,gleich mal einbauen gehen.:-)


gruss
tuker1965