VM LiveView Lite for rFactor & rFactor2

I'm sorry, but I have to correct one thing.
After a few drivers have tested it, the better laptimes were not displayed.
But the reason was simply that it had to be ASC instead of DESC.
That's all .
So the Code-snipped has to be

Code:

GROUP BY DriverName ASC

 

Yes, sorry for the stupid mistake
Thank's

 

hi mates
after Frank Geyer has finshed the work with the VortexLiveview he posted the source (18.12.13..the .rar is posted here in this forum ) of that before B342 was released (20.12.13)
Now I see that you worked on it and solved the problems and your servers are running
where can i get the new complete version of the liveview now?
we want it to run for our DTM league
with the older version the dedi lost connection with 4 drivers or more who crashes into cars or walls
thnx in advance

 

No I have not solved the problems of crashes on some leagues but it still works ... Apparently the problem does exist in France ...

 

If you want i can upload the basic-version (if i can find it here on my machine ).
We've made some customisation, so it's better to give you the basic-version.
But we have no problems with it.
It run's on all our servers (currently 6 ractor1 and 2 rFactor2 server).

EDIT Here is the original-link from Frank of the Version we use:

DOWNLOAD V 20130411​

 

thnx mate
we will give it a try and lets hope that its stable for B382

 

Here it is strange, the last modified date of the DLL archive proposed by redapg is 11/04/2013 and on my server I had the dll 25/05/2012
It is curious, take test
Keep us updated Tyrex

 

It should be, we run rFactor Build 382 and, as i said before, we never had any trouble with 382 or former builds.

It's just the latest Version Frank himself posted in the first post of this thread .

 

Unfortunately the problem isn't solved finally
The "GROUP BY..." has to be changed and i am not able to do it the way that it works as i want it.
So i need help again.

I try to explain what the "problem" is:
The mod has e.g. 6 classes of cars, let's call them A,B,C,D,E,F.
Driver 1 drives his fastest lap with a car from class A and a slower one with a car from class D.
When i now take "GROUP BY DriverName ASC" the lap driven with the car from class A is shown.
When i take "GROUP BY DriverName DESC" the lap driven with the car from class D is shown.

So it seems as if the query first sorts the laps in order of laptimes and now, depending on if i choose ASC or DESC the DriverNames are grouped from first to last or last to first entry in first order.
So when i take my example and have to drivers, where one has driven his fastest lap with a car from class A and another one with a fastest lap driven with a car from class D, one of them will not be shown with the correct laptime/car in the hotlaplist.

I hope i could make you understand what i mean

I wasn't able to manage that the right laps are shown.
It must be something like "first order by laptime ASC and then group by Drivername ASC".

 

I quite understand, I do a test on one or two laps and I quite understand why it does not work;
I'll see what I can do
Thank you for the comment

 

I think we should compare the variable LapTime
Let me explain:
The higher the value, the lower the ride is fast.
In fact, it will do in php:
Whether LapTime is less than the previous value, whether it displays the new time, if not we leave the old and displays nothing

 

Sorry Valbuena, i am not sure if i understood what you've posted.
My experience in php and sql is not that big unfortunately (and google translator isn't my friend too )...

I always try to help myself to looking around in web where i can get information and try it out then.

But in this case i couldn't find something helpful.

The only thing i've found was to try it with a subquery, which sorts the data in order of laptimes and after that to group these data about DriverName.

But i couldn't make it work, because of wrong syntax or other mistake from me i guess.

 

I think i got it now
I played around a lot and the following solution seems to work as wanted.

replace the original line:

Code:

$SelectHotlaps = "SELECT SQL_CACHE * FROM `hotlaps` WHERE `TrackName` = '" . $mySQLiConn->real_escape_string($TrackName) . "' AND `VehicleClass` LIKE '" . $mySQLiConn->real_escape_string($VehicleClass) . "' ORDER BY `TrackName` ASC, `LapTime`, `LastUpdate`";

(should be line 110 in original hotlap.php)

with this one:

Code:

$SelectHotlaps = "SELECT * FROM (SELECT * FROM `hotlaps` WHERE `TrackName` = '" . $mySQLiConn->real_escape_string($TrackName) . "' AND `VehicleClass` LIKE '" . $mySQLiConn->real_escape_string($VehicleClass) . "' ORDER BY `LapTime` ASC) AS t1 GROUP BY `DriverName` ASC ORDER BY `LapTime` ASC";

 

thank's

 

Hi there,

this is just a recompile of our Plugin (VMHotlaps.dll) against the latest InternalsPlugin5 and the current rF2 Build 382 for the last official release of the VM LiveView Lite rFactor 2 live timing suite.

View attachment VMHotlaps.382.5D.rar
MD5: 1b438c361358c8043bf5e2f22af3b09d
.5D: .5 = Plugin was compiled against InternalsPlugin5, D = Default - meaning scoring data will be placed directly into the ..\VMHotlaps\.. folder.

View attachment VMHotlaps.382.5S.rar
MD5: b1c7c53552197d9e3e6b73f221d116ed
.5S: .5 = Plugin was compiled against InternalsPlugin5, S = Subfolders - meaning scoring data will be placed into subfolders of ..\VMHotlaps\.. folder based on the profile's PlrFileName.

View attachment rF2.Example.Plugin.Source.Code.382.rar
MD5: 237de854c557c9a524b8e61dc9775566

Have fun and cheers
Frank

 

Thanks Franck. Do you think it will solve the hanging issue we've got with this build?

 

Hi gagipro,

ure welcome. This time, I just tested the Plugin for some couple of hours regarding its stability while running the DS and switching through its sessions. No crashes detected so far, so just give it a try and report back here please.

Thanks and cheers
Frank

 

You rule Frank!!

We will, if course, report you back every bug.

Thx again

 

thank you,Franck I'll reinstall the server rFactor 2

 

Vielen Dank, Frank. Wir testen es auch aus und sagen Bescheid. Danke für den gleichzeitigen Support auch von Rainer/United-Simracer.de