"._RATINGS.""; $showlist = 1; if(isset($_GET["delete"]) && isNumber($_GET["delete"])) { $rid = $_GET["delete"]; $confirm = isset($_GET["confirm"]) ? $_GET["confirm"] : false; if($confirm == "yes") { $result5 = dbquery("SELECT rating FROM ".TABLEPREFIX."fanfiction_ratings WHERE rid = '$rid'"); $ratings = dbassoc($result5); dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET rid = '"._NONE."' WHERE sid = '$ratingresult[sid]'"); dbquery("DELETE FROM ".TABLEPREFIX."fanfiction_ratings WHERE rid = '$rid'"); $output .= write_message(_ACTIONSUCCESSFUL); } else if ($confirm == "no") { $output .= write_message(_ACTIONCANCELLED); } else { $showlist = 0; $output .= write_message(_CONFIRMDELETE."

[ "._YES." | "._NO." ]"); } } if (isset($_POST["submit"]) && ((isset($_GET['rid']) && isNumber($_GET['rid'])) || $_GET['rid'] == "new")) { $newrate = escapestring(strip_tags(descript($_POST['rating']))); $newtext = escapestring(strip_tags(descript($_POST['warningtext']))); $ratingwarning = isset($_POST['ratingwarning']) ? 1 : 0; if(isset($_POST['rusersonly'])) $ratingwarning = $ratingwarning + 4; if(isset($_POST['ageconsent'])) $ratingwarning = $ratingwarning + 2; if($_GET["rid"] == "new") $ratingquery = "INSERT INTO ".TABLEPREFIX."fanfiction_ratings (rating, ratingwarning, warningtext) VALUES ('$newrate', '$ratingwarning', '$newtext')"; else $ratingquery = "UPDATE ".TABLEPREFIX."fanfiction_ratings SET rating = '$newrate', ratingwarning = '$ratingwarning', warningtext = '$newtext' WHERE rid = '".$_GET['rid']."'"; dbquery($ratingquery); if($_GET["rid"] != "new" && $newrate != $_POST['oldrating']) dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET rid = '$newrate' WHERE rid = '".$_POST['oldrating']."'"); $output .= write_message(_ACTIONSUCCESSFUL); } else if(isset($_GET["rid"])) { $showlist = 0; $new = $_GET['rid'] == "new" ? true : false; if(!$new && isNumber($_GET["rid"])) { $ratingquery = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_ratings WHERE rid = '".$_GET['rid']."' LIMIT 1"); $rating = dbassoc($ratingquery); } $output .= "

".($new ? _NEWRAT : _EDITRAT)."

"._RATING.": [?]"._HELP_RATING.""; if(isset($rating)) $output .= ""; $warninglevel = isset($rating) ? sprintf("%03b", $rating['ratingwarning']) : array(0,0,0); $output .= "

"._WARNINGPOP.": [?]"._HELP_RATINGWARNING."

"._AGECHECK.": [?]"._HELP_RATINGCONSENT."

"._RUSERSONLY.": [?]"._HELP_RATINGUSERS."

"._WARNINGTEXT.": "; if($tinyMCE) $output .= "

"._TINYMCETOGGLE."

"; $output .= "

[?]"._HELP_RATINGWARNTEXT."

"; } if($showlist) { $result = dbquery("SELECT * from ".TABLEPREFIX."fanfiction_ratings"); //List of current ratings $output .= ""; $output .= ""; while ($ratingresults = dbassoc($result)) { $output .= ""; } $output .= "

"._RATINGS."
"._RATING."	"._WARNING."	"._OPTIONS."
".$ratingresults['rating']; if($ratingresults['ratingwarning'] >= 1) $output .= "	"._YES.""; else $output .= "	"._NO.""; $output .= "	"._EDIT." \| "._DELETE."
"._ADDRAT."

"; } ?>