Stats Site

  • Thread starter Thread starter jasguer
  • 1,071 comments
  • 108,855 views
That is a wicked site you have there sir. I don't know how you get hold of all that info, but good on you for the effort you put in. I was also wondering how much data can you actually get. The stats world in gt sport can be pretty much endless, total drift points, most miles in a day, most livery likes, etc. How far are you willing to go with it?
 
Wow that is so cool
PDHc.jpg

I race far too much :) You already tracked 1289 of my races lol.
I take it you like Monza mate
 
That is a wicked site you have there sir. I don't know how you get hold of all that info, but good on you for the effort you put in. I was also wondering how much data can you actually get. The stats world in gt sport can be pretty much endless, total drift points, most miles in a day, most livery likes, etc. How far are you willing to go with it?

Thank you, I pull the data from directly from PD. I'm willing to go as far as the data allows me to go. (:confused::crazy: Just don't ask about the car that was used for races or qualifying.......it's a sore spot - the car info, believe it or not, doesn't exist anywhere I can find.) I started with stats that I thought people would be most interested in and would expand from there. I've already added several charts/tables that people have requested so if there's anything you'd like to see, I can try to make it happen. There is a request board on the site so anyone can request a feature to be added to the site. The board needs some enhancements but it works for now.

I do have plans to add likes on liveries and photos to the player summary early this week and now that you mention it, I think there might be a few people interested in a total drift points leaderboard.

Just signed up for this, looks very interesting

Does it extract driver data from GTS or does it only start when you are registered?

Some of the data only starts updating after you have registered, but there are a few exceptions.
  • Race history will occasionally show up if you raced against another user that happened to be registered at the time that you raced against that person. I collect the full result set for races entered by registered users.
  • Driver Rating graph will only be collected for registered users
  • Qualifying lap times, including My Track Records, and general profile stats are collected for every profile, registered or not
  • FIA race results are collected for all profiles
I think that's about it but if there's something specific you're looking for I can let you know how that data is collected.
 
I take it you like Monza mate

I like the challenge as it's the hardest track to survive in GT Sport :)
SPHc.jpg

I beat the odds today and remained positive in SR!

I have been lowering my DR to B though as a shield against penalties from getting rear ended. My weekend so far, hide out in the pits on the last lap to lower DR to get away from DR penalty A.
LPHc.jpg

Little photo shop on your driver rating, suggestion perhaps :)


Question: Is the drivers by driver rating real time info, historical or over all?
 
I like the challenge as it's the hardest track to survive in GT Sport :)
SPHc.jpg

I beat the odds today and remained positive in SR!

I have been lowering my DR to B though as a shield against penalties from getting rear ended. My weekend so far, hide out in the pits on the last lap to lower DR to get away from DR penalty A.
LPHc.jpg

Little photo shop on your driver rating, suggestion perhaps :)


Question: Is the drivers by driver rating real time info, historical or over all?

I need to do some work on the formatting on that page this week, so maybe I'll give the option to show a combined graph like your image or each in separate graphs.

The short answer is that Drivers by Driver Rating isn't really real time but it's about as close as I can get it to real time.

Side note, this is the first time I've actually written this process out so I've realized some errors I've made that I could correct to make the process more efficient.

The longer answer is:
  1. The Drivers By Driver rating chart is based on the driver rating value that is part of the users profile.
  2. There are almost 900 registered users on the site, (almost 1000!), it takes about 2 minutes to update all of these profiles and this process recycles every 10 minutes.
  3. Next profiles that have more than one race are updated by country in ascending order of profile count, Nicaragua is first, United States is last. There are about 1 million profiles with more than one sports mode race and those take about 12 hours to update. However, now that I write this I should reconfigure this to only update profiles that have more than one race in the past week or so, that would cut down on the length of time this part takes. Once this phase complete it automatically repeats.
  4. The remaining 3.5 million profiles are updated by country in ascending order of profile count, the same way that profiles with more than one race are updated. This phase takes about 36 hours to complete and recycles automatically.
  5. Items 2, 3, and 4 all are running at the same time,
    1. item 2 repeats every 10 minutes
    2. item 3 repeats every 12 hours
    3. item 4 repeats every 36 hours
  6. Meanwhile, there is a process that recalculates the rankings every 3 hours. This is the part that causes people to say that the rankings aren't showing up because the data is cleared from the ranking tables and recalculated with the most recent set of data. During this phase, the rankings for the different stats on the leader boards page, drivers by country, drivers by level, drivers by race count, drivers by wins, drivers by region, and drivers by driver rating are all updated individually. The reason for this is that calculating and display rankings by world, region and country for 4.5 million profiles is a very resource intensive process and my first attempts resulted in web site pages that would take minutes to open. Nobody in their right mind would find waiting 4 minutes for a web page to open acceptable. The quickest and most efficient way I found, (if anyone has any better suggestions please let me know), was to compile all of the rankings ahead of time. For example, since everyone has cars in their garage, it takes about 8 minutes to calculate the rankings by world, region and country and prep the entries for the 3.5 million entries and get them ready to display on the page. Now the page loads in about 2 seconds and paging through the rankings of profiles by car count is relatively quick.
