0"); while($s = dbassoc($stories)) { dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET classes = '".implode(",", array_diff(explode(",", $s['classes']), array($class)))."' WHERE sid = '$s[sid]' LIMIT 1"); } $series = dbquery("SELECT seriesid, classes FROM ".TABLEPREFIX."fanfiction_series WHERE FIND_IN_SET('$class', classes) > 0"); while($s = dbassoc($series)) { dbquery("UPDATE ".TABLEPREFIX."fanfiction_series SET classes = '".implode(",", array_diff(explode(",", $s['classes']), array($class)))."' WHERE seriesid = '$s[seriesid]' LIMIT 1"); } $code = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_codeblocks WHERE code_type = 'delclass'"); while($c = dbassoc($code)) { eval($c['code_text']); } dbquery("DELETE FROM ".TABLEPREFIX."fanfiction_classes WHERE class_id = '$class' LIMIT 1"); } } if(isset($_GET['newitems']) && isNumber($_GET['newitems'])) { if(isset($_POST['submit'])) { for($x = 1; $x <= $itemsperpage; $x++) { $item = escapestring(descript(strip_tags($_POST["item_$x"]))); if($item) { $result = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_classes(`class_type`, `class_name`) VALUES('$_GET[newitems]', '$item')"); if(!$result) $output .= write_error(magicunquote($item).": "._ERROR."
"); } } $listtype = $_GET['newitems']; } else { $type = dbquery("SELECT classtype_title FROM ".TABLEPREFIX."fanfiction_classtypes WHERE classtype_id = '$_GET[newitems]' LIMIT 1"); list($thistype) = dbrow($type); $output .= "

$thistype

"; $list = false; } } if(isset($listtype)) { $thislist = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_classes WHERE class_type = '$listtype'"); $output .= ""; if(!dbnumrows($thislist)) $output .= ""; while($class = dbassoc($thislist)) { $output .= ""; } $output .= "

"._CLASS."	"._OPTIONS."
"._NORESULTS."
$class[class_name]	"._EDIT." \| "._DELETE."
"._ADDNEWCLASSES."

"; $list = false; } if(isset($_GET['type']) && empty($_GET['delete'])) { if(isset($_POST['submit'])) { $type_name = escapestring(descript(strip_tags($_POST['type_name']))); $type_title = escapestring(descript(strip_tags($_POST['type_title']))); if(isset($_POST['type_id'])) $result = dbquery("UPDATE ".TABLEPREFIX."fanfiction_classtypes SET classtype_name = '$type_name', classtype_title = '$type_title' WHERE classtype_id = '".$_POST['type_id']."' LIMIT 1"); else { $result = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_classtypes(classtype_name, classtype_title) VALUES('$type_name', '$type_title')"); $id = dbinsertid($result); $result2 = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_pagelinks(link_name, link_text, link_url) VALUES('".$type_name."_link', '$type_title', 'browse.php?type=class&type_id=$id')"); } if($result) $output .= write_message(_ACTIONSUCCESSFUL); else $output .= write_error(_ERROR); } else { if(isNumber($_GET['type'])) { $typequery = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_classtypes WHERE classtype_id = '$_GET[type]' LIMIT 1"); $thistype = dbassoc($typequery); } $output .= "

"; $output .= write_message(_CLASSNOTE); $list = false; } } if(isset($_GET['class']) && empty($_GET['delete'])) { if(isset($_POST['submit'])) { if(isset($_GET['class']) && isNumber($_GET['class'])) $class_id = $_GET['class']; $class_name = escapestring(descript(strip_tags($_POST['class_name']))); $class_type = isNumber($_POST['type_id']) ? $_POST['type_id'] : false; if(isset($class_id)) $result = dbquery("UPDATE ".TABLEPREFIX."fanfiction_classes SET class_name = '$class_name', class_type = '$class_type' WHERE class_id = '$class_id' LIMIT 1"); if($result) $output .= write_message(_ACTIONSUCCESSFUL); else $output .= write_error(_ERROR); } else { if(isNumber($_GET['class'])) { $typequery = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_classes WHERE class_id = '$_GET[class]' LIMIT 1"); $thisclass = dbassoc($typequery); } $output .= "

"; $output .= write_message(_CLASSNOTE); $list = false; } } if($list) { $types = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_classtypes"); $output .= "

"; if(!dbnumrows($types)) $output .= ""; while($type = dbassoc($types)) { $output .= ""; } $output .= "

"._CLASSTYPES."	"._OPTIONS."
"._NORESULTS."
$type[classtype_title]	"._EDIT." \| "._DELETE."
"._ADDNEWCLASSTYPE."

"; $output .= write_message(_CLASSLISTNOTE); } ?>