assign("sid", $stories['sid']);
unset($challengelinks, $challengeadmin, $serieslinks, $categorylinks, $adminlinks, $authlink);
if($stories['coauthors'] == 1) {
$array_coauthors = array();
$coauth = dbquery("SELECT "._PENNAMEFIELD." as penname, co.uid FROM ".TABLEPREFIX."fanfiction_coauthors AS co LEFT JOIN "._AUTHORTABLE." ON co.uid = "._UIDFIELD." WHERE co.sid = '".$stories['sid']."'");
while($c = dbassoc($coauth)) {
$array_coauthors[$c['uid']] = $c['penname'];
}
$stories['coauthors'] = $array_coauthors;
unset($array_coauthors);
}
else $stories['coauthors'] = array( );
$tpl->assign("title" , stripslashes(title_link($stories)) );
$tpl->assign("author" , author_link($stories));
$tpl->assign("summary", stripslashes($stories['summary']) );
$tpl->assign("rating" , !empty($ratingslist) && !empty($stories['rid'] && key_exists('name', $ratingslist) ) ? $ratingslist[$stories['rid']]['name'] : "");
$tpl->assign("score", ratingpics($stories['rating']) );
$tpl->assign("count", $stories['count'] ? $stories['count'] : "0");
$allclasslist = "";
$adminlinks = "";
$storyclasses = array( );
if($stories['classes'] > 0) {
foreach(explode(",", $stories['classes']) as $c) {
if(array_key_exists($c, $classlist)) {
if(isset($action) && $action == "printable") {
$storyclasses[$classlist["$c"]['type']][] = $classlist[$c]['name'];
}
else {
$storyclasses[$classlist["$c"]['type']][] =
"".$classlist[$c]['name']."";
}
}
}
}
foreach($classtypelist as $num => $c) {
if(isset($storyclasses[$num])) {
$tpl->assign($c['name'], implode(", ", $storyclasses[$num]));
$allclasslist .= "".$c['title'].": ".implode(", ", $storyclasses[$num])."
";
}
else {
$tpl->assign($c['name'], _NONE);
$allclasslist .= "".$c['title'].": "._NONE."
";
}
}
// We only want to pull this list once
if(!isset($storycodeblocks)) {
$storycodeblocks = array( );
$codequery = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_codeblocks WHERE code_type = 'storyblock'");
while($code = dbassoc($codequery)) {
$storycodeblocks[] = $code['code_text'];
}
}
if(count($storycodeblocks)) foreach($storycodeblocks as $c) { eval($c); }
$tpl->assign("classifications", $allclasslist);
$seriesquery = "SELECT series.* FROM ".TABLEPREFIX."fanfiction_inseries as list, ".TABLEPREFIX."fanfiction_series as series WHERE list.sid = '".$stories['sid']."' AND series.seriesid = list.seriesid";
$seriesresult = dbquery($seriesquery) or die(_FATALERROR."
Query: $seriesquery
Error: (". $dbconnect->errno.") ". $dbconnect->error);
$serieslinks = array( );
while($s = dbassoc($seriesresult)) {
if(isset($action) && $action == "printable") $serieslinks[] = stripslashes($s['title']);
else $serieslinks[] = "".stripslashes($s['title'])."";
}
$tpl->assign("serieslinks", (count($serieslinks) > 0 ? implode(", ", $serieslinks) : _NONE));
$tpl->assign("characters", ($stories['charid'] ? charlist($stories['charid']) : _NONE));
$tpl->assign("category", $stories['catid'] == '-1' || !$stories['catid'] ? _ORPHAN : catlist($stories['catid']));
$tpl->assign("completed" , ($stories['completed'] ? _YES : _NO) );
$tpl->assign("roundrobin" , ($stories['rr'] ? (!empty($roundrobin) ? $roundrobin : "
") : "") );
$tpl->assign("ratingpics" , ratingpics($stories['rating']) );
$tpl->assign("reviews" , ($reviewsallowed ? ""._REVIEWS."" : "") );
if(isMEMBER && !empty($favorites))
$tpl->assign("addtofaves", "["._ADDSTORY2FAVES."] ["._ADDAUTHOR2FAVES."]");
$numchapsquery = dbquery("SELECT count(sid) FROM ".TABLEPREFIX."fanfiction_chapters WHERE sid = '".$stories['sid']."' AND validated > 0");
list($chapters) = dbrow($numchapsquery);
$tpl->assign("numchapters", $chapters );
$tpl->assign("updated" , date("$dateformat", $stories['updated']) );
$tpl->assign("published" , date("$dateformat", $stories['date']) );
if(!empty($recentdays)) {
$recent = time( ) - ($recentdays * 24 * 60 *60);
if($stories['updated'] > $recent) $tpl->assign("new", isset($new) ? file_exists(_BASEDIR.$new) ? "" : $new : _NEW);
}
$tpl->assign("wordcount" , $stories['wordcount'] ? $stories['wordcount'] : "0" );
$tpl->assign("numreviews" , ($reviewsallowed == "1" ? "".$stories['reviews']."" : "") );
if((isADMIN && uLEVEL < 4) || USERUID == $stories['uid'] || (is_array($stories['coauthors']) && array_key_exists(USERUID, $stories['coauthors'])))
$adminlinks .= "["._EDIT."] ["._DELETE."]";
global $featured;
if($stories['featured'] == 1) {
$tpl->assign("featuredstory", (isset($featured) ? $featured : "
"));
$tpl->assign("featuredtext", _FSTORY);
if(isADMIN && uLEVEL < 4) $adminlinks .= " ["._FEATURED.": "._RETIRE." | "._REMOVE."]";
}
else if($stories['featured'] == 2) {
$tpl->assign("featuredstory", (isset($retired) ? $retired : "
"));
$tpl->assign("featuredtext", _PFSTORY);
if(isADMIN && uLEVEL < 4) $adminlinks .= " ["._REMOVE."]";
}
else if(isADMIN && uLEVEL < 4) $adminlinks .= " ["._FEATURED."]";
$tpl->assign("toc", ""._TOC."");
$tpl->assign("oddeven", ($count % 2 ? "odd" : "even"));
$tpl->assign("reportthis", "["._REPORTTHIS."]");
if(isADMIN && uLEVEL < 4) $tpl->assign("adminlinks", "