"._CHARACTERS.""; if(isset($_GET["delete"])) { $charid = $_GET["delete"]; $confirm = isset($_GET['confirm']) ? $_GET['confirm'] : false; if($confirm == "yes" && isNumber($charid)) { $result5 = dbquery("SELECT catid, charname FROM ".TABLEPREFIX."fanfiction_characters WHERE charid = '$charid'"); $chars = dbassoc($result5); dbquery("DELETE FROM ".TABLEPREFIX."fanfiction_characters where charid = '$charid'"); $storyquery = dbquery("SELECT charid, sid FROM ".TABLEPREFIX."fanfiction_stories WHERE FIND_IN_SET('$charid', charid) > 0"); while($story = dbassoc($storyquery)) { $newcharlist = array_diff(explode(",", $story['charid']), array($charid)); dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET charid = '".($newcharlist ? implode(",", $newcharlist) : "")."' WHERE sid = '$story[sid]'"); } $seriesquery = dbquery("SELECT characters, seriesid FROM ".TABLEPREFIX."fanfiction_series WHERE FIND_IN_SET('$charid', characters) > 0"); while($series = dbassoc($seriesquery)) { $newcharlist = array_diff(explode(",", $series['characters']), array($charid)); dbquery("UPDATE ".TABLEPREFIX."fanfiction_series SET characters = '".($newcharlist ? implode(",", $newcharlist) : "")."' WHERE seriesid = '$series[seriesid]'"); } $code = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_codeblocks WHERE code_type = 'delchar'"); while($c = dbassoc($code)) { eval($c['code_text']); } $output .= write_message(_ACTIONSUCCESSFUL); } else if ($confirm == "no") { $output .= write_message(_ACTIONCANCELLED); } else { $output .= write_message(_CONFIRMDELETE."

[ "._YES." | "._NO." ]"); } } if(isset($_GET['do']) && $_GET['do'] == "addform") { if(isset($_GET['charid']) && isNumber($_GET['charid'])) $charid = $_GET['charid']; if(isset($_POST['numchars']) && isNumber($_POST['numchars'])) $numchars = $_POST['numchars']; if(!isset($numchars)) $numchars = $itemsperpage; if(isset($charid)) { $charquery = dbquery("SELECT charname, bio FROM ".TABLEPREFIX."fanfiction_characters WHERE charid = '$charid' LIMIT 1"); $charinfo = dbassoc($charquery); $output .= "
"; $numchars = 1; } else if(isset($_GET['catid'])) { $output .= ""; } else { $output .= "
"; } for($x = 1; $x <= $numchars; $x++) { $output .= "
".(isset($charid) ? _EDITCHAR : _NEWCHAR." $x")."
[?]"._HELP_CHARS."
"; if($tinyMCE) $output .= "
"; } $output .= "
"; unset($_POST['submit']); } if(isset($_POST["submit"])) { if($_GET["do"] == "add") { $numchars = $_POST["numchars"]; if(!isNumber($numchars)) $numchars = $itempsperpage; for($x = 1; $x <= $numchars; $x++) { if(isset($_POST["character$x"]) && $_POST["character$x"] != "") { $result = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_characters (charname, bio, catid) VALUES('".escapestring(descript(strip_tags(trim($_POST["character$x"]))))."', '".escapestring(descript($_POST["bio$x"]))."', '$_POST[catid]')"); } } } else if($_GET["do"] == "update") { $result = dbquery("UPDATE ".TABLEPREFIX."fanfiction_characters SET charname = '".escapestring(descript(strip_tags(trim($_POST["character1"]))))."', bio = '".escapestring(descript($_POST["bio1"]))."' WHERE charid = '$_POST[charid]'"); } $output .= write_message(_ACTIONSUCCESSFUL); } if(!isset($_GET['do']) || isset($_POST['submit'])) { if(isset($_GET['cat']) && isNumber($_GET['cat'])) $cat = $_GET['cat']; else $cat = -1; $output .= "
"; // Repopulate the characters list to reflect any changes we made. $charlist = array( ); $result = dbquery("SELECT charname, catid, charid FROM ".TABLEPREFIX."fanfiction_characters ORDER BY charname"); while($char = dbassoc($result)) { $charlist[$char['charid']] = array("name" => stripslashes($char['charname']), "catid" => $char['catid']); } //List of current characters $output .= "
"._CHOOSECATNOTE."

"; $count = 0; foreach($charlist as $char =>$charinfo) { if($charinfo['catid'] == $cat) { $output .= ""; $count++; } } if($count == 0) $output .= ""; $output .= "
"._CHARACTER.""._OPTIONS."
".$charinfo['name'].""._EDIT." | "._DELETE."
"._NORESULTS."

"; $output .= "
"._ADDNEWCHARS."
[?]"._HELP_NUMCHARS."
 
"; } ?>