WebUI

WebUI

Databases

We are using two separate databases (db1 and db2) to store user information. Db1 has a Customer table that stores usernames and passwords. This information is kept separate as a security measure. Db2 contains a Customer table that stores less sensitive information about the user (first name, last name, email address, birthday, and gender). Db2 also contains a gamesPlayed table that stores basic game history information. Each Vir-Pong match will be a new row in the table (game ID, username of player 1, username of player 2, score of player 1, and score of player 2). Please note that since db1 and db2 are separate databases, you will need to connect to both of them if you would like to access all this information. The database structure is as follows.

db1

Customer table

username

password

db2

Customer table

username

firstname

lastname

email

birthday

gender

gamesPlayed table

gameID

username1

username2

score1

score2

Layout

The Vir-Pong website layout will eventually be skinned such that the user can select a color theme that suits their preferences. Currently, we have two color themes: Vir-Pong Classic and Logger Pride.

Hex Color Codes

Vir-Pong Classic: dark blue, golden yellow, light blue

#001166

#DDAA11

#7788CC

Logger Pride: maroon, dark gray, light gray

#800000

#999999

#DDDDDD