CMS Re-coding Help!

D

Detox

Member
Jul 24, 2010
365
24
Hello DevBest,
I'm using clean version of PlusEMU Database that was released and now it's messing up my CMS just a little bit...
Images:
a9ts0j.png

Code:

PHP: 
           </div>
                <div class = "right"></div>
                            <script type="text/javascript">
                                document.observe("dom:loaded", function() { PromoSlideShow.init(); });
                            </script>
                           <div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix red ">
<h2 class="title"><span style="float: left;">Hot Rooms</span></h2>
<?php
 
$get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 5")or die(mysql_error());
 
while ($room = mysql_fetch_assoc($get))
{
    if ($eo == 'even')
    {
        $eo = 'odd';
    }
    else
    {
        $eo = 'even';
    }
 
    echo '<li class="' . $eo . '">
    <span class="clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '" title="Go There" roomid="' . $room['id'] . '">
    <span class="room-enter">Enter room</span>
    <span class="room-name">' . ($room['caption']) . '</span>
    <span class="room-description">' . ($room['description']) . '</span>       
    <span class="room-owner">Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a></span>
    </span>
    </li>';
}
 
?>

<div id="room-more-data-h124" style="display: none">
<ul class="habblet-list room-more-data">
 
<?php
 
$get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 6,10")or die(mysql_error());
 
while ($room = mysql_fetch_assoc($get))
{
    if ($eo == 'even')
    {
        $eo = 'odd';
    }
    else
    {
        $eo = 'even';
    }
 
    echo '<li class="' . $eo . '">
    <span class="clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '" title="Go There" roomid="' . $room['id'] . '">
    <span class="room-enter">Enter room</span> <br>
    <span class="room-name">' . ($room['caption']) . '</span> <br>
    <span class="room-description">' . ($room['description']) . '</span>       
    <span class="room-owner">Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a></span>
    </span>
    </li>';
}
 
?>
</div>
<table style="margin-left: 55px; padding-top: 6px;">
<tr style="padding: 0;">
</td>
</tr>
</table>
</div>
</div>
</div>
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title"><span style="float: left;">Random Groups</span></h2>
<div style="padding: 5px;">
<table style="margin-left: 55px; padding-top: 6px;">
<tr style="padding: 0;">


                            </div>
                        </div>
                        <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                        
                    </div>
                    
                        


                        <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    </div>
                </div>
            <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]-->
       </tr>
       </table>
       </div>
       </div>
       </div>
       </div>

Secondly It's my home page...

Images:
33xtpo0.png


Code:
PHP: 
<?php

$getGroupCount = mysql_query("SELECT `GroupId` FROM `user_groups` WHERE `userid` = '".$userData['id']."'");
if (mysql_num_rows($getGroupCount) == 0)
    $groupCount = 0;
else
    $groupCount = mysql_num_rows($getGroupCount);
?>
    <div class="widget-corner" id="widget-1938125-handle">
        <div class="widget-headline"><h3><span class="header-left">&nbsp;</span><span class="header-middle">MY GROUPS (<span id="groups-list-size"><?php echo $groupCount; ?></span>)</span><span class="header-right">&nbsp;</span></h3>
        </div> 
    </div>
    <div class="widget-body">
    <?php if ($groupCount == 0) { ?>
    <div class="widget-content">

<div class="groups-list-none">
You are not a member of any Groups!
</div>

<div class="groups-list-loading"><div><a href="#" class="groups-loading-close"></a></div><div class="clear"></div><p style="text-align:center"><img src="{url}/app/tpl/skins/Habbo/images/progress_bubbles.gif" alt="" width="29" height="6" /></p></div>
<div class="groups-list-info"></div>

        <div class="clear"></div>
        </div>
        <?php } else if ($groupCount > 0) { ?>
        <div class="widget-content">
        <div class="groups-list-container">
        <ul class="groups-list">
        <?php
        while ($theGroups = mysql_fetch_array($getGroupCount)) {
            $getGroup = mysql_query("SELECT `Name`,`DateCreated`,`Image` FROM `groups` WHERE `id` = '".$theGroups['GroupId']."'") or die(mysql_error());
            if (mysql_num_rows($getGroup) > 0) {
                $groupData = mysql_fetch_array(mysql_query("SELECT * FROM `groups` WHERE `id` = '".$theGroups['GroupId']."'"));
        ?>
        
            <li title="<?php echo filter($groupData['Name']); ?>" id="groups-list-7446454-142803">
                <div class="groups-list-icon"><a href="#"><img src="{groupImagerPath}<?php echo $groupData['Image']; ?>"></a></div>
                <div class="groups-list-open"></div>
                <h4>
                <a href="#"><?php echo filter($groupData['Name']); ?></a>
                </h4>
                <p>
                Group created:<br>
                <b><?php echo $groupData['DateCreated']; //date("d-m-y", $groupData['DateCreated']); ?></b>
                </p>
                <div class="clear"></div>
            </li>
        <?php
        }
        }
        ?>
        </ul>
        </div>
        </div>
        <?php } ?>


