Adventure Game Studio

Community => General Discussion => Topic started by: SSH on Tue 13/06/2006 11:00:46

Title: AGS Games ratings table
Post by: SSH on Tue 13/06/2006 11:00:46
Since CJ doesn't want to do this, by the magic of curl...

The AGS Games, by rating (http://ssh.me.uk/ranking.htm). 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...
Title: Re: AGS Games ratings table
Post by: Radiant on Tue 13/06/2006 11:56:29
That's pretty neat.

Please tell me what you think of the ideas in this thread (http://www.adventuregamestudio.co.uk/yabb/index.php?topic=26656)?
Title: Re: AGS Games ratings table
Post by: on Tue 13/06/2006 15:02:59
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??
Title: Re: AGS Games ratings table
Post by: SSH on Tue 13/06/2006 15:29:33
Nah, I had a PHP script use cURL (http://us3.php.net/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...
Title: Re: AGS Games ratings table
Post by: Kweepa on Tue 13/06/2006 16:15:05
Very nice.
It would be much more useful if the name was a hyperlink to the game's page. :=
Title: Re: AGS Games ratings table
Post by: lo_res_man on Tue 13/06/2006 17:17:46
Good grief! There is 5 whole games considered worse then "An Instagame: Luke's Existential Nightmare" they must be VERY bad.
Title: Re: AGS Games ratings table
Post by: SSH on Tue 13/06/2006 17:28:38
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...
Title: Re: AGS Games ratings table
Post by: Pumaman on Tue 13/06/2006 18:55:58
Hehe, very clever :P

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.
Title: Re: AGS Games ratings table
Post by: Andail on Tue 13/06/2006 19:26:21
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.
Title: Re: AGS Games ratings table
Post by: Vel on Tue 13/06/2006 19:43:43
Obviously the algorithm used by progarchives.com is 1337-est!

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