Gom Jabbar pointed out some bugs with the Author Listing on MPQ Archive. The listing is meant to show the author name along with the average score for all their reviewed maps but it was incorrectly working the score out and also counting maps when it shouldn’t have been. Turns out the problem was due to me including unreviewed maps in the count (Gom has a map on the “pending” list). Oops.

A slight tweak to the SQL sorted that one out. The side affect of which was it also removed authors from the list who had not yet (ha!) had their maps reviewed, which I think is the correct thing to do anyway.

So thanks Gom for spotting it.

By Paul

One thought on “MPQ Archive tweaks”

Leave a Reply

Your email address will not be published. Required fields are marked *