require_once "common.php";
isnewday(3);
page_header("Mount Editor");
addnav("G?Return to the Grotto","superuser.php");
addnav("M?Return to the Mundane","village.php");
addnav("Add a mount","mounts.php?op=add");
if ($_GET['op']=="del"){
$sql = "UPDATE mounts SET mountactive=0 WHERE mountid='{$_GET['id']}'";
db_query($sql);
$_GET['op']="";
}
if ($_GET['op']=="undel"){
$sql = "UPDATE mounts SET mountactive=1 WHERE mountid='{$_GET['id']}'";
db_query($sql);
$_GET['op']="";
}
if ($_GET['op']==""){
$sql = "SELECT * FROM mounts ORDER BY mountcategory, mountcostgems, mountcostgold";
output("
",true);
output("| Ops | Name | Cost | |
",true);
$result = db_query($sql);
$cat = "";
for ($i=0;$iCategory: {$row['mountcategory']} | ",true);
$cat = $row['mountcategory'];
}
output("",true);
output("| [ Edit |",true);
addnav("","mounts.php?op=edit&id={$row['mountid']}");
if ($row['mountactive']) {
output(" Deactivate ] | ",true);
addnav("","mounts.php?op=del&id={$row['mountid']}");
}else{
output(" Activate ]",true);
addnav("","mounts.php?op=undel&id={$row['mountid']}");
}
output("{$row['mountname']} | ",true);
output("{$row['mountcostgems']} gems, {$row['mountcostgold']} gold | ",true);
//output("{$row['mountbuff']} | ",true);
output("FF: {$row['mountforestfights']}, DarkHorse: {$row['tavern']} | ",true);
output("
",true);
}
output("
",true);
}elseif ($_GET['op']=="add"){
output("Add a mount:`n");
addnav("Mount Editor Home","mounts.php");
mountform(array());
}elseif ($_GET['op']=="edit"){
addnav("Mount Editor Home","mounts.php");
$sql = "SELECT * FROM mounts WHERE mountid='{$_GET['id']}'";
$result = db_query($sql);
if (db_num_rows($result)<=0){
output("`iThis mount was not found.`i");
}else{
output("Mount Editor:`n");
$row = db_fetch_assoc($result);
$row['mountbuff']=unserialize($row['mountbuff']);
mountform($row);
}
}elseif ($_GET['op']=="save"){
$buff = array();
reset($_POST['mount']['mountbuff']);
$_POST['mount']['mountbuff']['activate']=join(",",$_POST['mount']['mountbuff']['activate']);
while (list($key,$val)=each($_POST['mount']['mountbuff'])){
if ($val>""){
$buff[$key]=stripslashes($val);
}
}
//$buff['activate']=join(",",$buff['activate']);
$_POST['mount']['mountbuff']=$buff;
reset($_POST['mount']);
$keys='';
$vals='';
$sql='';
$i=0;
while (list($key,$val)=each($_POST['mount'])){
if (is_array($val)) $val = addslashes(serialize($val));
if ($_GET['id']>""){
$sql.=($i>0?",":"")."$key='$val'";
}else{
$keys.=($i>0?",":"")."$key";
$vals.=($i>0?",":"")."'$val'";
}
$i++;
}
if ($_GET['id']>""){
$sql="UPDATE mounts SET $sql WHERE mountid='{$_GET['id']}'";
}else{
$sql="INSERT INTO mounts ($keys) VALUES ($vals)";
}
db_query($sql);
if (db_affected_rows()>0){
output("Mount saved!");
}else{
output("Mount not saved: $sql");
}
addnav("Mount Editor Home","mounts.php");
}
function mountform($mount){
global $output;
output("";
}
page_footer();
?>