AR Ranking

Motivation

AirRivals, the EU Version of Masangsofts Aceonline (former SCO), published the highscores once a day and only of the current day. It was not possible to view previous days.

Therefore, in 2012 I wrote a program that saves the data once a day, and this website to make it publicly accessible, aswell as performing deeper analysis on the data (progress/day, Nation-balance).

Dataset

The first day data was recorded is the 2012-07-27, since then up to the 2016-08-24 - the day AR.de closed its gates - 1163 days are recorded. Unfortunately, mostly in the beginning, some days are missing, because the import wasn't stable. Since the 2014-01-05 every day is on record.

Methodology

AR.de published 5 tables every day: level, fame, brigade_total, brigade_monthly, pvp (duels). These were copied without modification/normalization into the same schema. All processing for views is done using complex joins on these tables.

Data

If you want to dig into the records yourself you are encouraged to! All historical data is directly available:

Download the MySQL Dump

Use the API as this website does (CORS is enabled): api.vi0lation.de