"._CHALLENGEADMIN."";
if(!isADMIN) accessDenied( );
if(isset($_GET['task']) && $_GET['task'] == "recalc") {
$challenges = dbquery("SELECT chalid, characters FROM ".TABLEPREFIX."fanfiction_challenges");
while($c = dbassoc($challenges)) {
unset($newchars, $count, $count1, $count2);
$stories = dbquery("SELECT COUNT(sid) AS count FROM ".TABLEPREFIX."fanfiction_stories WHERE FIND_IN_SET('".$c['chalid']."', challenges) > 0");
list($count1) = dbrow($stories);
$series = dbquery("SELECT COUNT(seriesid) FROM ".TABLEPREFIX."fanfiction_series WHERE FIND_IN_SET('".$c['chalid']."', challenges) > 0");
list($count2) = dbrow($series);
$count = $count1 + $count2;
dbquery("UPDATE ".TABLEPREFIX."fanfiction_challenges SET responses = '$count' WHERE chalid = $c[chalid]");
}
$output .= write_message(_ACTIONSUCCESSFUL);
}
if(isset($_POST['submit'])) {
$anonchallenges = $_POST['anonchallenges'] == 1 ? 1 : 0;
$result = dbquery("UPDATE ".$settingsprefix."fanfiction_settings SET anonchallenges = '$anonchallenges' WHERE sitekey = '".SITEKEY."'");
if($result) $output .= write_message(_ACTIONSUCCESSFUL);
else $output .= write_error(_ERROR);
}
else {
$output .= "";
$output .= write_message(""._RECALCCHAL."");
}
?>