Page 3 of 3
Posted: Mon Jan 17, 2011 11:44 pm
by ledfist
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.
Posted: Tue Jan 18, 2011 12:02 am
by Archangelus
Ty fwiffo, any idea at when it will be restored?
Posted: Tue Jan 18, 2011 9:36 am
by fwiffo
yea, trying to finish it sometime this week. ill make an announcement
Posted: Fri Jan 21, 2011 12:26 am
by fwiffo
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.
Posted: Mon Jan 24, 2011 8:50 pm
by JohnBarman
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
Posted: Mon Jan 24, 2011 9:21 pm
by fwiffo
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...
Posted: Mon Jan 24, 2011 10:09 pm
by JohnBarman
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