Dirt Rally

How This Site Works

Short annotation about this site:

GitHub link: https://github.com/VertexyLV/DirtRallySiteProject

You can contact me on STEAM (Vertexo) or enzolv21@gmail.com

This project emerged from my hobby - esports racing simulator (simulator/game - Dirt Rally).

This hobby project includes competition statistics database and website for Dirt Rally racing simulator. The website is published and currently used by Dirt Rally clients. At the base of the project is data scraping from the game’s official website. Python and Django framework are used for back-end programming. PostgreSQL as database and DigitalOcean as cloud service on Ubuntu operating system. HTML, CSS and JavaScript are used for front-end design. I taught myself programming and web development by making this site.

The reason I made this leaderboards site is the lack of statistics and ranks on the official Dirt Rally website. Therefore it is quite hard to valuate competitors by their skill level. On the original website, there are no appropriate long term leaderboards or ranks to determine the best or the fastest competitor by completed events. On this project's website I have accumulated data and statistics for top 1st place, in top 3 places, in top 10 places finishers and many other statistics. The same all statistics have been calculated by countries also.

This site will scrap all completed events information from official site and upload it on the server.

In upper right corner of the site you can see "Database active since: 07.27.2018". It is the date I started working on this site and scraping official events data. So the oldest Daily and Daily 2 event on this site is from 07.27.2018.

Site update time:

The official site updates new challenge entries every day at 10:00 (UTC).

This site will update completed leadearboards every day between 12:00 and 13:00 (UTC).

The 2 hour offset is necessary for minimizing data scraping interuptions due to official site not fully updated yet.

About Leaderboards page:

In Leaderboards page you can find 2 total leaderboards. Top Drivers and Top Countries leaderboards.

Top Drivers:
First is Top Drivers leaderboard in whitch all qualified drivers are sorted by one of the sorting parameters. Default sorting parameter is Points. Driver is qualified (put in the leaderboards) if he/she has completed at least 3 events overall. This was done to try to eliminate cheaters from ruining leaderboards. So if you want to see yourself in Top Drivers leaderboard, you have to complete at least 3 events of any kind.

Top Countries:
Second is Top Countries leaderboard in whitch all qualified drivers from each country are added together.

About Stats page:

In Stats page you can find 2 pages. Driver Stats and Country Stats.

Driver Stats:
First is Drivers Stats where all the stats for one specific driver are displayed.

Country Stats:
Second is Country Stats where all the stats for one specific country are displayed.

About All Events page:

In All Events page you can find and look at every individual event leaderbord from each category. Basically it is the same Events page as on the official Dirt Rally site, except that this site saves more than only last 10 events from each category. Plus there is aditional column of Point added to the tables.

How Points are calculated:

To give some life to the leaderborads and may be also to give reason to compet agains each other I have added Points system. Points for Daily, Weekly and Monthly events are calculated a little bit differently. The higher a driver finishes in particular event the more points he/she will get. Points ar dependent of total participants. In Daily and Daily2 events, drivers can actually lose points by finishing in bottom half. To get positive position point, driver has to overtake more drivers than are ahead of him at the end of the event. Top 100 and top 10 finishers get extra base points.

Excel link: Dirt Rally event points scoring examples.xlsx

Future implementations:

I have to figure out the best way to determine and rank most skilled drivers. Right now I have set default leaderboard sorting by Points. The methods how points are calculated are quite arbitrary, so it is probably not the optimal way. Percentage of Top 10 finishes also I thing would be a good way to determine the skill and stability.