Server Results

Hello good, I am trying to create a league with a statistical system on the web, but the server results json gives very strange information, numbers that do not make sense, but in the pdf guide it does not say anything, does anyone know what they mean? a greeting

 

I use simresults.net just copy result json file in there

 

O thanks but Is there a program that understands the data of the file and makes a table to upload it to my website?

 

Simresults will give you all the times,position fastest laps etc in a table but won't give you a league table I just made my own on.photoshop and fill in after each race

 

What numbers exactly you don't understand or don't make sense?

 

"currentDriverIndex": 0,
"timing": {
"lastLap": 144609,
"lastSplits": [
42654,
63990,
37965
],
"bestLap": 143568,
"bestSplits": [
42306,
63111,
37623
],
"totalTime": 1835910,
"lapCount": 12,
"lastSplitId": 2
},
"missingMandatoryPitstop": -1,
"driverTotalTimes": [
0.0
]
},
{
"car": {
"carId": 1033,
"raceNumber": 333,
"carModel": 2,
"cupCategory": 2,
"teamName": "",
"nationality": 0,
"carGuid": -1,
"teamGuid": -1,
"drivers": [

I want to make a statistics table for my league but there is no application that allows me to get the data and put it on my website, I know there are web aps but I cannot put them on my website except with iframes ..
A greeting.

 

This is what I get from json file inn simresults will give all statistics of each driver aswell

 

You need to parse the file yourself. The good thing is it is a JSON file, so it is very easy to deserialize it in your code and use as you need. Regarding the data, I think it is pretty self-explanatory, one thing that might come confusing is timing values (lastLap, lastSplits, totalTime...), which are in milliseconds. Car model and Track IDs are listed in the server handbook PDF.

 

I know that this website is fine but as you get all that data for a table on your website, that is not copying and pasting, it has an iframe but it is not too good, there is no app that extracts the data in html ACCTrackerManager would be the solution but It is only for private use I can not put it on my website.

 

you could use PowerShell to do the job easily...
With ConvertFrom-Json read that file and manipulate it as you wish.
At the end you can use ConvertTo-Html or ConvertTo-Xml for exporting to your website.

Now if you say, but my server is running Linux and not Windows... no problem: Installing PowerShell on Linux

 

Excuse the shameless plug, but ACC Results Companion (https://www.racedepartment.com/downloads/acc-results-companion.28298/download) might help you with this.

You point it at the server results folder


It will import the results files and parse them.


By right clicking on the session or laps, you can export as CSV or JSON with the codes (eg Car model) replaced with names etc and things like lap numbers and positions gaps all calculated. It would be all a bit manual though, so that may not be for you If so, @AndyK70 's suggestion is a good one

Main translations you'll need:-

• session type R/Q/FP = Race, qualifying and practice
• The final results are all in sessionResult.leaderboardLines
• isWetSession - 1 if wet - I don't know when the cutover occurs, but best to say if wet tyres were used
• carId - unique id for the car...this is likely to change session to session
• car model - see below
• car_model car_name
  0 Porsche 991 GT3 R
  1 Mercedes-AMG GT3
  2 Ferrari 488 GT3
  3 Audi R8 LMS GT3
  4 Lamborghini Huracan GT3
  5 McLaren 650S GT3
  6 Nissan GT-R Nismo GT3 (2018)
  7 BMW M6 GT3
  8 Bentley Continental GT3 (2018)
  9 Porsche 911II Cup GT3
  10 Nissan GT-R Nismo GT3 (2015)
  11 Bentley Continental GT3 (2015)
  12 Aston Martin Vantage AMR GT3
  13 Rieter R-EX GT3
  14 Emil Frey Jaguar G3
  15 Lexus RC F GT3
  16 Lamborghini Huracan GT3 EVO
  17 Honda NSX GT3
  18 Lamborghini Huracan ST
  19 Audi R8 LMS EVO
  20 AMR V8 Vantage GT3
  21 Honda NSX GT3 EVO
  22 McLaren 720S GT3
  23 Porsche 991 II GT3 R
  50 Alpine A110 GT4
  51 Aston Martin V8 Vantage GT4
  52 Audi R8 LMS GT4
  53 BMW M4 GT4
  55 Chevrolet Camaro GT4.R
  56 Ginetta G55 GT4
  57 KTM X-Bow GT4
  58 Maserati Granturismo MC GT4
  59 McLaren 570S GT4
  60 Mercedes AMG GT4
  61 Porsche 718 Cayman GT4 Clubsport
  
  
• Cupcategory = // Cup: Overall/Pro = 0, ProAm = 1, Am = 2, Silver = 3, National = 4
• playerId = I think this is the steamID3
• last/best laps and splits all in milliseconds.
• totaltime=Total time in race - don't rely on this though...includes wait time before green light
• For the laps
• The carId references back to the carId and driverId in the leaderboard​
• isValidForBest - indicates if track limits were observed or not
• laptime/splits as before in ms
• The laps are listed in order of the cars crossing the line - if you were going to use the laps, you'd need to calculate lap number, position and gap if you wanted them
• At the end you have any penalties listed referring back to the carId

 

Hello, thanks, that application is perfect, you just have to export the file and upload it to a table, thank you very much indeed.