|
1
|
1
|
new file mode 100644
|
|
...
|
...
|
@@ -0,0 +1,11 @@
|
|
|
1
|
+<?php
|
|
|
2
|
+if(!defined("_CHARSET")) exit( );
|
|
|
3
|
+list($field_id, $field_title) = dbrow(dbquery("SELECT field_id, field_title FROM ".TABLEPREFIX."fanfiction_authorfields WHERE field_name = 'betareader'"));
|
|
|
4
|
+$listOpts .= "<option value=\"authors.php?".($let ? "let=$let&" : "")."list=beta\"".($list == "beta" ? " selected" : "").">$field_title</option>";
|
|
|
5
|
+if($list == "beta") {
|
|
|
6
|
+ $countquery = "SELECT COUNT(DISTINCT ai.uid) FROM ".TABLEPREFIX."fanfiction_authorinfo as ai, "._AUTHORTABLE." WHERE ai.field = '$field_id' AND ai.info = '"._YES."' AND "._UIDFIELD." = ai.uid".(isset($letter) ? " AND $letter" : "");
|
|
|
7
|
+ $authorquery = "SELECT ap.stories as stories, "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid FROM ".TABLEPREFIX."fanfiction_authorinfo as ai, "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs AS ap ON "._UIDFIELD." = ap.uid WHERE ai.field = '$field_id' AND ai.info = '"._YES."' AND "._UIDFIELD." = ai.uid ".(isset($letter) ? " AND $letter" : "")." GROUP BY "._UIDFIELD;
|
|
|
8
|
+ $pagetitle .= $field_title;
|
|
|
9
|
+}
|
|
|
10
|
+
|
|
|
11
|
+?>
|
|
0
|
12
|
\ No newline at end of file
|