Jump to content

The Jarl's List: The Leadboard Tool You've Been Waiting For!


349 replies to this topic

#21 chucklesMuch

    Member

  • PipPipPipPipPipPipPipPip
  • Shredder
  • Shredder
  • 1,424 posts
  • Google+: Link
  • LocationNew Zealand

Posted 07 September 2017 - 02:10 AM

There is a certain irony about the name of the 139790th ranked player (page 4660), they have only played 10 games though and maybe they are... or will be.

#22 Scurro

    Member

  • PipPipPipPipPip
  • Elite Founder
  • Elite Founder
  • 143 posts

Posted 07 September 2017 - 05:21 AM

View PostFox With A Shotgun, on 07 September 2017 - 01:54 AM, said:

98% 1% 0% 2%
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 SFC174

    Member

  • PipPipPipPipPipPipPip
  • The Pharaoh
  • The Pharaoh
  • 695 posts

Posted 07 September 2017 - 04:45 PM

Just curious, how often does the database scrape new info? Haven't noticed any changes since I first looked so I figure its daily at most?

Thx

#24 Nightbird

    Member

  • PipPipPipPipPipPipPipPipPipPip
  • The God of Death
  • The God of Death
  • 7,518 posts

Posted 07 September 2017 - 04:55 PM

You forgot the formula Jarl's rank=actual rank - 4000 :D

#25 Lightfoot

    Member

  • PipPipPipPipPipPipPipPipPipPip
  • Bad Company
  • Bad Company
  • 6,612 posts
  • LocationOlympus Mons

Posted 07 September 2017 - 08:31 PM

Hilarious. I rank about 77% in most criteria, but in not getting killed I am in the top 2%. I never check my stats, mostly.

#26 Scurro

    Member

  • PipPipPipPipPip
  • Elite Founder
  • Elite Founder
  • 143 posts

Posted 07 September 2017 - 09:01 PM

View PostSFC174, on 07 September 2017 - 04:45 PM, said:

Just curious, how often does the database scrape new info? Haven't noticed any changes since I first looked so I figure its daily at most?

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 Jarl Dane

    Member

  • PipPipPipPipPipPipPipPip
  • Point Commander
  • Point Commander
  • 1,803 posts
  • Twitter: Link
  • LocationJarnFolk Cluster

Posted 08 September 2017 - 02:50 PM

The website is constantly being updated and if anyone has any suggestions or finds any bugs.. please share them with us =)

#28 Scurro

    Member

  • PipPipPipPipPip
  • Elite Founder
  • Elite Founder
  • 143 posts

Posted 08 September 2017 - 07:29 PM

Sorry about the dowtime. I was fixing some errors I found in the database. I've since fixed the problems and updated the site to allow sorting for main leaderboard now. :)

#29 Deathlike

    Member

  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • Littlest Helper
  • Littlest Helper
  • 29,240 posts
  • Location#NOToTaterBalance #BadBalanceOverlordIsBad

Posted 08 September 2017 - 07:34 PM

Self-scrub, confirmed!

Thanks for reaffirming how bad I am! :D :D :D

#30 Christof Romulus

    Member

  • PipPipPipPipPipPipPip
  • Legendary Founder
  • Legendary Founder
  • 898 posts
  • LocationAS7-D(F), GRF-1N(P)

Posted 08 September 2017 - 08:57 PM

Something's up with that leaderboard:

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 Scurro

    Member

  • PipPipPipPipPip
  • Elite Founder
  • Elite Founder
  • 143 posts

Posted 08 September 2017 - 09:30 PM

View PostChristof Romulus, on 08 September 2017 - 08:57 PM, said:

Something's up with that leaderboard:

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 Y E O N N E

    Member

  • PipPipPipPipPipPipPipPipPipPipPipPip
  • The Nimble
  • The Nimble
  • 16,810 posts

Posted 08 September 2017 - 09:58 PM

> 2203 kills
> 1005 deaths
> K/D = 1.00

:v

#33 Deathlike

    Member

  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • Littlest Helper
  • Littlest Helper
  • 29,240 posts
  • Location#NOToTaterBalance #BadBalanceOverlordIsBad

Posted 08 September 2017 - 09:59 PM

View PostYeonne Greene, on 08 September 2017 - 09:58 PM, said:

> 2203 kills
> 1005 deaths
> K/D = 1.00

:v


All the K-Ds are 1.00.

Cause, "math".

Edited by Deathlike, 08 September 2017 - 10:00 PM.


#34 Y E O N N E

    Member

  • PipPipPipPipPipPipPipPipPipPipPipPip
  • The Nimble
  • The Nimble
  • 16,810 posts

Posted 08 September 2017 - 10:07 PM

View PostDeathlike, on 08 September 2017 - 09:59 PM, said:


All the K-Ds are 1.00.

Cause, "math".


Must be a recent math, since it wasn't like that yesterday.

#35 Scurro

    Member

  • PipPipPipPipPip
  • Elite Founder
  • Elite Founder
  • 143 posts

Posted 08 September 2017 - 10:15 PM

View PostYeonne Greene, on 08 September 2017 - 10:07 PM, said:


Must be a recent math, since it wasn't like that yesterday.



Yup working on the fix. Typo :3

#36 Deathlike

    Member

  • PipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • Littlest Helper
  • Littlest Helper
  • 29,240 posts
  • Location#NOToTaterBalance #BadBalanceOverlordIsBad

Posted 08 September 2017 - 10:16 PM

View PostYeonne 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 Scurro

    Member

  • PipPipPipPipPip
  • Elite Founder
  • Elite Founder
  • 143 posts

Posted 08 September 2017 - 10:28 PM

It's fixed now.

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 Mighty Wings

    Member

  • PipPip
  • 44 posts

Posted 09 September 2017 - 02:01 AM

This is pretty cool, next step, bring back mechstats ..didn't another Isen guy make that also? You stat ****** :)

#39 Jarl Dane

    Member

  • PipPipPipPipPipPipPipPip
  • Point Commander
  • Point Commander
  • 1,803 posts
  • Twitter: Link
  • LocationJarnFolk Cluster

Posted 09 September 2017 - 04:56 AM

View PostMighty Wings, on 09 September 2017 - 02:01 AM, said:

This is pretty cool, next step, bring back mechstats ..didn't another Isen guy make that also? You stat ****** Posted Image


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 Khereg

    Member

  • PipPipPipPipPipPipPip
  • Knight Errant
  • Knight Errant
  • 919 posts
  • LocationDenver, CO

Posted 09 September 2017 - 06:33 AM

That feeling when your alt is waaay higher up the list than your main.





12 user(s) are reading this topic

0 members, 12 guests, 0 anonymous users