Pc Lap Counter
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Pc Lap Counter

Logiciel de comptage
 
HomeHome  SearchSearch  RegisterRegister  Log in  

 

 Classement général

Go down 
4 posters
AuthorMessage
xander




Number of posts : 22
Registration date : 2011-11-01

Classement général Empty
PostSubject: Classement général   Classement général Empty19/6/2016, 21:46

Bonjour,

Es-t’il possible d'afficher le classement général complet dans zoom ??
J'arrive a avoir les pilotes du segment en cours mais pas tous les pilotes.

Xander
Back to top Go down
bernard70




Number of posts : 5
Registration date : 2017-11-04

Classement général Empty
PostSubject: Re: Classement général   Classement général Empty17/11/2018, 15:31

Ce serait effectivement un gros plus cheers
Back to top Go down
morris1400

morris1400


Number of posts : 61
Registration date : 2008-02-10

Classement général Empty
PostSubject: Re: Classement général   Classement général Empty31/7/2019, 21:06

pas d'avancé la dessus ??
Back to top Go down
bruacucunalsucri




Number of posts : 4
Registration date : 2015-05-17

Classement général Empty
PostSubject: Re: Classement général   Classement général Empty3/2/2020, 19:47

Hi Guy,

First of all my compliments for the great work you are doing!

I strongly support this request, because it is the "missing icing on top of the cake"!

IMHO as of current PCLC version (5.43c) on the zoom screen are already available:
- Current heat result (within lanes boxes)
- Current session result (in a separate box)
the best solution is to add a new box to present the general results of the race at the point in time of the current session.

I made some prototyping on PCLC database on an effective race managed, resulting this query:
SELECT A.DriverID As Driver, A.Lap As Laps, A.LapTime As LastLapTime, A.LaneID As InLane,
           A.DriverRaceTime As LastLapAtSecond, A.TeamID, A.CarID, A.FuelUsed, A.FuelLeft,
           A.PitstopNo, A.Penalty
FROM RaceLaps A
WHERE A.RaceID = 36
 AND A.DriverRaceTime < 780
 AND RecID IN (SELECT MAX(B.RecID) As MaxRecID
                          FROM RaceLaps B
                        WHERE B.RaceID = 36 AND B.DriverRaceTime < 780
                       GROUP BY B.DriverID)
ORDER BY A.Lap DESC,A.DriverRaceTime ASC;

In this query:
- 36: is the RaceID currently running (repeated two times, one in the main query one in the subquery)
- 780: is the number of seconds since beginning of current session (also repeated two times, one in the main query one in the subquery)

Data coming from this query should be refreshed once in a period to let people looking at it to analyze data presented.
IMHO it should be configurable between 15 seconds and 10 minutes because:
- in a sprint race I would like to have it refreshed every 30 seconds.
- in a 24h race I would like to have it refreshed every 2 to 5 minutes

Drivers/teams currently running could be put in evidence with a different background colour if requested (it is important for sprint races while is not important for endurance races).

Let us know if you consider it applicable!

Best Regards,
Gianni

P.S: probably this post should be moved to "Demand" section with title "ZOOM - Classement général"; there is already another request from a Portuguese club titled "Overall Rating on zoom screen". IMHO both are describing the same functionality.
Back to top Go down
bernard70




Number of posts : 5
Registration date : 2017-11-04

Classement général Empty
PostSubject: Re: Classement général   Classement général Empty18/1/2021, 15:06

Hi,
As a workaround, what we are currently doing (hmmm what we were used to do before covid) is :
- For sprints races : displaying the generated web page at the end of each heat and/or during the heat => has do be done manually.
- For endurance races : displaying the main window instead of the zoom window.
But indeed, this would be very nice to have this feature out of the box in the zoom window.
Cheers,
Bernard
Back to top Go down
Sponsored content





Classement général Empty
PostSubject: Re: Classement général   Classement général Empty

Back to top Go down
 
Classement général
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Pc Lap Counter :: Zoom Setting-
Jump to: