Invalid characterset or character set not supported Ratings improved(?)





Ratings improved(?)
December 18, 2007

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...

Feedback
woodhouse woodhouse - December 18, 2007 (06:17 AM)
The Average User Rating always displays 10 stars now?

Ex. 1

Ex. 2
woodhouse woodhouse - December 18, 2007 (09:45 AM)
The list of Best Reviewed games doesn't seem to be working properly either.
honestgamer honestgamer - December 18, 2007 (12:23 PM)
Thanks for pointing those things out, Woodhouse. They've been fixed.

eXTReMe Tracker
© 1998-2024 HonestGamers
None of the material contained within this site may be reproduced in any conceivable fashion without permission from the author(s) of said material. This site is not sponsored or endorsed by Nintendo, Sega, Sony, Microsoft, or any other such party. Opinions expressed on this site do not necessarily represent the opinion of site staff or sponsors.