"._REVOKEADMIN."";
if($_GET["confirm"] == "yes" && USERUID != $_GET['revoke']) {
$result = dbquery("UPDATE ".TABLEPREFIX."fanfiction_authorprefs SET level = '0' WHERE uid = '".$_GET['revoke']."'");
if($result) $output .= write_message(_ACTIONSUCCESSFUL);
else {
$result = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_authorprefs(`level`, `uid`) VALUES ('0', '".$_GET['revoke']."')"); // shouldn't be possible, but better safe than sorry.
$output .= write_error(_ERROR." "._TRYAGAIN);
}
}
else
$output .= write_message(_ACTIONCANCELLED);
}
else {
$output .= write_message(_CONFIRMADMINREVOKE." [ "._YES." | "._NO." ]");
}
}
else if($do) {
if(isset($_POST['submit'])) {
$contact = (isset($_POST['contact']) && $_POST['contact'] == "on" ? "1" : "0");
if($_POST['catid']) $categories = $_POST['catid'];
else $categories = "0";
if(check_prefs($_POST['uid'])) $result = dbquery("UPDATE ".TABLEPREFIX."fanfiction_authorprefs SET level = '".$_POST['adlevel']."', contact = '$contact', categories = '$categories' WHERE uid = '".$_POST['uid']."'");
else $result = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_authorprefs(`level`, `contact`, `categories`, `uid`) VALUES ('".$_POST['adlevel']."', '$contact', '$categories', '".$_POST['uid']."')");
if($result) $output .= write_message(_ACTIONSUCCESSFUL._BACK2ADMIN);
else $output .= write_message(_ERROR);
}
else {
if($do == "edit") {
$uid = $_GET['uid'];
$info = dbquery("SELECT "._PENNAMEFIELD." as penname, level, categories, contact FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON ap.uid = "._UIDFIELD." WHERE "._UIDFIELD." = '$uid' LIMIT 1");
list($penname, $adlevel, $adcategories, $adcontact) = dbrow($info);
$catid = explode(",", $adcategories);
}
$uid = isset($_REQUEST['uid']) ? $_REQUEST['uid'] : false;
if(!isNumber($uid)) $uid = false;
$output .= "".($do == "edit" ? _EDITADMIN : _ADDADMIN)."
";
}
}
else if(isset($_GET['category'])) {
$where = "WHERE (categories = '0' OR FIND_IN_SET('".$_GET['category']."', categories) > 0) AND ap.level > 0";
list($category) = dbrow(dbquery("SELECT category FROM ".TABLEPREFIX."fanfiction_categories WHERE catid = '".$_GET['category']."' LIMIT 1"));
$output .= "$category "._ADMINS."
";
$authorlink = " 0 AND stories.validated > 0 $where AND ap.level > 0 ".(isset($letter) ? " AND $letter" : "")." AND ap.uid = "._UIDFIELD." GROUP BY "._UIDFIELD;
include("includes/members_list.php");
$output .= ""._ADDADMIN."
";
}
else {
if($let == _OTHER) $letter = _PENNAMEFIELD." REGEXP '^[^a-z]'";
else $letter = _PENNAMEFIELD." LIKE '".$let."%'";
$output .= "";
$authorlink = " 0";
$authorquery = "SELECT "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid, count(stories.uid) as stories FROM (".TABLEPREFIX."fanfiction_authorprefs as ap, "._AUTHORTABLE.") LEFT JOIN ".TABLEPREFIX."fanfiction_stories as stories ON ("._UIDFIELD." = stories.uid) AND stories.validated > 0 WHERE ap.level > 0 ".(isset($letter) ? " AND $letter" : "")." AND ap.uid = "._UIDFIELD." GROUP BY "._UIDFIELD;
include("includes/members_list.php");
$output .= write_message(""._ADDADMIN."");
}
?>