?php

require_once('./data_classes/server-data.php_data_classes-core.php.php');
require_once('./data_classes/server-data.php_data_classes-session.php.php');

$pagename = "Top User";
$pageid = "14";
$body_id = "credits";

include('./templates/community_subheader.php');
include('./templates/community_header.php');

?>

<div id="container">

<!-- / Table left - Credits -->
<div id="content" style="position: relative" class="clearfix">
<div id="column" class="column">
<div class="habblet-container ">
<div class="cbb clearfix orange ">
<h2 class="title"><span style="float: left;">Taler</span> </h2>
<div align="left">
<table width="100%">
<tr>

<?php

$row = mysql_query("SELECT * FROM users WHERE rank < 5 ORDER BY credits DESC LIMIT 5");
while($sql = mysql_fetch_assoc($row)){

?>

<tr><td width="5px"></td>
<td width="20px">
<img src="<?php echo $avatar; echo $sql['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td>
<td width="195px"><a href="<?php echo $path; ?>/home/<?php echo $sql['username']; ?>"><b><?php echo $sql['username']; ?></b></a><br /><?php echo $sql['credits']; ?> Taler</td>
	  <?php } ?>
</tr>
</table>
</div> </div>

</div>

<!-- / Table center - Onlinezeit -->
<div id="column" class="column"><div class="habblet-container ">
<div class="cbb clearfix orange ">
<h2 class="title"><span style="float: left;">Onlinezeit</span> </h2>
<div align="left">
<table width="100%">

<tr>
<?php

$userstats_a = mysql_query("SELECT * FROM user_stats ORDER BY OnlineTime DESC LIMIT 5");
while($userstats = mysql_fetch_assoc($userstats_a)){
$row = mysql_fetch_assoc($row = mysql_query("SELECT * FROM users WHERE id = '".$userstats['id']."' LIMIT 5"));

$time = 3600*24; // 60*60*24

?>

<tr><td width="5px"> </td>
<td width="20px"><img src="<?php echo $avatar; echo $row['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td>
<td width="195px"><a href="../home/<?php echo $row['username']; ?>"><b><?php echo $row['username']; ?></b></a><br />
<?php echo round($userstats['OnlineTime'] / $time); ?> Stunden</td>
</tr>

<?php } ?>
</table>
</div> </div>

</div>
</div> </div>

<!-- / Table center - Pixel -->
<div id="column" class="column"><div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title"><span style="float: left;">Pixel</span> </h2>
<div align="left">
<table width="100%">
<tr>

<?php

$row = mysql_query("SELECT * FROM users WHERE rank < 5 ORDER BY activity_points DESC LIMIT 5");
while($sql = mysql_fetch_assoc($row)){

?>
	  <tr><td width="5px"> </td>
            <td width="20px"><img src="<?php echo $avatar; echo $sql['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td> <td width="195px"><a href="../home/<?php echo $sql['username']; ?>"><b><?php echo $sql['username']; ?></b></a><br /><?php echo $sql['activity_points']; ?> Pixel</td>
	  <?php } ?>
</tr>
</table>
</div> </div>

</div>

<!-- / Table center - Geschenke -->
<div id="column" class="column"><div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title"><span style="float: left;">Geschenke vergeben</span> </h2>
<div align="left">
<table width="100%">

<tr>
<?php

$userstats_a = mysql_query("SELECT * FROM user_stats ORDER BY GiftsGiven DESC LIMIT 5");
while($userstats = mysql_fetch_assoc($userstats_a)){
$row = mysql_fetch_assoc($row = mysql_query("SELECT * FROM users WHERE id = '".$userstats['id']."' LIMIT 5"));

?>

<tr><td width="5px"> </td>
<td width="20px"><img src="<?php echo $avatar; echo $row['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td>
<td width="195px"><a href="../home/<?php echo $row['username']; ?>"><b><?php echo $row['username']; ?></b></a><br />
<?php echo $userstats['GiftsGiven']; ?> Geschenke vergeben</td>
</tr>

<?php } ?>
</table>
</div> </div>

</div>
</div> </div>



<!-- / Table right - Respect -->
<div id="column" class="column"><div class="habblet-container ">
<div class="cbb clearfix green ">
<h2 class="title"><span style="float: left;">Lobe</span> </h2>
<div align="left">
<table width="100%">

<tr>
<?php

$userstats_a = mysql_query("SELECT * FROM user_stats ORDER BY Respect DESC LIMIT 5");
while($userstats = mysql_fetch_assoc($userstats_a)){
$row = mysql_fetch_assoc($row = mysql_query("SELECT * FROM users WHERE id = '".$userstats['id']."' LIMIT 5"));

?>

<tr><td width="5px"> </td>
<td width="20px"><img src="<?php echo $avatar; echo $row['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td>
<td width="195px"><a href="../home/<?php echo $row['username']; ?>"><b><?php echo $row['username']; ?></b></a><br />
<?php echo $userstats['Respect']; ?> Lobe erhalten</td>
</tr>

<?php } ?>
</table>
</div> </div>

</div>

<!-- / Table right - Geschenke² -->
<div id="column" class="column"><div class="habblet-container ">
<div class="cbb clearfix green ">
<h2 class="title"><span style="float: left;">Geschenke erhalten</span> </h2>
<div align="left">
<table width="100%">

<tr>
<?php

$i = 0;
$userstats_a = mysql_query("SELECT * FROM user_stats ORDER BY GiftsReceived DESC LIMIT 5");
while($userstats = mysql_fetch_assoc($userstats_a)){

$row = mysql_fetch_assoc($row = mysql_query("SELECT * FROM users WHERE id = '".$userstats['id']."' LIMIT 5"));

$i++;

?>

<tr><td width="5px"> </td>
<td width="20px"><img src="<?php echo $avatar; echo $row['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td>
<td width="195px"><a href="../home/<?php echo $row['username']; ?>"><b><?php echo $row['username']; ?></b></a><br />
<?php echo $userstats['GiftsReceived']; ?> Geschenke erhalten</td>
</tr>

<?php } ?>
</table>
</div> </div>

</div>
</div> </div>

<script type="text/javascript">
		HabboView.run();
	</script>
				<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>


</div>

<?php include('./templates/login_footer.php'); ?>