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 : "\""._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 : _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 : "\""._FSTORY."\"")); $tpl->assign("featuredtext", _FSTORY); if(isADMIN && uLEVEL < 4) $adminlinks .= " ["._FEATURED.": "._RETIRE." | "._REMOVE."]"; } else if($stories['featured'] == 2) { $tpl->assign("featuredstory", (isset($retired) ? $retired : "\""._PFSTORY."\"")); $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", "
"._ADMINOPTIONS.": ".$adminlinks."
"); else if(isMEMBER && (USERUID == $stories['uid'] || array_key_exists(USERUID, $stories['coauthors']))) $tpl->assign("adminlinks", "
"._OPTIONS.": ".$adminlinks."
"); $count++; ?>