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
Need UberCMS PHP 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="Pekka" data-source="post: 120221" data-attributes="member: 18604"><p>So I pretty much ripped the whole code off the userlookup and made it so it shows rooms and so you can edit the room and etc, but it seems to function properly except when I edit it, it wont update when I click update, can someone review the code and see what's missing and how to fix it, I would appreciate any kind or form of help, thanks!</p><p> </p><p>[PHP]<?php</p><p>if (!defined('IN_HK') || !IN_HK)</p><p>{</p><p> exit;</p><p>}</p><p> </p><p>if (!HK_LOGGED_IN || !$users->hasFuse(USER_ID, 'fuse_housekeeping_moderation'))</p><p>{</p><p> exit;</p><p>}</p><p> </p><p>$roomid = '';</p><p> </p><p>if (isset($_POST['room'])) { $roomid = filter($_POST['room']); }</p><p>require_once "top.php"; </p><p> </p><p>echo("<h1>Room Lookup</h1></p><p><br /><p>This tool can be used for looking up and editing a room!</p>");</p><p>echo '<br /></p><p><form method="post">Room ID:<br /></p><p><input type="text" name="room"><Br /></p><p><input type="submit" value="Lookup"></p><p></form>';</p><p>if (isset($roomid))</p><p>{</p><p>if (!@$_POST['update'])</p><p>{</p><p>$rooms = mysql_query("SELECT * from rooms where id = '$roomid'");</p><p>$room = mysql_fetch_array($rooms);</p><p>echo("<div align=\"center\"><form method=\"POST\"></p><p><table width=\"100%\"></p><p> </p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Room ID:</b></p><p></td></p><p><td align=\"left\"></p><p>$room[id]</p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Owner:</b></p><p></td></p><p><td align=\"left\"></p><p>$room[owner]</p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Room Type:</b></p><p></td></p><p><td align=\"left\"></p><p>$room[roomtype]</p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Room Name:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"caption\"</p><p>value=\"$room[caption]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Room Description:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"description\"</p><p>value=\"$room[description]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Room Category:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"category\"</p><p>value=\"$room[category]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Room State:</b></p><p></td></p><p><td align=\"left\"></p><p><select name=\"state\"</p><p>value=\"$room[state]\"></p><p><option>$room[state]</option></p><p><option>locked</option></p><p> <option>password</option></p><p> <option>open</option></p><p></select</p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Password of room if passworded:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"password\"</p><p>value=\"$room[password]\"></p><p></td></p><p></tr></p><p> </p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Room Model:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"model_name\"</p><p>value=\"$room[model_name]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Users currently inside:</b></p><p></td></p><p><td align=\"left\"></p><p>$room[users_now]</p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Max Users:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"users_max\"</p><p>value=\"$room[users_max]\"></p><p></td></p><p></tr></p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Score:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"score\"</p><p>value=\"$room[score]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Tags:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"tags\"</p><p>value=\"$room[tags]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Pets Allowed:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"allow_pets\"</p><p>value=\"$room[allow_pets]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Allow Pets to Freeload:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"allow_pets_eat\"</p><p>value=\"$room[allow_pets_eat]\"></p><p></td></p><p></tr></p><p> </p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Blocking Disabled:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"allow_walkthrough\"</p><p>value=\"$room[allow_walkthrough]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Wall is Hidden:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"allow_hidewall\"</p><p>value=\"$room[allow_hidewall]\"></p><p></td></p><p></tr></p><p> </p><p><tr></p><p><td align=\"right\" width=\"25%\"></p><p><b>Achievement:</b></p><p></td></p><p><td align=\"left\"></p><p><input name=\"achievement\"</p><p>value=\"$room[achievement]\"></p><p></td></p><p></tr></p><p><tr></p><p><td align=\"center\"></p><p></td></p><p><td align=\"left\"></p><p><input type=\"submit\" name=\"update\" value=\"Update\"></td></p><p></tr></p><p></table></p><p></form></p><p></div>");</p><p>}</p><p>else</p><p>{</p><p> </p><p>$caption = htmlspecialchars($_POST['caption']);</p><p>$description = htmlspecialchars($_POST['description']);</p><p>$state = htmlspecialchars($_POST['state']);</p><p>$model_name = htmlspecialchars($_POST['model_name']);</p><p>$category = htmlspecialchars($_POST['category']);</p><p>$users_max = htmlspecialchars($_POST['users_max']);</p><p>$score = htmlspecialchars($_POST['score']);</p><p>$tags = htmlspecialchars($_POST['tags']);</p><p>$allow_pets = htmlspecialchars($_POST['allow_pets']);</p><p>$allow_pets_eat = htmlspecialchars($_POST['allow_pets_eat']);</p><p>$allow_walkthrough = htmlspecialchars($_POST['allow_walkthrough']);</p><p>$allow_hidewall = htmlspecialchars($_POST['allow_hidewall']);</p><p>$achievement = htmlspecialchars($_POST['achievement']);</p><p>echo ("<br /><br />Room ID .'&room[id]'. has been updated.");</p><p>$update = mysql_query("Update rooms set caption = '$caption', description = '$description', state = '$state', model_name = '$model_name', category = '$category', users_max = '$users_max', score = '$score', tags = '$tags', allow_pets = '$allow_pets', allow_pets_eat = '$allow_pets_eat', allow_walkthrough = '$allow_walkthrough', allow_hidewall = '$allow_hidewall', achievement = '$achievement', achievement = '$achievement' where id = '$roomid'");</p><p>}</p><p>}</p><p>require_once "bottom.php";</p><p>?>[/PHP]</p></blockquote><p></p>
[QUOTE="Pekka, post: 120221, member: 18604"] So I pretty much ripped the whole code off the userlookup and made it so it shows rooms and so you can edit the room and etc, but it seems to function properly except when I edit it, it wont update when I click update, can someone review the code and see what's missing and how to fix it, I would appreciate any kind or form of help, thanks! [PHP]<?php if (!defined('IN_HK') || !IN_HK) { exit; } if (!HK_LOGGED_IN || !$users->hasFuse(USER_ID, 'fuse_housekeeping_moderation')) { exit; } $roomid = ''; if (isset($_POST['room'])) { $roomid = filter($_POST['room']); } require_once "top.php"; echo("<h1>Room Lookup</h1> <br /><p>This tool can be used for looking up and editing a room!</p>"); echo '<br /> <form method="post">Room ID:<br /> <input type="text" name="room"><Br /> <input type="submit" value="Lookup"> </form>'; if (isset($roomid)) { if (!@$_POST['update']) { $rooms = mysql_query("SELECT * from rooms where id = '$roomid'"); $room = mysql_fetch_array($rooms); echo("<div align=\"center\"><form method=\"POST\"> <table width=\"100%\"> <tr> <td align=\"right\" width=\"25%\"> <b>Room ID:</b> </td> <td align=\"left\"> $room[id] </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Owner:</b> </td> <td align=\"left\"> $room[owner] </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Room Type:</b> </td> <td align=\"left\"> $room[roomtype] </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Room Name:</b> </td> <td align=\"left\"> <input name=\"caption\" value=\"$room[caption]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Room Description:</b> </td> <td align=\"left\"> <input name=\"description\" value=\"$room[description]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Room Category:</b> </td> <td align=\"left\"> <input name=\"category\" value=\"$room[category]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Room State:</b> </td> <td align=\"left\"> <select name=\"state\" value=\"$room[state]\"> <option>$room[state]</option> <option>locked</option> <option>password</option> <option>open</option> </select </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Password of room if passworded:</b> </td> <td align=\"left\"> <input name=\"password\" value=\"$room[password]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Room Model:</b> </td> <td align=\"left\"> <input name=\"model_name\" value=\"$room[model_name]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Users currently inside:</b> </td> <td align=\"left\"> $room[users_now] </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Max Users:</b> </td> <td align=\"left\"> <input name=\"users_max\" value=\"$room[users_max]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Score:</b> </td> <td align=\"left\"> <input name=\"score\" value=\"$room[score]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Tags:</b> </td> <td align=\"left\"> <input name=\"tags\" value=\"$room[tags]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Pets Allowed:</b> </td> <td align=\"left\"> <input name=\"allow_pets\" value=\"$room[allow_pets]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Allow Pets to Freeload:</b> </td> <td align=\"left\"> <input name=\"allow_pets_eat\" value=\"$room[allow_pets_eat]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Blocking Disabled:</b> </td> <td align=\"left\"> <input name=\"allow_walkthrough\" value=\"$room[allow_walkthrough]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Wall is Hidden:</b> </td> <td align=\"left\"> <input name=\"allow_hidewall\" value=\"$room[allow_hidewall]\"> </td> </tr> <tr> <td align=\"right\" width=\"25%\"> <b>Achievement:</b> </td> <td align=\"left\"> <input name=\"achievement\" value=\"$room[achievement]\"> </td> </tr> <tr> <td align=\"center\"> </td> <td align=\"left\"> <input type=\"submit\" name=\"update\" value=\"Update\"></td> </tr> </table> </form> </div>"); } else { $caption = htmlspecialchars($_POST['caption']); $description = htmlspecialchars($_POST['description']); $state = htmlspecialchars($_POST['state']); $model_name = htmlspecialchars($_POST['model_name']); $category = htmlspecialchars($_POST['category']); $users_max = htmlspecialchars($_POST['users_max']); $score = htmlspecialchars($_POST['score']); $tags = htmlspecialchars($_POST['tags']); $allow_pets = htmlspecialchars($_POST['allow_pets']); $allow_pets_eat = htmlspecialchars($_POST['allow_pets_eat']); $allow_walkthrough = htmlspecialchars($_POST['allow_walkthrough']); $allow_hidewall = htmlspecialchars($_POST['allow_hidewall']); $achievement = htmlspecialchars($_POST['achievement']); echo ("<br /><br />Room ID .'&room[id]'. has been updated."); $update = mysql_query("Update rooms set caption = '$caption', description = '$description', state = '$state', model_name = '$model_name', category = '$category', users_max = '$users_max', score = '$score', tags = '$tags', allow_pets = '$allow_pets', allow_pets_eat = '$allow_pets_eat', allow_walkthrough = '$allow_walkthrough', allow_hidewall = '$allow_hidewall', achievement = '$achievement', achievement = '$achievement' where id = '$roomid'"); } } require_once "bottom.php"; ?>[/PHP] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Need UberCMS PHP Help
Top