Project CALC - car/track leaderboards for consoles

[cpcdem]

Totally understand, yeah, something like that would be interesting. I'll see what I can do

Oh c**p, I am a computer programmer, when users ask me for something I know I will not do, I always reply with "I'll see what I can do"! Payback time I guess

[Maskmagog]

Oh c**p, I am a computer programmer, when users ask me for something I know I will not do, I always reply with "I'll see what I can do"! Payback time I guess

Haha! I meant more like "I'll try to figure out what results I would want, then google how to do it, and then try to find some time to actually do it"

[cpcdem]

Haha! I meant more like "I'll try to figure out what results I would want, then google how to do it, and then try to find some time to actually do it"

OK, this sounds better

[Maskmagog]

Ok @cpcdem, have a look at https://projectcalc.org/stats.php

Been working on a WR ranking per your idea. Interesting to compare drivers. For example, Jack Scagnetti has "only" 14 WR, but is placed 11 on the Ranking board, with an average of over 915 drivers on his WR leaderboards. Whereas for example evolist, with 385 WR, has an average of 2 drivers per WR leaderboard.
Great idea, interesting data.

You can click on a header in the WR Ranking table to sort by that column.

Disclaimer: It's mostly correct I think, but sometimes the ranking points aren't 100% correct. My guess is that all laps by a player is counted if that player has multiple laps in the db for a combo.
This is the sql, if anyone has a solution:

SELECT *, COUNT(*) AS wrrows, SUM(totalrows2) AS totalrows3 FROM (
SELECT t1.*, t2.totalrows AS totalrows2 FROM laptimes t1 
JOIN ( 
SELECT gamertag,track,vehicle,laptime, MIN(laptime) AS min_laptime, COUNT(*) AS totalrows
FROM laptimes 
GROUP BY track,vehicle) AS t2 ON t1.laptime = t2.min_laptime AND t1.track = t2.track AND t1.vehicle = t2.vehicle
ORDER BY track,vehicle) AS t3 
GROUP BY gamertag
ORDER BY totalrows3 DESC
LIMIT 200

[cpcdem]

Hey that's fantastic, thank you very much! This is I think way more representative of people's efforts.

I was thinking also about another variation, to count also how many people someone has "below" him in every combo, so if someone is in 20th place in a combo with 100 entries, he would get 80 points. This way you can include in the leaderboard also people who have none (or very few) WRs. But I think this is much more difficult to implement, right?

Btw, guess this has become a good learning tool for SQL for you! Sorry I cannot help in this area, I have refused learning SQL since a lot of years ago But most probably someone else can step in...

[Maskmagog]

Thanks, yeah, I'm learning a lot

I have thought about that too, but I think it might be too difficult, or too heavy to make it work. That's a lot of data to go through. Might need a beefier server, or maybe another language or something. But we'll see

[cpcdem]

Yeah, with a procedural language, that's about 20-30 lines of code! Didn't you say you want to learn new things?

[Maskmagog]

New version of the PCalc tool, 0.6.0.8 - This time I (hopefully) managed to embed the fonts.
Download as usual from https://projectcalc.org/download.php

[cpcdem]

404 error unfortunately!

[Maskmagog]

Thank you, it was a typo in the adress