[HELP] User doesn't emerge in staff.php

Jacco

Junior Member
Members
5Posts:
1 Threads:
Oct 22Joined:
0 Reputation:
#1
Hello guys,

I'm editing BrainCMS and I am working right now on the staff page, its done but if I ranked myself or a user, it doesn't emerge in the staffbox.
Can someone help me?
PHP Code:
<div style="float:right; width: 68%;">
            <
div class="box">
<
div class="title yellow">
            
Hotel Manager
            
</div>
        
            
                
                
                <?
php
            $getRanks 
$dbh->prepare("SELECT id,name,badgeid,tab_colour FROM ranks WHERE id in (7)  ORDER BY id DESC");
            
$getRanks->execute();
            while (
$Ranks $getRanks->fetch())
            {    
                echo 
'
            
                '
;
                
$getMembers $dbh->prepare("SELECT id,username,email,motto,look,online FROM users WHERE rank = :ranid");
                
$getMembers->bindParam(':ranid'$Ranks['id']);
                
$getMembers->execute();
                if (
$getMembers->RowCount() > 0)
                {
                    while (
$member $getMembers->fetch())
                    {
                        
$username filter($member['username']);
                        
$motto filter($member['motto']);
                        
$email filter($member['email']);
                        
$look filter($member['look']);
                        
$online filter($member['online']);
                        if(
$online == 1){ $OnlineStatus "online"; } else { $OnlineStatus "offline"; }
                        echo 
'
                        
                        <div style="pointer;float: left;padding-top: 20px;border-radius: 7 px; width: 275px;margin-bottom: 5px;margin-left: 5px;margin-right: 5px;"><a href="/home/' 
$username '">
                        <div id="column" style="margin-top: -50px;margin-left: 10px;margin-right: 10px;margin-bottom: 10px;float: left;height:101px;width: 66px;border-radius: 555px;-moz-border-radius: 555px;-webkit-border-radius: 555px;background:url(https://habbo.com/habbo-imaging/avatarimage?figure='
.$look.'&amp;head_direction=2&amp;direction=2&amp;action=wlk&amp;gesture=sml&amp;size=m) no-repeat;background-position: 50% 10%;"></div>                            <b style="font-size: 16px;">' $username ' </b> <span class="staff-offline"></span>
 
                        <img src="https://hablife.nl/bibliotheek/c_images/album1584/ADM.gif" style="margin-right:5px;margin-top: 0px;" align="right"> 
                        </a><img style="float: right;" src="/web/images/'
.$OnlineStatus.'.gif">
                        <br>  <img src="/templates/brain/style/images/icons/motto.png"> <i style="font-size: 12px;">' 
$motto '</i>
                                                <br>  <img src="/templates/brain/style/images/icons/editlook.gif" style="
    margin-left: 82px;
"><a href="mailto:' 
$email '?Subject=Onderwerp voor de staff: %20' $username '" target="_top"><i style="font-size: 12px;margin-left: 2px;">' $email '</i></a>
                                                
                        <br>
                        </div>
                        
                        
                        '
;
                    }
                }
                else
                {
                                                echo 
'<center><i>Er zijn momenteel geen HabLife\'s met deze rank!</i></center>';
                }
                echo 
'
            
                '
;
            }
        
?>

                        
                        
                        
                        </div>
                        
            
                        
            
</div>    
        
        <div style="float:right; width: 68%;">
            <div class="box">
<div class="title pink">
            Community Manager
            </div>
        
            
                
                
                <?php
            $getRanks 
$dbh->prepare("SELECT id,name,badgeid,tab_colour FROM ranks WHERE id in (6)  ORDER BY id DESC");
            