<div class="clear"></div>
</div>
</p>

<script type="text/javascript">
document.observe("dom:loaded", function() {
    new GroupsWidget('55331348', '1938125');
});
</script>
<div class="movable widget GroupsWidget" id="widget-1938125" style=" left: 600px; top: -3px; z-index: 10;">
<div class="w_skin_defaultskin">
<div class="widget-corner" id="widget-1938125-handle">
<div class="widget-headline"><h3><span class="header-left">&nbsp;</span><span class="header-middle">MY BADGES (<span id="groups-list-size">15</span>)</span><span class="header-right">&nbsp;</span></h3>
</div>
</div>
<div class="widget-body">
<div class="widget-content">
<div class="groups-list-container">
<ul class="groups-list">
<?php
$badges = mysql_query("SELECT * FROM users_badges WHERE user_id = '".$_SESSION['user']['id']."' ORDER BY id DESC");
if(mysql_num_rows($badges) < 1) {
echo 'You have no badges';
}
while($badge = mysql_fetch_assoc($badges)) {
echo '<img class="'.$badge['badge_id'].'" src="../images/'.$badge['badge_id'].'.gif" title="'.$badge['badge_id'].'"/>
';
}
?>
</ul>
</div>
</div>
</div>
</div>
</div>
<div class="movable widget RoomsWidget" id="widget-902024" style=" left: 1px; top: 300px; z-index: 4;">
<div class="w_skin_defaultskin">
<div class="widget-corner" id="widget-902024-handle">
<div class="widget-headline"><h3><span class="header-left">&nbsp;</span><span class="header-middle">MY ROOMS (2)</span><span class="header-right">&nbsp;</span></h3>
</div>
</div>
<div class="widget-body">
<div class="widget-content">
<div id="room_wrapper">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<div class="room_image">

<?php   
$getRooms = mysql_query("SELECT `caption`,`description` FROM `rooms` WHERE `owner` = '".filter($_GET['username'])."'");
if (mysql_num_rows($getRooms) == 1) {
    echo 'You do not have any rooms<div class="clear"></div>';
} else {
?>
<div id="room_wrapper">
<table border="0" cellpadding="0" cellspacing="0">
<?php
while ($roomData = mysql_fetch_array($getRooms)) {
$roomDescription = null;
if ($roomData['description'] == null)
    $roomDescription = 'No room description!';
else
    $roomDescription = $roomData['description'];
    echo '<tr>
<td valign="top" >
        <div class="room_image">
                <img src="{url}/app/tpl/skins/Habbo/images/myhabbo/rooms/room_icon_open.gif" alt="" align="middle"/>
        </div>
</td>
<td>
            <div class="room_info">
            
                <div class="room_name">
                    '.$roomData['caption'].'
                </div>
                    <img id="room-63773258-report" class="report-button report-r"
                        alt="report"
                        src="{url}/app/tpl/skins/Habbo/images/myhabbo/buttons/report_button.gif"
                        style="display: none;" />
                <div class="clear"></div>
                <div>'.$roomDescription.'
                </div>
                    <!--a href="http://www.habbo.com/client?forwardId=2&amp;roomId=63773258"
                       target="72f577c250db9e5c22a5880ef8cb10f8ad18d7b6"
                       id="room-navigation-link_63773258"
                       onclick="HabboClient.roomForward(this, \'63773258\', \'private\', true); return false;">
                     enter room
                     </a-->
            </div>
            

        <br class=\"clear\" />

</td>
</tr>';
}
?>
</table>
</div>

<?php } ?>


</div>
</td>
 
Sort by date Sort by votes
Zaka

Zaka

Programmer
Feb 9, 2012
471
121
Detox said:
Hello DevBest,
I'm using clean version of PlusEMU Database that was released and now it's messing up my CMS just a little bit...
Images:
a9ts0j.png

Code:

PHP: 
           </div>
                <div class = "right"></div>
                            <script type="text/javascript">
                                document.observe("dom:loaded", function() { PromoSlideShow.init(); });
                            </script>
                           <div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix red ">
