Design Document For DRAFT1846
Introduction
DRAFT1846 has been designed to look and feel as much like BOARD18 as possible.
This means that a couple of the sections of the BOARD18 design document can be applied, for the most part, directly to DRAFT1846.
These sections are:
The diagram to the right shows the general control flow between the DRAFT1846 components.
Database Structure
The DRAFT1846 database is structured as follows:
mysql> show columns from draft_table; +---------------+------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+-------------------+-----------------------------+ | draft_id | int(11) unsigned | NO | PRI | NULL | auto_increment | | draft | text | YES | | NULL | | | activity_date | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +---------------+------------------+------+-----+-------------------+-----------------------------+ 3 rows in set (0.00 sec)
The draft field is a text string containing the stringafied JSON data object as shown below.
JASON Data Object
This Object contains all of the information about a given draft except for the Draft ID.
array ( 'status' => 'Active', 'updtCount' => 0, 'numbPlayers' => 4, 'curPlayer' => 1, 'deck' => array ( 0 => 'Ohio and Indiana', 1 => 'Michigan Central', 2 => 'Meat Packing Co.', 3 => 'Blank Card', 4 => 'Mail Contract', 5 => 'Big 4', 6 => 'Tunnel Blasting Co.', 7 => 'Blank Card', 8 => 'Michigan Southern', 9 => 'Blank Card', 10 => 'Blank Card', 11 => 'Chicago and W. Indiana', ), 'hand' => array ( ), 'players' => array ( 0 => array ( 'name' => 'Paul', 'email' => 'paul.zieske@gmail.com', 'confirmed' => 'Yes', 'cash' => 400, 'privates' => array ( ), ), 1 => array ( 'name' => 'Chris', 'email' => 'garden.nomad@gmail.com', 'confirmed' => 'Yes', 'cash' => 400, 'privates' => array ( ), ), 2 => array ( 'name' => 'Rich', 'email' => 'rich02@board18.org', 'confirmed' => 'Yes', 'cash' => 400, 'privates' => array ( ), ), 3 => array ( 'name' => 'Frank', 'email' => 'franktaw@netscape.net', 'confirmed' => 'Yes', 'cash' => 400, 'privates' => array ( ), ), ), 'return' => 'success', )
This page is a stub. |
The BOARD18 Project will soon be expanding it. |