include 'db.php'; $ret = mysql_query("SELECT id FROM choose_rooms WHERE end_here=0 AND blurb='' AND room_1=0 AND room_2=0"); foreach ($ret['rows'] as $row) { $ok = delete_room($row['id']); echo $ok ? '. ' : 'x '; flush(); } $ret = mysql_query("SELECT id FROM choose_rooms WHERE end_here=0 AND text_1='' AND room_1=0 AND room_2=0"); foreach ($ret['rows'] as $row) { $ok = delete_room($row['id']); echo $ok ? '. ' : 'x '; flush(); } $ret = mysql_query("SELECT id FROM choose_rooms WHERE end_here=0 AND text_2='' AND room_1=0 AND room_2=0"); foreach ($ret['rows'] as $row) { $ok = delete_room($row['id']); echo $ok ? '. ' : 'x '; flush(); } echo "<br />All done!"; function delete_room($id) { $room = db_single(mysql_query("SELECT * FROM choose_rooms WHERE id=" . $id)); $parent = db_single(mysql_query("SELECT * FROM choose_rooms WHERE room_1=" . $id . " OR room_2=" . $id)); if ($room['room_1']) { return 0; } if ($room['room_2']) { return 0; } db_write("DELETE FROM choose_rooms WHERE id=" . $id);
require '../model/database.php'; require '../model/room_db.php'; $action = filter_input(INPUT_POST, 'action'); if ($action === NULL) { $action = filter_input(INPUT_GET, 'action'); if ($action === NULL) { $action = 'list_rooms'; } } if ($action == 'list_rooms') { $rooms = get_rooms(); include 'room_list.php'; } if ($action == 'add_room') { $name = filter_input(INPUT_POST, 'name'); if ($name == null) { $error = "Please enter a room name"; echo $error; } else { $detectRoomName = detect_room_name($name); $rooms = get_rooms(); include 'room_list.php'; } } if ($action == 'delete_room') { $room_id = filter_input(INPUT_POST, 'room_id'); delete_room($room_id); $rooms = get_rooms(); include 'room_list.php'; }
session_start(); $err_message = " Unable to process your request due to the following problems: <br>\n"; if ($_POST["Submit"]) { if ($_POST["Submit"] == "Submit") { if ($_POST["RoomName"] != "") { if ($_POST["RoomID"]) { // Update changed rooms update_room($_POST["RoomID"], $_POST["RoomName"], &$err_message); } else { // Add a new room if given add_new_room($_POST["RoomName"]); } } } else { if ($_POST["Submit"] == "Confirm") { delete_room($_POST["RoomID"]); } } } $rooms = get_rooms(); if ($_GET["add"]) { do_html_header("Add Room", &$err_message); ?> <!-- Start add section --> <form name="frmEdit" method="post" action="rooms.php"> <div style="padding-top: 0.5cm; padding-bottom: 0.5cm"> <span> Room Name: </span> <span style="padding-left: 1cm"> <input name="RoomName" type="text" size="40" maxlength="50" value="">
/** * Wrapper and actualiser to delete a room. Does not return. * * @param MEMBER The member, who is at the room being deleted */ function delete_room_wrap($member_id) { list($realm, $x, $y) = get_loc_details($member_id); $attempt_member = $member_id; if (!has_specific_permission($attempt_member, 'administer_ocworld') && $GLOBALS['SITE_DB']->query_value('w_rooms', 'owner', array('location_x' => $x, 'location_y' => $y, 'location_realm' => $realm)) != $attempt_member) { ocw_refresh_with_message(do_lang_tempcode('ACCESS_DENIED__I_ERROR', $GLOBALS['FORUM_DRIVER']->get_username(get_member())), 'warn'); } if ($x == 0 && ($y == 0 || $y == 1 || $y == 2)) { ocw_refresh_with_message(do_lang_tempcode('W_DEL_MAIN'), 'warn'); } $name = $GLOBALS['SITE_DB']->query_value('w_rooms', 'name', array('location_x' => $x, 'location_y' => $y, 'location_realm' => $realm)); // Refund them require_code('points2'); $price = get_price('mud_room'); charge_member($attempt_member, intval(-0.7 * $price), do_lang('W_DELETE_ROOM_OCWORLD', $name)); delete_room($x, $y, $realm); }
$error_msg .= "A room number is required. <BR>"; } if (empty($rm_cap)) { $error_msg .= "A capacity for the room is required. <BR>"; } if ($error_msg != "") { include "add_room.php"; exit; } else { add_room($rm_nbr, $rm_cap); } } } else { if ($action == "delete") { $id = filter_input(INPUT_GET, "id"); delete_room($id); } else { if ($action == "edit") { $rm = get_room(filter_input(INPUT_GET, "id")); include "edit_room.php"; exit; } else { if ($action == "edit_room") { $choice = filter_input(INPUT_POST, "choice"); $rm_nbr = filter_input(INPUT_POST, "rm_nbr"); $rm_cap = filter_input(INPUT_POST, "rm_cap"); $rm_id = filter_input(INPUT_POST, "rm_id"); if ($choice == "Make Changes") { $error_msg = ""; if (empty($rm_nbr)) { $error_msg .= "A room number is required. <BR>";
function dbase_parse($cmd, $message) { global $pisql, $dbhost, $dbuser, $dbpass, $dbname; global $log; // Used by daemon global $apperr, $appmsg; // For ajax usage if (!$pisql || !$pisql->ping()) { $log->lwrite("dbase_parse:: Ping failed, making new pisql connection to server", 1); $pisql = new mysqli($dbhost, $dbuser, $dbpass, $dbname); } // If there is an error if ($pisql->connect_errno) { $log->lwrite("dbase_parse:: Failed to connect to MySQL: (" . $pisql->connect_errno . ") " . $pisql->connect_error, 1); return -1; } // For logging only if (is_array($message)) { $str = ""; foreach ($message as $key => $val) { $str .= " {" . $key . ":" . $val . "},"; } $log->lwrite("dbase_parse:: " . $cmd . ": " . $str, 1); } else { $log->lwrite("dbase_parse:: message: " . $cmd . ": " . $message, 1); } // // Depending on $cmd execute database function switch ($cmd) { // Database case "load_database": $ret = load_database(); break; // Device // Device case "load_devices": $ret = load_devices(); break; case "add_device": $ret = add_device($message); break; case "delete_device": $ret = delete_device($message); break; case "store_device": $ret = store_device($message); break; // Room // Room case "add_room": $ret = add_room($message); break; case "delete_room": $ret = delete_room($message); break; // Scene // Scene case "read_scene": $ret = load_scene($message); break; case "load_scenes": $ret = load_scenes(); break; case "add_scene": $ret = add_scene($message); break; case "delete_scene": $ret = delete_scene($message); break; case "upd_scene": $ret = upd_scene($message); break; case "store_scene": $ret = store_scene($message); break; // Timer // Timer case "add_timer": $ret = add_timer($message); break; case "delete_timer": $ret = delete_timer($message); break; case "store_timer": $ret = store_timer($message); break; // Handset // Handset case "add_handset": $ret = add_handset($message); break; case "delete_handset": $ret = delete_handset($message); break; case "store_handset": $ret = store_handset($message); break; // Weather // Weather case "add_weather": $ret = add_weather($message); break; case "delete_weather": $ret = delete_weather($message); break; // Setting // Setting case "store_setting": $ret = store_setting($message); break; default: } if ($ret >= 0) { // Prepare structure to send back to the calling ajax client (in stdout) $send = array('tcnt' => $ret, 'appmsg' => $appmsg, 'status' => 'OK', 'apperr' => $apperr); $output = json_encode($send); } else { // Functions need to fill apperr themselves! $send = array('tcnt' => $ret, 'appmsg' => $appmsg, 'status' => 'ERR', 'apperr' => $apperr); $output = json_encode($send); } return $output; }
require '.auth_modsession'; require '.config_commonfunctions'; ?> <table align="center" border="1" cellpadding="5"> <tr> <td align="center"><a href="portal_servermanagement.php">Server Management Menu</a></td> <td align="center"><a href="logout.php">Logout</a></td> </tr> <tr> <td colspan="2"> <?php if ($_SERVER['REQUEST_METHOD'] == 'POST') { $idroom = $_POST['roomid']; if (empty($idroom)) { echo "failed, server id can not be blank"; exit; } $results = delete_room(trim($idroom)); if (strpos(strtolower($results), "fail") !== false) { echo $results; exit; } echo "Room deleted successfully"; } ?> </td> </tr> </table> </body> </html>
$ret = db_fetch("SELECT id FROM choose_rooms WHERE end_here=0 AND blurb='' AND room_1=0 AND room_2=0"); foreach ($ret[rows] as $row){ $ok = delete_room($row[id]); echo $ok?'. ':'x '; flush(); } $ret = db_fetch("SELECT id FROM choose_rooms WHERE end_here=0 AND text_1='' AND room_1=0 AND room_2=0"); foreach ($ret[rows] as $row){ $ok = delete_room($row[id]); echo $ok?'. ':'x '; flush(); } $ret = db_fetch("SELECT id FROM choose_rooms WHERE end_here=0 AND text_2='' AND room_1=0 AND room_2=0"); foreach ($ret[rows] as $row){ $ok = delete_room($row[id]); echo $ok?'. ':'x '; flush(); } echo "<br />All done!"; function delete_room($id){ $room = db_single(db_fetch("SELECT * FROM choose_rooms WHERE id=$id")); $parent = db_single(db_fetch("SELECT * FROM choose_rooms WHERE room_1=$id OR room_2=$id")); if ($room[room_1]) return 0; if ($room[room_2]) return 0;
function dbase_parse($cmd, $message) { // switch ($cmd) { case "add_device": $ret = add_device($message); break; case "delete_device": $ret = delete_device($message); break; case "add_room": $ret = add_room($message); break; case "delete_room": $ret = delete_room($message); break; case "add_scene": break; case "delete_scene": break; case "upd_scene": break; case "add_timer": break; case "delete_timer": break; case "store_timer": break; case "add_handset": break; case "delete_handset": break; case "store_handset": break; case "add_weather": break; case "delete_weather": break; case "store_setting": break; default: } if ($ret >= 0) { // Prepare structure to send back to the calling ajax client (in stdout) $send = array('tcnt' => $ret, 'appmsg' => $appmsg, 'status' => 'OK', 'apperr' => $apperr); $output = json_encode($send); } else { // Functions need to fill apperr themselves! $send = array('tcnt' => $ret, 'appmsg' => $appmsg, 'status' => 'ERR', 'apperr' => $apperr); $output = json_encode($send); } return $output; }