"._MANAGEREVIEWS.""; $count = dbquery("SELECT count(s.sid) FROM ".TABLEPREFIX."fanfiction_stories AS s LEFT JOIN ".TABLEPREFIX."fanfiction_coauthors AS c ON s.sid = c.sid WHERE s.uid = '".USERUID."' OR c.uid = '".USERUID."'"); list($numrows)= dbrow($count); $count2 = dbquery("SELECT count(seriesid) FROM ".TABLEPREFIX."fanfiction_series WHERE uid = '".USERUID."'"); list($numrows2)= dbrow($count2); $output .= ""; $x = 0; if($numrows2 > 0) { $query = dbquery("SELECT series.seriesid, series.title, series.reviews, sum(reviews.respond) as respond FROM ".TABLEPREFIX."fanfiction_series as series, ".TABLEPREFIX."fanfiction_reviews as reviews WHERE series.uid = '".USERUID."' AND series.seriesid = reviews.item AND reviews.type = 'SE' GROUP BY reviews.item ORDER BY series.title"); while($story = dbassoc($query)) { if($story['reviews'] > 0) { $output .= ""; $x++; } } } if($x == 0) $output .= ""; $output .= ""; $x = 0; if($numrows > 0) { $query = dbquery("SELECT story.sid, story.title, story.reviews, sum(reviews.respond) as respond FROM ".TABLEPREFIX."fanfiction_stories as story JOIN ".TABLEPREFIX."fanfiction_reviews as reviews ON story.sid = reviews.item AND reviews.type = 'ST' LEFT JOIN ".TABLEPREFIX."fanfiction_coauthors AS c ON c.sid = story.sid WHERE (story.uid = '".USERUID."' OR c.uid = '".USERUID."') GROUP BY reviews.item ORDER BY story.title"); while($story = dbassoc($query)) { if($story['reviews'] > 0) { $output .= ""; $x++; } } } if($x == 0) $output .= ""; // For other items that might receive reviews such as fan art. $code = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_codeblocks WHERE code_type = 'revreceived'"); while($c = dbassoc($code)) { eval($c['code_text']); } $output .= "

"._SERIES."	"._REVIEWS."	"._UNRESPONDED."
".$story['title']."	".$story['reviews']."	".($story['reviews'] - $story['respond'])."
"._NORESULTS."
"._STORIES."	"._REVIEWS."	"._UNRESPONDED."
".$story['title']."	".$story['reviews']."	".($story['reviews'] - $story['respond'])."
"._NORESULTS."

"; ?>