The Shelf: Game Catalog Website

Website allows users to maintain a virtual collection that is based on their personal collection. Users are able to add and remove games in their own collection, or view games in the database and other collections. Those without an account are only able to view the games in the database, as well as view user's profiles and their collections.

How to run

Install XAMPP

Place entire project in htdocs

Create the database, named Game_Database

Use queries in sql/Game_Database.sql to populate database

Update MySQL user and MySQL password in php/dbConnect.php

---

Update Log

UPDATE 11/29/21

• Implemented static pagination
  • Personal profiles supported
  • Removing games supported
  • Adding games supported
  • Viewing other profiles supported
• Updated Add Games
  • Updated UI
  • Added console sorting
  • Fixed adding games on multiple consoles
• Updated viewing other user's collections
  • Can now sort through other user's games
• Various bug fixes

---

UPDATE 11/15/21

• Implemented Viewing Profiles
  • View profiles from searched users
  • View your own profile
• Implemented Editing Profiles
  • Update profile images
  • Update profile information
• Various bug fixes

---

UPDATE 11/08/21

• Implemented 'database.php'
  • Search through database's games implemented
  • Implemnted beta version of looking up users in the database
    • If a user is signed in, they cannot search themselves
• Added filters to removing games from collections
• Various UI updates
• Began implementing user profile page

---

UPDATE 10/18/21

• Implemented adding games to the database: MOD only feature
• Viewing: Now pulls console list from user's collection
• Display what filters were chosen
• Added Genre filters to view games
• DATABASE UPDATES:
  • Added GENRES table
  • Modified GAMES table to include genreID variable

---

UPDATE 10/11/21

• Implemented console sorting when viewing collection
• Began implementing adding games to the database forms
  • MOD only feature

---

UPDATE 10/3/21

• Implemented adding games to collections
  • Implemented search functionality
• Add filter functionality to 'View Collection' page

---

UPDATE 10/02/21

• Implemented basic version of 'View Collection'
  • Filter variable supported (needs work)
• Implemented removing games from collections

---

UPDATE 9/26/21

• NEW USERS: Content is saved if account creation fails
• Began work implementing 'Edit Collection'
• Name proposal: The Shelf
• Updated site presentation

---

UPDATE 9/19/21

• Fixed password hashing and storage
• Implemented Forgot Username/Password page
• Updated about.php

---

UPDATE 9/18/21

• Merged all initial files from patch-1 branch