The Jarl's List: The Leadboard Tool You've Been Waiting For!
#21
Posted 07 September 2017 - 02:10 AM
#22
Posted 07 September 2017 - 05:21 AM
Fox With A Shotgun, on 07 September 2017 - 01:54 AM, said:
Lights-mediums-heavies-assaults. 98 + 1 + 0 + 2 = 101%. Dat rounding.
Yes. This is because of a rounding error.
CONCAT(ROUND(SUM(`lightgames`)/SUM(`Games Played`) * 100),'%') as `Light Percentage`, CONCAT(ROUND(SUM(`mediumgames`)/SUM(`Games Played`) * 100),'%') as `Medium Percentage`, CONCAT(ROUND(SUM(`heavygames`)/SUM(`Games Played`) * 100),'%') as `Heavy Percentage`, CONCAT(ROUND(SUM(`assaultgames`)/SUM(`Games Played`) * 100),'%') as `Assault Percentage`
#23
Posted 07 September 2017 - 04:45 PM
Thx
#24
Posted 07 September 2017 - 04:55 PM
#25
Posted 07 September 2017 - 08:31 PM
#26
Posted 07 September 2017 - 09:01 PM
SFC174, on 07 September 2017 - 04:45 PM, said:
Thx
It is updated automatically each season (monthly). I have it automatically output the date the database was last modified near the bottom.
I've been going through and cleaning up issues I have found so you might see the date sometimes update but full stats wont be pulled till the first.
Edited by Scurro, 07 September 2017 - 09:01 PM.
#27
Posted 08 September 2017 - 02:50 PM
#28
Posted 08 September 2017 - 07:29 PM
#29
Posted 08 September 2017 - 07:34 PM
Thanks for reaffirming how bad I am!
#30
Posted 08 September 2017 - 08:57 PM
SustainedEyeContact comes in at number 30 on page 1, but comes in number 32 on page2.
When searched for, he is number 32. So who is really number 30 or 31?
#31
Posted 08 September 2017 - 09:30 PM
Christof Romulus, on 08 September 2017 - 08:57 PM, said:
SustainedEyeContact comes in at number 30 on page 1, but comes in number 32 on page2.
When searched for, he is number 32. So who is really number 30 or 31?
This is because there are multiple players tied at that score. I will need to set a second condition for rank at tied players.
#32
Posted 08 September 2017 - 09:58 PM
> 1005 deaths
> K/D = 1.00
:v
#36
Posted 08 September 2017 - 10:16 PM
Yeonne Greene, on 08 September 2017 - 10:07 PM, said:
Must be a recent math, since it wasn't like that yesterday.
It's fixable... at least it won't take 60 to 90 days to fix (unlike some of the fail stat tracking that goes on with "0" games using a weapon "more than 0" times).
Edited by Deathlike, 08 September 2017 - 10:16 PM.
#37
Posted 08 September 2017 - 10:28 PM
I've been busy working on optimizing the database and adding new features that sometimes basic stuff slips by.
I've also fixed the sorting to now use average score as the second order for rank placement if there is a tie.
Thanks for letting me know if you find any issues.
#38
Posted 09 September 2017 - 02:01 AM
#39
Posted 09 September 2017 - 04:56 AM
Mighty Wings, on 09 September 2017 - 02:01 AM, said:
Yeah... but he's long gone now. His pyre burns and his memory fades; yet his fame remains.
But today, in the dismal now, we only have sage Scuro to light the way in the dark chaotic abyss with only his math and code to guide us.
#40
Posted 09 September 2017 - 06:33 AM
5 user(s) are reading this topic
0 members, 5 guests, 0 anonymous users