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;
}
