staff_streets.php

<?php

//------------------------------------------------
//Mod created by Cronus.
//You can find more of his mods for sale
//and join his MCCode developers community here:
//http://www.cronwerks.com/forum
//------------------------------------------------

@include_once(DIRNAME(__FILE__) .'/sglobals.php');
$data = array_merge($_GET, $_POST); //$data = $_GET and $_POST for the forms etc ;)
$data['cmd'] = (ctype_alpha($data['cmd']) && is_string($data['cmd']) && isset($data['cmd']) && !empty($data['cmd'])) ? strtolower(trim(strip_tags($data['cmd']))) : add();
switch($data['cmd']) {
case'add': add(); break;
case'edit': edit(); break;
case'del': del(); break;
default: add(); break;
}
function add() {
global $data, $db;
if(!isset($data['name'])) {
echo'Adding a new step.<hr />
<form action="?cmd=add" method="post">
<input type="hidden" name="cmd" value="add">
Name:<input type="text" value="" name="name"><br />
Text:<br /><textarea name="text"></textarea><br />
Area: <select type="dropdown" name="area">
<option value="1">The Local Park</option>
<option value="2">The Maze</option>
<option value="3">Area 3</option>
<option value="4">Area 4</option>
<option value="5">Area 5</option>
</select><br />
Reward Type:
<input type="radio" name="type" value="Item" />Item <input type="radio" name="type" value="Money" /> Money  <input type="radio" name="type" value="Crystals" /> Crystals  <input type="radio" name="type" value="Energy" /> Energy  <input type="radio" name="type" value="Brave" /> Brave  <input type="radio" name="type" value="Will" /> Will  <input type="radio" name="type" value="Health" /> Health  <input type="radio" name="type" value="Exp" /> Exp  <input type="radio" name="type" value="Crime_Exp" /> Crime Exp  <input type="radio" name="type" value="Jail" /> Jail  <input type="radio" name="type" value="Hosp" /> Hospital<br />
Reqard Qty, or Jail/Hosp Time:
<input type="text" value="" name="QTY"><br />
Item ID OR Hosp/Jail reason:
<input type="text" value="" name="Item_ID"><br />
<input type="submit" value="Create" ><br />
</form>';
exit(headers::endpage());
}
$db->query("INSERT INTO `findable` (`ID`, `Name`, `Text`, `Area`)VALUES('', '".$_POST['name']."', '".$_POST['text']."', ".$_POST['area'].");");
$last = $db->insert_id();
stafflog_add(" Step Name {$_POST['name']} has been added to the streets  ");
switch($_POST['type']) {
case'Item': $db->query("UPDATE `findable` SET `Item_ID` = ".$_POST['Item_ID'].", `QTY` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Money': $db->query("UPDATE `findable` SET `Money` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Crystals': $db->query("UPDATE `findable` SET `Crystals` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Energy': $db->query("UPDATE `findable` SET `Energy` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Brave': $db->query("UPDATE `findable` SET `Brave` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Will': $db->query("UPDATE `findable` SET `Will` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Health': $db->query("UPDATE `findable` SET `Health` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Exp': $db->query("UPDATE `findable` SET `Exp` = ".$_POST['QTY']." WHERE (`ID` = ". $last .");"); break;
case'Hosp': $db->query("UPDATE `findable` SET `Hosp` = ".$_POST['QTY'].", `H_Reason` = ".$_POST['Item_ID']." WHERE (`ID` = ". $last .");"); break;
case'Jail': $db->query("UPDATE `findable` SET `Jail` = ".$_POST['QTY'].", `J_Reason` = ".$_POST['Item_ID']." WHERE (`ID` = ". $last .");"); break;
default: echo'There has been an error. You didnt fill everything in.'; $db->query("DELETE FROM `findable` WHERE (`ID` = ", $last ,");"); exit(headers::endpage()); break;
}
echo'The step has been added successfully.';
exit(headers::endpage());
}
function del() {
global $data, $db;
if(isset($data['delete'])) {
if($data['no']) {
echo'<meta HTTP-EQUIV="refresh" content="0;url=/staff.php" />';
exit();
}
$db->query("DELETE FROM `findable` WHERE (`ID` = ". $data['delete'] .");");
echo'The step has been deleted.';
exit(headers::endpage());
}
elseif(isset($data['ID'])) {
echo'Are you sure......<br />
<form action="" method="post">
<input type="hidden" name="cmd" value="del">
<input type="hidden" name="delete" value="'.$data['ID'].'">
<input type="submit" value="Yes">
<input type="submit" value="No" name="no">
</form>';
exit(headers::endpage());
}
else{
echo'Select which step you would like to delete.....<br />
<form action="" method="post">
<input type="hidden" name="cmd" value="del">
<select type="dropdown" name="ID">';
$get_steps = $db->query("SELECT `Name`, `ID` FROM `findable` ORDER BY `ID`;");
while($step = $db->fetch_row($get_steps)) {
echo'<option value="'.$step['ID'].'">'.$step['Name'].'</option>';
}
echo'</select><br />
<input type="submit" value="Delete" />
</form>';
exit(headers::endpage());
}
}
function edit() {
global $data, $db;
if(!isset($data['ID'])) {
echo'Select which step to edit...<br />
<form action="" method="post">
<input type="hidden" name="cmd" value="edit">
<select type="dropdown" name="ID">';
$get_steps = $db->query("SELECT `Name`, `ID` FROM `findable` ORDER BY `ID`;");
while($step = $db->fetch_row($get_steps)) {
echo'<option value="'.$step['ID'].'">'.$step['Name'].'</option>';
}
echo'</select><br />
<input type="submit" value="Edit" />
</form>';
exit(headers::endpage());
}
if(!isset($data['edit'])) {
echo'You are editing a step....<br />';
$get_step = $db->query("SELECT * FROM `findable` WHERE (`ID` = ". $data['ID'] .");");
while($step = $db->fetch_row($get_step)) {
echo'<form action="" method="post">
<input type="hidden" name="cmd" value="edit">
<input type="hidden" name="edit" value="1">
<input type="hidden" name="ID" value="'.$data['ID'].'">
Name:<input type="text" name="name" value="'.$step['Name'].'"><br />
Text:<br /><textarea name="text">'.$step['Text'].'</textarea><br />
Area: <select type="dropdown" name="area">';
for($i=1; $i<=5; $i++) {
if($i == $step['Area']) { $selected = 'selected="selected"'; } else { $selected = ''; }
echo'<option value="'.$i.'"'.$selected.'>Area '.$i.'</option>';
}
echo'</select><br />
Reward Type:<br />';
$array = array('Money', 'Crystals', 'Energy', 'Brave', 'Will', 'Health', 'EXP', 'Crime_Exp', 'Item_ID');
for($i=0; $i<count($array); $i++) {
$name = str_replace('_', ' ', $array[$i]);
if($step[$array[$i]]) {
echo $name.': <input type="text" value="'.$step[$array[$i]].'" name="'.strtolower($array[$i]).'" /><br />';
}
else {
echo $name.': <input type="text" value="'.$step[$array[$i]].'" name="'.strtolower($array[$i]).'" /><br />';
}
}
echo'Item QTY only: <input type="text" value="'.$step['QTY'].'" name="QTY" /><br />
Jail Time: <input type="text" value="'.$step['Jail'].'" name="jail" /><br />
Jail Reason: <input type="text" value="'.$step['J_Reason'].'" name="jail_reason" /><br />
Hosp Time: <input type="text" value="'.$step['Hosp'].'" name="hosp" /><br />
Hosp Reason: <input type="text" value="'.$step['H_Reason'].'" name="hosp_reason" /><br />
<input type="submit" value="Edit" />
</form>';
}
exit(headers::endpage());
}
if(isset($data['edit'])) {
//Query useses seperate lines for easy-to-read(ness)
$db->query("UPDATE `findable` SET ".
"`Name` = '". $data['name'] ."', ".
"`Text` = '". $data['text'] ."', ".
"`Area` = ". $data['area'] .", ".
"`Item_ID` = ". $data['item_id'] .", ".
"`QTY` = ". $data['QTY'] .", ".
"`Money` = ". $data['money'] .", ".
"`Crystals` = ". $data['crystals'] .", ".
"`Energy` = ". $data['energy'] .", ".
"`Brave` = ". $data['brave'] .", ".
"`Will` = ". $data['will'] .", ".
"`Health` = ". $data['health'] .", ".
"`Exp` = ". $data['exp'] .", ".
"`Crime_Exp` = ". $data['crime_exp'] .", ".
"`Hosp` = ". $data['hosp'] .", ".
"`H_Reason` = '". $data['hosp_reason'] ."', ".
"`Jail` = ". $data['jail'] .", ".
"`J_Reason` = '". $data['jail_reason'] ."' ".
"WHERE (`ID` = ". $data['ID'] .");");
echo'Step successfully edited....';
exit(headers::endpage());
}
}