week 13 Trade show

In our final trade show, we get the positive feedback on our main project. Cheers.

Our final project is showing below. You can test our website at http://deco1800-50.uqcloud.net/.

Technical Discussion & Components

Main components

Elements and roles: Setup database, Write All server side code, Write HTML Code (rank.php), Write CSS Code (style.css),

Facts:

Datbase has been fully setup and operational. Tables has been created and data have been inserted.

Server side codes has successfully implemented a login system, this contains user login information check, php session store and send cookies to client side and display login/logout button depends on user’s login information.

Server dies codes has successfully implemented a ranking system, this contains current user check, updating user’s highest score with database, retrieve highest score information and find a user’s overall position.

Front end html code rank.php has been written to support ranking system, this contains html codes and integrate style.css to rank.php.

Front end css code style.css has been written to support ranking system.

Components working together

Modify CSS Code (styles.css)

Others’ work, they defined classes in css file.

My work, I combined them together. I have received many css files and each of them is for a single page. To make it more standard, I have been modified all css files to make them unified.

Transform front end code to be back end compatible (All files ending with .php, most of javascript files)

Other’s work, they write html code and java scripts.

My work, I modify them to become back end compatible. I have received files ending with .html. To running it on php server, I have changed them to php and modify all links. Most of the page has been inserted php codes to support login system and to be php compatible.

Week 12 IMPLEMENTATION

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.

Week 11 Digital Prototype testing

Because of the time rushing these weeks, the front end code and the back end code has not been components already. In order to get the last feedback from user before the trade show and final delivery,  we decided to test the front end website and the back end rank list with login system respective so that it would not influence our feedback collection.

Our feedback collection is showing below. 

week 10 The data base setting and login system setting

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.

Login details and Instructions

We have setup five user accounts. They accounts information has been listed below:

Username: user1 Password: password

Username: user2 Password: password

Username: user3 Password: password

Username: user4 Password: password

Username: user5 Password: password

For the database, as it is for assignment only and not designed to release to public, considering local connection is pretty safe for an assignment test environment. We currently using no password for database. If we are going to release it to public, we will setup a password for it. We already designed a configuration file called database.php (in user folder) to do this.