AGS Games ratings table

[SSH]

Since CJ doesn't want to do this, by the magic of curl...

The AGS Games, by rating. However, its not updated so this is the ratings as of yesterday. Also, as you will recall, CJ has now made that only forum members can vote as some games had been artifically pumped up the rankings. I think you can plainly see which ones...

[Radiant]

That's pretty neat.

Please tell me what you think of the ideas in this thread?

[m0ds]

Nice work SSH, looks pretty good and works brilliantly!

So is Novi really the number one AGS game?

Also - does it update automatically, or did you sit and enter all those figures??

[SSH]

Nah, I had a PHP script use cURL to collect the info, parse it and write to a CSV file which I read into Excel then found a javascript on the web that would let you click on column headings to sort by them. but the PHP takes ages to run, so I'm not going to have it dynamically update: I'll just run it when I feel like it...

[Kweepa]

Very nice.
It would be much more useful if the name was a hyperlink to the game's page.

[lo_res_man]

Good grief! There is 5 whole games considered worse then "An Instagame: Luke's Existential Nightmare" they must be VERY bad.

[SSH]

Due to the previous ease of cheating ratings, please don't take any position in the table as definitive. Also, people vote silly anyway, even without cheating: For example: the FOY rolling demo rates ABOVE the proper demo! D'oh!

And Steve, I'll do that for the next version but unfortunately I forgot to write that info out while collecting and I'm not going to run it again just yet...

[Pumaman]

Hehe, very clever

Actually, I guess now that voting is restricted to registered users only, it would probably be acceptable to introduce a sort-by-rating system. The reason I was really against it in the past is people could well start using the list to try and jack up or jack down the ratings for games. Now that's much harder to do, it probably wouldn't be so bad.

[Andail]

There is still an issue regarding how the number of votes should be accounted for. A game with one 100% vote should hardly be higher ranked than a game with an average percentage of 85, but with 10000 votes.

[Vel]

Obviously the algorithm used by progarchives.com is 1337-est!

ORDER BY power(avg_ratings, 3)*log((n_ratings+3)*2) DESC