<h2 class="title"><span style="float: left;">Hot Rooms</span></h2>
<?php
 
$get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 5")or die(mysql_error());
 
while ($room = mysql_fetch_assoc($get))
{
    if ($eo == 'even')
    {
        $eo = 'odd';
    }
    else
    {
        $eo = 'even';
    }
 
    echo '<li class="' . $eo . '">
    <span class="clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '" title="Go There" roomid="' . $room['id'] . '">
    <span class="room-enter">Enter room</span>
    <span class="room-name">' . ($room['caption']) . '</span>
    <span class="room-description">' . ($room['description']) . '</span>      
    <span class="room-owner">Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a></span>
    </span>
    </li>';
}
 
?>

<div id="room-more-data-h124" style="display: none">
<ul class="habblet-list room-more-data">
 
<?php
 
$get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 6,10")or die(mysql_error());
 
while ($room = mysql_fetch_assoc($get))
{
    if ($eo == 'even')
    {
        $eo = 'odd';
    }
    else
    {
        $eo = 'even';
    }
 
    echo '<li class="' . $eo . '">
    <span class="clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '" title="Go There" roomid="' . $room['id'] . '">
    <span class="room-enter">Enter room</span> <br>
    <span class="room-name">' . ($room['caption']) . '</span> <br>
    <span class="room-description">' . ($room['description']) . '</span>      
    <span class="room-owner">Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a></span>
    </span>
    </li>';
}
 
?>
</div>
<table style="margin-left: 55px; padding-top: 6px;">
<tr style="padding: 0;">
</td>
</tr>
</table>
</div>
</div>
</div>
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title"><span style="float: left;">Random Groups</span></h2>
<div style="padding: 5px;">
<table style="margin-left: 55px; padding-top: 6px;">
<tr style="padding: 0;">


                            </div>
                        </div>
                        <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                       
                    </div>
                   
                       


                        <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    </div>
                </div>
            <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]-->
       </tr>
       </table>
       </div>
       </div>
       </div>
       </div>

Secondly It's my home page...

Images:
33xtpo0.png


Code:
PHP: 
<?php

$getGroupCount = mysql_query("SELECT `GroupId` FROM `user_groups` WHERE `userid` = '".$userData['id']."'");
if (mysql_num_rows($getGroupCount) == 0)
    $groupCount = 0;
else
    $groupCount = mysql_num_rows($getGroupCount);
?>
    <div class="widget-corner" id="widget-1938125-handle">
        <div class="widget-headline"><h3><span class="header-left">&nbsp;</span><span class="header-middle">MY GROUPS (<span id="groups-list-size"><?php echo $groupCount; ?></span>)</span><span class="header-right">&nbsp;</span></h3>
        </div>
    </div>
    <div class="widget-body">
    <?php if ($groupCount == 0) { ?>
    <div class="widget-content">

<div class="groups-list-none">
You are not a member of any Groups!
</div>

<div class="groups-list-loading"><div><a href="#" class="groups-loading-close"></a></div><div class="clear"></div><p style="text-align:center"><img src="{url}/app/tpl/skins/Habbo/images/progress_bubbles.gif" alt="" width="29" height="6" /></p></div>
<div class="groups-list-info"></div>

        <div class="clear"></div>
        </div>
        <?php } else if ($groupCount > 0) { ?>
        <div class="widget-content">
        <div class="groups-list-container">
        <ul class="groups-list">
        <?php
        while ($theGroups = mysql_fetch_array($getGroupCount)) {
            $getGroup = mysql_query("SELECT `Name`,`DateCreated`,`Image` FROM `groups` WHERE `id` = '".$theGroups['GroupId']."'") or die(mysql_error());
            if (mysql_num_rows($getGroup) > 0) {
                $groupData = mysql_fetch_array(mysql_query("SELECT * FROM `groups` WHERE `id` = '".$theGroups['GroupId']."'"));
        ?>
       
            <li title="<?php echo filter($groupData['Name']); ?>" id="groups-list-7446454-142803">
                <div class="groups-list-icon"><a href="#"><img src="{groupImagerPath}<?php echo $groupData['Image']; ?>"></a></div>
                <div class="groups-list-open"></div>
                <h4>
                <a href="#"><?php echo filter($groupData['Name']); ?></a>
                </h4>
                <p>
                Group created:<br>
                <b><?php echo $groupData['DateCreated']; //date("d-m-y", $groupData['DateCreated']); ?></b>
                </p>
                <div class="clear"></div>
            </li>
        <?php
        }
        }
        ?>
        </ul>
        </div>
        </div>
        <?php } ?>


