[2019] Last week I rewrote our entire backend for stats on Leaguepedia, and there's a bunch of cool new things possible now!

So first of all everything loads WAY faster, and a ton more data is able to be processed per page. So we can start doing a lot more things like cumulative MSI champion and player stats.

Stats are also now agnostic to a player namechanging in the middle - it doesn't matter that Wunder was Wunderwear at the start, he'll just be displayed as the last ID he played on within that time frame.

And our stats queries are now a lot nicer! There's an option to show net values instead of per-game if you want to check total values over a period of time or tournament or whatever.

Also, our player yearly stats pages are now 100% dynamic - previously we had a script that added the needed tournaments, but it had to be run per tournament, and the tournaments were hard-coded into the page. Now, the entire page will populate itself! (And it's waaaaaaaaaay faster!)

The backend for this is Cargo, which is a SQL wrapper - so you can do your own queries too! If you look at the bottom of the form, I show you the WHERE condition of the current query, and you can edit it to make you own if you want. I'm insanely busy this week before summer starts but in the 1st or 2nd week of summer split I'll write a user guide for this with docs on our tables.

I'm infinitely excited about this - from a technical pov this was the last piece of the wiki still running on SMW, and now we are 100% on Cargo, and there are soooooo many things that are possible now! I'm also super happy to talk about how the queries work so feel free to ask me in the comments, or if you have coding experience & want to start contributing to the wiki that would be awesome! (on-wiki stuff is mostly Lua, there's also some Python and JS involved)