home



here you go



Phase 5 (summit)

Website

Possible Quires

current version of game (12/14/2010)

Phase 4

images needed for game code help

games schema for data transfer Updated the table into this relational schema: I believe that build_time, dead_time and runtime need to be changed from date to binary_double to match the time given from XNA.

-> Removed GP_Name from GamePiece and replaced it with type

PLAYER

P_Name - char(20) - not null - primary key

Game

G_ID - number - not null - primary key

Final_Score - number - not null

Runtime - binary_double - not null

Version - char(10) - not null

Played_By - char(20) - not null - foreign key references Player (P_Name)

GamePiece

GP_ID - number - not null - primary key

Build_time - binary_double - not null

Dead_time - binary_double - not null

Used_in - number - not null - foreign key references Game (G_ID)

type - number - not null

Ship

GP_ID - number - primary key - foreign key references GamePiece (GP_ID)

Enemy

GP_ID - number - primary key - foreign key references GamePiece (GP_ID)

E_Level - number - not null

Weapon

GP_ID - number - primary key - foreign key references GamePiece (GP_ID)

W_Level - number - not null

W_Owner - number - not null - foreign key references GamePiece (GP_ID)

Missile

GP_ID - number - primary key - foreign key references GamePiece (GP_ID)

DMG - binary_float - not null

Target - number - foreign key references GamePiece (GP_ID)

Health - binary_float

M_Owner - number - not null - foreign key references GamePiece (GP_ID)

GameDates

G_ID - primary key - foreign key references Game (G_ID)

datetime - timestamp - not null

CREATE OR REPLACE TRIGGER gameINSERT

AFTER INSERT ON game REFERENCING NEW AS newRow FOR EACH ROW

BEGIN

insert into gamedates values (:newRow.G_ID, sysdate);

END;


 * Project Concept:**

The general idea of the program is still intact from the last phase. We are going to mine data from a video game and use this data to make the game better (through balancing and such). Instead of using the game //Starcraft 2// for our project, we will be creating our own game. The game will be a shmup (side-scrolling shoot ‘em up).

//DataCraft 2// is meant to speed up the process of game-balancing, by finding problem areas that game developers can focus their efforts towards. //DataCraft 2// is a two part process, starting with data-mining. Various players will play through our game that we create. Behind the scenes, we would be recording statistics of the game. These include which ship the player chose, which weapons the players used, how far they got through the game before losing, etc. The next step in the //DataCraft 2// process would be analyzing the repository of data that is created after players have completed a reasonable amount of games. We could look for any number of things, one being for enemies that are too strong. If one type of enemy ship has the majority of kills, then we could focus our efforts on balancing that particular ship type.


 * Application Requirements:**

1. A game that we can extract data from. 2. A database to hold all of the data from various playthroughs of the game. 3. A web application that can communicate to the database, so that anyone could view statistics from the game.
 * Functionality:**

1. The game will be built in flash. 2. The game will send database queries to a Java socket server. 3. The Java socket server will forward these queries to our database. 4. The web application will be a simple web page (that has a text box where people can type in queries) that will communicate with the database using php.

**ER diagram****: **
 * link


 * Team Members:**

Bill Decker Chris Williams Xinyi Wu