VM LiveView Lite for rFactor & rFactor2

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

  1. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi xoa,

    the "inc.mysqli.conn.php" should remain untouched!

    The user credentials for the php scripts to able to access the db is located in the "inc.config.php".

    If your loader works, align the mysql access credentials from the loader config with the mysql access credentials within the "inc.config.php".

    Cheers
    Frank

    EDIT: And don't forget to modify the config entry $siteURL = "http://your-domain.com/vmliveview"; to your site accordingly ... !!!
     
  2. xoa

    xoa Registered

    Joined:
    Mar 11, 2011
    Messages:
    44
    Likes Received:
    0
    Danke Frank

    I will try it out. :)
     
  3. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Gern geschehen :)
     
  4. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Preview for next release

    Monitor
    - Color Code: light purple for BestS1, BestS2, BestLap compared to overall best lap time
    - Last Lap: now showing split time until current lap is completed
    - rF1: http://vxracing.de/vmliveview/monitor.php
    - rF2: http://vxracing.de/vmliveview2/monitor.php

    Hotlaps
    - added up-count for timed laps: Column Laps
    - added parameter ALL (case sensitive!) for TrackName: ...
    - rF1: http://vxracing.de/vmliveview/hotlaps.php?TrackName=ALL
    - rF2: http://vxracing.de/vmliveview2/hotlaps.php?TrackName=ALL
     
  5. xoa

    xoa Registered

    Joined:
    Mar 11, 2011
    Messages:
    44
    Likes Received:
    0
    Great Frank. When will it be released? :)
     
  6. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Like usual it is always hard to make thorough predictions in those cases ;) ... but I guess somewhat around Wednesday this week ... !?!?
     
  7. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    ### Update: 15. March 2012 ###

    ### PHP Scripts ###
    - hotlaps.php ... added parameter ..?TrackName=ALL (case sensitive!)
    - hotlaps.php ... added up-count handling for timed session laps

    - inc.mysqli.create.php ... modified to meet database structure 2.001

    - monitor.php ... modified sector lights handling
    - monitor.php ... modified Last Lap and Best Lap handling for split times during timed session laps

    - styles.css ... added common class .toptime

    ### Database ###
    - updated database structure ... current version: 2.001
    for more details see .sql update script "..\mysql\vmliveview.db.update.2001.sql"
    *** REQUIRES rFactorSL.exe 2.027 BETA OR HIGHER ***

    - vmliveview.db.manual.setup.sql ... modified to meet database structure 2.001

    ### rFactor Session Loader ###
    - current version rFactorSL.exe: 2.027 beta

    - corrected double data type conversions regarding to the current selected OS system locale
    - added up-count logging for timed session laps
    - added logging for overall top session times for best S1, S2, Lap

    ### rFactor Session Recovery ###
    - current version rFactorSR.exe: 2.011 beta

    - corrected double data type conversions regarding to the current selected OS system locale

    ### SEE FIRST POST FOR DOWNLOAD LINK ###
     
  8. Hoschi

    Hoschi Registered

    Joined:
    Nov 18, 2011
    Messages:
    94
    Likes Received:
    0
    Nice Frank, great work :D
     
  9. xoa

    xoa Registered

    Joined:
    Mar 11, 2011
    Messages:
    44
    Likes Received:
    0
    many thanks Frank ;)
     
  10. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Thanx guys :)
     
  11. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Last edited by a moderator: Mar 26, 2012
  12. MystaMagoo

    MystaMagoo Registered

    Joined:
    Oct 5, 2010
    Messages:
    775
    Likes Received:
    4
    Struggling to get this to work :(

    Pretty sure it's because I don't know where to place the files?
    I use wamp as my server.

    Seem to have loaded database ok.
    Getting confused as to which folder to place into wamp?

    inside folder apache/htdocs is folder vmliveview which looks like the one I need in wamp?
    I've altered my httpd-vhosts.conf accordingly.
    added to windows host file.
    The mysql folder/files is confusing me?
    Where do they go?
    Do I need to alter them?

    Also this line...
    <xmlURL>file://Your-rFactor-Root-Directory/VMHotlaps/CurrentScoring.xml</xmlURL>
    Should it look like this....
    <xmlURL>file://C:\Program Files (x86)\rFactor2/VMHotlaps/CurrentScoring.xml</xmlURL>
    Notice the //\\ orientation.

    I'm placing all files on server.
    Where does folder rFactorSL go?

    The session loader doesn't seem to find my server which may mean I'm not editing rFactorSL.exe.xml correctly?

    Any help appreciated :)
    I'll keep trying though.
     
    Last edited by a moderator: Mar 19, 2012
  13. robibcn76

    robibcn76 Registered

    Joined:
    Jan 11, 2012
    Messages:
    4
    Likes Received:
    0
    PUT IN FOLDERS XAMPP:

    htdocs (in apache or any other Apache as an example)
    conf (in apache or any other Apache as an example)



    <xmlURL> file :/ / Your-rFactor-Root-Directory/VMHotlaps/CurrentScoring.xml </ xmlURL>
    (example on my server)

    <xmlURL> D: \ TCAFiles \ Users \ Bailon \ 1 \ VMHotlaps \ CurrentScoring.xml </ xmlURL>


    Where does rFactorSL folder go?
    Anywhere you want, usually if you want more vmliveview1 rfactor servers, vmliveview2 etcetc, better in the first directory vmliveview ...

    output:
    xampp / htdocs / vmliveview / rFactorSL





    The mysql folder / files that confuses me?
    Where do they go?
    Do I have to change?

    If you have problems installing database, create file named vmliveview01 Mysql manually, then insert mysql files


    I also took, but then seems not so difficult, I am Spanish and my English is not very good, so it cost me more ..... jjjjj

    I also I have a question, now posting

    I hope this serves some help that said, sure that all is not well explained by me, sure it helps the creator .....
    (google translate)
     
  14. robibcn76

    robibcn76 Registered

    Joined:
    Jan 11, 2012
    Messages:
    4
    Likes Received:
    0
    I also I have a little doubt on the subject of HOTLAPS, since it records the "TURNS TOTAL OF EACH PLAYER", surely I can have installed something wrong ......

    View attachment 1609

    Also I have a small problem or query:

    When cycle ends marquee active pilots in the second round pilots do not check active again, always cool to see F5 drivers online after first round of marquee ....

    first marquee ....
    View attachment 1610

    second marquee ..... (second cycle repetition)
    View attachment 1611

    Thanks in advance
    Thanks for your work and your help .... My congratulations for that great plugin
    (google translate)
     
  15. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi Mysta,

    yeah documentation is not best one :( ...

    ... if this is your location of rFactor2 !?!? Then use this config line:

    <xmlURL>file://C:/Program Files (x86)/rFactor2/VMHotlaps/CurrentScoring.xml</xmlURL>

    An URL String has to be formed accoarding to this http://en.wikipedia.org/wiki/Uniform_Resource_Locator and this http://www.w3schools.com/tags/ref_urlencode.asp

    The rFactor Session Loader folder can be in any place e.g.:

    C:\Games\rFactor Session Loader\rFactor2\Server Instance 01\MySql.Data.dll
    C:\Games\rFactor Session Loader\rFactor2\Server Instance 01\rFactorSL.exe
    C:\Games\rFactor Session Loader\rFactor2\Server Instance 01\rFactorSL.exe.xml


    If WAMP is up an running and the vmliveview folder resides in the htdocs folder you can use the setup.php to setup the database:

    HTML:
    http://localhost/vmliveview/setup.php
    ...

    ok ... just saw robibcn76 already helped us out here ... thanx rob :)

    Hope this helps ... !?!?

    Cheers
    Frank
     
    Last edited by a moderator: Mar 19, 2012
  16. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    @rob:

    Marquee
    Originally the marquee was designed for a 4 Class endurance event, but I am gonna put in a cycle control for the next release.

    Hotlaps
    What is the DBVersion value of the database in table sessioninfos?
    What is the Version of the loader you are using?
    Any error .log file of the folder available?

    Thank you & Cheers
    Frank
     
  17. MystaMagoo

    MystaMagoo Registered

    Joined:
    Oct 5, 2010
    Messages:
    775
    Likes Received:
    4
    Thanks Guys :)

    Trying to use the 'setup.php'
    May be a problem with mysql admin user?
    Don't think I have a mysql user?
    Got a phpmyadmin user.

    Error connecting to database:(access denied for user 'liveview'@'localhost' using password:yes)

    No wait,success,it was some weird password thing???

    Now lets see if I can get it working.......
    ____________________________________

    Almost there :)

    I get a database connection error?
    http://stimulatedgaming.com/vmliveview/monitor.php

    Working now :)
    Think it was a password problem.
     
    Last edited by a moderator: Mar 19, 2012
  18. xoa

    xoa Registered

    Joined:
    Mar 11, 2011
    Messages:
    44
    Likes Received:
    0
    Great, can't wait the new version. :)
     
  19. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    @Mysta: Nice! Glad you made it ... :)

    @xoa: I'll try to hurry ;) ... but right now I am stuck a little bit to plot a real track view from the data provided by the plugin, which I would like to provide with the next release ...
     
  20. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Last edited by a moderator: Mar 26, 2012

Share This Page