Hey Devbest!
Trying to setup Room Of The Week for my retro and for some reason the rooms are not showing on the script. It only shows this -
My page script will be down below -
Does anyone have any idea?
Trying to setup Room Of The Week for my retro and for some reason the rooms are not showing on the script. It only shows this -
My page script will be down below -
Code:
<?php
if(!isset($_SESSION['user']['username'])){
header('Location: index');
exit();
}
//Room Of The Week Script Made By HillBilly For The ***** Community\\
//--------------------------------------------------------------------\\
//This File is under a DBAD license. Claiming it as yours, selling, \\
//renaming or re-releasing makes you a dick and everyone is allowed to\\
//call you a dick. \\
//--------------------------------------------------------------------\\
$rankLimit = "5"; //From what rank can manage winners?
$limit_rooms = "1"; //How many rooms are you allowed to enter?
$txt_succes = '<p class="confirmation">You\'ve succesfully entered this weeks ROTW competition!</p>'; //Message for succesfull entry
$txt_h4x = '<p class="h4x">No fuck you faggot!</p>'; //Message when people try to exploit our system.
$txt_already_entered = '<p class="h4x">You already entered for this week!</p>'; //Message when people already entered a room.
$txt_not_your_room = '<p class="h4x">This is not your room!</p>'; //Message when people try to exploit our system.
$txt_delete_em_all = '<p class="confirmation">Deleted all entries!</p>'; //Message confirmation for truncating entries table.
?>
<!DOCTYPE html>
<?php include 'checktheban.php'; ?>
<title> HabEasy - Room Of The Week </title>
<link rel="stylesheet" type="text/css" href="app/tpl/skins/Mango/styles/disconnected.css"/>
<link rel="stylesheet" type="text/css" href="app/tpl/skins/Mango/styles/frontpage.css"/>
<link rel="stylesheet" type="text/css" href="app/tpl/skins/Mango/styles/global.css"/>
<link rel="stylesheet" type="text/css" href="app/tpl/skins/Mango/styles/login.css"/>
<link rel="stylesheet" type="text/css" href="app/tpl/skins/Mango/styles/register.css"/>
<link rel="stylesheet" type="text/css" href="app/tpl/skins/Habbo/styles/personal.css"/>
<script src="app/tpl/skins/Mango/js/homes.js" type="text/javascript"></script><script src="app/tpl/skins/Mango/js/jq.js" type="text/javascript"></script><script src="app/tpl/skins/Mango/js/jqeury-1.2.6.pack.js" type="text/javascript"></script><script src="app/tpl/skins/Mango/js/jquery.js" type="text/javascript"></script><script src="app/tpl/skins/Mango/js/mango.js" type="text/javascript"></script><script src="app/tpl/skins/Mango/js/tooltip.js" type="text/javascript"></script>
<script src="app/tpl/skins/Mango/player.js" type="text/javascript"></script>
<div class="bgtop"></div>
<div id="header_bar">
<div id="container-me">
<div class="mid">
<div class="lefts">
Welcome to HabEasy Hotel, {username}!
</div>
<div class="right">
<span style=""><img src="app/tpl/skins/Mango/images/creditIcon.png" style="vertical-align:middle;margin-right:5px;"/><span>{coins}</span>
<span style=""><img src="app/tpl/skins/Mango/images/pixelIcon.png" style="vertical-align:middle;margin-right:5px;"/>{activitypoints}</span>
<span style="">
<img src="app/tpl/skins/Mango/images/icon_users.png" style="vertical-align:middle;margin-right:5px;"/><script src="http://code.jquery.com/jquery-latest.js"></script>
{online} {hotelName}'s Online!
</span>
</div>
</div>
</div>
</div>
<div id="content">
<div id="headertje">
<div id="margin" style="margin-left: 15px; margin-top: 33px;"></div>
<div id="enter-hotel" style="margin-top:40px; margin-right: 5px;">
<div class="open" style="margin-top: -45px;">
<a href="http://habeasy.com/api.php" target="ClientWndw" onclick="window.open('http://habeasy.com/api.php','ClientWndw','width=980,height=597,resizable=1');return false;">Enter {hotelName} Hotel<i></i></a><b></b>
</div>
</div>
</div>
<div id="menubalkie">
<span class="class1">
<div class="menuitems"><a href="index.php?url=me"><img src="app/tpl/skins/Mango/_php/blue.php?t={username}&s=7&w=1"></a></div>
<div class="menuitems"><a href="index.php?url=news"><img src="app/tpl/skins/Mango/_php/blue.php?t=Community&s=7&w=1"></a></div>
<div class="menuitems"><a href="index.php?url=store"><img src="app/tpl/skins/Mango/_php/blue.php?t=HabEasy Store&s=7&w=1"></a></div>
<div class="menuitems"><a href="index.php?url=staff"><img src="app/tpl/skins/Mango/_php/blue.php?t=Staff&s=7&w=1"></a></div>
<div class="menuitems"><a href="index.php?url=logout"><img src="app/tpl/skins/Mango/_php/blue.php?t=Log Out&s=7&w=1"></a></div>
</span>
</div>
<div id="menusubbalkie">
<span class="class2">
<div class="menuitems2"><a href="index.php?url=me"><b>Homepage</b></a></div>
<div class="menuitems2"><a href="index.php?url=account">Account Settings</a></div>
<div class="menuitems2"><a href="index.php?url=rules" target="_blank">Hotel Rules</a></div>
<div class="menuitems2"><a href="http://facebook.com/habeasy" target="_blank">Like our Facebook Page!</a></div>
<div class="menuitems2"><a href="http://twitter.com/habeasy" target="_blank">Twitter</a></div>
</span>
</div>
</div>
<div id="container">
<div id="content" style="position: relative" class="clearfix">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title">Submit Your Room!</h2>
<div style="padding:5px">
<?php
$check = mysql_query("SELECT NULL FROM rotw_entries WHERE username = '".$_SESSION['user']['username']."'");
if(mysql_num_rows($check) < $limit_rooms){
if(isset($_POST['id'])){
if(is_numeric($_POST['id'])){
$sql = mysql_query("SELECT caption, description, state FROM rooms WHERE owner = '".$_SESSION['user']['username']."' AND id = '".$_POST['id']."' LIMIT 1");
if(mysql_num_rows($sql)){
$row = mysql_fetch_array($sql);
mysql_query("INSERT INTO rotw_entries VALUES ('".$_POST['id']."', '".$_SESSION['user']['username']."', '".$row['caption']."', '".$row['description']."', '".$row['state']."')");
echo $txt_succes;
}else{
echo $txt_not_your_room;
}
}else{
echo $txt_h4x;
}
}else{
?>
<form method="post">
<table style="font-size:11px;" width="100%">
<tr>
<td width="10%"></td>
<td width="40%"><b>Name</b></td>
<td width="5%"></td>
<td width="40"><i>Description</i></td>
<td width="5%"></td>
</tr>
<?php
$rooms = mysql_query("SELECT id, caption, state, description FROM rooms WHERE owner = '".$_SESSION['user']['username']."'");
while($room = mysql_fetch_array($rooms)){
echo "
<tr>
<td><img src=\"{url}/app/tpl/skins/Mango/images/rooms/room_icon_".$room['state'].".gif\" alt=\"".$room['state']."\" valign=\"middle\" /></td>
<td><b>".$room['caption']."</b>
<td> - </td>
<td><i>".$room['description']."</i></td>
<td><input type=\"radio\" name=\"id\" value=\"".$room['id']."\" /></td>
</tr>
";
}
?>
</table>
<br />
<div class="article-body">
<input type="submit" name="submit" value="Submit Room!" />
</div>
</form>
<?php
}
}else{
echo $txt_already_entered;
}
?>
</div>
</div>
</div>
<?php
if($_SESSION['user']['rank'] >= $rankLimit){
?>
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title">Select winners:</h2>
<div style="padding:5px">
<form method="post">
<?php
if(isset($_POST['winners'])){
$winners = explode(',', $_POST['winners']);
$i = 1;
foreach($winners as $win){
if($i <= 3){
$win = mysql_real_escape_string($win);
$info = mysql_fetch_array(mysql_query("SELECT * FROM rotw_entries WHERE room_id = '".$win."'"));
mysql_query("UPDATE rotw_winners SET username = '".$info['username']."', name='".$info['room_name']."', description='".$info['room_description']."' WHERE place = '".$i."'");
}
$i++;
}
}
?>
<table style="font-size:11px;" width="100%">
<tr>
<td width="10%"></td>
<td width="15%"><u>User</u></td>
<td width="30%"><b>Name</b></td>
<td width="5%"></td>
<td width="35"><i>Description</i></td>
<td width="5%">ID</td>
</tr>
<?php
$rooms = mysql_query("SELECT * FROM rotw_entries");
while($room = mysql_fetch_array($rooms)){
echo "
<tr>
<td><img src=\"{url}/app/tpl/skins/Mango/images/rooms/room_icon_".$room['state'].".gif\" alt=\"".$room['state']."\" valign=\"middle\" /></td>
<td><u>".$room['username']."</u></td>
<td><b>".$room['room_name']."</b></td>
<td> - </td>
<td><i>".$room['room_description']."</i></td>
<td>".$room['room_id']."</td>
</tr>
";
}
?>
</table>
Winners: <input type="text" value="1,2,3" name="winners" />
<input type="submit" name="submit" value="Submit Winners!" />
</form>
</div>
</div>
</div>
<?php
}
?>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title">What Is ROTW?</h2>
<div style="padding:5px">
ROTW stands for <b>R</b>oom <b>O</b>f <b>T</b>he <b>W</b>eek. Every week you can submit your room as entry for ROTW.<br />
The top 3 rooms will be rewarded with rare furniture!<br />
Don't forget to enter. It is fairly simple! <br />
You can submit <?php echo $limit_rooms; ?> room<?php if($limit_rooms > 1){ echo "s"; } ?> every week. <br />
<br><br>
</div>
</div>
</div>
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title">Winners Last Week:</h2>
<div style="padding:5px">
<b>These are last week winners:</b><br /><br />
<?php
$query = mysql_query('SELECT * FROM rotw_winners ORDER BY place ASC LIMIT 3');
while($row = mysql_fetch_array($query)){
echo '<img src="{url}/app/tpl/skins/Mango/images/rooms/'.$row['place'].'.gif" valign="middle" />'.$row['username'].' : <b>'.$row['name'].'</b> - <i>'.$row['description'].'</i><br />';
}
?>
</div>
</div>
</div>
<?php
if($_SESSION['user']['rank'] >= $rankLimit){
?>
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title">Truncate Entries</h2>
<div style="padding:5px">
<b>Click damn button to delete all ROTW entries:</b><br /><br />
<?php
if(isset($_POST['delete_em_all'])){
mysql_query("TRUNCATE rotw_entries");
echo $txt_delete_em_all;
}
?>
<form method="post"><input type="submit" name="delete_em_all" value="Delete dem shit!" /></form>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
</div>
</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]-->
</html>
<!--
//Room Of The Week Script Made By HillBilly For The ***** Community\\
//--------------------------------------------------------------------\\
//This File is under a DBAD license. Claiming it as yours, selling, \\
//renaming or re-releasing makes you a dick and everyone is allowed to\\
//call you a dick. So Dont Be A Dick! \\
//--------------------------------------------------------------------\\
-->Does anyone have any idea?
