[WIP] Live Timing, Session Results, Track Rendering & League Management [Discontinued]

Discussion in 'Other' started by B1K3R, Apr 16, 2013.

  1. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    This needs IIS (Internet Information Services with .Net 4.0 and above) and mySQL 5.x. Installation instructions included.

    Change log v0.2:
    1. Web site has been updated for cross browser compatibility.
    2. It has also been updated to handle different country formats (especially DE)
    3. Added security to certain pages, specifically Draw Track
    4. Lowered the site header for better compatibility with smaller devices
    5. Plugin was crashing dedicated server at times. This has now been fixed.

    Change log v0.4:
    1. Added Driver and Session Hotlap pages.
    2. Added Admin login and security on some pages
    3. If a driver leaves during a session, live timing is updated accordingly
    4. Minor bugs and fixes

    Change log v0.5:
    1. Fixed errors when XML log files contain HEX values at the end of the file
    2. Fixed error with duplicate primary key
    3. Fixed error when laptime is empty string
    4. Fixed error when mysql object returns null due to multi-threading

    Change log v0.6:Web:
    1. Added Dashboard pages to web
    2. Added separate components of live timing, map pages etc so that they can be used separately
    3. Faster loading results and statistics components
    4. More informative Server List which is order by most drivers in server
    5. Bugs and fixes
    Loader:
    1. Loader now further handles corrupted XML log files by stripping out any illegal HEX values
    2. If XML file is corrupted beyond auto repair, (like missing tags etc), it will be skipped
    3. Bug fixes to certain program crashes
    4. It now supports TestDay sessions
    5. Added Driver Swaps
    Plugin:
    1. No changes

    Change log v0.61 and v0.62:Web:
    1. Sector times now appear "live" and not just at the end of the lap2. Purple sector times for best sectors have been added
    3. If you look at image (top), I added an hour glass. It shows the remaining time or laps according to setting
    4. I could not find any field in plugin which shows the time of day of the race Maybe I missed it...
    5. This will be part of next Loader release.
    6. You can now select a driver from the grid (see first highlighted row, image in post above) and the circle on map for that driver changes color too
    7. In Test Day, the remaining time was wrong. It now shows the correct time.
    8. Re-shuffled some of the fields in Live Timing Grid
    9. The AI can now be filtered out from the Results (not live timing). A database script has been provided with the patch. If you'd like to keep AI results, run script
    1_broadcast_update_0.6.2_AI_Enabled.sql, otherwise 1_broadcast_update_0.6.2_AI_Disabled.sql. I will do a screen in the near future with settings where user can change this from a click of a button.

    Change log v0.7:
    Added:1. Km/h of driver to live timing
    2. Cloud %
    3. Rain %
    5. Track wetness %
    4. Wind
    5. fix to live timing page due to "Please Wait Loading" flickering
    6. some bugs and fixes

    Change log v0.7.0.1:
    1. Added From/To Dates to Session/Driver result pages
    2. The driver statistics widget in dashboard now also includes best laps directly from live timing
    3. Km/hr in live timing has been updated to only show Top Speed and not current speed

    Change log v0.8:
    1. Currently, if a driver leaves in mid session, the hotlaps are not recorded since they are not present in ISI xml log. The system has now been updated to record the hotlaps (best time, speed etc) during a session, regardless if driver leaves before end of session. This data is then merged with the results/statistics if not present in xml log
    2. User will be able to zoom maps in and out and saved for his/her preference (using cookies). Map can also be dragged around. If too big, it might disappear, but look at the bottom of the page
    3. Hotlaps page as requested by Dean
    4. Some bugs and fixes


    Change log v0.9:
    1. Various bugs and fixes.

    Change log v0.9.1:
    1. Re-wrote the apps to work with socket streaming.

    Change log v0.9.1.1:
    Web

    1. Bug fix for error when saving Settings in web.
    2. Bug fix when drawing map and try to save settings for French language server
    Listener
    1. Updated application to load JSON file if found, otherwise it will load ini file
    2. Hotlaps data are now being updated instantly (within a minute). Before it used to wait for session to be finished.


    Change log v0.9.1.2:
    Web

    1. New screens in the Results section (plus graphs section for lap progression).
    2. Faster loading of Driver stats (top 30) and Last Session results.
    3. New Maintain Car Class screen. Now admin can change the colors for each class to be used when rendered on track.
    4. League Management section - this is in early beta and I included so that you get the feel and give me feedback on it.
    5. Added components that can be used separately as shown below. If sessionId is empty/omitted, it will take the value from the server list
    6. Some bugs and fixes.
    Listener
    1. Memory leak fix.
    2. Better handling of mySQL errors.

    Change log v0.9.1.3:
    Web

    1. League Management section - update/fixes as requested by communities.
    2. Translation module - now users can choose their language
    3. Faster loading of Driver stats (top 50) and Last Session results.
    4. Added the components links page in Admin section. You can then use the generated link directly in your web site.
    5. Some bugs and fixes.
    Listener
    1. Bugs and fixes.

    Change log v0.9.5.0:
    Web

    1. League Management section - update/fixes as requested by communities.
    Listener
    1. Stream to External and Internal IPs

    Change log v0.9.6.0:
    Listener
    1. Memory leak fix with the Listener.
    a. This should be fixed as it was extensively tested but please let me know if you encounter the issue again. I have put the memory used by the app on the main window of the listener. Note that if many users are
    connected to the web, the ram is expected to go up, but should not keep going up until it crashed.
    b. Some bug fixes to the listener
    Web
    2. The web widgets on the main live timing page have been improved.
    a. All grids (including video) can be re sized, moved around or closed altogether
    b. The timing grid has 3 extra buttons on top
    (i) Choose driver from list and then its highlighted on grid and map
    (ii) User can decrease or increase the font size

    3. Proper team name has been added to the grids

    4. Some fixes to the league stuff as reported by some.

    5. Added the horizontal server list widget in the components section


    Download links:
    Full Install 0.9.7.0: Discontinued
     
    Last edited: Apr 25, 2017
  2. steeve

    steeve Registered

    Joined:
    Jan 9, 2012
    Messages:
    87
    Likes Received:
    0
    Nice work, I will follow this project because I am very interested ....
     
  3. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    Cool, thanks Steve. If anyone is interested to help me test it, send me a pm, I'll give the install files, help install etc so that I can clear up all the bugs and see how it behaves on a server rather than my local pc. I still have lots to iron/update, but we I'll get there soon :)

    Thanks!
     
  4. Neuro

    Neuro Registered

    Joined:
    Jan 12, 2012
    Messages:
    53
    Likes Received:
    0
    Looks very promising. Keep up the good work! :cool:
     
  5. TIG_green

    TIG_green Registered

    Joined:
    Jul 21, 2012
    Messages:
    3,038
    Likes Received:
    44
    Yet another interesting software :)
     
  6. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
  7. GT_ONE

    GT_ONE Registered

    Joined:
    Dec 25, 2011
    Messages:
    272
    Likes Received:
    9
    Nice work, I will follow this project :)
     
  8. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    Thanks :)

    I need to do some testing to see how the system behaves. Especially the Listener/Loader and the track/car map rendering. System is not polished yet and still lots to do, but I would like to see how certain functionality behave.

    So...if you have:

    1: An rFactor 2 game server with .Net 4.0/4.5 (see point A below) installed.

    2: A web server with IIS (see point B below) and .Net 4.0/4.5 installed. Ideally, this will be the game server but if not, don't worry, the system has inbuilt web services. However note that if you'll have separate web/game servers, the web app could be slower.

    3: mySQL 5.x installed where the web app is hosted. Again, the loader/listener can use web services.

    Components required:
    A: .Net 4.0 or 4.5 can be found here (http://msdn.microsoft.com/en-us/library/vstudio/5a4x27ek(v=vs.100).aspx). If you do a windows update, this will be updated automatically or you can manually download the .Net4.0/4.5 from MS website.

    B: IIS (Internet Information Services). This comes with your windows CD. More info can be found here (http://www.microsoft.com/web/platform/server.aspx)

    C: mySQL can be found here (http://dev.mysql.com/downloads/)


    ....then send me a PM, and I'll give you the install files and will guide you with installation if need be. This project is for the community, so the better we make it, the more the community can benefit :)


    Thanks!
     
  9. Fergy

    Fergy Registered

    Joined:
    Jan 12, 2012
    Messages:
    597
    Likes Received:
    26
    Great work;)
     
  10. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    Thanks Fergy :)

    Paul is supposed to be helping me with testing the app. Hopefull, he'll have some spare time soon :)
     
  11. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    I've put up a demo for those interested. Game server will be down most times so data might be static.
     
    Last edited by a moderator: Oct 28, 2014
  12. TIG_green

    TIG_green Registered

    Joined:
    Jul 21, 2012
    Messages:
    3,038
    Likes Received:
    44
    Is it possible to add also sector 3 times separately?

    Looking good ;)
     
  13. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    What is Sector 3 TIG_Green? I did not see it in the plugin :confused:
     
  14. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    For those who do not have IIS, well good news, they can use the FREE UltiDev Web Server Pro Build 18 (v. 2.0.18) found on http://ultidev.com/Download/

    It's quite easy to install. I tested it and put up the website in 5 minutes. Contact me if you need help installing it ;)
     
  15. Paul Swire

    Paul Swire Registered

    Joined:
    Jan 21, 2012
    Messages:
    168
    Likes Received:
    6
  16. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    Update:

    Live Timing software:
    Version 0.1:
    Phased out

    Version 0.2:

    Notes:
    1. Plugin and Loader have not been updated in v0.2, so no need to run setup for these again if upgrading.
    2. The website needs to be refreshed. So backup your web.config to keep the paths you had entered before then update the new config manually. You can keep the images folder but just overwrite it with the new one.
    3. The database folder has new scripts. If updating from version 0.1, you only need to run script 3 to 6 first. Once the website is up, change the password.

    Change log:
    1. Web site has been updated for cross browser compatibility.
    2. It has also been updated to handle different country formats (especially DE)
    3. Added security to certain pages, specifically Draw Track
    4. Lowered the site header for better compatibility with smaller devices

    PS: I don't bite. So feel free to message me if you need help with the installation.
     
    Last edited by a moderator: Oct 28, 2014
  17. Paul Swire

    Paul Swire Registered

    Joined:
    Jan 21, 2012
    Messages:
    168
    Likes Received:
    6
    Great work B1K3R :D
     
  18. GT_ONE

    GT_ONE Registered

    Joined:
    Dec 25, 2011
    Messages:
    272
    Likes Received:
    9
    Last edited by a moderator: May 16, 2013
  19. B1K3R

    B1K3R Registered

    Joined:
    Apr 6, 2012
    Messages:
    1,605
    Likes Received:
    88
    You are welcome :)

    In your TS_piste.html, change width="950" to width="100%" in iframe :)

    It will look better
     
  20. Nibiru

    Nibiru Registered

    Joined:
    Dec 24, 2011
    Messages:
    1,200
    Likes Received:
    1,293
    Huge thanks to B1K3R for his help in getting my system up and running. Like he says above he doesn't bite, he is very friendly and very helpful. Keep up the great work mate. :cool:
     
    Last edited by a moderator: May 19, 2013

Share This Page