Reply to thread

Message

<blockquote data-quote="Sledmore" data-source="post: 212153" data-attributes="member: 591">In your topstats you're fetching more than enough data this should work better for you:&nbsp;[PHP]&lt;!DOCTYPE html&gt;&lt;html lang=&quot;en&quot;&gt;&nbsp; &nbsp; &lt;head&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=utf-8&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;title&gt;HabZon: eXpert&lt;/title&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;?php include_once('header.php'); ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;metab&quot;&gt;&lt;a href=&quot;{url}/me&quot;&gt;{username} &lt;img src=&quot;{url}/app/tpl/skins/{skin}/images/id.png&quot; style=&quot;vertical-align: middle;&quot;&gt;&lt;/a&gt;&lt;span&gt;&lt;/span&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;li class=&quot;selected&quot;&gt;&lt;strong&gt;Commmunity&nbsp; &lt;img src=&quot;{url}/app/tpl/skins/{skin}/images/forum_2.gif&quot; style=&quot;vertical-align: middle;&quot;&gt;&lt;/strong&gt;&lt;span&gt;&lt;/span&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;{url}/shop&quot;&gt;Shop &lt;img src=&quot;{url}/app/tpl/skins/{skin}/images/new_11.gif&quot; style=&quot;vertical-align: middle;&quot;&gt;&lt;/a&gt;&lt;span&gt;&lt;/span&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ul&gt;&lt;div id=&quot;ibxs-online&quot;&gt;&lt;div class=&quot;rounded&quot;&gt;&lt;div style=&quot;padding-top:7px;&quot;&gt;&lt;a href=&quot;/client&quot; class=&quot;new-button green-button&quot; style=&quot;float:left;&quot; target=&quot;ClientWnd&quot; onclick=&quot;HabboClient.openOrFocus(this); return false;&quot;&gt;&lt;b&gt;Enter HabZon&lt;/b&gt;&lt;i&gt;&lt;/i&gt;&lt;/a&gt;&lt;/div&gt;&lt;span style=&quot;margin-top:-2px&quot;&gt;{online} User(s) online &lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;div id=&quot;content-container&quot;&gt;&lt;div id=&quot;navi2-container&quot; class=&quot;pngbg&quot;&gt;&lt;div id=&quot;navi2&quot; class=&quot;pngbg clearfix&quot;&gt;&lt;ul&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;&quot;&gt;&lt;a href=&quot;{url}/community&quot;&gt;Community&lt;/a&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;&quot;&gt;&lt;a href=&quot;{url}/news&quot;&gt;News&lt;/a&gt;&lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;&quot;&gt;&lt;a href=&quot;{url}/Management&quot;&gt;Management&lt;/li&gt;&lt;li class=&quot;selected&quot;&gt;Administration&lt;/a&gt;&lt;/li&gt;&lt;li class=&quot;&quot;&gt;&lt;a href=&quot;{url}/Events&quot;&gt;Events&lt;/a&gt;&lt;/li&gt;&lt;li class=&quot; last&quot;&gt;&lt;a href=&quot;{url}/logout&quot; class=&quot;userlink&quot; id=&quot;signout&quot;&gt;Sign Out&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ul&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&lt;div id=&quot;container&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;content&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;column&quot; class=&quot;column&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;habblet-container&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&lt;div class=&quot;box-content&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;Respects&lt;/h2&gt;&lt;table width=&quot;100%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt; &lt;?php&nbsp;&nbsp;$userstats_a = mysql_query(&quot;SELECT * FROM user_stats ORDER BY RespectGiven DESC LIMIT 10&quot;);while($userstats = mysql_fetch_assoc($userstats_a)){$row = mysql_fetch_assoc($row = mysql_query(&quot;SELECT * FROM users WHERE id = '&quot;.$userstats['id'].&quot;' LIMIT 10&quot;));&nbsp;&nbsp;?&gt;&nbsp;&nbsp;&lt;tr&gt;&lt;td width=&quot;5px&quot;&gt; &lt;/td&gt;&lt;td width=&quot;20px&quot;&gt;&lt;img src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=&lt;?php echo $avatar; echo $row['look']; ?&gt;&amp;size=s&amp;direction=2&amp;head_direction=2&amp;gesture=sml&amp;size=m&quot; align=&quot;left&quot;&gt;&lt;/td&gt;&lt;td width=&quot;195px&quot;&gt;&lt;a href=&quot;/stats&quot;&gt;&lt;b&gt;&lt;?php echo $row['username']; ?&gt;&lt;/b&gt;&lt;/a&gt;&lt;br /&gt;&lt;?php echo $userstats['RespectGiven']; ?&gt; Respects&lt;/td&gt;&lt;/tr&gt;&nbsp;&nbsp;&lt;?php } ?&gt;&lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp;&nbsp;&lt;div id=&quot;column&quot; class=&quot;column&quot;&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix blue &quot;&gt;&lt;div class=&quot;habblet box-content&quot;&gt;&nbsp; &lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: middle;&quot;&gt;Credits&lt;/span&gt; &lt;/h2&gt;&lt;div align=&quot;middle&quot;&gt;&lt;table width=&quot;100%&quot;&gt;&nbsp;&nbsp;&lt;tr&gt;&lt;?php&nbsp;&nbsp;$users_a = mysql_query(&quot;SELECT * FROM `users` WHERE `rank` &lt;= '2' ORDER BY `credits` DESC LIMIT 10&quot;);while($users = mysql_fetch_assoc($users_a)){&nbsp;?&gt;&nbsp;&nbsp;&lt;tr&gt;&lt;td width=&quot;5px&quot;&gt; &lt;/td&gt;&lt;td width=&quot;20px&quot;&gt;&lt;img src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=&lt;?php echo $users['look']; ?&gt;&amp;size=s&amp;direction=2&amp;head_direction=2&amp;gesture=sml&amp;size=m&quot; align=&quot;left&quot;&gt;&lt;/td&gt;&lt;td width=&quot;195px&quot;&gt;&lt;a href=&quot;/users&quot;&gt;&lt;b&gt;&lt;?php echo $row['username']; ?&gt;&lt;/b&gt;&lt;/a&gt;&lt;br /&gt;&lt;?php echo $users['credits']; ?&gt; Credits&lt;/td&gt;&lt;/tr&gt;&nbsp;&nbsp;&lt;?php } ?&gt;&lt;/table&gt;&nbsp;&nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp;&nbsp;&nbsp;&lt;div id=&quot;column&quot; class=&quot;column&quot;&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp; &lt;div class=&quot;habblet box-content&quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: middle;&quot;&gt;Pixels&lt;/span&gt; &lt;/h2&gt;&lt;div align=&quot;middle&quot;&gt;&lt;table width=&quot;100%&quot;&gt;&nbsp;&nbsp;&lt;tr&gt; &lt;?php&nbsp;&nbsp;$users_a = mysql_query(&quot;SELECT * FROM `users` WHERE `rank` &lt;= '2' ORDER BY `activity_points` DESC LIMIT 10&quot;);while($users = mysql_fetch_assoc($users_a)){&nbsp;?&gt;&nbsp;&nbsp;&lt;tr&gt;&lt;td width=&quot;5px&quot;&gt; &lt;/td&gt;&lt;td width=&quot;20px&quot;&gt;&lt;img src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=&lt;?php echo $users['look']; ?&gt;&amp;size=s&amp;direction=2&amp;head_direction=2&amp;gesture=sml&amp;size=m&quot; align=&quot;left&quot;&gt;&lt;/td&gt;&lt;td width=&quot;195px&quot;&gt;&lt;a href=&quot;/users&quot;&gt;&lt;b&gt;&lt;?php echo $row['username']; ?&gt;&lt;/b&gt;&lt;/a&gt;&lt;br /&gt;&lt;?php echo $users['activity_points']; ?&gt; Pixels&lt;/td&gt;&lt;/tr&gt;&nbsp;&nbsp;&lt;?php } ?&gt;&lt;/table&gt;[/PHP]</blockquote>

