0) {
$query = dbquery("SELECT "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE." WHERE "._UIDFIELD." = '$uid' LIMIT 1");
list($penname) = dbrow($query);
$output = "".stripslashes($penname)."
\n";
$squery = "SELECT stories.*, "._PENNAMEFIELD." as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(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 $squery AND (stories.uid = '$uid' OR coauth.uid = '$uid') "._ORDERBY;
$cquery = "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 $countquery AND (stories.uid = '$uid' OR coauth.uid = '$uid')";
$numrows = search($squery, $cquery, "browse.php?");
}
else {
$output .= ""._AUTHORS.($let ? " - $let" : "")."
".build_alphalinks("browse.php?$terms&", $let);
if($let == _OTHER) $query = " "._PENNAMEFIELD." REGEXP '^[^a-z]'";
else if($let) $query = " "._PENNAMEFIELD." LIKE '$let%'";
else $query = "";
$authorquery = "SELECT "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid, ap.stories FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs AS ap ON "._UIDFIELD." = ap.uid WHERE ap.stories > 0 ".($query ? " AND $query" : "");
$countquery = "SELECT count(ap.uid) FROM ".TABLEPREFIX."fanfiction_authorprefs AS ap LEFT JOIN "._AUTHORTABLE." ON "._UIDFIELD." = ap.uid ".($query ? " AND $query" : "");
$uid = 0;
$count = dbquery($countquery);
list($numrows)= dbrow($count);
$limit = $itemsperpage * $displaycolumns;
$total = ($numrows > $limit ? $limit : $numrows);
$list = floor($total / $displaycolumns);
if($total % $displaycolumns != 0) $list++;
$colwidth = (100/ $displaycolumns) -1;
$count = 0;
$column = 1;
$result2 = dbquery($authorquery." ORDER BY "._PENNAMEFIELD." LIMIT $offset,$limit");
$output .= "".($displaycolumns ? "
" : "");
while($auth = dbassoc($result2)) {
$count++;
$output .= "
".stripslashes($auth['penname'])." [".$auth['stories']."]
";
if( $count >= $list && $column != $displaycolumns) {
$output .= "
";
if($total % $displaycolumns == $column) $list--;
$column++;
$count = 0;
}
}
$output .= "
".($displaycolumns ? "
" : "")."