I orginally had this posted in the New Feature Suggestions board, but I think it fits better in the Mod forum, since I saw others asking for things here related to the Top 10 Lists.
I was just wondering if there was some way to have a Top 10 List of the authors who have the most total reviews and the # of their reviews from all their stories total.
Is there a way to include this on the Top 10s?
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
Try duplicating and editing this code:
case "prolificreviewers":
$result = dbquery("SELECT count(reviews.uid) AS count, "._PENNAMEFIELD." as penname , "._UIDFIELD." as uid FROM ".TABLEPREFIX."fanfiction_reviews as reviews, "._AUTHORTABLE." WHERE reviews.uid = "._UIDFIELD." AND reviews.review != 'No Review' GROUP BY reviews.uid ORDER BY count DESC LIMIT 10");
if(dbnumrows($result) == 0) $output .= write_message(_NORESULTS);
$count = 1;
while($author = dbassoc($result)) {
$output .= "$count. <a href=""viewuser.php?uid=".$author['uid'"]."">".$author['penname']."</a> [".$author['count']."]<br /> ";
$count++;
}
break;
archive:
site:
Available for skin/mod commission! 🙂
Not to sound completely stupid (even though with efiction I basically am) but do I add and edit this into the mySQL database? And then I create a new panel in the 10 lists, right?
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
Ah, no, I apologise!
I forgot to mention where that's from ...
toplists/default.php
Near the bottom. 🙂
archive:
site:
Available for skin/mod commission! 🙂
I tried to duplicate that section and just change reviews to authors but I have NO clue what to change and what to change it to in order to get it working correctly.
Thanks for the suggestion...I think it's just a bit too advanced for me to figure out! 😛
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
You'd need a much more complicated query because reviews are saved by the item not the author of the item.
OK...So does that mean that I should just forget about it?
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
I think I would. To pull it from the database would be a resource intensive query. You'd probably have to save it in a table of it's own and update it each time a review was added.
