Stats Site

  • Thread starter Thread starter jasguer
  • 1,071 comments
  • 108,830 views
Uh, sure........aliens!

That's weird, data is hard. I'll need to figure out why there's such a difference. I need to rewrite those queries anyway to get rid of the duplicates.
I think once you have rectified this issue, my correct ranking will be displayed as number 1 in the world for the majority of statistics. Thanks 👍
 
And I think I've fixed it. I do need to get the query that pulling the data to run faster but it is at least functional.
 
@Robben it looks correct to me. Mine is showing up as 8,140 total, 1,345 world rank, 216 region rank and 148 country rank
Alright, show off.


Good work man... it's really cool to be able to see this. Did you say that you were able to add the vehicle used in to the table?
 
I believe it was if the race was one make or garage car.

Just finished changing the personal records page, how's it look now @Robben :D
 
Last edited:
Man what a site! And i really, but really love the personal track records! Good job mate!

Little thing, i amost can't see the tabs text like; Home, Races, Leaderboards, Search and News because they are grey, just like their surroundings. The text were white before i thought? I use a android phone.

Great site, keep up the good work!


@jasguer could you fix this?
 
With the addition of car type I now have some formatting issues. Fine weather is causing some rows to be double height. Also one of my BB Raceway times has disappeared... I had one which was from the gr. 3 daily and another from the gr. 3
upload_2018-2-20_14-0-31.png
 
With the addition of car type I now have some formatting issues. Fine weather is causing some rows to be double height. Also one of my BB Raceway times has disappeared... I had one which was from the gr. 3 daily and another from the gr. 3
View attachment 715719

I see why it disappeared, the times are combined based on track, time of day, weather, car category and whether or not it's one make or garage car. The only difference between those two races at BB were that one was a daily race and the other was an FIA race. The current logic doesn't distinguish the two since technically, qualifying should be the same. Unless of course I'm mistaken.
 
I see why it disappeared, the times are combined based on track, time of day, weather, car category and whether or not it's one make or garage car. The only difference between those two races at BB were that one was a daily race and the other was an FIA race. The current logic doesn't distinguish the two since technically, qualifying should be the same. Unless of course I'm mistaken.

I only mentioned it as they were both listed previously. There is actually a distinction too, in that the FIA races are a closed 10 minute qualifying with the rest of the competitors on the track. No big deal though :)
 
That is true, but, only the pre-race open practice lap times update the leaderboards. I'm pretty sure of this at least. If you set a faster time in the 10 minute closed session, it doesn't update your fastest lap time.
 
I just finished adding another page, Race Averages that will eventually contain your average qualifying, finish, laps led etc. for each track. There isn't much data right now, and the data only updates about once per day but it will eventually contain the average results for your races. Also, I'll eventually add stats such as your wins by track, top 5 and/or top 10 finish or anything else that might get suggested in the future.
 
I just finished adding another page, Race Averages that will eventually contain your average qualifying, finish, laps led etc. for each track. There isn't much data right now, and the data only updates about once per day but it will eventually contain the average results for your races. Also, I'll eventually add stats such as your wins by track, top 5 and/or top 10 finish or anything else that might get suggested in the future.
I just jumped on to see how my Q laps fared yesterday evening and noticed the new tab to this holy grail of pages! You're an actual genius! :bowdown:

Edit: What is max led and avg led?

Edit edit: I still can't over how cool this is! How are you capturing SR losses and gains per race as well?
 
Last edited:
Back