PhoenixPHP Community Page

Subway · Jun 27, 2011

MichaelMadman said:
With the users with most credit can you make it filter out like above rank 3. Mine just shows staff.

Try doing something yourself all you do is wait for other's to release stuff for Habplus try figure something out.

IAmNotAGirl · Jun 27, 2011

I am loving this... NOT!

Predict · Jun 27, 2011

MichaelMadman said:
With the users with most credit can you make it filter out like above rank 3. Mine just shows staff.

PHP:

<?php 
$datosTop = mysql_query("SELECT * FROM users WHERE credits IS NOT NULL AND rank < 3 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=3&head_direction=3&gesture=sml&size=s" align="left"></td> <td width="195px"><a href="%www%/home/'.$datosTop10['username'].'">'.$datosTop10['username'].'</a><br /> '.$datosTop10['credits'].' Creditis<br /><br /><br /><br />'; 

echo '</td> 
            
          '; 
} 
?>

Request received.

Rhinodanny · Jun 27, 2011

Predict said:

PHP:

<?php 
$datosTop = mysql_query("SELECT * FROM users WHERE credits IS NOT NULL AND rank < 3 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=3&head_direction=3&gesture=sml&size=s" align="left"></td> <td width="195px"><a href="%www%/home/'.$datosTop10['username'].'">'.$datosTop10['username'].'</a><br /> '.$datosTop10['credits'].' Creditis<br /><br /><br /><br />'; 

echo '</td> 
            
          '; 
} 
?>

Request received.

I had already updated the code

I've edit the orginal post with your fix.

Habbi · Jun 27, 2011

Mine is the same problem, with the one of Kuiz

Vegar · Jun 28, 2011

I really like this, but i get some function.include errors.

Warning: include(random-community.php) [function.include]: failed to open stream: No such file or directory in /home/pixelhotel/domains/pixelhotel.me/public_html/community.php on line 5

Warning: include(random-community.php) [function.include]: failed to open stream: No such file or directory in /home/pixelhotel/domains/pixelhotel.me/public_html/community.php on line 5

Warning: include() [function.include]: Failed opening 'random-community.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/pixelhotel/domains/pixelhotel.me/public_html/community.php on line 5

---------- Post added at 02:42 AM ---------- Previous post was at 02:29 AM ----------

Ok, i removed the include('random-community.php'); and my include errors disappeared, but my server stats box is still messed up. Its like all wide as the page.

pLEDGE · Jun 29, 2011

Mine is better

To view the content, you need to sign in or register

Code:

HTML Code:
<div class="column" id="column1">
    <div class="contentBox">
        <div class="boxHeader">Random Habbo's</div>
        <div class="boxContent"><?php
        // linje 1
        echo '<div style="margin-top: -10px; margin-left: 10px;">';
        $l1 = mysql_query("SELECT * FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 6;");
        while($h1 = mysql_fetch_assoc($l1))
        {
            echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h1['look'].'" alt="">';
        }
        echo '</div>';
        // linje 2
        echo '<div style="margin-left: 40px; margin-top: -60px;">';
        $l2 = mysql_query("SELECT * FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 6;");
        while($h2 = mysql_fetch_assoc($l2))
        {
            echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h2['look'].'" alt="" class="tooltip">';
        }
        echo '</div>';
        // linje 3
        echo '<div style="margin-top: -60px; margin-left: 10px;">';
        $l3 = mysql_query("SELECT * FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 6;");
        while($h3 = mysql_fetch_assoc($l3))
        {
            echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h3['look'].'" alt="" class="tooltip">';
        }
        echo '</div>';
    ?>
    </div></div>
</div>

Joopie · Jun 29, 2011

pLEDGE said:

Mine is better

To view the content, you need to sign in or register

Code:

HTML Code:
<div class="column" id="column1">
    <div class="contentBox">
        <div class="boxHeader">Random Habbo's</div>
        <div class="boxContent"><?php
        // linje 1
        echo '<div style="margin-top: -10px; margin-left: 10px;">';
        $l1 = mysql_query("SELECT * FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 6;");
        while($h1 = mysql_fetch_assoc($l1))
        {
            echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h1['look'].'" alt="">';
        }
        echo '</div>';
        // linje 2
        echo '<div style="margin-left: 40px; margin-top: -60px;">';
        $l2 = mysql_query("SELECT * FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 6;");
        while($h2 = mysql_fetch_assoc($l2))
        {
            echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h2['look'].'" alt="" class="tooltip">';
        }
        echo '</div>';
        // linje 3
        echo '<div style="margin-top: -60px; margin-left: 10px;">';
        $l3 = mysql_query("SELECT * FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 6;");
        while($h3 = mysql_fetch_assoc($l3))
        {
            echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h3['look'].'" alt="" class="tooltip">';
        }
        echo '</div>';
    ?>
    </div></div>
