| "._FEATUREDSTORIES." |
|---|
";
if(!dbnumrows($fresult)) $output .= "| "._NOSTORIES." |
";
while($story = dbassoc($fresult)) {
$output .= "
| $story[title] "._BY." ".$story['penname']." | ".($story['featured'] == 1 ? ""._CURRENT."" : ""._RETIRED."")." |
";
}
$output .= "
"._FEATUREDNOTE;
return $output;
}
// end featured
function submitted()
{
global $tableprefix, $admincats, $allowed_tags, $dbconnect;
$output = ""._SUBMITTED."
";
$query = "SELECT story.title as storytitle, chapter.uid, chapter.sid, story.catid, chapter.chapid, chapter.inorder, chapter.title, author.penname FROM (".TABLEPREFIX."fanfiction_chapters as chapter, ".TABLEPREFIX."fanfiction_authors as author) LEFT JOIN ".TABLEPREFIX."fanfiction_stories as story ON story.sid = chapter.sid WHERE chapter.validated = '0' AND chapter.uid = author.uid ORDER BY story.title ASC, chapter.inorder ASC";
$result = dbquery($query) or die(_FATALERROR."Query: ".$query."
Error: (". $dbconnect->errno.") ". $dbconnect->error);
$output .= "| "._TITLE." | "._AUTHOR." | "._CATEGORY." | "._OPTIONS." |
|---|
";
$array = explode(",", $admincats);
while ($story = dbassoc($result))
{
unset($catstring);
$result3 = dbquery("SELECT catid, category FROM ".TABLEPREFIX."fanfiction_categories WHERE FIND_IN_SET(catid, '".$story['catid']."')");
while($cats = dbassoc($result3)) {
$catstring[] = "".$cats['category']."";
}
if(!$admincats || sizeof(array_intersect(explode(",", $story['catid']), explode(",", $admincats)))) {
$output .= "";
$output .= "| ".$story['storytitle']."";
if($story['title']) $output .= " : ".$story['title']."";
$output .= " | ".$story['penname']." | ";
$output .= "".(is_array($catstring) ? implode(", ", $catstring) : "")." | ";
$output .= ""._VALIDATE." | "._DELETE.": "._CHAPTER." "._OR." "._STORY." | "._YESLETTER." | "._NOLETTER." |
";
}
}
$output .= "
";
return $output;
}
// end submitted function
function validate( ) {
global $tableprefix, $level, $store, $storiespath, $allowed_tags, $admincats, $sitename, $siteemail, $url, $alertson;
$output = ""._VIEWSUBMITTED."
";
if($_GET['validate'] == "yes") {
$storyquery = dbquery("SELECT story.validated, story.catid, story.sid, story.title, story.summary, story.uid, author.penname, chapter.inorder FROM ".TABLEPREFIX."fanfiction_stories as story, ".TABLEPREFIX."fanfiction_chapters as chapter, ".TABLEPREFIX."fanfiction_authors as author WHERE author.uid = story.uid AND chapter.sid = story.sid AND chapter.chapid ='".$_GET['chapid']."' LIMIT 1");
list($validated, $catid, $sid, $title, $summary, $authoruid, $author, $inorder) = dbassoc($storyquery);
if($admincats == "0" || sizeof(array_intersect(explode(",", $catid), explode(",", $admincats)))) {
include("includes/emailer.php");
if($validated != "1") {
dbquery("UPDATE ".TABLEPREFIX. "fanfiction_stories SET validated = '1', updated = '".time()."' WHERE sid = '".$_GET['sid']."'");
$categories = explode(",", $catid);
include("functions.php");
foreach($categories as $cat) {
categoryitems($cat, 1);
}
if($alertson) {
$subject = _NEWSTORYAT;
$mailtext = sprintf(_AUTHORALERTNOTE, $title, $author, $summary, $sid);
$favorites = dbquery("SELECT author.uid, email, penname FROM ".TABLEPREFIX."fanfiction_favauth as fav, ".TABLEPREFIX."fanfiction_authors as author WHERE fav.favuid = $authoruid AND fav.uid = author.uid");
while($favuser = dbassoc($favorites)) {
sendemail($favuser['penname'], $favuser['email'], $sitename, $siteemail, $subject, $mailtext, "html");
}
}
}
else if($alertson) {
$subject = _STORYALERT;
$mailtext = sprintf(_STORYALERTNOTE, $title, $author, $sid, $inorder);
$favorites = dbquery("SELECT author.uid, penname, email FROM ".TABLEPREFIX."fanfiction_favstor as fav, ".TABLEPREFIX."fanfiction_authors as author WHERE sid = '$sid' AND fav.uid = author.uid");
while($favuser = dbassoc($favorites)) {
sendemail($favuser['penname'], $favuser['email'], $sitename, $siteemail, $subject, $mailtext, "html");
}
}
dbquery("UPDATE ".TABLEPREFIX."fanfiction_chapters SET validated = '1' WHERE chapid = '".$_GET['chapid']."'");
dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET updated = '" . time() . "' WHERE sid = '$sid'");
$output .= ""._STORYVALIDATED."";
}
else
$output .= "
"._NOTAUTHORIZEDADMIN." "._TRYAGAIN."
";
}
else {
$result = dbquery("SELECT story.title as storytitle, story.sid, story.catid, story.rid, story.gid, story.charid, story.wid, story.summary as storysummary, chapter.chapid, chapter.title, chapter.storytext, author.penname, chapter.uid as uid FROM ".TABLEPREFIX."fanfiction_authors as author, ".TABLEPREFIX."fanfiction_stories as story, ".TABLEPREFIX."fanfiction_chapters as chapter WHERE chapter.chapid = '".$_GET['chapid']."' AND chapter.sid = story.sid AND chapter.uid = author.uid");
$story = dbassoc($result);
$output .= ""._AUTHOR.": ".$story['penname']."
";
$output .= ""._TITLE.": ".$story['storytitle'].": ".$story['title'];
$output .= "
";
$result3 = dbquery("SELECT catid, category FROM ".TABLEPREFIX."fanfiction_categories WHERE FIND_IN_SET(catid, '".$story['catid']."')");
$catstring = "";
$count = 0;
while($cats = dbassoc($result3)) {
if($count > 0) $catstring .= ", ";
$catstring .= "".$cats['category']."";
$categories[] = $cats['catid'];
$count++;
}
$output .= ""._CATEGORY.": $catstring
";
$output .= ""._GENRES.": ".(isset($story['gid']) ? preg_replace("/,/", ", ", $story['gid']) : _NONE);
$output .= "
";
$output .= ""._RATING.": ".$story['rid']."
";
if($story['wid'] != "")
{
$output .= ""._WARNINGS.": ".(isset($story['wid']) ? preg_replace("/,/", ", ", $story['wid']) : _NONE);
$output .= "
";
}
$output .= ""._CHARACTERS.": ".$story['charid'];
$output .= "
";
$output .= ""._SUMMARY.": ".$story['storysummary']."
";
$output .= ""._VALIDATE." | "._EDIT." - "._STORY." | "._DELETE." - "._STORY." | "._YESLETTER." | "._NOLETTER."
";
if($store == "files")
{
$file = "$storiespath/".$story['uid']."/".$story['chapid'].".txt";
$log_file = fopen($file, "r");
$file_contents = fread($log_file, filesize($file));
$storytext .= $file_contents;
fclose($log_file);
}
else if($store == "mysql")
{
$storytext .= $story['storytext'];
}
if(strpos($story, "
") === false && strpos($story, "") === false && strpos($story, "
") === false) $storytext = nl2br($storytext);
$storytext = format_story($storytext, $allowed_tags);
$output .= $storytext;
$output .= "
";
$output .= ""._VALIDATE." | "._EDIT." - "._CHAPTER." | "._DELETE." - "._CHAPTER." | "._YESLETTER." | "._NOLETTER."
";
}
return $output;
}
// end validate
function yesletter( ) {
global $tableprefix, $level, $adminemail, $sitename, $siteemail, $allowed_tags;
if($_POST['submit']) {
if($adminemail)
$ademail = $adminemail;
else
$ademail = $siteemail;
$subject = stripinput($_POST['subject']);
$letter = nl2br(stripinput($_POST['letter']));
include("includes/emailer.php");
$result = sendemail($_POST['email'], $_POST['email'], $adminname, $ademail, $subject, $letter, "html");
if($result) echo "
"._EMAILSENT."
";
else echo ""._ERROR."
";
}
else {
$authorquery = dbquery("SELECT email,penname FROM ".TABLEPREFIX."fanfiction_authors WHERE uid = '".$_GET['uid']."' LIMIT 1");
$author = dbassoc($authorquery);
$storyquery = dbquery("SELECT story.title, chapter.title as chapter FROM ".TABLEPREFIX."fanfiction_stories as story, ".TABLEPREFIX."fanfiction_chapters as chapter WHERE chapter.chapid = '".$_GET['chapid']."' AND chapter.sid = story.sid LIMIT 1");
$story = dbassoc($storyquery);
$letter = file_get_contents("messages/thankyou.txt");
echo "";
echo "| Story: | ".$story['title'].": ".$story['chapter']." |
";
echo "| "._BY.": | ".$author['penname']." |
";
echo "