My Game List
My Game List
The website’s purpose is to facilitate discussions about the community’s favorite games, and what makes
them good. In a perfect world, the discourse that will be spurred will give information to the gaming
industry about which mechanics gamers like, and hopefully, create more fun games all around the world.
A login module will also be needed, as we should be able to track down who posts and discusses. It will
also help to reduce trolls. However, the fact that people can curate their page, and personal ratings will
also help create a community.
Another important module will be the commenting and rating system. This is the main feature of the
website, so it should be flexible enough to make quick ratings, and also more comprehensive reviews.
Objectives
Our objectives will be focused on solving the problems found in the previous section.
The user table will be SHA-256 encrypted. That way even if the data gets leaked, there can be no
information that people can find or use. The columns in this database will be as follows: userType, email,
password, username, and userID.
The game table, will consist of the following columns: gameName, releaseDate, genre, synopsis,
developers, publisher, image, and gameID.
The review table will consist of the following columns: username, gameName, rating, comment, postdate,
likes, dislikes, and reviewID.
Over the course of development, the solutions for the modules will be found here as they are developed.
Scope
The scope of this project will be reviews about video games. The website can facilitate discourse about
video games. It will not let you play the games, but it will direct you to where they are downloadable.
Everything other than reviewing video games is not within the scope of the project. We are trying to make
a fun website where we can rate video games, not discuss politics, not cure cancer, and not find aliens.
Tools to be used
IDE: Visual Studio, Visual Studio Code, or Replit. Although it is likely not to be the main text editor of
use, chances are Notepad++ will be in there somewhere. Others, still need to be discussed with our
missing member. But this document will be updated as discussions commence.
DBMS: Either XAMPP or MSSQL, still need to be discussed with our missing member. But this
document will be updated as discussions commence.
Language: HTML, CSS, JS, others still need to be discussed with our missing member. But this document
will be updated as discussions commence.
References
MyAnimeList - https://myanimelist.net/
SHA-256 Advantages - https://www.encryptionconsulting.com/education-center/sha-256
Visual Studio Code - https://code.visualstudio.com/
Visual Studio - https://visualstudio.microsoft.com/
Replit - https://replit.com/
Notepad++ - https://notepad-plus-plus.org/
XAMPP - https://www.apachefriends.org/
MSSQL - https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Trello - https://trello.com/
Discord - https://discord.com/
HTML - https://developer.mozilla.org/en-US/docs/Web/HTML
JavaScript - https://developer.mozilla.org/en-US/docs/Web/JavaScript
Cascading Style Sheets - https://developer.mozilla.org/en-US/docs/Web/CSS