Game Ratings

Posted by Ferret on April 7, 2011, 2:28 a.m.

Hey, editing on the game pages works now and it won't submit zero ratings.

The real work is that I'm going to need help from you guys to do is to look out for any previous games that are still affected by that bug. If you find any games with incorrect ratings please notify either me or another admin/mod/person with db access to fix this.

I'll do my best to look through recent games, but that doesn't mean I won't miss some or that some older games got affected.

Edit: All recent games fixed. Please keep an eye out for older games.

Comments

Rusky 13 years, 7 months ago

awesome!

Castypher 13 years, 7 months ago

Thank you Ferret. I love you.

Rez 13 years, 7 months ago

yay

Glen 13 years, 7 months ago

Some older games don't have files and yet their listings still exist and appear on people's "favorite games". Ancient Ants for example. http://64digits.com/games/4815/ancient_ants.rar file doesn't exist, but there's still a page for it.

PY 13 years, 7 months ago

Couldn't you just do a database query for all 0 ratings? Or failing that, just remove all 0 ratings immediately before you generate the average?

Of course, 64d being 64d, it probably does something stupid like not store the ratings but recompute the average every rate.

Ferret 13 years, 7 months ago

@Glen, that may be one of those games that got lost in the server transition, if that user ever comes back and wants to resend the files we can replace it for him.

@PY, You'd be correct, game's only hold number of ratings, total ratings, and the final rating. Though it is possible to search through the game comments which do in fact hold a rating, I'm probably going to use that to make a loop that searches for zeros and correct the game it's posted on.