I noticed some funny business going on with the ratings system, in that the rank associated with games was not displaying properly. I found out that this was because the INT field in the database didn't want to accept decimals (the most common number in that system), and therefore the rankings were all skewed (since they're generated on the fly).
Anyway, I've done some coding behind the scenes and now games should rank properly. As far as I can tell, only games with five or more ratings are ranked (which was my goal). If you visit a profile for a game without enough ratings to qualify, you'll see "N/A" in place of a ranking.
Games that have received the same precise ranking score are then organized according to number of total ratings.
This may all be very boring to some of you, but it does give additional value to the rating system throughout the site and hopefully will have positive long-term effects. Remember that the "While you're here..." box does factor in a game's ranking when displaying a related game, so your efforts to rate all your favorite games could very well help a casual site visitor to find a hidden gem he never knew about!
Anyway, I think now I'll get some sleep. Coding this change took WAY longer than it should have...
|Most recent blog posts from Jason Venter...|
|woodhouse - December 18, 2007 (06:17 AM)
The Average User Rating always displays 10 stars now?
|woodhouse - December 18, 2007 (09:45 AM)
The list of Best Reviewed games doesn't seem to be working properly either.
|honestgamer - December 18, 2007 (12:23 PM)
Thanks for pointing those things out, Woodhouse. They've been fixed.