349 replies to this topic

[chucklesMuch]

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.

[Scurro]

Fox 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`

[SFC174]

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

[Nightbird]

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

[Lightfoot]

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.

[Scurro]

SFC174, 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.

[Jarl Dane]

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

[Scurro]

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.

[Deathlike]

Self-scrub, confirmed!

Thanks for reaffirming how bad I am!

[Christof Romulus]

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?

[Scurro]

Christof 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.

[Y E O N N E]

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

:v

[Deathlike]

Yeonne 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.

[Y E O N N E]

Deathlike, 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.

[Scurro]

Yeonne 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

[Deathlike]

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.

[Scurro]

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.

[Mighty Wings]

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

[Jarl Dane]

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

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.

[Khereg]

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