"._SUBMITTED.""; $view = isset($_GET['view']) ? $_GET['view'] : false; $output .= "

"; $result = dbquery("SELECT story.title as storytitle, chapter.uid, chapter.sid, story.catid, chapter.chapid, chapter.inorder, chapter.title, "._PENNAMEFIELD." as penname FROM (".TABLEPREFIX."fanfiction_chapters as chapter, "._AUTHORTABLE.") LEFT JOIN ".TABLEPREFIX."fanfiction_stories as story ON story.sid = chapter.sid WHERE chapter.validated = '0' AND chapter.uid = "._UIDFIELD." ORDER BY story.title"); if(dbnumrows($result)) { $output .= ""; $array = explode(",", $admincats); while ($story = dbassoc($result)) { if(!$admincats || $_GET['view'] == "all" || sizeof(array_intersect(explode(",", $story['catid']), explode(",", $admincats)))) { $output .= ""; $output .= ""; $output .= ""; $output .= ""; } } $output .= "

"._TITLE."	"._AUTHOR."	"._CATEGORY."	"._OPTIONS."
".stripslashes($story['storytitle']).""; if(isset($story['title'])) $output .= " : ".stripslashes($story['title']).""; $output .= "	$story[penname]	".catlist($story['catid'])."	"._VALIDATE." "._DELETE.": "._CHAPTER." "._OR." "._STORY." "._YESLETTER." \| "._NOLETTER."

"; } else $output .= write_message(_NORESULTS); ?>