<div class="clear"></div>
</div>
</p>

<script type="text/javascript">
document.observe("dom:loaded", function() {
    new GroupsWidget('55331348', '1938125');
});
</script>
<div class="movable widget GroupsWidget" id="widget-1938125" style=" left: 600px; top: -3px; z-index: 10;">
<div class="w_skin_defaultskin">
<div class="widget-corner" id="widget-1938125-handle">
<div class="widget-headline"><h3><span class="header-left">&nbsp;</span><span class="header-middle">MY BADGES (<span id="groups-list-size">15</span>)</span><span class="header-right">&nbsp;</span></h3>
</div>
</div>
<div class="widget-body">
<div class="widget-content">
<div class="groups-list-container">
<ul class="groups-list">
<?php
$badges = mysql_query("SELECT * FROM users_badges WHERE user_id = '".$_SESSION['user']['id']."' ORDER BY id DESC");
if(mysql_num_rows($badges) < 1) {
echo 'You have no badges';
}
while($badge = mysql_fetch_assoc($badges)) {
echo '<img class="'.$badge['badge_id'].'" src="../images/'.$badge['badge_id'].'.gif" title="'.$badge['badge_id'].'"/>
';
}
?>
</ul>
</div>
</div>
</div>
</div>
</div>
<div class="movable widget RoomsWidget" id="widget-902024" style=" left: 1px; top: 300px; z-index: 4;">
<div class="w_skin_defaultskin">
<div class="widget-corner" id="widget-902024-handle">
<div class="widget-headline"><h3><span class="header-left">&nbsp;</span><span class="header-middle">MY ROOMS (2)</span><span class="header-right">&nbsp;</span></h3>
</div>
</div>
<div class="widget-body">
<div class="widget-content">
<div id="room_wrapper">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<div class="room_image">

<?php  
$getRooms = mysql_query("SELECT `caption`,`description` FROM `rooms` WHERE `owner` = '".filter($_GET['username'])."'");
if (mysql_num_rows($getRooms) == 1) {
    echo 'You do not have any rooms<div class="clear"></div>';
} else {
?>
<div id="room_wrapper">
<table border="0" cellpadding="0" cellspacing="0">
<?php
while ($roomData = mysql_fetch_array($getRooms)) {
$roomDescription = null;
if ($roomData['description'] == null)
    $roomDescription = 'No room description!';
else
    $roomDescription = $roomData['description'];
    echo '<tr>
<td valign="top" >
        <div class="room_image">
                <img src="{url}/app/tpl/skins/Habbo/images/myhabbo/rooms/room_icon_open.gif" alt="" align="middle"/>
        </div>
</td>
<td>
            <div class="room_info">
           
                <div class="room_name">
                    '.$roomData['caption'].'
                </div>
                    <img id="room-63773258-report" class="report-button report-r"
                        alt="report"
                        src="{url}/app/tpl/skins/Habbo/images/myhabbo/buttons/report_button.gif"
                        style="display: none;" />
                <div class="clear"></div>
                <div>'.$roomDescription.'
                </div>
                    <!--a href="http://www.habbo.com/client?forwardId=2&amp;roomId=63773258"
                       target="72f577c250db9e5c22a5880ef8cb10f8ad18d7b6"
                       id="room-navigation-link_63773258"
                       onclick="HabboClient.roomForward(this, \'63773258\', \'private\', true); return false;">
                     enter room
                     </a-->
            </div>
           

        <br class=\"clear\" />

</td>
</tr>';
}
?>
</table>
</div>

<?php } ?>


</div>
</td>
Click to expand...
First one, didn't check the code, but for the 2nd one, PlusEMU uses userid in owner instead of username, so thats why you don't get the rooms showed.
 
Upvote 0 Downvote
D

Detox

Member
Jul 24, 2010
365
24
Zaka said:
First one, didn't check the code, but for the 2nd one, PlusEMU uses userid in owner instead of username, so thats why you don't get the rooms showed.
Click to expand...
Yes. Now it does in Sledmore Release but previously it didn't. That's why I need help to re-code it cause I'm going to be releasing my CMS... you can view it at
You must be registered for see links
 
Upvote 0 Downvote
Zaka

Zaka

Programmer
Feb 9, 2012
471
121
Detox said:
Yes. Now it does in Sledmore Release but previously it didn't. That's why I need help to re-code it cause I'm going to be releasing my CMS... you can view it at
You must be registered for see links
Click to expand...
Oh, I thought you just wanted help with pointing out the issues :p not on a computer right now so a bit hard to write code
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top