"; if(isset($_GET['list'])) $list = $_GET['list']; else $list = "members"; if(!$let) { $let = false; $ptitle = ""; } else { $ptitle = " -- $let"; if($let == _OTHER) { $letter = _PENNAMEFIELD." REGEXP '^[^a-z]'"; } else{ $letter = _PENNAMEFIELD." LIKE '$let%'"; } } $listOpts = ""; $countquery = ""; if($list == "authors") { $pagetitle .= _AUTHORS; $authorquery = "SELECT "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid, ap.stories FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON ap.uid = "._UIDFIELD." WHERE ap.stories > 0 ".(isset($letter) ? " AND $letter" : "")." GROUP BY "._UIDFIELD; $countquery = "SELECT count("._UIDFIELD.") FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON "._UIDFIELD." = ap.uid WHERE ap.stories > 0 ".(isset($letter) ? " AND $letter" : ""); } else if($list == "admins") { $pagetitle .= _SITEADMINS; $countquery = _MEMBERCOUNT." WHERE ap.level > 0 AND ap.level < 4".(isset($letter) ? " AND $letter" : ""); $authorquery = _MEMBERLIST." WHERE ap.level > 0 AND ap.level < 4".(isset($letter) ? " AND $letter" : "")." GROUP BY "._UIDFIELD; } $codequery = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_codeblocks WHERE code_type = 'membersList'"); while($code = dbassoc($codequery)) { eval($code['code_text']); } if(empty($countquery)) { $pagetitle .= _MEMBERS; $countquery = _MEMBERCOUNT.(isset($letter) ? " WHERE $letter" : ""); $authorquery = _MEMBERLIST.(isset($letter) ? " WHERE $letter" : "")." GROUP BY "._UIDFIELD; } $output .= $pagetitle.$ptitle; $output .= "

"; $output .= ""._ALLMEMBERS." "._AUTHORS." "._SITEADMINS."$listOpts

"; $pagelink="authors.php?list=".($list ? $list : "members")."&".($let ? "let=$let&" : ""); include("includes/members_list.php"); $tpl->assign( "output", $output ); $tpl->printToScreen(); dbclose( ); ?>