[QUOTE="Sledmore, post: 212153, member: 591"] In your topstats you're fetching more than enough data this should work better for you: [PHP] <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>HabZon: eXpert</title> <?php include_once('header.php'); ?> <li class="metab"><a href="{url}/me">{username} <img src="{url}/app/tpl/skins/{skin}/images/id.png" style="vertical-align: middle;"></a></li> <li class="selected">Commmunity <img src="{url}/app/tpl/skins/{skin}/images/forum_2.gif" style="vertical-align: middle;"></li> <li><a href="{url}/shop">Shop <img src="{url}/app/tpl/skins/{skin}/images/new_11.gif" style="vertical-align: middle;"></a></li> </ul> <div id="ibxs-online"><div class="rounded"> <div style="padding-top:7px;"> <a href="/client" class="new-button green-button" style="float:left;" target="ClientWnd" onclick="HabboClient.openOrFocus(this); return false;">Enter HabZon</a></div> {online} User(s) online </div></div> </div> </div> <div id="content-container"> <div id="navi2-container" class="pngbg"> <div id="navi2" class="pngbg clearfix"> <ul> <li class=""><a href="{url}/community">Community</a></li> <li class=""><a href="{url}/news">News</a></li> <li class=""><a href="{url}/Management">Management</li> <li class="selected">Administration</a></li> <li class=""><a href="{url}/Events">Events</a></li> <li class=" last"><a href="{url}/logout" class="userlink" id="signout">Sign Out</a> </ul> </div> </div> <div id="container"> <div> <div class="content"> <div id="column" class="column"> <div class="habblet-container"> <div class="cbb clearfix blue "> <div class="box-content"> <h2 class="title">Respects</h2> <table width="100%"> <tr> <?php $userstats_a = mysql_query("SELECT * FROM user_stats ORDER BY RespectGiven DESC LIMIT 10"); while($userstats = mysql_fetch_assoc($userstats_a)){ $row = mysql_fetch_assoc($row = mysql_query("SELECT * FROM users WHERE id = '".$userstats['id']."' LIMIT 10")); ?> <tr><td width="5px"> </td> <td width="20px"><img src="http://www.habbo.nl/habbo-imaging/avatarimage?figure=<?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="/stats"><?php echo $row['username']; ?></a> <?php echo $userstats['RespectGiven']; ?> Respects</td> </tr> <?php } ?> </table> </div> </div> </div> </div> <div id="column" class="column"><div class="habblet-container "><div class="cbb clearfix blue "> <div class="habblet box-content"> <h2 class="title">Credits </h2> <div align="middle"> <table width="100%"> <tr> <?php $users_a = mysql_query("SELECT * FROM `users` WHERE `rank` <= '2' ORDER BY `credits` DESC LIMIT 10"); while($users = mysql_fetch_assoc($users_a)){ ?> <tr><td width="5px"> </td> <td width="20px"><img src="http://www.habbo.nl/habbo-imaging/avatarimage?figure=<?php echo $users['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td> <td width="195px"><a href="/users"><?php echo $row['username']; ?></a> <?php echo $users['credits']; ?> Credits</td> </tr> <?php } ?> </table> </div> </div> </div> </div> </div> <div id="column" class="column"><div class="habblet-container "><div class="cbb clearfix blue "> <div class="habblet box-content"> <h2 class="title">Pixels </h2> <div align="middle"> <table width="100%"> <tr> <?php $users_a = mysql_query("SELECT * FROM `users` WHERE `rank` <= '2' ORDER BY `activity_points` DESC LIMIT 10"); while($users = mysql_fetch_assoc($users_a)){ ?> <tr><td width="5px"> </td> <td width="20px"><img src="http://www.habbo.nl/habbo-imaging/avatarimage?figure=<?php echo $users['look']; ?>&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td> <td width="195px"><a href="/users"><?php echo $row['username']; ?></a> <?php echo $users['activity_points']; ?> Pixels</td> </tr> <?php } ?> </table> [/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members