Most popular LoL stats tracker only give you records and analysis on your ranked/normal games, but none is made solely for ARAM games...until now
This is where you can keep track of your ARAM-centric scores, where we will give you the ultimate stats break down for all your random goodness. To see this app live please go to: https://aram-stats.herokuapp.com/
If you don't care about League of Legends and just want to see what the app does, you can type in my summoner name 'ragingoat' and see what it does.
League of Legends is an online MOBA(Multiplayer online battle arena) type game that is currently the most played PC game of all time, and has a professional league for the elite players around the globe competing for yearly championship titles.
ARAM stands for All-Random-All-Mid. This is the mode where the game map has only one lane and all 10 players from two teams duke it out to claim each other's nexus. While most serious/professional gamers don't play this mode, ARAM is quite popular among casual players who either don't have the time or don't want very competitive games like ranked game mode.
Due to Riot Games API restriction on normal game stats being made public, there's no way to get your historical ARAM game stats past the last 10 games that you've played. This means we can only start recording your stats right now, but it will continue to build as long as you check back in.
No, due to this app being a hobby project, and to limit bandwidth and memory usage, the database server only retrieves new data when you query your summoner name.
No, I only pull 5v5-Unranked-ARAM-queue match statistics.
ARAM Stats is built with:
- Server Side: node.JS, expressJS,Socket.io
- Database: PostgreSQL (9.5)
- Client Side: AngularJS, Bootstrap, Compass*
To use this web app, you must have an active League of Legends account (create account/download the game here: https://signup.na.leagueoflegends.com/en/signup/index?realm_key=na), and you must have played a game of in ARAM mode in your last 10 games to see any data.
You can check out mine and a few of my friends accounts for evaluation:
- ragingoat
- haywires
- ebpally
- I first set up a local postgres server (9.5 or above to get the newest features such as ON CONFLICT/IF NOT EXISTS) using node.js and expressJS for development.
- Get Riot API Key to start playing with json data, and narrow down the essential data to store into my local database.
- I ended up creating 4 tables: summoner, champion, game, and summary.
- This makes it easier to join the tables while making queries, getting exact summoner/champion info as needed. Most of the changes to data occur in game and summary tables.
- Set up all the queries I care about, such as overall KDA(Kill-death-assist ratio), most kills, or most gold earned and build into a routine for easy retrieval.
- Once all the queried data return correctly, develop client side app using AngularJS for displaying data.
- Deploy using heroku.