Hi, im sorry for my bad englisch i'm from Germany.
I've coded for you a top user page, the datats are pixels and credits. The desc limit is 5 and staffs will not show.
screen:
code:
Please thanks if you like itPHP Code:<?php
define('USERNAME_REQUIRED', TRUE);
define('ACCOUNT_REQUIRED', TRUE);
include('global.php');
define("THIS_SCRIPT", 'topuser');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $sitename." - ".$lang['topuser']; ?></title>
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
<script type="text/javascript" src="Public/JS/jquery.history.js"></script>
<link type="text/css" rel="stylesheet" href="Public/Styles/<?php echo $currentstyle ?>/CSS/main.css" />
</head>
<body id="mainbox">
<div class="mainBox">
<?php
include("header.php");
include("system/communitynav.php");
?>
<div class="mid" id="midcontent">
<div class="column" id="column3">
<div class="contentBox">
<div class="boxHeader">Most credits</div>
<div class="boxContent">
<table>
<?php
$datosTop = mysql_query("SELECT * FROM users WHERE rank <3 AND 1 ORDER BY credits DESC LIMIT 5");
while($datosTop10 = mysql_fetch_array($datosTop)){
echo '
<tr><td width="5px"></td>
<td width="20px">';
echo '<img src="http://www.habbo.com.es/habbo-imaging/avatarimage?figure=' . $datosTop10['look'] . '&direction=2&head_direction=2&gesture=sml&action=&size=m" align="left"></td> <td width="195px"><b><a href="home.php?u='.$datosTop10['username'].'">'.$datosTop10['username'].'</a><br /><br />'.$datosTop10['credits'].' Taler</b>';
echo '</td>'; } ?>
</table>
</div>
</div>
</div>
<div class="column" id="column1">
<div class="contentBox">
<div class="boxHeader">TopUser of the hotel</div>
<div class="boxContent">
<b>To publish special achievements, efforts and successes, the user 5 best user of her category will be honored on the left and right side the<br /><br /><br />
Awarded to the user in the categories<br />
• Most credits in the Hotel. <br />
• Most pixel in the hotel. <br />
<br /><br />
Congratulations to all listed users!</b>
</div>
</div>
</div>
<div class="column" id="column3">
<div class="contentBox">
<div class="boxHeader">Most pixel</div>
<div class="boxContent">
<table>
<?php
$datosTop = mysql_query("SELECT * FROM users WHERE rank <3 AND 1 ORDER BY activity_points DESC LIMIT 5");
while($datosTop10 = mysql_fetch_array($datosTop)){
echo '
<tr><td width="5px"></td>
<td width="20px">';
echo '<img src="http://www.habbo.com.es/habbo-imaging/avatarimage?figure=' . $datosTop10['look'] . '&direction=4&head_direction=4&gesture=sml&action=&size=m" align="left"></td> <td width="195px"><b><a href="home.php?u='.$datosTop10['username'].'">'.$datosTop10['username'].'</a><br /><br />'.$datosTop10['activity_points'].' Pixel</b>';
echo '</td>'; } ?>
</table>
</div>
</div>
</div></div>
<?php include("system/footer.php"); ?>
</div>
</body>
</html>
Originally Posted by Subway
