Couple of SQL Problems.

Results 1 to 12 of 12
  1. #1
    Apprentice WolfyMods is offline
    MemberRank
    Aug 2015 Join Date
    11Posts

    Couple of SQL Problems.

    Hey guys im having a few SQL problems.

    1. Homeroom.

    Im wanting to set a room as the default home room for new users. Yet on other tutorials i have seen they say to go to localhost/phpmyadmin but i dont have that, it comes up with an error. (picture 1) Also i dont have the homeroom table in my SQL database. (picture 2)
    Spoiler:








    2. Ranks

    When im recruiting staff i dont know what ranks are what. Been told that i should have a table that says Ranks in my database but its not there. See in image.
    Spoiler:





    3. Staff Page

    When i make staff it doesnt automatically populate the staff page.
    currently have 2 rank 9's (that show up on staff), 2 rank 8's and 1 rank 5.

    Spoiler:





    Please can you help me with this.

    Thanks:)


  2. #2
    Proficient Member Xesause is offline
    MemberRank
    Feb 2015 Join Date
    181Posts

    Re: Couple of SQL Problems.

    First of all:
    Not all webserver installations come with phpMyAdmin by default. You can, indeed, also use navicat.

    Second
    :
    What CMS & Emu do you use? It's really strange that there's no rank table, and stranger than that, that the CMS still knows what the rank 9 is called.

    Third
    :
    Home rooms are not stored in a separate table, but in the users table.
    This query will probably work:
    UPDATE users SET home_room = .....
    Put your room id on the dots.

  3. #3
    Member Charlotte Potts is offline
    MemberRank
    Aug 2015 Join Date
    YorkshireLocation
    64Posts

    Re: Couple of SQL Problems.

    1). In Navicat click "Query" at the top then navigate to "New Query" just bellow. Then type "UPDATE users SET home_room = 'room_id';" room_id being the ID of the new home room.

    2). Looks like it could be under user_rankings, check that table and tell me otherwise.

    3). Can you post the staff.php page so we can have a look at how the data is being grabbed from the database. My guess is it's not doing the foreach for the different ranks correctly.

    -hope this helped (:

  4. #4
    Apprentice WolfyMods is offline
    MemberRank
    Aug 2015 Join Date
    11Posts

    Re: Couple of SQL Problems.

    The EMU and CMS is the Azure one.

    Also here is the staff.phb

    Code:
     
    <!DOCTYPE html>
    <html lang="en">
        <head>
            <meta http-equiv="content-type" content="text/html; charset=utf-8">
            <title>{hotelName} - Staff</title>
            
            <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css">
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs2.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/visual.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/common.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/fullcontent.js"></script>
            
            <script type="text/javascript">
                document.habboLoggedIn = true;
                var habboName = "{username}";
                var habboId = {userid};
                var habboReqPath = "";
                var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";
                var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";
                var habboPartner = "";
                var habboDefaultClientPopupUrl = "{url}/client";
                window.name = "habboMain";
                if (typeof HabboClient != "undefined") {
                    HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";
                    HabboClient.maximizeWindow = true;
                }
            </script>
            
            <!--[if IE 8]>
                <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie8.css" type="text/css">
            <![endif]-->
            <!--[if lt IE 8]>
                <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie.css" type="text/css" />
            <![endif]-->
            <!--[if lt IE 7]>
                <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie6.css" type="text/css" />
                <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/pngfix.js"></script>
                <script type="text/javascript">
                    try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
                </script>
                <style type="text/css">
                    body { behavior: url({url}/app/tpl/skins/Habbo/js/csshover.htc); }
                </style>
            <![endif]-->
        </head>
        
        <body id="home">
        
            <div id="overlay"></div>
                 <?php include ("includes/header.php"); ?>
                    <ul id="navi">
                    <?php
                            if(isset($_SESSION['user']['id']))
                                echo '<li><a href="{url}/me">{username}</a><span></span></li>';
                                  else
                                   {
                                      echo '<li><a href="{url}/register">Register Today!</a><span></span></li>';
                                   }
                    ?>
                        <li class="selected"><strong>Community</strong><span></span></li>
                        <li><a href="{url}/shop">Shop</a><span></span></li>
                    </ul>
                    <div id="habbos-online">
                        <div class="rounded"><span>{online} {online_text}</span></div>
                    </div>
                </div>
            </div>
            <div id="content-container">
                <div class="pngbg" id="navi2-container">
                    <div class="pngbg clearfix" id="navi2">
                        <ul>
                            <li class=""><a href="{url}/community">Community</a></li>
                            <li class=""><a href="{url}/news">News</a></li>
                            <li class=" selected ">Staff</li>
                            <li><a href="{url}/events">Events</a></li>
                        </ul>
                    </div>
                </div>
               <div id="container">
        <div id="content">
    
    
                                  <div id="column1" class="column">
                                   <div class="habblet-container ">
                                <div class="cbb clearfix blue ">
                                    <h2 class="title">Staff Management</h2>
                                        <div style="padding:7px 7px 1px">
                                        <?php
                                            $vipUsers = mysql_query("SELECT * FROM users WHERE rank = '9' ORDER BY rank LIMIT 10") or die(mysql_error());
                                            while($vipUser = mysql_fetch_assoc($vipUsers)){
                                        ?>
                                        <p>
                                            <div style='width: 64px; height: 81px; margin-top:-22px; margin-left:-10px; float: left; background: url(http://www.habbo.it/habbo-imaging/avatarimage?figure=<?php echo $vipUser['look']; ?>&action=crr=43&direction=&gesture=sml&size=m&img_format=gif);'></div>
                                            <p style="margin-left:52px;">
                                                <?php if($vipUser['online']==1){ ?><img src='http://cloudhabbo.co.uk/app/tpl/skins/{skin}/images/online.gif' style="float:right"/><?php } else { ?><img src='http://cloudhabbo.co.uk/app/tpl/skins/{skin}/images/offline.gif' style="float:right"/><?php } ?>
                                                <a href='#'><strong><?php echo $vipUser['username']; ?></strong></a>
                                                <br><font color='grey'><?php echo $vipUser['motto']; ?></font><br>
                                                <small>Last Online: <?php echo date("D dS, M Y", $vipUser['last_online']); ?></small><br><br><hr>
                                        </p>
                                        <?php } ?>
                                    </div>
                                </div>
                                </div>
                            </div>
                                <div id="column2" class="column">
    <div class="habblet-container ">
                    <div class="box-content1"> 
                            <div class="cbb clearfix darkred">
    
    
                                <h2 class="title">About Staff
                                </h2>
                            <div style="padding:5px">
                            {hotelname} staff are people behind the curtain who manage, moderate, and maintain the hotel to ensure we
                        remain online and afloat on a daily basis. Members of upper management ensure {hotelname} runs like clockwork
                        24/7 to give our users the best Habbo private server experience possible.
    </div></div></div></div>
    
    
    <div class="habblet-container ">
                    <div class="box-content1"> 
                            <div class="cbb clearfix red ">
    
    
                                <h2 class="title">How to join the team?
                                </h2>
                            <div style="padding:5px">
                    Occasionally we will release staff applications to give the community a chance at joining management.
                    Becoming a staff member on {hotelname} isn't easy and a set of requirements and criterias must be met.
                    Please never ask for staff in-game. When we're looking for staff, a news article will be posted or you
                    will be approached.
                                    </div></div></div></div>
                    <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    
                <script type="text/javascript">
                    document.observe('dom:loaded', function() {
                        CurrentRoomEvents.init();
                    });
                </script>
            </div>
    
    
            <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
            <script type="text/javascript">
                HabboView.run();
            </script>
            
            
            
            <!--[if lt IE 7]>
                <script type="text/javascript">
                    Pngfix.doPngImageFix();
                </script>
            <![endif]-->
            
            <div id="footer" >
                <?php include('includes/footer.php'); ?>
                <?php include('includes/checktheban.php'); ?>
            </div>
        
        </body>
    </html>

  5. #5
    Member Charlotte Potts is offline
    MemberRank
    Aug 2015 Join Date
    YorkshireLocation
    64Posts

    Re: Couple of SQL Problems.

    Can you send me the data in user_rabkings and I'll code you a new staff page.

  6. #6
    Apprentice WolfyMods is offline
    MemberRank
    Aug 2015 Join Date
    11Posts

    Re: Couple of SQL Problems.

    Quote Originally Posted by Charlotte Potts View Post
    Can you send me the data in user_rabkings and I'll code you a new staff page.
    There is nothing actually in the user_rankings table

  7. #7
    Member Charlotte Potts is offline
    MemberRank
    Aug 2015 Join Date
    YorkshireLocation
    64Posts

    Re: Couple of SQL Problems.

    That's okay, I'll make a ranks table for you. I'll work on it after my program (:

    - - - Updated - - -

    Here you go:

    1). In Navicat click "Query" at the top then navigate to "New Query" just bellow. Then Paste this code into the box:
    Spoiler:
    Code:
    DROP TABLE IF EXISTS `site_ranks`;CREATE TABLE `site_ranks` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(50) NOT NULL DEFAULT 'Default',
      `enabled` enum('false','true') NOT NULL DEFAULT 'true',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;


    2). Replace your staff.php page with this:
    Spoiler:
    Code:
    <!DOCTYPE html><html lang="en">
        <head>
            <meta http-equiv="content-type" content="text/html; charset=utf-8">
            <title>{hotelName} - Staff</title>
            
            <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css">
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs2.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/visual.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/common.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/fullcontent.js"></script>
            
            <script type="text/javascript">
                document.habboLoggedIn = true;
                var habboName = "{username}";
                var habboId = {userid};
                var habboReqPath = "";
                var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";
                var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";
                var habboPartner = "";
                var habboDefaultClientPopupUrl = "{url}/client";
                window.name = "habboMain";
                if (typeof HabboClient != "undefined") {
                    HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";
                    HabboClient.maximizeWindow = true;
                }
            </script>
            
            <!--[if IE 8]>
                <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie8.css" type="text/css">
            <![endif]-->
            <!--[if lt IE 8]>
                <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie.css" type="text/css" />
            <![endif]-->
            <!--[if lt IE 7]>
                <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie6.css" type="text/css" />
                <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/pngfix.js"></script>
                <script type="text/javascript">
                    try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
                </script>
                <style type="text/css">
                    body { behavior: url({url}/app/tpl/skins/Habbo/js/csshover.htc); }
                </style>
            <![endif]-->
        </head>
        
        <body id="home">
        
            <div id="overlay"></div>
                 <?php include ("includes/header.php"); ?>
                    <ul id="navi">
                    <?php
                            if(isset($_SESSION['user']['id']))
                                echo '<li><a href="{url}/me">{username}</a><span></span></li>';
                                  else
                                   {
                                      echo '<li><a href="{url}/register">Register Today!</a><span></span></li>';
                                   }
                    ?>
                        <li class="selected"><strong>Community</strong><span></span></li>
                        <li><a href="{url}/shop">Shop</a><span></span></li>
                    </ul>
                    <div id="habbos-online">
                        <div class="rounded"><span>{online} {online_text}</span></div>
                    </div>
                </div>
            </div>
            <div id="content-container">
                <div class="pngbg" id="navi2-container">
                    <div class="pngbg clearfix" id="navi2">
                        <ul>
                            <li class=""><a href="{url}/community">Community</a></li>
                            <li class=""><a href="{url}/news">News</a></li>
                            <li class=" selected ">Staff</li>
                            <li><a href="{url}/events">Events</a></li>
                        </ul>
                    </div>
                </div>
               <div id="container">
        <div id="content">
    
    
    
    
                                    <div id="column1" class="column">
                                    <?php
                                        $Ranks = mysql_query("SELECT id, name FROM site_ranks WHERE enabled = 'true' ORDER BY id DESC") or die(mysql_error());
                                        
                                        while ($Rank = mysql_fetch_assoc($Ranks)){
                                        {
                                            $vipUsers = mysql_query("SELECT * FROM users WHERE rank = '" .$Rank['id'] . "' ORDER BY rank LIMIT 10") or die(mysql_error());
                                        ?>
                                            <div class="habblet-container ">
                                                <div class="cbb clearfix blue ">
                                                    <h2 class="title"><?php echo $Rank['name']; ?></h2>
                                                    <div style="padding:7px 7px 1px">
                                                    <?php
                                                        while($vipUser = mysql_fetch_assoc($vipUsers)){
                                                    ?>
                                                        <p>
                                                            <div style='width: 64px; height: 81px; margin-top:-22px; margin-left:-10px; float: left; background: url(http://www.habbo.it/habbo-imaging/avatarimage?figure=<?php echo $vipUser['look']; ?>&action=crr=43&direction=&gesture=sml&size=m&img_format=gif);'></div>
                                                            <p style="margin-left:52px;">
                                                            <?php if($vipUser['online']==1){ ?><img src='http://cloudhabbo.co.uk/app/tpl/skins/{skin}/images/online.gif' style="float:right"/><?php } else { ?><img src='http://cloudhabbo.co.uk/app/tpl/skins/{skin}/images/offline.gif' style="float:right"/><?php } ?>
                                                            <a href='#'><strong><?php echo $vipUser['username']; ?></strong></a>
                                                            <br><font color='grey'><?php echo $vipUser['motto']; ?></font><br>
                                                            <small>Last Online: <?php echo date("D dS, M Y", $vipUser['last_online']); ?></small><br><br><hr>
                                                        </p>
                                                    <?php } ?>
                                                    </div>
                                                </div>
                                            </div>
                                        <?php } ?>
                                    </div>
                                <div id="column2" class="column">
    <div class="habblet-container ">
                    <div class="box-content1"> 
                            <div class="cbb clearfix darkred">
    
    
    
    
                                <h2 class="title">About Staff
                                </h2>
                            <div style="padding:5px">
                            {hotelname} staff are people behind the curtain who manage, moderate, and maintain the hotel to ensure we
                        remain online and afloat on a daily basis. Members of upper management ensure {hotelname} runs like clockwork
                        24/7 to give our users the best Habbo private server experience possible.
    </div></div></div></div>
    
    
    
    
    <div class="habblet-container ">
                    <div class="box-content1"> 
                            <div class="cbb clearfix red ">
    
    
    
    
                                <h2 class="title">How to join the team?
                                </h2>
                            <div style="padding:5px">
                    Occasionally we will release staff applications to give the community a chance at joining management.
                    Becoming a staff member on {hotelname} isn't easy and a set of requirements and criterias must be met.
                    Please never ask for staff in-game. When we're looking for staff, a news article will be posted or you
                    will be approached.
                                    </div></div></div></div>
                    <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    
                <script type="text/javascript">
                    document.observe('dom:loaded', function() {
                        CurrentRoomEvents.init();
                    });
                </script>
            </div>
    
    
    
    
            <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
            <script type="text/javascript">
                HabboView.run();
            </script>
            
            
            
            <!--[if lt IE 7]>
                <script type="text/javascript">
                    Pngfix.doPngImageFix();
                </script>
            <![endif]-->
            
            <div id="footer" >
                <?php include('includes/footer.php'); ?>
                <?php include('includes/checktheban.php'); ?>
            </div>
        
        </body>
    </html>


    Then everything should work. P.s in the ranks table you can set which rank is visible on the staff page by setting enable to "true" or "false".

    Anymore problems I'd be happy to help :)
    -Charlotte

  8. #8
    Apprentice WolfyMods is offline
    MemberRank
    Aug 2015 Join Date
    11Posts

    Re: Couple of SQL Problems.

    Quote Originally Posted by Charlotte Potts View Post
    That's okay, I'll make a ranks table for you. I'll work on it after my program (:

    - - - Updated - - -

    Here you go:

    1). In Navicat click "Query" at the top then navigate to "New Query" just bellow. Then Paste this code into the box:
    Spoiler:
    Code:
    DROP TABLE IF EXISTS `site_ranks`;CREATE TABLE `site_ranks` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(50) NOT NULL DEFAULT 'Default',
      `enabled` enum('false','true') NOT NULL DEFAULT 'true',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;


    2). Replace your staff.php page with this:
    Spoiler:
    Code:
    <!DOCTYPE html><html lang="en">
        <head>
            <meta http-equiv="content-type" content="text/html; charset=utf-8">
            <title>{hotelName} - Staff</title>
            
            <link rel="stylesheet" href="https://forum.ragezone.com/{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css">
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs2.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/visual.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/common.js"></script>
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/fullcontent.js"></script>
            
            <script type="text/javascript">
                document.habboLoggedIn = true;
                var habboName = "{username}";
                var habboId = {userid};
                var habboReqPath = "";
                var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";
                var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";
                var habboPartner = "";
                var habboDefaultClientPopupUrl = "{url}/client";
                window.name = "habboMain";
                if (typeof HabboClient != "undefined") {
                    HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";
                    HabboClient.maximizeWindow = true;
                }
            </script>
            
            <!--[if IE 8]>
                <link rel="stylesheet" href="https://forum.ragezone.com/{url}/app/tpl/skins/Habbo/styles/ie8.css" type="text/css">
            <![endif]-->
            <!--[if lt IE 8]>
                <link rel="stylesheet" href="https://forum.ragezone.com/{url}/app/tpl/skins/Habbo/styles/ie.css" type="text/css" />
            <![endif]-->
            <!--[if lt IE 7]>
                <link rel="stylesheet" href="https://forum.ragezone.com/{url}/app/tpl/skins/Habbo/styles/ie6.css" type="text/css" />
                <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/pngfix.js"></script>
                <script type="text/javascript">
                    try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
                </script>
                <style type="text/css">
                    body { behavior: url({url}/app/tpl/skins/Habbo/js/csshover.htc); }
                </style>
            <![endif]-->
        </head>
        
        <body id="home">
        
            <div id="overlay"></div>
                 <?php include ("includes/header.php"); ?>
                    <ul id="navi">
                    <?php
                            if(isset($_SESSION['user']['id']))
                                echo '<li><a href="{url}/me">{username}</a><span></span></li>';
                                  else
                                   {
                                      echo '<li><a href="{url}/register">Register Today!</a><span></span></li>';
                                   }
                    ?>
                        <li class="selected"><strong>Community</strong><span></span></li>
                        <li><a href="{url}/shop">Shop</a><span></span></li>
                    </ul>
                    <div id="habbos-online">
                        <div class="rounded"><span>{online} {online_text}</span></div>
                    </div>
                </div>
            </div>
            <div id="content-container">
                <div class="pngbg" id="navi2-container">
                    <div class="pngbg clearfix" id="navi2">
                        <ul>
                            <li class=""><a href="{url}/community">Community</a></li>
                            <li class=""><a href="{url}/news">News</a></li>
                            <li class=" selected ">Staff</li>
                            <li><a href="{url}/events">Events</a></li>
                        </ul>
                    </div>
                </div>
               <div id="container">
        <div id="content">
    
    
    
    
                                    <div id="column1" class="column">
                                    <?php
                                        $Ranks = mysql_query("SELECT id, name FROM site_ranks WHERE enabled = 'true' ORDER BY id DESC") or die(mysql_error());
                                        
                                        while ($Rank = mysql_fetch_assoc($Ranks)){
                                        {
                                            $vipUsers = mysql_query("SELECT * FROM users WHERE rank = '" .$Rank['id'] . "' ORDER BY rank LIMIT 10") or die(mysql_error());
                                        ?>
                                            <div class="habblet-container ">
                                                <div class="cbb clearfix blue ">
                                                    <h2 class="title"><?php echo $Rank['name']; ?></h2>
                                                    <div style="padding:7px 7px 1px">
                                                    <?php
                                                        while($vipUser = mysql_fetch_assoc($vipUsers)){
                                                    ?>
                                                        <p>
                                                            <div style='width: 64px; height: 81px; margin-top:-22px; margin-left:-10px; float: left; background: url(http://www.habbo.it/habbo-imaging/avatarimage?figure=<?php echo $vipUser['look']; ?>&action=crr=43&direction=&gesture=sml&size=m&img_format=gif);'></div>
                                                            <p style="margin-left:52px;">
                                                            <?php if($vipUser['online']==1){ ?><img src='http://cloudhabbo.co.uk/app/tpl/skins/{skin}/images/online.gif' style="float:right"/><?php } else { ?><img src='http://cloudhabbo.co.uk/app/tpl/skins/{skin}/images/offline.gif' style="float:right"/><?php } ?>
                                                            <a href='#'><strong><?php echo $vipUser['username']; ?></strong></a>
                                                            <br><font color='grey'><?php echo $vipUser['motto']; ?></font><br>
                                                            <small>Last Online: <?php echo date("D dS, M Y", $vipUser['last_online']); ?></small><br><br><hr>
                                                        </p>
                                                    <?php } ?>
                                                    </div>
                                                </div>
                                            </div>
                                        <?php } ?>
                                    </div>
                                <div id="column2" class="column">
    <div class="habblet-container ">
                    <div class="box-content1"> 
                            <div class="cbb clearfix darkred">
    
    
    
    
                                <h2 class="title">About Staff
                                </h2>
                            <div style="padding:5px">
                            {hotelname} staff are people behind the curtain who manage, moderate, and maintain the hotel to ensure we
                        remain online and afloat on a daily basis. Members of upper management ensure {hotelname} runs like clockwork
                        24/7 to give our users the best Habbo private server experience possible.
    </div></div></div></div>
    
    
    
    
    <div class="habblet-container ">
                    <div class="box-content1"> 
                            <div class="cbb clearfix red ">
    
    
    
    
                                <h2 class="title">How to join the team?
                                </h2>
                            <div style="padding:5px">
                    Occasionally we will release staff applications to give the community a chance at joining management.
                    Becoming a staff member on {hotelname} isn't easy and a set of requirements and criterias must be met.
                    Please never ask for staff in-game. When we're looking for staff, a news article will be posted or you
                    will be approached.
                                    </div></div></div></div>
                    <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    
                <script type="text/javascript">
                    document.observe('dom:loaded', function() {
                        CurrentRoomEvents.init();
                    });
                </script>
            </div>
    
    
    
    
            <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
            <script type="text/javascript">
                HabboView.run();
            </script>
            
            
            
            <!--[if lt IE 7]>
                <script type="text/javascript">
                    Pngfix.doPngImageFix();
                </script>
            <![endif]-->
            
            <div id="footer" >
                <?php include('includes/footer.php'); ?>
                <?php include('includes/checktheban.php'); ?>
            </div>
        
        </body>
    </html>


    Then everything should work. P.s in the ranks table you can set which rank is visible on the staff page by setting enable to "true" or "false".

    Anymore problems I'd be happy to help :)
    -Charlotte
    right i done that now the staff page doesnt load at all :(

  9. #9
    Member Charlotte Potts is offline
    MemberRank
    Aug 2015 Join Date
    YorkshireLocation
    64Posts

    Re: Couple of SQL Problems.

    Have you give the site_ranks table some data?

  10. #10
    Valued Member Troll Hotel is offline
    MemberRank
    Nov 2012 Join Date
    SlovakiaLocation
    144Posts

    Re: Couple of SQL Problems.

    Quote Originally Posted by WolfyMods View Post
    right i done that now the staff page doesnt load at all :(
    Try to run error_reporting(E_ALL); on the top of the staff page and post the error if you get one .

  11. #11
    Apprentice WolfyMods is offline
    MemberRank
    Aug 2015 Join Date
    11Posts

    Re: Couple of SQL Problems.

    Yeah i added values to site_ranks

  12. #12
    Member Charlotte Potts is offline
    MemberRank
    Aug 2015 Join Date
    YorkshireLocation
    64Posts

    Re: Couple of SQL Problems.

    1). Put this code at the top of your staff.php page and post the errow:
    Spoiler:
    Code:
    <?php
    
    	ini_set('display_errors',1);
    	ini_set('display_startup_errors',1);
    	error_reporting(-1);
    	
    ?>



Advertisement