As part of my support of the gaming community I belong to, and have been volunteering my time to support, I have been creating a software application for our players and our staff. This application now hosts a wide range of tools for players to engage with the server and learn more about the game while also consisting of tools for staff to manage and moderate our players.
This dual use architecture has led to development of a wide range of functionality from case management to crafting resources for the game. It is built with Next.JS as the underlying framework for our React development backed by a MySQL database and connection to that using a query builder. All queries are built to be reused throughout the application with permissions checks to exclude sensitive data from player views.
This application has been a focus of mine in my free time for the last two years and has evolved greatly. From online player statistics on the Player Portal, a Crafting Compendium, Account Profile, and Case Management tools the application is a passion of mine. I still continue to expand the use of the application whenever possible. Feel free to explore it at the link below.