Stats board tryout

ledfist · Post by **ledfist** » Mon Jan 17, 2011 11:44 pm

Archangelus wrote:QUOTE (Archangelus @ Jan 16 2011, 09:44 PM) I cant see the top 10 on fwifo´s page, its only me or it isnt working at all?

Same,
Forbidden

You don't have permission to access /cgi-bin/monthlytop10.pl on this server.

Archangelus · Post by **Archangelus** » Tue Jan 18, 2011 12:02 am

Ty fwiffo, any idea at when it will be restored?

fwiffo · Post by **fwiffo** » Tue Jan 18, 2011 9:36 am

yea, trying to finish it sometime this week. ill make an announcement

fwiffo · Post by **fwiffo** » Fri Jan 21, 2011 12:26 am

ok i guess im pretty much finished with the new updated monthly top10 script. i simplified it a ton and now (surprise!) runs much faster. i also cut away a bunch of old code that did some tricks that im sure nobody will miss.

typical run times should be under 2 seconds. now all i need to do is upload the script over to the server and fix the permissions on the link to allow public use.

i'll put up a real post when i get to do that tonight.

thx to all who kept bugging me to finish this... believe it or not, it worked

ps.

my next project involves something related to achievements... your ideas and suggestions are welcome. as usual, nothing pretty, nothing fancy... just stats... and perhaps ending up with some autogenerated graphic that one might use as a sig... maybe. but i think i'll have to require registration for that so i dont have to go generating a bunch and only have 1 or 2 used... plus how am i suppose to know which achievement you want to display?... think sc2... i guess ill model after that.

JohnBarman · Post by **JohnBarman** » Mon Jan 24, 2011 8:50 pm

Added the TOP 10 stats to my view too. And modified the original post plus the link to point to a correct place.

Br,
JohnBarman

fwiffo · Post by **fwiffo** » Mon Jan 24, 2011 9:21 pm

cool stuff, i love the option to select a callsign so even if you dont make the top 10, you can see where you're at.

i used to allow displaying everyone ranked but now i just restrict to only top 10 cuz it just took too long to calculate. maybe im just using some very inefficient sql query...

JohnBarman · Post by **JohnBarman** » Mon Jan 24, 2011 10:09 pm

fwiffo wrote:QUOTE (fwiffo @ Jan 24 2011, 11:21 PM) cool stuff, i love the option to select a callsign so even if you dont make the top 10, you can see where you're at.

i used to allow displaying everyone ranked but now i just restrict to only top 10 cuz it just took too long to calculate. maybe im just using some very inefficient sql query...

In my solution the top stats are sort of pre calculated on a separate table after each data load to callsigns that have played during the daily cycle. From that I am then summing up the different TOP's plus the possible selected Callsign which is bit faster. Let's see when more data gets piled up

.

From that it is possible to get weekly TOP's too. It needs bit of tweaking still but you can check that one too from this.
Weekly TOP