The CTPP project we have joined is an interactive 3D game which simulates natural disasters. This first project is on Earthquakes, but future iterations will see this extended to cover other natural disasters, for example tornadoes.

The vision of our part in this project is to create an event tracking, storing, and restoring system, which will have multiple uses. It will also be useful and extendable past the life cycle of this project.

We have three main components to this project:

1. A MySQL database which will store player stats associated with a user id, session id, and timestamp, along with similar stats for object types which exist in the game. These will be organized into a relational model to allow modules developed around it to ascertain unique and useful information about these statistics and events.
   
   
2. An event translator, which will be able to listen for any events which the database is to store, translate them into a query string, and post them to the database. The event translator will be modular in such a way that it can be easily modified to support new incoming message types not forseen at this stage of the project, or even to post to new database/persistant storage not planned for at this time.
   
   
3. Multiple Query Modules, which will read predetermined information from the database, in order to present useful information to the user/system.
   
   
• Game Save Module: Stores information about a game session suficient to allow restoration at a later time.
  
  
• Game Load Module: Given a game save, retrieves information needed to restore game session.
  
  
• Results Analysis Module: Upon completion of a game session, returns a detailed analysis of the players performance, along with a grade based on preset (and editable) criteria.
  
  
• Real Time Status Update Module: Supports real-time updates on the progress of the player during gameplay, at least 1x per second, with the goal of 10x per second support.
  
  
• High Score Module: Retrieves a list of High Scores from all stored and completed game sessions.