LaKKT

LaKKT used to be an analysis tool for the strategy game Lords & Knights. It kept track of all the castles owned by all players on the map and can help tracking captures and losses, can generate maps, calculate distances and attack times as well as helping the players organize their defenses.

I build this software with a few other players of the game. It is build using Bootstrap as the JS/CSS library with a backend written in pure PHP, without any frameworks used. It used an MSSQL database. A previous version of this tool has been written in .NET, which we did port to PHP. The data import, which was executed as a cron job, has been ported from .NET to C#.

In the end, it stored about 2GB of data from about 40 different maps. The data was collected over a period of three years. This data includes all the castle wins/losses, their construction status and every renaming of every castle or player happened in these three years. Based on this data, the system could generate reports about the activity of other alliances spotting inactive or infrequently playing players.