Hope that answers your question. :cheers:
 
@jasquer - just a quick query - my race history has not updated with some of the races I ran last night - one was interlagos in the dailies and the other was a nations cup race. I'll keep an eye out just in case they turn up
 
Odd, mine have all turned up already. Suzuka was worth 20 SR points at SR.S, no wonder there were so few red ratings last night. Still plenty people with penalties. One race I went from 9th to 3rd in the last two laps as everyone in front of me were taking each other out, the survivor slowing down for a penalty.
 
Odd, mine have all turned up already. Suzuka was worth 20 SR points at SR.S, no wonder there were so few red ratings last night. Still plenty people with penalties. One race I went from 9th to 3rd in the last two laps as everyone in front of me were taking each other out, the survivor slowing down for a penalty.
I had 2 races turn up from earlier in the evening, but the last 2 races haven't appeared
 
One of mine is missing too. I did 3 on Interlagos yesterday (1 before FIA then 2 after) but the one from before is not there.
 
I had 2 races turn up from earlier in the evening, but the last 2 races haven't appeared

One of mine is missing too. I did 3 on Interlagos yesterday (1 before FIA then 2 after) but the one from before is not there.

I'm not sure if this is due to the maintenance last night or if they just haven't been updated yet. Everything looks fine on my side of things, I'd give it a few more hours and if it hasn't updated I'll check again.

Also, there's at least part of an addition that someone had requested for photos and livery information.

1FA51E03-5074-4FF9-9F40-A03D0C11C4BA.jpeg
 
Morning Jason, my first race at Interlagos is now showing. Bit odd that it was the first one that was missing though :scared:

Also, funnily enough... just noticed here on your 'drivers by driver rating page' that there are some weird anomalies - see there are a few odd players with a DR but no SR ranking? I say funnily enough as I was in a race with one of these guys the other evening - when the race started it showed in the columns A --. Any ideas?

upload_2018-3-13_7-37-13.png
 
Last edited:
@jasguer - On the Daily races pages, would it be possible to show your record details for the race you are displaying - that way, you know everything you need to know, ie how you are doing compared with your previous best time along with all the times achieved on the day for yourself and the rest of the country / world
 
Select Daily race B
Returned the info of both B and C races
The qualifying time displayed should be race C right?
Anyone experience the same?
D0447126-B723-44CD-8250-EC11CC6DB098.png
 
@jasguer Are the various timestamps on the site in GMT or some other time zone? Can you easily add/change the label to make that clear? Thank you!
 
Thanks for that, even tho I initially had received likes in mind, not given ;)

Sorry about that I just read the description of the achievements again and I thought it was the right one. I'll see if I can find that.


@jasguer Are the various timestamps on the site in GMT or some other time zone? Can you easily add/change the label to make that clear? Thank you!

Well, it's complicated. The data I'm getting is in a specific format, i.e. 2018-03-14T11:32:45Z the letters T and Z are significant because this indicates that the date-time stamp is in UTC time. What's great [code:sarcasm] is when these times are inserted into the database, Microsoft in their infinite wisdom says, "oh, this is UTC time, here, let me automatically convert that to your local time for you, you really don't want UTC, do you?" :banghead: In some places I converted the times back to UTC in other places I didn't. It is on my list of things to get to. On a related note, you can now change your time zone on the site by clicking your name at the top of the page and then clicking on edit profile. It is my plan to make all the times that are in the database UTC time and then use whatever time zone information users have set on their profile to convert the UTC times to their local times. But first, I need to update about 200 million time stamps, switch the date/time settings on the server to UTC and then locate places in the code where I'm manually updating the time.

@xxxman1 's issue explains @anthaliscious post above. For some reason B is being reported as A and B for Asia region.

@Lord Grey definitely not GMT :( I think it's -5 which could be US Eastern time?

-5 Central Daylight Time where we arbitrarily turn our clocks forward so it's still light out at 9pm when I'm trying to go to sleep.
 
Thanks for a great stat site, its amazing that this isn’t built in-game.

How often does it update? My stats is from 14th of March.
 
FYI, my Race History now seems to have settled into a pattern of updating 24 hours in arrears, so this morning I can see Wednesday's races, yesterday I could see Tuesday's races etc... 👍
 
Back