$getRanks->execute();
            while (
$Ranks $getRanks->fetch())
            {    
                echo 
'
            
                '
;
                
$getMembers $dbh->prepare("SELECT id,username,motto,email,look,online FROM users WHERE rank = :ranid");
                
$getMembers->bindParam(':ranid'$Ranks['id']);
                
$getMembers->execute();
                if (
$getMembers->RowCount() > 0)
                {
                    while (
$member $getMembers->fetch())
                    {
                        
$username filter($member['username']);
                        
$motto filter($member['motto']);
                        
$email filter($member['email']);
                        
$look filter($member['look']);
                        
$online filter($member['online']);
                        if(
$online == 1){ $OnlineStatus "online"; } else { $OnlineStatus "offline"; }
                        echo 
'
                        
                        <div style="pointer;float: left;padding-top: 20px;border-radius: 7 px; width: 275px;margin-bottom: 5px;margin-left: 5px;margin-right: 5px;"><a href="/home/' 
$username '">
                        <div id="column" style="margin-top: -50px;margin-left: 10px;margin-right: 10px;margin-bottom: 10px;float: left;height:101px;width: 66px;border-radius: 555px;-moz-border-radius: 555px;-webkit-border-radius: 555px;background:url(https://habbo.com/habbo-imaging/avatarimage?figure='
.$look.'&amp;head_direction=2&amp;direction=2&amp;action=wlk&amp;gesture=sml&amp;size=m) no-repeat;background-position: 50% 10%;"></div>        
                            <b style="font-size: 16px;">' 
$username ' </b> <span class="staff-offline"></span> 
                        <img src="https://hablife.nl/bibliotheek/c_images/album1584/ADM.gif" style="margin-right:5px;margin-top: 0px;" align="right"> 
                        </a><img style="float: right;" src="/web/images/'
.$OnlineStatus.'.gif">
                        <br>  <img src="/templates/brain/style/images/icons/motto.png"> <i style="font-size: 12px;">' 
$motto '</i>
                                                <br>  <img src="/templates/brain/style/images/icons/editlook.gif" style="
    margin-left: 0px;
"><a href="mailto:' 
$email '?Subject=Onderwerp voor de staff: %20' $username '" target="_top"><i style="font-size: 12px;margin-left: 2px;">' $email '</i></a>
                                                
                        <br>
                        </div>
                        
                        
                        '
;
                    }
                }
                else
                {
                                                echo 
'<center><i>Er zijn momenteel geen HabLife\'s met deze rank!</i></center>';
                }
                echo 
'
            
                '
;
            }
        
?>

                        
                        
                        
                        </div>
                        
            
                        
            
</div>    
        
        <div style="float:right; width: 68%;">
            <div class="box">
<div class="title red">
            Moderatoren
            </div>
        
            
                
                
                <?php
            $getRanks 
$dbh->prepare("SELECT id,name,badgeid,tab_colour FROM ranks WHERE id in (5)  ORDER BY id DESC");
            
$getRanks->execute();
            while (
$Ranks $getRanks->fetch())
            {    
                echo 
'
            
                '
;
                
$getMembers $dbh->prepare("SELECT id,username,motto,email,look,online FROM users WHERE rank = :ranid");
                
$getMembers->bindParam(':ranid'$Ranks['id']);
                
$getMembers->execute();
                if (
$getMembers->RowCount() > 0)
                {
                    while (
$member $getMembers->fetch())
                    {
                        
$username filter($member['username']);
                        
$motto filter($member['motto']);
                        
$email filter($member['email']);
                        
$look filter($member['look']);
                        
$online filter($member['online']);
                        if(
$online == 1){ $OnlineStatus "online"; } else { $OnlineStatus "offline"; }
                        echo 
'
                        
                        <div style="pointer;float: left;padding-top: 20px;border-radius: 7 px; width: 275px;margin-bottom: 5px;margin-left: 5px;margin-right: 5px;"><a href="/home/' 
$username '">
                        <div id="column" style="margin-top: -50px;margin-left: 10px;margin-right: 10px;margin-bottom: 10px;float: left;height:101px;width: 66px;border-radius: 555px;-moz-border-radius: 555px;-webkit-border-radius: 555px;background:url(https://habbo.com/habbo-imaging/avatarimage?figure='
.$look.'&amp;head_direction=2&amp;direction=2&amp;action=wlk&amp;gesture=sml&amp;size=m) no-repeat;background-position: 50% 10%;"></div>                
                            <b style="font-size: 16px;">' 
$username ' </b> <span class="staff-offline"></span> 
                        <img src="https://hablife.nl/bibliotheek/c_images/album1584/MOD.gif" style="margin-right:5px;margin-top: 0px;" align="right"> 
                        </a><img style="float: right;" src="/web/images/'
.$OnlineStatus.'.gif">
                        <br>  <img src="/templates/brain/style/images/icons/motto.png"> <i style="font-size: 12px;">' 
$motto '</i>
                                                <br>  <img src="/templates/brain/style/images/icons/editlook.gif" style="
    margin-left: 82px;
"><a href="mailto:' 
$email '?Subject=Onderwerp voor de staff: %20' $username '" target="_top"><i style="font-size: 12px;margin-left: 2px;">' $email '</i></a>
                                                
                        <br>
                        </div>
                        
                        
                        '
;
                    }
                }
                else
                {
                            echo 
'<center><i>Er zijn momenteel geen HabLife\'s met deze rank!</i></center>';
                    
                }
                echo 
'
            
                '
;
            }
        
?>

                        
                        
                        
                        </div>
                        
            
                        
            
</div>    
<div style="float:right; width: 68%;">
            <div class="box">
            <div class="title green">
            Ambassadeurs
            </div>
            
            
                
                
                <?php
            $getRanks 
$dbh->prepare("SELECT id,name,badgeid,tab_colour FROM ranks WHERE id in (3)  ORDER BY id DESC");
            
$getRanks->execute();
            while (
$Ranks $getRanks->fetch())
            {    
                echo 
'
            
                '
;
                
$getMembers $dbh->prepare("SELECT id,username,motto,email,look,online FROM users WHERE rank = :ranid");
                
$getMembers->bindParam(':ranid'$Ranks['id']);
                
$getMembers->execute();
                if (
$getMembers->RowCount() > 0)
                {
                    while (
$member $getMembers->fetch())
                    {
                        
$username filter($member['username']);
                        
$motto filter($member['motto']);
                        
$email filter($member['email']);
                        
$look filter($member['look']);
                        
$online filter($member['online']);
                        if(
$online == 1){ $OnlineStatus "online"; } else { $OnlineStatus "offline"; }
                        echo 
'
                        
                        <div style="pointer;float: left;padding-top: 20px;border-radius: 7 px; width: 275px;margin-bottom: 5px;margin-left: 5px;margin-right: 5px;"><a href="/home/' 
$username '">
                        <div id="column" style="margin-top: -50px;margin-left: 10px;margin-right: 10px;margin-bottom: 10px;float: left;height:101px;width: 66px;border-radius: 555px;-moz-border-radius: 555px;-webkit-border-radius: 555px;background:url(https://habbo.com/habbo-imaging/avatarimage?figure='
.$look.'&amp;head_direction=2&amp;direction=2&amp;action=wlk&amp;gesture=sml&amp;size=m) no-repeat;background-position: 50% 10%;"></div>    
                            <b style="font-size: 16px;">' 
$username ' </b> <span class="staff-offline"></span> 
                        <img src="https://hablife.nl/bibliotheek/c_images/album1584/AMB.gif" style="margin-right:5px;margin-top: 0px;" align="right"> 
                        </a><img style="float: right;" src="/web/images/'
.$OnlineStatus.'.gif">
                        <br>  <img src="/templates/brain/style/images/icons/motto.png"> <i style="font-size: 12px;">' 
$motto '</i>
                                                <br>  <img src="/templates/brain/style/images/icons/editlook.gif" style="
    margin-left: 0px;
"><a href="mailto:' 
$email '?Subject=Onderwerp voor de staff: %20' $username '" target="_top"><i style="font-size: 12px;margin-left: 2px;">' $email '</i></a>
                                                
                        <br>
                        </div>
                        
                        
                        '
;
                    }
                }
                else
                {
                                                echo 
'<center><i>Er zijn momenteel geen HabLife\'s met deze rank!</i></center>';
                }
                echo 
'
            
                '
;
            }
        
?>

                        
                        
                        
                        </div> 

I use Arcturus by the way!
And this is the style of the staff page.
Screen: Please log in or register to see this link.
The greatest healing therapy is friendship and love.
Reply

Tom

RetroRiper Love
Owner
Developer
60Posts:
6 Threads:
Oct 07Joined:
4 Reputation:
Developer
#2
Do you have the table ranks in you database?

And what is your rank number?
[Image: logo.png]
Reply
Users browsing this thread:
1 Guest(s)