Page 5 of 6 FirstFirst ... 3456 LastLast
Results 41 to 50 of 60

Thread: Project CALC - car/track leaderboards for consoles

  1. #41
    GT3 Pilot
    Join Date
    Jul 2017
    Posts
    3,832
    Platform
    PC
    Quote Originally Posted by Maskmagog View Post
    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

  2. #42
    Superkart Pilot Maskmagog's Avatar
    Join Date
    Sep 2017
    Posts
    570
    Platform
    XBOX1 X
    Quote Originally Posted by cpcdem View Post
    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"
    Thrustmaster TX, Italia 458 wheel, T3PA-Pro, Firmware 54, Xbox One X, public OS, 24" 1080 monitor
    Don't miss Yorkie065's excellent videos: Ep26-LiveTrack pt1. Ep 27-LiveTrack pt2.
    Project CALC - unified leaderboards - Forum thread

  3. #43
    GT3 Pilot
    Join Date
    Jul 2017
    Posts
    3,832
    Platform
    PC
    Quote Originally Posted by Maskmagog View Post
    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

  4. #44
    Superkart Pilot Maskmagog's Avatar
    Join Date
    Sep 2017
    Posts
    570
    Platform
    XBOX1 X
    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:

    Code:
    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
    Thrustmaster TX, Italia 458 wheel, T3PA-Pro, Firmware 54, Xbox One X, public OS, 24" 1080 monitor
    Don't miss Yorkie065's excellent videos: Ep26-LiveTrack pt1. Ep 27-LiveTrack pt2.
    Project CALC - unified leaderboards - Forum thread
    The following 2 users likes this Post: cpcdem, JasonSandwich


  5. #45
    GT3 Pilot
    Join Date
    Jul 2017
    Posts
    3,832
    Platform
    PC
    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...

  6. #46
    Superkart Pilot Maskmagog's Avatar
    Join Date
    Sep 2017
    Posts
    570
    Platform
    XBOX1 X
    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
    Thrustmaster TX, Italia 458 wheel, T3PA-Pro, Firmware 54, Xbox One X, public OS, 24" 1080 monitor
    Don't miss Yorkie065's excellent videos: Ep26-LiveTrack pt1. Ep 27-LiveTrack pt2.
    Project CALC - unified leaderboards - Forum thread

  7. #47
    GT3 Pilot
    Join Date
    Jul 2017
    Posts
    3,832
    Platform
    PC
    Yeah, with a procedural language, that's about 20-30 lines of code! Didn't you say you want to learn new things?
    The following user likes this Post: Maskmagog


  8. #48
    Superkart Pilot Maskmagog's Avatar
    Join Date
    Sep 2017
    Posts
    570
    Platform
    XBOX1 X
    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
    Last edited by Maskmagog; 19-10-2019 at 22:12. Reason: typo
    Thrustmaster TX, Italia 458 wheel, T3PA-Pro, Firmware 54, Xbox One X, public OS, 24" 1080 monitor
    Don't miss Yorkie065's excellent videos: Ep26-LiveTrack pt1. Ep 27-LiveTrack pt2.
    Project CALC - unified leaderboards - Forum thread
    The following user likes this Post: cpcdem


  9. #49
    GT3 Pilot
    Join Date
    Jul 2017
    Posts
    3,832
    Platform
    PC
    404 error unfortunately!
    The following user likes this Post: Maskmagog


  10. #50
    Superkart Pilot Maskmagog's Avatar
    Join Date
    Sep 2017
    Posts
    570
    Platform
    XBOX1 X
    Thank you, it was a typo in the adress
    Thrustmaster TX, Italia 458 wheel, T3PA-Pro, Firmware 54, Xbox One X, public OS, 24" 1080 monitor
    Don't miss Yorkie065's excellent videos: Ep26-LiveTrack pt1. Ep 27-LiveTrack pt2.
    Project CALC - unified leaderboards - Forum thread
    The following user likes this Post: cpcdem


Similar Threads

  1. Leaderboards on consoles
    By simsimsheree in forum General Discussion
    Replies: 23
    Last Post: 22-03-2018, 22:52
  2. Project CARS Leaderboards - a development request?
    By pippinfort in forum General Discussion
    Replies: 6
    Last Post: 18-12-2015, 12:40
  3. How to pick spring rates? (and how do they interact with Jussi's calc?)
    By Gibbon in forum The Garage - Car Setup Talk
    Replies: 10
    Last Post: 28-10-2015, 13:31
  4. [Consoles] More groups / filtering on Leaderboards
    By Ma5hEd in forum Feature Suggestions
    Replies: 12
    Last Post: 15-08-2015, 13:35
  5. Anyone here got this on BOTH consoles?
    By chris4652009 in forum Project CARS on Playstation 4
    Replies: 6
    Last Post: 12-05-2015, 08:26

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •