Now where did I keep my achievements?
Having trouble keeping track of all of your gaming achievements? Then allow this .NET Core app to help. Add and keep track of game achievement counts to have a clean view of all of your achievements.
Features Include:
- Grand total and percentage for all games combined
- Ability to add as many games as you like
- Percentages keeping track of achievements for each game
- Able to edit games anytime you need
This application was created on my free time and I wanted to put some of my new .NET Core skills to use. The main objective of this app was to recreate an Excel sheet that I had that does the same thing, but only to make it more seamless and easier to use. The way the app works is that it connects to a MySQL database on my own local WAMP server. From there you can the add a game, edit the achievement earned or max achievements need, or delete the game needed.
The first thing I did was created some test data to make sure I could read it from the database first, the test data was they key part of making sure that everything could work. Once the data was created, I needed to make my table next. By making sure that the table columns was close to or the exact same as the database columns, it made making the table a very easy job. Once the table was made, the next task was to add games to the table.
From previous lessons in our Web Application Programming course, we were taught on how to securely add data to a MySQL database. The main point… NO CONCATENATIONS. If anything was to be concatenated, it can easily be grabbed my hackers and ruin everything in the database. Now, this app is just being run on my own localhost server, so security is not really a problem, but it best to approach each app as you are making it for the public.
A couple things I want to improve in this app is sorting everything altogether. Right now it sorts by the name, but there may need to be a time where I need the AchievementTracker to sort by percentage or the number of achievements earned. This will require some database manipulation, but it will allow for a better user experience. Another feature that I want to add is allowing the user to add goals into the app so you see yourself working towards a value that you assign yourself. This may require some page work and additional database needs, but if I was able to add this feature, I would of completely remade the master excel sheet that I have originally made.
Want to run the app yourself, you can do it here. Please note: while Microsoft Azure is free for students, it will run slower than a usual app.
Want to take a look at the code and download it? You can see it here on my GitHub repo.