VM LiveView Lite for rFactor & rFactor2

Discussion in 'Plugins' started by Frank Geyer, Feb 20, 2012.

  1. redapg

    redapg Registered

    Joined:
    Jan 16, 2012
    Messages:
    2,056
    Likes Received:
    774
    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
     
  2. Valbuena72

    Valbuena72 Registered

    Joined:
    Dec 23, 2011
    Messages:
    194
    Likes Received:
    0
    Yes, sorry for the stupid mistake
    Thank's
     
  3. Tirex

    Tirex Registered

    Joined:
    Dec 7, 2013
    Messages:
    37
    Likes Received:
    0
    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
     
  4. Valbuena72

    Valbuena72 Registered

    Joined:
    Dec 23, 2011
    Messages:
    194
    Likes Received:
    0
    No I have not solved the problems of crashes on some leagues but it still works ... Apparently the problem does exist in France ...
     
  5. redapg

    redapg Registered

    Joined:
    Jan 16, 2012
    Messages:
    2,056
    Likes Received:
    774
    If you want i can upload the basic-version (if i can find it here on my machine :D).
    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:
     
    Last edited by a moderator: Jan 4, 2014
  6. Tirex

    Tirex Registered

    Joined:
    Dec 7, 2013
    Messages:
    37
    Likes Received:
    0
    thnx mate
    we will give it a try and lets hope that its stable for B382:cool:
     
  7. Valbuena72

    Valbuena72 Registered

    Joined:
    Dec 23, 2011
    Messages:
    194
    Likes Received:
    0
    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
     
  8. redapg

    redapg Registered

    Joined:
    Jan 16, 2012
    Messages:
    2,056
    Likes Received:
    774
    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 ;).
     
    Last edited by a moderator: Jan 5, 2014
  9. redapg

    redapg Registered

    Joined:
    Jan 16, 2012
    Messages:
    2,056
    Likes Received:
    774
    Unfortunately the problem isn't solved finally [​IMG]
    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 [​IMG]

    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".
     
  10. Valbuena72

    Valbuena72 Registered

    Joined:
    Dec 23, 2011
    Messages:
    194
    Likes Received:
    0
    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
     
  11. Valbuena72

    Valbuena72 Registered

    Joined:
    Dec 23, 2011
    Messages:
    194
    Likes Received:
    0
    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
     
  12. redapg

    redapg Registered

    Joined:
    Jan 16, 2012
    Messages:
    2,056
    Likes Received:
    774
    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 :D)...

    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.
     
  13. redapg

    redapg Registered

    Joined:
    Jan 16, 2012
    Messages:
    2,056
    Likes Received:
    774
    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";
     
  14. Valbuena72

    Valbuena72 Registered

    Joined:
    Dec 23, 2011
    Messages:
    194
    Likes Received:
    0
  15. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    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
     
    Last edited by a moderator: Jan 31, 2014
  16. gagipro

    gagipro Registered

    Joined:
    Feb 26, 2013
    Messages:
    461
    Likes Received:
    0
    Thanks Franck. Do you think it will solve the hanging issue we've got with this build?
     
  17. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    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
     
  18. gagipro

    gagipro Registered

    Joined:
    Feb 26, 2013
    Messages:
    461
    Likes Received:
    0
    You rule Frank!!

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

    Thx again
     
  19. Valbuena72

    Valbuena72 Registered

    Joined:
    Dec 23, 2011
    Messages:
    194
    Likes Received:
    0
    thank you,Franck I'll reinstall the server rFactor 2
     
  20. Tirex

    Tirex Registered

    Joined:
    Dec 7, 2013
    Messages:
    37
    Likes Received:
    0
    Vielen Dank, Frank. Wir testen es auch aus und sagen Bescheid. Danke für den gleichzeitigen Support auch von Rainer/United-Simracer.de
     

Share This Page