";
$tpl->assign("sort", $sort);
$countquery = dbquery("SELECT count(stories.sid) FROM ".TABLEPREFIX."fanfiction_stories as stories LEFT JOIN ".TABLEPREFIX."fanfiction_coauthors as coauth ON stories.sid = coauth.sid WHERE validated > 0 AND (stories.uid = '$uid' OR coauth.uid = '$uid')");
list($numstories) = dbrow($countquery);
if($numstories) {
$count = 0;
$tpl->newBlock("listings");
$tpl->assign("stories", "");
$storyquery = dbquery("SELECT stories.*, "._PENNAMEFIELD." as penname, stories.date as date, stories.updated as updated FROM ("._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_stories as stories) LEFT JOIN ".TABLEPREFIX."fanfiction_coauthors as coauth ON coauth.sid = stories.sid WHERE "._UIDFIELD." = stories.uid AND stories.validated > 0 AND (stories.uid = '$uid' OR coauth.uid = '$uid') GROUP BY stories.sid "._ORDERBY." LIMIT $offset, $itemsperpage");
while($stories = dbassoc($storyquery)) {
$tpl->newBlock("storyblock");
include("includes/storyblock.php");
}
$tpl->gotoBlock("listings");
if($numstories > $itemsperpage) $tpl->assign("pagelinks", build_pagelinks("viewuser.php?action=storiesby&uid=$uid".(isset($_GET['sort']) ? ($_GET['sort'] == "alpha" ? "&sort=alpha" : "&sort=update") : "")."&", $numstories, $offset));
$tpl->gotoBlock("_ROOT");
}
else $output .= write_message(_NORESULTS);
?>