betteln4.php

<?php
userstatus();
head('Dein Bettellink');
?>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
	<tr>
		<td align="right"><b>Dein Reflink:</b></td>
		<td align="left">&nbsp;<a href="<?=$domain;?>/?ref=<?=$_SESSION['uid'];?>" target="_blank"><?=$domain;?>/?ref=<?=$_SESSION['uid'];?></a></td>
	</tr>
	<tr>
		<td align="right"><b>Reflink und Bettellink:</b></td>
		<td align="left">&nbsp;<a href="<?=$domain;?>/?content=/betteln&amp;ref=<?=$_SESSION['uid'];?>" target="_blank"><?=$domain;?>/?content=/betteln&amp;ref=<?=$_SESSION['uid'];?></a></td>
	</tr>
</table>
<?php
foot();

head('Die Top 25 Bettler');
?>
<table width="100%" cellpadding="1" cellspacing="1" border="0" class="tr_table">
	<tr class="tr_head">
		<td width="50"><b>Rang</b></td>
		<td><b>Mitglied</b></td>
		<td width="100"><b>Aufrufe</b></td>
		<td width="150"><b><?=$waehrung;?></b></td>
	</tr>
<?php
$rang = 1;
$sql = db_query ('SELECT k.uid, k.angebettelt, k.bv, u.nickname FROM ' . $db_prefix . '_kontodaten k LEFT JOIN ' . $db_prefix . '_userdaten u ON u.uid = k.uid ORDER BY angebettelt DESC LIMIT 25');
while ($user = mysqli_fetch_array($sql)) {
    $row = ($rang % 2 == 0) ? 0 : 1;
    echo '	<tr class="tr_row' . $row . '">
		<td align="right">' . $rang++ . '.&nbsp;</td>
		<td>&nbsp;' . $user['nickname'] . '</td>
		<td align="right">' . number_format($user['angebettelt'], 0) . '&nbsp;</td>
		<td align="right">' . number_format($user['bv'], 2, ',', '.') . ' ' . $waehrung . '&nbsp;</td>
	</tr>';
}
?>
</table>
<?php foot(); ?>