Board Game Arena

Code: Select all

CREATE TABLE IF NOT EXISTS `tfs_gameboard_tiles` (
  `position_h` int(1) NOT NULL,
  `position_v` int(1) NOT NULL,
  `card_id` int(10) DEFAULT NULL,
  `properties` text,
  `player_id` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Code: Select all

INSERT INTO `tfs_gameboard_tiles` (`position_h`, `position_v`, `card_id`, `properties`, `player_id`) VALUES
(0, 1, NULL, NULL, NULL),
(0, 2, NULL, NULL, NULL),
(0, 3, NULL, NULL, NULL),
(1, 0, NULL, NULL, NULL),
(1, 1, NULL, NULL, NULL),
(1, 2, NULL, NULL, NULL),
(1, 3, NULL, NULL, NULL),
(1, 4, NULL, NULL, NULL),
(2, 0, NULL, NULL, NULL),
(2, 1, NULL, NULL, NULL),
(2, 2, NULL, NULL, NULL),
(2, 3, NULL, NULL, NULL),
(2, 4, NULL, NULL, NULL),
(3, 0, NULL, NULL, NULL),
(3, 1, NULL, NULL, NULL),
(3, 2, NULL, NULL, NULL),
(3, 3, NULL, NULL, NULL),
(3, 4, NULL, NULL, NULL),
(4, 1, NULL, NULL, NULL),
(4, 2, NULL, NULL, NULL),
(4, 3, NULL, NULL, NULL);

Code: Select all

self::getCollectionFromDb("SELECT * FROM tfs_gameboard_tiles")

Code: Select all

array(5) {
  [0]=>
  array(5) {
    ["position_h"]=>
    string(1) "0"
    ["position_v"]=>
    string(1) "3"
    ["card_id"]=>
    NULL
    ["properties"]=>
    NULL
    ["player_id"]=>
    NULL
  }
  [1]=>
  array(5) {
    ["position_h"]=>
    string(1) "1"
    ["position_v"]=>
    string(1) "4"
    ["card_id"]=>
    NULL
    ["properties"]=>
    NULL
    ["player_id"]=>
    NULL
  }
  [2]=>
  array(5) {
    ["position_h"]=>
    string(1) "2"
    ["position_v"]=>
    string(1) "4"
    ["card_id"]=>
    NULL
    ["properties"]=>
    NULL
    ["player_id"]=>
    NULL
  }
  [3]=>
  array(5) {
    ["position_h"]=>
    string(1) "3"
    ["position_v"]=>
    string(1) "4"
    ["card_id"]=>
    NULL
    ["properties"]=>
    NULL
    ["player_id"]=>
    NULL
  }
  [4]=>
  array(5) {
    ["position_h"]=>
    string(1) "4"
    ["position_v"]=>
    string(1) "3"
    ["card_id"]=>
    NULL
    ["properties"]=>
    NULL
    ["player_id"]=>
    NULL
  }
}

Code: Select all

CREATE TABLE IF NOT EXISTS `tfs_gameboard_tiles` (
  `row_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `position_h` int(1) NOT NULL,
  `position_v` int(1) NOT NULL,
  `card_id` int(10) DEFAULT NULL,
  `properties` text,
  `player_id` int(10) DEFAULT NULL,
   PRIMARY KEY (`row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;