IMPLEMENTATION
o how
does the system work(database )
Our
back-end side which is running on server is powered by PHP. We choose php for
its efficiency and also because it is supported by UQ. Our back end system
mainly used to manage user login and highest score rank system. We have created
a login system so user can login with their own credentials. After user played
their game and get a score, a score will be posted to our server. Then server
check if this user made a higher score than before. If it is the case, the
server will update its score information by updating relative information in
database. If it is not the case, server will just ignore it.
|
Name
|
Type
|
|
Id
|
Int(Primary)
|
|
Username
|
Char
|
|
Password
|
Char(MD5
Encrypted)
|
|
Highest
score
|
Int
|
In
this table, id is a self-incremental variable that is used to identify users.
This has been set to int and used as a primary key. As it is a primary key, the
value of id also should be unique. Username is the actual nickname of users,
this is mainly used for display names on rank page. Password is the password
that user can used to login to the system. For security reason, this database
does not store the password itself directly, instead, an md5 encrypted value
has been stored. When user try to login, it will see if the md5 from user’s input
match what is stored in database. Highest score is used to store the score of
user’s highest achievement. When display the rank on rank page, this is used
for reference of rank position and it has been used to display at rank page
too.
Our
database is based on MySQL. In this database, there is only one table. The
table information has been listed below.
o What
is fully functional
Login
system is fully functional and our login page and redirect user back to where
it come from after user logged in.
Our
ranking system is fully functional. This system is not only show the first
three highest score winner, but also displays user’s position. For example,
user may not be able to get into first three positions and currently ranked at
5. Our ranking system will tell user he or is currently positioned at 5. This
will encourage user to be more engage in this game.
Our
database system have been setup and fully functional to support these systems.
没有评论:
发表评论