</div>

Let me correct that with this:

Code:

<div class="column" id="column1">
    <div class="contentBox">
        <div class="boxHeader">Random Habbo's</div>
        <div class="boxContent"><?php
        // linje 1
        $l1 = mysql_query("SELECT `look` FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 18;");
        $i = 1;
        while($h1 = mysql_fetch_assoc($l1))
        {
        	if ($i == 1)
        	{
        		echo '<div style="margin-top: -10px; margin-left: 10px;">';
        	}
        	else if ($i == 7)
        	{
        		echo '</div><div style="margin-left: 40px; margin-top: -60px;">';
        	}
        	else if ($i == 13)
        	{
        		echo  '</div><div style="margin-top: -60px; margin-left: 10px;">';
        	}
        
          echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h1['look'].'" alt="" />';
          
          $i++;
        }
        echo '</div>';
    ?>
    </div></div>
</div>

Not tested!, There could things be wrong, That you must fix it by yourself

tt1:

Only the idee :thumbup:

Predict · Jun 29, 2011

PHP:

<div class="column" id="column1">
    <div class="contentBox">
        <div class="boxHeader">Random Habbo's</div>
        <div class="boxContent"><?php
        // linje 1
        $l1 = mysql_query("SELECT * FROM `users` WHERE `look` != 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62' ORDER BY RAND() LIMIT 18;");
        $i = 1;
        while($h1 = mysql_fetch_assoc($l1))
        {
        	if ($i == 1)
        	{
        		echo '<div style="margin-top: -10px; margin-left: 10px;">';
        	}
        	else if ($i == 7)
        	{
        		echo '</div><div style="margin-left: 40px; margin-top: -60px;">';
        	}
        	else if ($i == 13)
        	{
        		echo  '</div><div style="margin-top: -60px; margin-left: 10px;">';
        	}
        
          echo '<a href="home.php?u='.$h1['username'].'"><img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$h1['look'].'" alt="" /></a>';
          
          $i++;
        }
        echo '</div>';
    ?>
    </div></div>
</div>

Updated the idea. ;]

MedsHotel · Jun 29, 2011

were can i get install.php ?

Mithex · Jun 29, 2011

jamieturner said:
lmao Mithex, what you on about run install.

The install file is for the errors on the homepage to do with the navigation bar.

For this error you need to remove the include random-community at the top of the page which i have fixed and already done for this guy.

There is a file in the root of phoenix, that most people forget to run. Mainly cause its not like PHPRetro where you are forced to run it. Many people do not run it and get problems.

MedsHotel · Jun 29, 2011

I cant find it, please can you SEND me a New Code or can you make a Step by Step Guide ?

Subway · Jun 30, 2011

Rofl step by step guide?

Go here cheese: Habbo Help - Habbo Development - RaGEZONE forums

PEjump · Jun 30, 2011

I just think that you've changed some div's and added some more function's and changed some of the div boxe's although is it very nice and i love to see more of this work going around

Joopie · Jun 30, 2011

PEjump said:
I just think that you've changed some div's and added some more function's and changed some of the div boxe's although is it very nice and i love to see more of this work going around

Faker

PhoenixPHP Community Page

Subway

Custom Title Activated

IAmNotAGirl

Newbie Spellweaver

Predict

Legendary Battlemage

Rhinodanny

Newbie Spellweaver

Habbi

Newbie Spellweaver

Vegar

Newbie Spellweaver

pLEDGE

Experienced Elementalist

Joopie

Thoughtful Unicorn

Predict

Legendary Battlemage

MedsHotel

Newbie Spellweaver

Mithex

Thanks for the memories!

MedsHotel

Newbie Spellweaver

Subway

Custom Title Activated

PEjump

Initiate Mage

Joopie

Thoughtful Unicorn

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners