It has been less than a year since I officially release Royfuss Games, and now I have completely overhauled it. I took what I learned about web development, and applied it to my favorite project site. I am overjoyed with the results!
First off, it is officially mobile friendly! Pico helped a lot with it. Some pages have elements that are wider and bleed a little bit, but it is hard to notice. I am excited I can check on my collection on my phone without constantly adjusting the zoom. I needed to make the header images wider and taller, so they currently stretched to fit when viewing on a computer. It will be nice to use larger screenshot snippets, but I will be updating existing ones.
Second, I am really proud of the new search! I took some JavaScript knowledge, and made a more robust search. Searching by game name offers a lot flexibility. I also created searches that allow you to select consoles, stores, and launchers. In addition to returning results, it will also tell you the number of results. I like it, and have used it a lot.
Thirdly, I expanded the navigation, while making it mobile friendly. I am not a big fan of hamburger navigation structures, but I think it works well for this site. I also added a handy “back to top” button when you scroll down on any page. The new navigation structure allows me to expand the site.
Speaking of expanding the site, I added achievement pages to it! I have some stats to give you an idea how big of an undertaking this was. My database was 453KB with all of my gaming collection and data before achievements. After adding achievements, it ballooned to 2.33 MB; that’s almost two floppy disks! My game table is 836 rows, my obtain table (ie. game copies) table is 909 rows, and my session and archive session tables are 2,615 rows combined. My new achievements table blows all of them out of the water. It comes in at a whopping 13,330 rows! It took me so long to import all of those achievements, and I am not quite done. I skipped a few games, like Payday 2 and Killing Floor. I played those games for a few minutes, and they have so many achievements; it was not worth the database space.
I’m happy with the site, but there are probably some errors. So far, most of the errors I have encountered are typos on my end. I will be fixing them. If you are curious about how I imported the achievements, I plan on doing a post in the future. Stay tuned!
Pingback: Scraping Achievements – Royfuss