2 things?

ForgottenHZ

New Member
Jun 27, 2013
11
0
Hello,

my news is messed up:

MHTs5qg.png


And

How do I make top stats not have the staff memebrs on it?
 

HonkyWam

Tickle me Elmo!
Dec 8, 2011
289
4
You need a new, news.php I'll post it for you, also you need to explain what cms are you using, also post your top stats here and ill do what you want me to do :p Oh also, I'll just pm it.
 

Sledmore

Chaturbate Livestreamer
Staff member
FindRetros Moderator
Jul 24, 2010
5,199
3,934
For the news you need to change the body from:
Code:
<body id="home"
to:
Code:
<body id="news"

For the topstats simply add AND `rank` <= '2' to the queries which will only show users with the rank 1 or 2.
 

HonkyWam

Tickle me Elmo!
Dec 8, 2011
289
4
We
Okay I use HabboExtreme but I want news to be normal here is topstats

can you make it better to?

Here, if you want to use that code, I also took off the facebook thing which is garbage, use the new.php i gave you, but the guy above has the fix for the topstats.php
 

Sledmore

Chaturbate Livestreamer
Staff member
FindRetros Moderator
Jul 24, 2010
5,199
3,934
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><span></span></li>
                     <li class="selected"><strong>Commmunity  <img src="{url}/app/tpl/skins/{skin}/images/forum_2.gif" style="vertical-align: middle;"></strong><span></span></li>
<li><a href="{url}/shop">Shop <img src="{url}/app/tpl/skins/{skin}/images/new_11.gif" style="vertical-align: middle;"></a><span></span></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;"><b>Enter HabZon</b><i></i></a></div>
<span style="margin-top:-2px">
{online} User(s) online </span>
</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"><b><?php echo $row['username']; ?></b></a><br />
<?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"><span style="float: middle;">Credits</span> </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"><b><?php echo $row['username']; ?></b></a><br />
<?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"><span style="float: middle;">Pixels</span> </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"><b><?php echo $row['username']; ?></b></a><br />
<?php echo $users['activity_points']; ?> Pixels</td>
</tr>
 
 
<?php } ?>
</table>
 

Users who are viewing this thread

Top