Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
CMS Re-coding Help!
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Detox" data-source="post: 401231" data-attributes="member: 596"><p>Hello DevBest,</p><p>I'm using clean version of PlusEMU Database that was released and now it's messing up my CMS just a little bit...</p><p>Images: </p><p><img src="http://i68.tinypic.com/a9ts0j.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> </p><p>Code:</p><p></p><p>[PHP] </div></p><p> <div class = "right"></div></p><p> <script type="text/javascript"></p><p> document.observe("dom:loaded", function() { PromoSlideShow.init(); });</p><p> </script></p><p> <div id="column1" class="column"></p><p><div class="habblet-container "></p><p><div class="cbb clearfix red "></p><p><h2 class="title"><span style="float: left;">Hot Rooms</span></h2></p><p><?php</p><p> </p><p>$get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 5")or die(mysql_error());</p><p> </p><p>while ($room = mysql_fetch_assoc($get))</p><p>{</p><p> if ($eo == 'even')</p><p> {</p><p> $eo = 'odd';</p><p> }</p><p> else</p><p> {</p><p> $eo = 'even';</p><p> }</p><p> </p><p> echo '<li class="' . $eo . '"></p><p> <span class="clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '" title="Go There" roomid="' . $room['id'] . '"></p><p> <span class="room-enter">Enter room</span></p><p> <span class="room-name">' . ($room['caption']) . '</span></p><p> <span class="room-description">' . ($room['description']) . '</span> </p><p> <span class="room-owner">Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a></span></p><p> </span></p><p> </li>';</p><p>}</p><p> </p><p>?></p><p></p><p><div id="room-more-data-h124" style="display: none"></p><p><ul class="habblet-list room-more-data"></p><p> </p><p><?php</p><p> </p><p>$get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 6,10")or die(mysql_error());</p><p> </p><p>while ($room = mysql_fetch_assoc($get))</p><p>{</p><p> if ($eo == 'even')</p><p> {</p><p> $eo = 'odd';</p><p> }</p><p> else</p><p> {</p><p> $eo = 'even';</p><p> }</p><p> </p><p> echo '<li class="' . $eo . '"></p><p> <span class="clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '" title="Go There" roomid="' . $room['id'] . '"></p><p> <span class="room-enter">Enter room</span> <br></p><p> <span class="room-name">' . ($room['caption']) . '</span> <br></p><p> <span class="room-description">' . ($room['description']) . '</span> </p><p> <span class="room-owner">Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a></span></p><p> </span></p><p> </li>';</p><p>}</p><p> </p><p>?></p><p></div></p><p><table style="margin-left: 55px; padding-top: 6px;"></p><p><tr style="padding: 0;"></p><p></td></p><p></tr></p><p></table></p><p></div></p><p></div></p><p></div></p><p><div id="column2" class="column"></p><p><div class="habblet-container "></p><p><div class="cbb clearfix blue "></p><p><h2 class="title"><span style="float: left;">Random Groups</span></h2></p><p><div style="padding: 5px;"></p><p><table style="margin-left: 55px; padding-top: 6px;"></p><p><tr style="padding: 0;"></p><p></p><p></p><p> </div></p><p> </div></p><p> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script></p><p> </p><p> </div></p><p> </p><p> </p><p></p><p></p><p> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script></p><p> </div></p><p> </div></p><p> <script type="text/javascript"></p><p> document.observe('dom:loaded', function() {</p><p> CurrentRoomEvents.init();</p><p> });</p><p> </script></p><p> </div></p><p> </p><p> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script></p><p> <script type="text/javascript"></p><p> HabboView.run();</p><p> </script></p><p></p><p> <!--[if lt IE 7]></p><p> <script type="text/javascript"></p><p> Pngfix.doPngImageFix();</p><p> </script></p><p> <![endif]--></p><p> </tr></p><p> </table></p><p> </div></p><p> </div></p><p> </div></p><p> </div></p><p>[/PHP]</p><p></p><p>Secondly It's my home page...</p><p></p><p>Images:</p><p><img src="http://i63.tinypic.com/33xtpo0.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> </p><p></p><p>Code:</p><p>[PHP]<?php</p><p></p><p>$getGroupCount = mysql_query("SELECT `GroupId` FROM `user_groups` WHERE `userid` = '".$userData['id']."'");</p><p>if (mysql_num_rows($getGroupCount) == 0)</p><p> $groupCount = 0;</p><p>else</p><p> $groupCount = mysql_num_rows($getGroupCount);</p><p>?></p><p> <div class="widget-corner" id="widget-1938125-handle"></p><p> <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></p><p> </div> </p><p> </div></p><p> <div class="widget-body"></p><p> <?php if ($groupCount == 0) { ?></p><p> <div class="widget-content"></p><p></p><p><div class="groups-list-none"></p><p>You are not a member of any Groups!</p><p></div></p><p></p><p><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></p><p><div class="groups-list-info"></div></p><p></p><p> <div class="clear"></div></p><p> </div></p><p> <?php } else if ($groupCount > 0) { ?></p><p> <div class="widget-content"></p><p> <div class="groups-list-container"></p><p> <ul class="groups-list"></p><p> <?php</p><p> while ($theGroups = mysql_fetch_array($getGroupCount)) {</p><p> $getGroup = mysql_query("SELECT `Name`,`DateCreated`,`Image` FROM `groups` WHERE `id` = '".$theGroups['GroupId']."'") or die(mysql_error());</p><p> if (mysql_num_rows($getGroup) > 0) {</p><p> $groupData = mysql_fetch_array(mysql_query("SELECT * FROM `groups` WHERE `id` = '".$theGroups['GroupId']."'"));</p><p> ?></p><p> </p><p> <li title="<?php echo filter($groupData['Name']); ?>" id="groups-list-7446454-142803"></p><p> <div class="groups-list-icon"><a href="#"><img src="{groupImagerPath}<?php echo $groupData['Image']; ?>"></a></div></p><p> <div class="groups-list-open"></div></p><p> <h4></p><p> <a href="#"><?php echo filter($groupData['Name']); ?></a></p><p> </h4></p><p> <p></p><p> Group created:<br></p><p> <b><?php echo $groupData['DateCreated']; //date("d-m-y", $groupData['DateCreated']); ?></b></p><p> </p></p><p> <div class="clear"></div></p><p> </li></p><p> <?php</p><p> }</p><p> }</p><p> ?></p><p> </ul></p><p> </div></p><p> </div></p><p> <?php } ?></p><p></p><p></p><p><div class="clear"></div></p><p></div></p><p></p></p><p></p><p><script type="text/javascript"></p><p>document.observe("dom:loaded", function() {</p><p> new GroupsWidget('55331348', '1938125');</p><p>});</p><p></script></p><p><div class="movable widget GroupsWidget" id="widget-1938125" style=" left: 600px; top: -3px; z-index: 10;"></p><p><div class="w_skin_defaultskin"></p><p><div class="widget-corner" id="widget-1938125-handle"></p><p><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></p><p></div></p><p></div></p><p><div class="widget-body"></p><p><div class="widget-content"></p><p><div class="groups-list-container"></p><p><ul class="groups-list"></p><p><?php</p><p>$badges = mysql_query("SELECT * FROM users_badges WHERE user_id = '".$_SESSION['user']['id']."' ORDER BY id DESC");</p><p>if(mysql_num_rows($badges) < 1) {</p><p>echo 'You have no badges';</p><p>}</p><p>while($badge = mysql_fetch_assoc($badges)) {</p><p>echo '<img class="'.$badge['badge_id'].'" src="../images/'.$badge['badge_id'].'.gif" title="'.$badge['badge_id'].'"/></p><p>';</p><p>}</p><p>?></p><p></ul></p><p></div></p><p></div></p><p></div></p><p></div></p><p></div></p><p><div class="movable widget RoomsWidget" id="widget-902024" style=" left: 1px; top: 300px; z-index: 4;"></p><p><div class="w_skin_defaultskin"></p><p><div class="widget-corner" id="widget-902024-handle"></p><p><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></p><p></div></p><p></div></p><p><div class="widget-body"></p><p><div class="widget-content"></p><p><div id="room_wrapper"></p><p><table border="0" cellpadding="0" cellspacing="0"></p><p><tr></p><p><td valign="top"></p><p><div class="room_image"></p><p></p><p><?php </p><p>$getRooms = mysql_query("SELECT `caption`,`description` FROM `rooms` WHERE `owner` = '".filter($_GET['username'])."'");</p><p>if (mysql_num_rows($getRooms) == 1) {</p><p> echo 'You do not have any rooms<div class="clear"></div>';</p><p>} else {</p><p>?></p><p><div id="room_wrapper"></p><p><table border="0" cellpadding="0" cellspacing="0"></p><p><?php</p><p>while ($roomData = mysql_fetch_array($getRooms)) {</p><p>$roomDescription = null;</p><p>if ($roomData['description'] == null)</p><p> $roomDescription = 'No room description!';</p><p>else</p><p> $roomDescription = $roomData['description'];</p><p> echo '<tr></p><p><td valign="top" ></p><p> <div class="room_image"></p><p> <img src="{url}/app/tpl/skins/Habbo/images/myhabbo/rooms/room_icon_open.gif" alt="" align="middle"/></p><p> </div></p><p></td></p><p><td></p><p> <div class="room_info"></p><p> </p><p> <div class="room_name"></p><p> '.$roomData['caption'].'</p><p> </div></p><p> <img id="room-63773258-report" class="report-button report-r"</p><p> alt="report"</p><p> src="{url}/app/tpl/skins/Habbo/images/myhabbo/buttons/report_button.gif"</p><p> style="display: none;" /></p><p> <div class="clear"></div></p><p> <div>'.$roomDescription.'</p><p> </div></p><p> <!--a href="http://www.habbo.com/client?forwardId=2&amp;roomId=63773258"</p><p> target="72f577c250db9e5c22a5880ef8cb10f8ad18d7b6"</p><p> id="room-navigation-link_63773258"</p><p> onclick="HabboClient.roomForward(this, \'63773258\', \'private\', true); return false;"></p><p> enter room</p><p> </a--></p><p> </div></p><p> </p><p></p><p> <br class=\"clear\" /></p><p></p><p></td></p><p></tr>';</p><p>}</p><p>?></p><p></table></p><p></div></p><p></p><p><?php } ?></p><p></p><p></p><p></div></p><p></td></p><p>[/PHP]</p></blockquote><p></p>
[QUOTE="Detox, post: 401231, member: 596"] 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: [IMG]http://i68.tinypic.com/a9ts0j.png[/IMG] 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> [/PHP] Secondly It's my home page... Images: [IMG]http://i63.tinypic.com/33xtpo0.png[/IMG] 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"> </span><span class="header-middle">MY GROUPS (<span id="groups-list-size"><?php echo $groupCount; ?></span>)</span><span class="header-right"> </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"> </span><span class="header-middle">MY BADGES (<span id="groups-list-size">15</span>)</span><span class="header-right"> </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"> </span><span class="header-middle">MY ROOMS (2)</span><span class="header-right"> </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&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> [/PHP] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
CMS Re-coding Help!
Top