-- phpMyAdmin SQL Dump -- version 2.11.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 26, 2013 at 12:59 AM -- Server version: 5.1.58 -- PHP Version: 5.2.17 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `a5481727_adwd` -- -- -------------------------------------------------------- -- -- Table structure for table `Allies` -- CREATE TABLE `Allies` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` text COLLATE latin1_german2_ci NOT NULL, `Deck` int(11) NOT NULL DEFAULT '0', `Owner` int(11) NOT NULL DEFAULT '255', `Position` int(11) NOT NULL DEFAULT '0', `Display` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=49 ; -- -- Dumping data for table `Allies` -- INSERT INTO `Allies` VALUES(1, 'Arryn Army', 1, 255, 5, 0); INSERT INTO `Allies` VALUES(2, 'Arryn Leadership', 1, 255, 1, 0); INSERT INTO `Allies` VALUES(3, 'Arryn Military Support', 1, 255, 3, 0); INSERT INTO `Allies` VALUES(4, 'Arryn Plots', 1, 255, 0, 1); INSERT INTO `Allies` VALUES(5, 'Arryn Political Support', 1, 255, 4, 0); INSERT INTO `Allies` VALUES(6, 'Arryn Lookout', 1, 255, 2, 0); INSERT INTO `Allies` VALUES(7, 'Tully Army', 2, 255, 4, 0); INSERT INTO `Allies` VALUES(8, 'Tully Leadership', 2, 255, 3, 0); INSERT INTO `Allies` VALUES(9, 'Tully Military Support', 2, 255, 0, 1); INSERT INTO `Allies` VALUES(10, 'Tully Plots', 2, 255, 5, 0); INSERT INTO `Allies` VALUES(11, 'Tully Political Support', 2, 255, 2, 0); INSERT INTO `Allies` VALUES(12, 'Tully Supplies', 2, 255, 1, 0); INSERT INTO `Allies` VALUES(13, 'Frey Army', 3, 255, 3, 0); INSERT INTO `Allies` VALUES(14, 'Frey Leadership', 3, 255, 1, 0); INSERT INTO `Allies` VALUES(15, 'Frey Military Support', 3, 255, 4, 0); INSERT INTO `Allies` VALUES(16, 'Frey Plots', 3, 255, 1, 0); INSERT INTO `Allies` VALUES(17, 'Frey Political Support', 3, 255, 0, 1); INSERT INTO `Allies` VALUES(18, 'Frey Galleys', 3, 255, 5, 0); INSERT INTO `Allies` VALUES(19, 'Sellsword Army', 4, 255, 2, 0); INSERT INTO `Allies` VALUES(20, 'Outlaw Leadership', 4, 255, 1, 0); INSERT INTO `Allies` VALUES(21, 'Outlaw Military Support', 4, 255, 4, 0); INSERT INTO `Allies` VALUES(22, 'Filthy Accusations', 4, 255, 0, 1); INSERT INTO `Allies` VALUES(23, 'Mercanary Raiders', 4, 255, 3, 0); INSERT INTO `Allies` VALUES(24, 'Mercenary Transport', 4, 255, 5, 0); INSERT INTO `Allies` VALUES(25, 'Bolton Army', 5, 255, 5, 0); INSERT INTO `Allies` VALUES(26, 'Bolton Leadership', 5, 255, 2, 0); INSERT INTO `Allies` VALUES(27, 'Bolton Military Support', 5, 255, 4, 0); INSERT INTO `Allies` VALUES(28, 'Bolton Plots', 5, 255, 1, 0); INSERT INTO `Allies` VALUES(29, 'Bolton Political Support', 5, 255, 3, 0); INSERT INTO `Allies` VALUES(30, 'Bolton Flayers', 5, 255, 0, 1); INSERT INTO `Allies` VALUES(31, 'Unsullied Army', 6, 255, 5, 0); INSERT INTO `Allies` VALUES(32, 'Dothraki Army', 6, 255, 4, 0); INSERT INTO `Allies` VALUES(33, 'Braavos Leadership', 6, 255, 0, 1); INSERT INTO `Allies` VALUES(34, 'Tyrosh Military Support', 6, 255, 1, 0); INSERT INTO `Allies` VALUES(35, 'Qarth Warlocks', 6, 255, 2, 0); INSERT INTO `Allies` VALUES(36, 'Varys Little Birds', 6, 255, 3, 0); -- -------------------------------------------------------- -- -- Table structure for table `ClaimTrack` -- CREATE TABLE `ClaimTrack` ( `First` tinytext COLLATE latin1_german2_ci NOT NULL, `Second` tinytext COLLATE latin1_german2_ci NOT NULL, `Third` tinytext COLLATE latin1_german2_ci NOT NULL, `Fourth` tinytext COLLATE latin1_german2_ci NOT NULL, `Fifth` tinytext COLLATE latin1_german2_ci NOT NULL, `Sixth` tinytext COLLATE latin1_german2_ci NOT NULL, `Seventh` tinytext COLLATE latin1_german2_ci NOT NULL, `Eighth` tinytext COLLATE latin1_german2_ci NOT NULL, `Ninth` tinytext COLLATE latin1_german2_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci; -- -- Dumping data for table `ClaimTrack` -- INSERT INTO `ClaimTrack` VALUES('Baratheon', 'Lannister', 'Greyjoy', 'Lannister', 'Baratheon', 'Baratheon', 'Baratheon', 'empty', 'empty'); -- -------------------------------------------------------- -- -- Table structure for table `Events` -- CREATE TABLE `Events` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Deck` int(11) NOT NULL DEFAULT '0', `Name` text COLLATE latin1_german2_ci NOT NULL, `Position` int(11) NOT NULL DEFAULT '0', `Text1` text COLLATE latin1_german2_ci NOT NULL, `Text2` text COLLATE latin1_german2_ci NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=61 ; -- -- Dumping data for table `Events` -- INSERT INTO `Events` VALUES(1, 1, 'Mustering', 5, '', ''); INSERT INTO `Events` VALUES(2, 1, 'Supply', -1, '', ''); INSERT INTO `Events` VALUES(3, 1, 'Mustering', 6, '', ''); INSERT INTO `Events` VALUES(4, 1, 'Supply', -1, '', ''); INSERT INTO `Events` VALUES(5, 1, 'Mustering', 8, '', ''); INSERT INTO `Events` VALUES(6, 1, 'Supply', 9, '', ''); INSERT INTO `Events` VALUES(7, 1, 'Throne of Blades*', 7, '', ''); INSERT INTO `Events` VALUES(8, 1, 'Last Days of Summer*', 4, '', ''); INSERT INTO `Events` VALUES(9, 1, 'Throne of Blades*', -1, '', ''); INSERT INTO `Events` VALUES(10, 1, 'Winter is Coming', -1, '', ''); INSERT INTO `Events` VALUES(11, 2, 'Game of Thrones', 5, '', ''); INSERT INTO `Events` VALUES(12, 2, 'Clash of Kings', 7, '', ''); INSERT INTO `Events` VALUES(13, 2, 'Game of Thrones', 2, '', ''); INSERT INTO `Events` VALUES(14, 2, 'Dark Wings, Dark Words*', 6, '', ''); INSERT INTO `Events` VALUES(15, 2, 'Clash of Kings', 8, '', ''); INSERT INTO `Events` VALUES(16, 2, 'Game of Thrones', 0, '', ''); INSERT INTO `Events` VALUES(17, 2, 'Last Days of Summer*', 1, '', ''); INSERT INTO `Events` VALUES(18, 2, 'Game of Thrones', 3, '', ''); INSERT INTO `Events` VALUES(19, 2, 'Clash of Kings', 4, '', ''); INSERT INTO `Events` VALUES(20, 2, 'Dark Wings, Dark Words*', 9, '', ''); INSERT INTO `Events` VALUES(21, 3, 'Wildling Attack', 2, '', ''); INSERT INTO `Events` VALUES(22, 3, 'Sea of Storms*', 5, '', ''); INSERT INTO `Events` VALUES(23, 3, 'Rains of Autumn*', 8, '', ''); INSERT INTO `Events` VALUES(24, 3, 'Feast for Crows*', 6, '', ''); INSERT INTO `Events` VALUES(25, 3, 'Wildling Attack', 0, '', ''); INSERT INTO `Events` VALUES(26, 3, 'Web of Lies*', 1, '', ''); INSERT INTO `Events` VALUES(27, 3, 'Wildling Attack', 4, '', ''); INSERT INTO `Events` VALUES(28, 3, 'Storm of Swords*', 9, '', ''); INSERT INTO `Events` VALUES(29, 3, 'Put to the Sword', 7, '', ''); INSERT INTO `Events` VALUES(30, 3, 'Put to the Sword', 3, '', ''); INSERT INTO `Events` VALUES(31, 4, 'Massing on the Milkwater', 6, 'Lowest Bidder: If he has more than one House Card in his hand, he discards all cards with the highest combat strength.\r\nEveryone Else: If they have more than one House Card in their hands, they must choose and discard one of those cards.', 'Highest Bidder: Returns his entire House Card discard pile into his hand.'); INSERT INTO `Events` VALUES(32, 4, 'A King Beyond the Wall', 3, 'Lowest Bidder: Moves his tokens to the lowest position on every influence track.\r\nEveryone else: In turn order, each player chooses either the Fiefdoms or King''s Court influence track and moves his token to the lowest position of that track.', 'Highest Bidder: Moves his token to the top of one influence track of his choice, then takes the appropriate Dominance token.'); INSERT INTO `Events` VALUES(33, 4, 'Mammoth Riders', 4, 'Lowest Bidder: Destroys 3 of his units anywhere.\r\nEveryone Else: Destroys 2 of their units anywhere.', 'Highest Bidder: May retrieve 1 House Card of his choice from his House Card discard pile.'); INSERT INTO `Events` VALUES(34, 4, 'Crow Killers', 5, 'Lowest Bidder: Replaces all of his Knights with available Footmen. Any Knight unable to be replaced is destroyed.\r\nEveryone Else: Replaces 2 of their Knights with available Footmen. Any Knight unable to be replaced is destroyed.', 'Highest Bidder: May immediately replace up to 2 of his Footmen, anywhere, with available Knights.'); INSERT INTO `Events` VALUES(35, 4, 'The Horde Decends', 7, 'Lowest Bidder: Destroys 2 of his units at one of his Castles or Strongholds. If unable, he destroys 2 of his units anywhere.\r\nEveryone Else: Destroys 1 of their units anywhere.', 'Highest Bidder: May muster forces (following normal mustering rules) in any one Castle or Stronghold area he controls.'); INSERT INTO `Events` VALUES(36, 4, 'Skinchanger Scout', 0, 'Lowest Bidder: Discards all available Power tokens.\r\nEveryone Else: Discards 2 available Power tokens, or as many as they area able.', 'Highest Bidder: All Power tokens he bid on this attack are immediately returned to his available Power.'); INSERT INTO `Events` VALUES(37, 4, 'Rattleshirt''s Raiders', 8, 'Lowest Bidder: Is reduced 2 positions on the Supply track (to no lower than 0).\r\nEveryone Else: Is reduced 1 position on the Supply track (to no lower than 0).\r\nThen reconcile armies to their new Supply limits.', 'Highest Bidder: Is increased 1 position on the Supply track (to no higher than 6).'); INSERT INTO `Events` VALUES(38, 4, 'Silence at the Wall', 1, 'Nothing happens.', 'Nothing happens.'); INSERT INTO `Events` VALUES(39, 4, 'Preemptive Raid', 2, 'Lowest Bidder: Chooses one of the following: A. Destroys 2 of his units anywhere. B. Is reduced 2 positions on his highest Influence track.\r\nEveryone Else: Nothing happens.', 'Highest Bidder: The wildlings immediately attack again with a strength of 6. You do not participate in the bidding against this attack (nor do you receive any rewards or penalties).'); -- -------------------------------------------------------- -- -- Table structure for table `General` -- CREATE TABLE `General` ( `Turn` int(11) NOT NULL DEFAULT '1', `Weather` int(11) NOT NULL DEFAULT '0', `DisplayOrders` int(11) NOT NULL DEFAULT '0', `Wildlings` int(11) NOT NULL, `WildlingsCard` int(11) NOT NULL DEFAULT '3', `ShowWildCard` int(11) NOT NULL, `NextWildCard` text COLLATE latin1_german2_ci NOT NULL, `IllegalOrder` text COLLATE latin1_german2_ci NOT NULL, PRIMARY KEY (`Turn`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci; -- -- Dumping data for table `General` -- INSERT INTO `General` VALUES(6, 0, 1, 0, 4, 0, 'Mammoth Riders', 'consolidate'); -- -------------------------------------------------------- -- -- Table structure for table `Housecards` -- CREATE TABLE `Housecards` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `House` int(11) NOT NULL DEFAULT '0', `Name` mediumtext COLLATE latin1_german2_ci NOT NULL, `Used` int(1) NOT NULL DEFAULT '0', `Swords` int(11) NOT NULL DEFAULT '0', `Forts` int(11) NOT NULL DEFAULT '0', `Text` text COLLATE latin1_german2_ci NOT NULL, `Strength` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=43 ; -- -- Dumping data for table `Housecards` -- INSERT INTO `Housecards` VALUES(1, 0, 'Stannis Baratheon', 1, 0, 0, 'If you are not being supported in this combat, remove all Support orders (including your own) adjacent to the embattled area, canceling any supporting strengths they may have been providing', 4); INSERT INTO `Housecards` VALUES(2, 0, 'Jon Snow', 1, 0, 0, 'If you win this combat you may decrease or increase the Wilding track by one space (to a minimum of 0 and a maximum of 10)\r\n', 3); INSERT INTO `Housecards` VALUES(3, 0, 'Melisandre', 1, 0, 0, 'After combat, you may return any House card in your discard pile (including this card) to your hand by discarding a number of your available Power tokens equal to the printed combat strength of that card', 2); INSERT INTO `Housecards` VALUES(4, 0, 'Bastard of Nightsong', 0, 0, 1, '', 2); INSERT INTO `Housecards` VALUES(5, 0, 'Ser Davos Seaworth', 1, 1, 1, '', 1); INSERT INTO `Housecards` VALUES(6, 0, 'Ser Axell Florent', 1, 1, 0, '', 1); INSERT INTO `Housecards` VALUES(7, 0, 'Mance Rayder', 1, 0, 0, 'Your final combat strength is equal to the current position of the Wilding Threat token', 0); INSERT INTO `Housecards` VALUES(8, 1, 'Ser Jaime Lannister', 1, 1, 1, '', 4); INSERT INTO `Housecards` VALUES(9, 1, 'Ser Kevan Lannister', 0, 0, 1, '', 3); INSERT INTO `Housecards` VALUES(10, 1, 'Daven Lannister', 0, 1, 0, '', 2); INSERT INTO `Housecards` VALUES(11, 1, 'Ser Ilyn Payne', 1, 0, 0, 'If you win this combat, you may destroy one of your opponents Footmen in any area (in addition to normal casualties). If that unit is the last unit in its area, remove any Order token there as well\r\n', 2); INSERT INTO `Housecards` VALUES(12, 1, 'Cersei Lannister', 1, 0, 1, '', 1); INSERT INTO `Housecards` VALUES(13, 1, 'Ser Addam Marbrand', 1, 0, 0, 'If you are attacking, all of your participating Knights (including supporting Lannister Knights) add +3 combat strength instead of +2', 1); INSERT INTO `Housecards` VALUES(14, 1, 'Qyburn', 1, 0, 0, 'You may discard two of your available Power tokens to choose a House card in any player’s discard pile. Qyburn gains the printed combat strength and combat icons of that card, ignoring its text ability', 0); INSERT INTO `Housecards` VALUES(15, 2, 'Roose Bolton', 1, 1, 0, '', 4); INSERT INTO `Housecards` VALUES(16, 2, 'Ramsay Bolton', 0, 0, 0, 'If your “Reek” House card is still in your hand, this card gains +1 combat strength and three sword icons\r\n', 3); INSERT INTO `Housecards` VALUES(17, 2, 'Black Walder', 1, 1, 0, '', 2); INSERT INTO `Housecards` VALUES(18, 2, 'Steelshanks Walton', 1, 0, 1, '', 2); INSERT INTO `Housecards` VALUES(19, 2, 'Walder Frey', 1, 0, 0, 'Any player (other than your opponent) who grants support to your opponent must grant that support to you instead\r\n', 1); INSERT INTO `Housecards` VALUES(20, 2, 'Damon Dance-for-Me', 0, 1, 0, '', 1); INSERT INTO `Housecards` VALUES(21, 2, 'Reek', 0, 0, 0, 'If your “Ramsay Bolton” House card is in your discard pile, immediately return it to your hand. If you lose this combat, you may return Reek to your hand\r\n', 0); INSERT INTO `Housecards` VALUES(22, 3, 'Euron Crows Eye', 0, 0, 0, 'If your opponent has a higher position on the Fiefdoms Influence track than you, this card gains +1 combat strength\r\n', 4); INSERT INTO `Housecards` VALUES(23, 3, 'Victarion Greyjoy', 1, 2, 0, '', 3); INSERT INTO `Housecards` VALUES(24, 3, 'Asha Greyjoy', 1, 0, 1, '', 2); INSERT INTO `Housecards` VALUES(25, 3, 'Rodrik The Reader', 1, 0, 0, 'If you win this combat, you may search any Westeros deck for a card of your choice. Shuffle the remaining cards and place the chosen card facedown on top of the deck\r\n', 2); INSERT INTO `Housecards` VALUES(26, 3, 'Qarl The Maid', 1, 0, 0, 'If you are attacking and lose this combat, gain three Power tokens\r\n', 1); INSERT INTO `Housecards` VALUES(27, 3, 'Ser Harras Harlaw', 0, 1, 0, '', 1); INSERT INTO `Housecards` VALUES(28, 3, 'Aeron Damphair', 0, 0, 0, 'You may discard any number of your available Power tokens to increase the combat strength of this card by the number of Power tokens discarded\r\n', 0); INSERT INTO `Housecards` VALUES(29, 4, 'Mace Tyrell', 1, 1, 1, '', 4); INSERT INTO `Housecards` VALUES(30, 4, 'Randyll Tarly', 0, 2, 0, '', 3); INSERT INTO `Housecards` VALUES(31, 4, 'Willas Tyrell', 0, 0, 1, '', 2); INSERT INTO `Housecards` VALUES(32, 4, 'Ser Jon Fossoway', 1, 1, 0, '', 2); INSERT INTO `Housecards` VALUES(33, 4, 'Paxter Redwynne', 1, 0, 0, 'If the embattled area is a sea area, all of your participating Ships (including supporting Tyrell Ships) add +2 combat strength instead of +1\r\n', 1); INSERT INTO `Housecards` VALUES(34, 4, 'Queen of Thorns', 1, 0, 0, 'Ignore all text abilities printed on your opponents House card\r\n', 1); INSERT INTO `Housecards` VALUES(35, 4, 'Margaery Tyrell', 0, 0, 0, 'If you are defending your home area or an area that contains one of your Power tokens, your opponent’s final combat strength is 2\r\n', 0); INSERT INTO `Housecards` VALUES(36, 5, 'Doran Martell', 0, 0, 0, 'For each House card in your hand, this card gains a fortification and a sword icon, and suffers a -1 combat strength (to a minimum of 0)\r\n', 4); INSERT INTO `Housecards` VALUES(37, 5, 'Areo Hotah', 1, 0, 2, '', 3); INSERT INTO `Housecards` VALUES(38, 5, 'Bastard of Godsgrace', 0, 0, 1, '', 2); INSERT INTO `Housecards` VALUES(39, 5, 'Big Man', 1, 1, 0, '', 2); INSERT INTO `Housecards` VALUES(40, 5, 'Ser Gerris Drinkwater', 0, 0, 0, 'If you win this combat, you may move one position higher on one Influence track of your choice\r\n', 1); INSERT INTO `Housecards` VALUES(41, 5, 'Quentyn Martel', 1, 0, 0, 'For each House card in your discard pile, this card gains +1 combat strength\r\n', 1); INSERT INTO `Housecards` VALUES(42, 5, 'Nymeria Sand', 0, 1, 1, '', 0); -- -------------------------------------------------------- -- -- Table structure for table `HouseInfo` -- CREATE TABLE `HouseInfo` ( `ID` int(11) NOT NULL DEFAULT '0', `Mail` text COLLATE latin1_german2_ci NOT NULL, `Player` text COLLATE latin1_german2_ci NOT NULL, `Name` tinytext COLLATE latin1_german2_ci NOT NULL, `Password` text COLLATE latin1_german2_ci NOT NULL, `Claim` int(11) NOT NULL DEFAULT '0', `Supply` int(11) NOT NULL DEFAULT '0', `PowerOnHand` int(11) NOT NULL DEFAULT '0', `IronThrone` int(11) NOT NULL DEFAULT '0', `Fiefdoms` int(11) NOT NULL DEFAULT '0', `KingsCourt` int(11) NOT NULL DEFAULT '0', `WaitingForBid` int(11) NOT NULL DEFAULT '0', `ActualBid` int(11) NOT NULL DEFAULT '0', `WaitingForOrders` int(11) NOT NULL DEFAULT '0', `WaitingForHouseCard` int(11) NOT NULL DEFAULT '0', `ActualHouseCard` int(11) NOT NULL DEFAULT '0', `ActualTactic` int(11) NOT NULL DEFAULT '0', `Hostage1` int(11) NOT NULL DEFAULT '0', `Hostage2` int(11) NOT NULL DEFAULT '0', `Hostage3` int(11) NOT NULL DEFAULT '0', `Hostage4` int(11) NOT NULL DEFAULT '0', `Hostage5` int(11) NOT NULL DEFAULT '0', `Hostage6` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci; -- -- Dumping data for table `HouseInfo` -- INSERT INTO `HouseInfo` VALUES(0, 'giorav@gmail.com', 'G', 'Baratheon', '111111', 4, 4, 0, 4, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `HouseInfo` VALUES(1, 'zigdonit@gmail.com', 'zigdonit', 'Lannister', '66584', 5, 5, 0, 2, 4, 3, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0); INSERT INTO `HouseInfo` VALUES(2, 'galrot@gmail.com', 'Gal', 'Stark', 'qwer', 5, 4, 0, 1, 2, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `HouseInfo` VALUES(3, 'ruryferries@hotmail.com', 'Rury', 'Greyjoy', 'comeze1', 3, 2, 3, 5, 6, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `HouseInfo` VALUES(4, 'orrlevo@yahoo.com', 'orr', 'Tyrell', 'gambit', 5, 5, 3, 3, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `HouseInfo` VALUES(5, 'jakobagger@gmail.com', 'Jakob', 'Martell', 'sesam', 3, 4, 0, 6, 3, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `Log` -- CREATE TABLE `Log` ( `Log` text COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `Log` -- INSERT INTO `Log` VALUES('170213 23:27:55 [84.111.184.34] - Events in deck 1 have been shuffled
'); INSERT INTO `Log` VALUES('170213 16:01:30 [79.179.181.175] - House Tyrell has picked a card for battle
'); INSERT INTO `Log` VALUES('170213 16:02:01 [79.179.181.175] - House cards revealed: Baratheon plays Lannister plays Ser Jaime Lannister Stark plays Greyjoy plays Tyrell plays Mace Tyrell Martell plays
'); INSERT INTO `Log` VALUES('170213 10:26:40 [132.77.4.43] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('170213 10:26:27 [132.77.4.43] - Lannister has started a battle with Tyrell
'); INSERT INTO `Log` VALUES('150213 13:23:08 [37.26.147.225] - Order in Winterfell was changed.
'); INSERT INTO `Log` VALUES('150213 12:25:26 [89.150.144.32] - Removed footman From The Boneway
'); INSERT INTO `Log` VALUES('150213 12:26:38 [89.150.144.32] - Order in The Boneway was changed.
'); INSERT INTO `Log` VALUES('150213 12:15:26 [84.109.39.165] - House cards revealed: Baratheon plays Lannister plays Stark plays Greyjoy plays Tyrell plays Ser Jon Fossoway Martell plays Big Man
'); INSERT INTO `Log` VALUES('150213 10:40:37 [89.150.144.32] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('150213 12:15:08 [84.109.39.165] - House Tyrell has picked a card for battle
'); INSERT INTO `Log` VALUES('150213 10:39:05 [89.150.144.32] - Removed knight From The Boneway
'); INSERT INTO `Log` VALUES('150213 10:39:18 [89.150.144.32] - Added knight to Princes Pass
'); INSERT INTO `Log` VALUES('150213 10:38:51 [89.150.144.32] - Map has started a battle with Tyrell
'); INSERT INTO `Log` VALUES('140213 02:44:56 [84.228.58.109] -
Adjusted PowerOnHand track:
Baratheon 0, Lannister 0, Stark 0, Greyjoy 3, Tyrell 3, Martell 0
'); INSERT INTO `Log` VALUES('140213 02:46:00 [84.228.58.109] - Removed order in Blackwater
'); INSERT INTO `Log` VALUES('140213 02:43:44 [84.228.58.109] - Removed order in Dragonstone
'); INSERT INTO `Log` VALUES('130213 14:08:36 [137.43.68.70] - Added routed footman to Flints Finger
'); INSERT INTO `Log` VALUES('130213 14:09:03 [137.43.68.70] - Order in Flints Finger was changed.
'); INSERT INTO `Log` VALUES('130213 10:14:31 [37.26.147.141] - House cards revealed: Baratheon plays Lannister plays Stark plays Walder Frey Greyjoy plays Qarl The Maid Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('130213 14:08:28 [137.43.68.70] - Removed footman From Flints Finger
'); INSERT INTO `Log` VALUES('130213 10:14:25 [37.26.147.141] - House Stark has picked a card for battle
'); INSERT INTO `Log` VALUES('130213 10:01:53 [137.43.68.177] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('130213 10:01:45 [137.43.68.177] - Map has started a battle with Stark
'); INSERT INTO `Log` VALUES('130213 09:08:20 [132.77.4.43] - House cards revealed: Baratheon plays Ser Axell Florent Lannister plays Cersei Lannister Stark plays Greyjoy plays Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('130213 07:57:38 [109.67.190.41] - Moved footman from Yronwood to Sunspear
'); INSERT INTO `Log` VALUES('130213 09:07:34 [132.77.4.43] - House Lannister has picked a card for battle
'); INSERT INTO `Log` VALUES('130213 07:57:44 [109.67.190.41] - Order in Sunspear was changed.
'); INSERT INTO `Log` VALUES('130213 07:49:05 [89.150.144.32] - Order in Yronwood was changed.
'); INSERT INTO `Log` VALUES('130213 07:56:52 [109.67.190.41] - Yronwood now belongs to Tyrell
'); INSERT INTO `Log` VALUES('130213 07:57:17 [109.67.190.41] - Moved all units from Sunspear to Yronwood
'); INSERT INTO `Log` VALUES('130213 07:48:44 [89.150.144.32] - Removed siege engine From Yronwood
'); INSERT INTO `Log` VALUES('130213 07:48:56 [89.150.144.32] - Removed footman From Yronwood
'); INSERT INTO `Log` VALUES('130213 07:48:29 [89.150.144.32] - Added routed footman to The Boneway
'); INSERT INTO `Log` VALUES('130213 07:48:11 [89.150.144.32] - Removed From
'); INSERT INTO `Log` VALUES('130213 07:43:55 [2.55.130.218] - House Baratheon has picked a card for battle
'); INSERT INTO `Log` VALUES('130213 07:43:39 [2.55.130.218] - Baratheon has started a battle with Lannister
'); INSERT INTO `Log` VALUES('130213 07:43:03 [2.55.130.218] - Moved footman from Dragonstone to Storms End
'); INSERT INTO `Log` VALUES('130213 07:43:26 [2.55.130.218] - Moved knight from Dragonstone to White Harbor
'); INSERT INTO `Log` VALUES('120213 17:51:33 [89.150.144.32] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('130213 06:30:34 [2.55.130.218] - House cards revealed: Baratheon plays Lannister plays Stark plays Greyjoy plays Tyrell plays Paxter Redwynne Martell plays Areo Hotah
'); INSERT INTO `Log` VALUES('120213 15:09:34 [109.67.190.41] - House Tyrell has picked a card for battle
'); INSERT INTO `Log` VALUES('120213 17:36:41 [137.43.68.177] - Order in Riverrun was changed.
'); INSERT INTO `Log` VALUES('120213 14:33:43 [213.57.41.123] - Moved footman from Blackwater to Kings Landing
'); INSERT INTO `Log` VALUES('120213 14:59:50 [109.67.190.41] - Tyrell has started a battle with Martell
'); INSERT INTO `Log` VALUES('120213 14:33:29 [213.57.41.123] - Moved knight from Blackwater to Stoney Sept
'); INSERT INTO `Log` VALUES('120213 14:33:11 [213.57.41.123] - Moved footman from Blackwater to Stoney Sept
'); INSERT INTO `Log` VALUES('110213 13:14:50 [84.111.184.34] - Moved knight from The Mountains of the Moon to The Eyrie
'); INSERT INTO `Log` VALUES('110213 13:15:22 [84.111.184.34] - Order in Greywater Watch was changed.
'); INSERT INTO `Log` VALUES('110213 13:14:56 [84.111.184.34] - Order in The Mountains of the Moon was changed.
'); INSERT INTO `Log` VALUES('110213 13:14:37 [84.111.184.34] - COULD NOT MOVE UNIT !!!
'); INSERT INTO `Log` VALUES('110213 08:54:53 [2.55.130.218] - Removed order in Sea of Dorne
'); INSERT INTO `Log` VALUES('110213 01:44:28 [80.179.194.223] - Removed order in White Harbor
'); INSERT INTO `Log` VALUES('110213 01:44:34 [80.179.194.223] - Removed order in Moat Calin
'); INSERT INTO `Log` VALUES('110213 00:24:57 [82.166.188.73] - Removed order in East Summer Sea
'); INSERT INTO `Log` VALUES('110213 00:25:13 [82.166.188.73] - Removed order in West Summer Sea
'); INSERT INTO `Log` VALUES('100213 16:08:25 [46.116.10.200] - Removed order in The Narrow Sea
'); INSERT INTO `Log` VALUES('100213 16:08:54 [46.116.10.200] - Next Wildling Card has been revealed to Raven holder.
'); INSERT INTO `Log` VALUES('100213 16:08:14 [46.116.10.200] - Removed order in The Shivering Sea
'); INSERT INTO `Log` VALUES('100213 10:33:01 [2.54.231.246] - Turn 6 Orders
Castle Black : Consolidate
Karhold : Raid
The Shivering Sea : Raid
Winterfell : March-1
The Stony Shore : Raid
Bay Of Ice : Support
White Harbor : Raid*
Widows Watch : Raid
Moat Calin : Support
Greywater Watch : Raid
Flints Finger : March
Seagard : Consolidate
The Twins : Support
The Fingers : Raid
The Mountains of the Moon : March
The Eyrie : Raid
Riverrun : Raid
Lannisport : Defend+2*
Stoney Sept : March+1*
Harrenhal : Defend+1
Crackclaw Point : Support+1*
Shipbreaker Bay : Support
Dragonstone : March
Blackwater Bay : Support+1*
Kings Landing : March
Blackwater : March-1
Searoad Marches : Raid
Ironmans Bay : Support
Pyke : March+1*
Sunset Sea : Defend+1
The Golden Sound : Support+1*
Highgarden : Support
The Reach : Defend+1
Kingswood : Support
Storms End : March+1*
The Boneway : March
Dornish Marches : Raid
Oldtown : March-1
Redwyne Straits : Defend+1
Three Towers : Raid
Princes Pass : Support
Yronwood : March-1
Sunspear : March
Salt Shore : Support
Starfall : Defend+1
The Arbor : March+1*
West Summer Sea : Raid
East Summer Sea : Raid
Sea of Dorne : Support
Port of Winterfell : Consolidate
Port of White Harbor : Consolidate
Port of Pyke : Raid
Port of Lannisport : Raid
Port of Dragonstone : Raid
Port of Oldtown : Raid
Port of Storms End : Raid
Port of Sunspear : Raid
The Narrow Sea : Raid

Tactic Baratheon : none
Tactic Lannister : none
Tactic Stark : none
Tactic Greyjoy : none
Tactic Tyrell : none
Tactic Martell : none

Power Baratheon : 0
Power Lannister : 0
Power Stark : 0
Power Greyjoy : 0
Power Tyrell : 3
Power Martell : 0

'); INSERT INTO `Log` VALUES('100213 10:31:26 [132.77.4.43] - House Lannister has assigned orders for turn
'); INSERT INTO `Log` VALUES('100213 10:25:32 [132.77.4.43] - Order in Harrenhal was changed.
'); INSERT INTO `Log` VALUES('100213 10:22:48 [132.77.4.43] - Order in Crackclaw Point was changed.
'); INSERT INTO `Log` VALUES('100213 10:22:21 [132.77.4.43] - Order in Kingswood was changed.
'); INSERT INTO `Log` VALUES('100213 10:17:42 [132.77.4.43] - Order in Blackwater was changed.
'); INSERT INTO `Log` VALUES('100213 10:19:30 [132.77.4.43] - Order in Stoney Sept was changed.
'); INSERT INTO `Log` VALUES('100213 10:20:39 [132.77.4.43] - Order in Kings Landing was changed.
'); INSERT INTO `Log` VALUES('090213 07:58:28 [84.228.58.109] - Order in Port of White Harbor was changed.
'); INSERT INTO `Log` VALUES('090213 07:56:29 [84.228.58.109] - Order in Port of White Harbor was changed.
'); INSERT INTO `Log` VALUES('090213 07:57:43 [84.228.58.109] - Order in Port of White Harbor was changed.
'); INSERT INTO `Log` VALUES('090213 07:55:46 [84.228.58.109] - Order in Port of White Harbor was changed.
'); INSERT INTO `Log` VALUES('080213 10:17:48 [89.150.144.32] - Order in The Boneway was changed.
'); INSERT INTO `Log` VALUES('080213 10:17:58 [89.150.144.32] - House Martell has assigned orders for turn
'); INSERT INTO `Log` VALUES('080213 10:17:11 [89.150.144.32] - Order in Sea of Dorne was changed.
'); INSERT INTO `Log` VALUES('080213 10:17:36 [89.150.144.32] - Order in Yronwood was changed.
'); INSERT INTO `Log` VALUES('080213 10:16:35 [89.150.144.32] - Order in Starfall was changed.
'); INSERT INTO `Log` VALUES('080213 10:16:10 [89.150.144.32] - Order in Princes Pass was changed.
'); INSERT INTO `Log` VALUES('060213 17:45:39 [84.229.159.4] - House Baratheon has assigned orders for turn
'); INSERT INTO `Log` VALUES('060213 17:43:24 [84.229.159.4] - Order in Dragonstone was changed.
'); INSERT INTO `Log` VALUES('060213 17:43:33 [84.229.159.4] - Order in Storms End was changed.
'); INSERT INTO `Log` VALUES('060213 17:43:58 [84.229.159.4] - Order in Port of White Harbor was changed.
'); INSERT INTO `Log` VALUES('060213 17:42:44 [84.229.159.4] - Order in Port of White Harbor was changed.
'); INSERT INTO `Log` VALUES('060213 17:42:37 [84.229.159.4] - Order in White Harbor was changed.
'); INSERT INTO `Log` VALUES('060213 17:42:11 [84.229.159.4] - Order in Shipbreaker Bay was changed.
'); INSERT INTO `Log` VALUES('060213 17:42:20 [84.229.159.4] - Order in The Narrow Sea was changed.
'); INSERT INTO `Log` VALUES('060213 14:14:08 [137.43.68.124] - Order in Flints Finger was changed.
'); INSERT INTO `Log` VALUES('060213 17:41:57 [84.229.159.4] - Order in Blackwater Bay was changed.
'); INSERT INTO `Log` VALUES('060213 14:11:47 [137.43.68.124] - Order in Riverrun was changed.
'); INSERT INTO `Log` VALUES('060213 14:11:54 [137.43.68.124] - Order in Pyke was changed.
'); INSERT INTO `Log` VALUES('060213 11:31:03 [137.43.78.180] - House Greyjoy has assigned orders for turn
'); INSERT INTO `Log` VALUES('060213 11:14:06 [137.43.78.180] - Order in Lannisport was changed.
'); INSERT INTO `Log` VALUES('060213 11:11:22 [137.43.78.180] - Order in Seagard was changed.
'); INSERT INTO `Log` VALUES('060213 11:11:38 [137.43.78.180] - Order in Pyke was changed.
'); INSERT INTO `Log` VALUES('060213 11:10:52 [137.43.78.180] - Order in Riverrun was changed.
'); INSERT INTO `Log` VALUES('060213 11:08:34 [137.43.78.180] - Order in Flints Finger was changed.
'); INSERT INTO `Log` VALUES('060213 11:07:20 [137.43.78.180] - Order in Sunset Sea was changed.
'); INSERT INTO `Log` VALUES('060213 11:04:55 [137.43.78.180] - Order in Ironmans Bay was changed.
'); INSERT INTO `Log` VALUES('060213 11:05:55 [137.43.78.180] - Order in Bay Of Ice was changed.
'); INSERT INTO `Log` VALUES('060213 11:04:43 [137.43.78.180] - Order in The Golden Sound was changed.
'); INSERT INTO `Log` VALUES('060213 10:50:35 [84.111.184.34] - House Stark has assigned orders for turn
'); INSERT INTO `Log` VALUES('060213 10:50:25 [84.111.184.34] - Order in The Mountains of the Moon was changed.
'); INSERT INTO `Log` VALUES('060213 10:49:46 [84.111.184.34] - Order in Greywater Watch was changed.
'); INSERT INTO `Log` VALUES('060213 10:49:16 [84.111.184.34] - Order in Castle Black was changed.
'); INSERT INTO `Log` VALUES('060213 10:48:47 [84.111.184.34] - Order in Port of Winterfell was changed.
'); INSERT INTO `Log` VALUES('060213 10:48:09 [84.111.184.34] - Order in The Twins was changed.
'); INSERT INTO `Log` VALUES('060213 10:48:20 [84.111.184.34] - Order in The Mountains of the Moon was changed.
'); INSERT INTO `Log` VALUES('060213 10:45:48 [84.111.184.34] - Order in Winterfell was changed.
'); INSERT INTO `Log` VALUES('060213 10:45:31 [84.111.184.34] - Order in Moat Calin was changed.
'); INSERT INTO `Log` VALUES('060213 10:44:48 [84.111.184.34] - Order in The Shivering Sea was changed.
'); INSERT INTO `Log` VALUES('060213 10:26:17 [2.55.117.187] -
Adjusted Fiefdoms track:
Baratheon 5, Lannister 4, Stark 2, Greyjoy 6, Tyrell 1, Martell 3
'); INSERT INTO `Log` VALUES('060213 07:14:10 [82.166.188.73] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:14:00 [82.166.188.73] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:13:48 [82.166.188.73] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:10:36 [82.166.188.73] - Order in Oldtown was changed.
'); INSERT INTO `Log` VALUES('060213 07:10:46 [82.166.188.73] - Order in Highgarden was changed.
'); INSERT INTO `Log` VALUES('060213 07:11:00 [82.166.188.73] - Order in The Reach was changed.
'); INSERT INTO `Log` VALUES('060213 07:11:28 [82.166.188.73] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:11:39 [82.166.188.73] - Added ship to West Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:11:54 [82.166.188.73] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:12:10 [82.166.188.73] - Moved ship from West Summer Sea to East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:12:24 [82.166.188.73] - Order in East Summer Sea was changed.
'); INSERT INTO `Log` VALUES('060213 07:12:49 [82.166.188.73] - Removed ship From East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:13:04 [82.166.188.73] - Removed ship From East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:13:22 [82.166.188.73] - Removed ship From East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:13:35 [82.166.188.73] - House Tyrell has assigned orders for turn
'); INSERT INTO `Log` VALUES('060213 01:27:43 [84.229.159.4] - Wildlings has been set to 0
'); INSERT INTO `Log` VALUES('050213 16:42:16 [84.229.159.4] -
Adjusted IronThrone track:
Baratheon 4, Lannister 2, Stark 1, Greyjoy 5, Tyrell 3, Martell 6
'); INSERT INTO `Log` VALUES('050213 16:42:28 [84.229.159.4] -
Adjusted Fiefdoms track:
Baratheon 2, Lannister 5, Stark 3, Greyjoy 4, Tyrell 1, Martell 6
'); INSERT INTO `Log` VALUES('060213 07:10:24 [82.166.188.73] - Order in Redwyne Straits was changed.
'); INSERT INTO `Log` VALUES('060213 07:10:03 [82.166.188.73] - Order in The Arbor was changed.
'); INSERT INTO `Log` VALUES('060213 07:09:52 [82.166.188.73] - Order in West Summer Sea was changed.
'); INSERT INTO `Log` VALUES('060213 07:09:39 [82.166.188.73] - Order in Salt Shore was changed.
'); INSERT INTO `Log` VALUES('060213 07:09:28 [82.166.188.73] - Order in Sunspear was changed.
'); INSERT INTO `Log` VALUES('060213 07:09:14 [82.166.188.73] - Removed ship From East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:09:04 [82.166.188.73] - Removed ship From East Summer Sea
'); INSERT INTO `Log` VALUES('060213 07:08:54 [82.166.188.73] - Removed ship From East Summer Sea
'); INSERT INTO `Log` VALUES('060213 01:26:38 [84.229.159.4] -
Adjusted Fiefdoms track:
Baratheon 6, Lannister 5, Stark 2, Greyjoy 3, Tyrell 1, Martell 4
'); INSERT INTO `Log` VALUES('050213 16:42:57 [84.229.159.4] -
Adjusted KingsCourt track:
Baratheon 1, Lannister 3, Stark 6, Greyjoy 2, Tyrell 4, Martell 5
'); INSERT INTO `Log` VALUES('050213 03:57:04 [2.55.117.187] - Wildlings card have been set to 4
'); INSERT INTO `Log` VALUES('050213 03:56:00 [132.77.4.43] - Wildlings card have been set to 4
'); INSERT INTO `Log` VALUES('040213 13:48:46 [84.229.159.4] - Wildlings card have been set to 4
'); INSERT INTO `Log` VALUES('040213 13:49:14 [84.229.159.4] - Wildlings card have been set to 3
'); INSERT INTO `Log` VALUES('040213 16:28:32 [84.229.159.4] - Ordering has started for turn 6
'); INSERT INTO `Log` VALUES('030213 15:03:13 [109.67.197.4] - House Tyrell has placed a bid
'); INSERT INTO `Log` VALUES('030213 15:37:32 [213.57.41.123] - House Lannister has placed a bid
'); INSERT INTO `Log` VALUES('030213 15:38:23 [84.229.159.4] - Bidding Done:\n
Baratheon bids 0, has now 1 \n
Lannister bids 0, has now 1 \n
Stark bids 0, has now 0 \n
Greyjoy bids 0, has now 0 \n
Tyrell bids 2, has now 3 \n
Martell bids 0, has now 0
'); INSERT INTO `Log` VALUES('030213 15:38:44 [84.229.159.4] - Wildlings card have been set to 3
'); INSERT INTO `Log` VALUES('030213 15:40:36 [84.229.159.4] - Bidding was started
'); INSERT INTO `Log` VALUES('030213 15:40:46 [84.229.159.4] - House Baratheon has placed a bid
'); INSERT INTO `Log` VALUES('030213 16:20:38 [137.43.68.142] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('030213 17:09:42 [137.43.68.142] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('030213 22:58:35 [109.67.197.4] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('040213 12:58:45 [213.57.41.123] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('040213 13:47:59 [84.229.159.4] - Bidding Done:\n
Baratheon bids 1, has now 0 \n
Lannister bids 1, has now 0 \n
Stark bids 0, has now 0 \n
Greyjoy bids 0, has now 0 \n
Tyrell bids 0, has now 3 \n
Martell bids 0, has now 0
'); INSERT INTO `Log` VALUES('030213 14:35:25 [137.43.68.142] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('030213 14:20:52 [84.229.159.4] - House Baratheon has placed a bid
'); INSERT INTO `Log` VALUES('030213 14:20:33 [84.229.159.4] - Bidding was started
'); INSERT INTO `Log` VALUES('030213 14:20:15 [84.229.159.4] -
Adjusted KingsCourt track:
Baratheon 1, Lannister 4, Stark 6, Greyjoy 2, Tyrell 5, Martell 3
'); INSERT INTO `Log` VALUES('030213 03:01:51 [132.77.139.222] - House Baratheon has placed a bid
'); INSERT INTO `Log` VALUES('030213 10:22:20 [89.150.144.32] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('030213 14:17:56 [84.229.159.4] - Bidding Done:\n
Baratheon bids 9, has now 1 \n
Lannister bids 6, has now 1 \n
Stark bids 4, has now 0 \n
Greyjoy bids 8, has now 0 \n
Tyrell bids 5, has now 5 \n
Martell bids 7, has now 0
'); INSERT INTO `Log` VALUES('030213 01:17:29 [82.166.188.73] - House Tyrell has placed a bid
'); INSERT INTO `Log` VALUES('030213 02:27:19 [82.166.188.73] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('020213 17:58:47 [84.229.159.4] -
Adjusted Fiefdoms track:
Baratheon 2, Lannister 6, Stark 3, Greyjoy 4, Tyrell 1, Martell 5
'); INSERT INTO `Log` VALUES('010213 14:08:02 [2.55.113.120] -
Adjusted Fiefdoms track:
Baratheon 2, Lannister 5, Stark 6, Greyjoy 4, Tyrell 1, Martell 5
'); INSERT INTO `Log` VALUES('010213 04:53:30 [84.228.25.12] - Bidding was started
'); INSERT INTO `Log` VALUES('010213 05:00:23 [132.77.4.43] - House Lannister has placed a bid
'); INSERT INTO `Log` VALUES('010213 09:02:26 [84.111.184.34] - House Stark has placed a bid
'); INSERT INTO `Log` VALUES('010213 06:22:24 [137.43.68.142] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('010213 04:52:56 [84.228.25.12] - Bidding Done:\n
Baratheon bids 2, has now 10 \n
Lannister bids 0, has now 7 \n
Stark bids 0, has now 4 \n
Greyjoy bids 0, has now 8 \n
Tyrell bids 2, has now 10 \n
Martell bids 0, has now 7
'); INSERT INTO `Log` VALUES('010213 04:17:40 [132.77.4.43] - House Lannister has placed a bid
'); INSERT INTO `Log` VALUES('010213 04:18:21 [132.77.4.43] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 17:55:48 [79.176.173.109] - House Tyrell has placed a bid
'); INSERT INTO `Log` VALUES('310113 23:01:37 [79.176.173.109] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 13:09:07 [137.43.68.24] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 15:22:25 [46.117.193.161] - House Stark has placed a bid
'); INSERT INTO `Log` VALUES('310113 12:33:46 [84.228.25.12] - House Baratheon has placed a bid
'); INSERT INTO `Log` VALUES('310113 12:29:33 [89.150.144.32] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 12:29:19 [89.150.144.32] - Added footman to Yronwood
'); INSERT INTO `Log` VALUES('310113 12:25:10 [84.228.25.12] -
Adjusted IronThrone track:
Baratheon 5, Lannister 2, Stark 1, Greyjoy 6, Tyrell 4, Martell 3
'); INSERT INTO `Log` VALUES('310113 12:27:20 [84.228.25.12] - House Baratheon has placed a bid
'); INSERT INTO `Log` VALUES('310113 12:24:29 [84.228.25.12] - Bidding was started
'); INSERT INTO `Log` VALUES('310113 12:23:58 [132.77.4.43] - House Lannister has placed a bid
'); INSERT INTO `Log` VALUES('310113 12:24:11 [84.228.25.12] - Bidding Done:\n
Baratheon bids 0, has now 12 \n
Lannister bids 8, has now 7 \n
Stark bids 13, has now 4 \n
Greyjoy bids 0, has now 8 \n
Tyrell bids 2, has now 12 \n
Martell bids 5, has now 7
'); INSERT INTO `Log` VALUES('310113 12:17:00 [84.228.25.12] - House Baratheon has placed a bid
'); INSERT INTO `Log` VALUES('310113 09:24:25 [82.166.188.73] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 03:36:36 [137.43.68.233] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 08:53:57 [89.150.144.32] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 08:54:27 [62.219.155.45] - House Map has placed a bid
'); INSERT INTO `Log` VALUES('310113 00:39:37 [80.179.194.223] - Added knight to Winterfell
'); INSERT INTO `Log` VALUES('310113 00:39:28 [80.179.194.223] - Added footman to Moat Calin
'); INSERT INTO `Log` VALUES('300113 03:53:49 [132.77.138.101] - Harrenhal now belongs to Lannister
'); INSERT INTO `Log` VALUES('300113 03:53:32 [132.77.138.101] - Removed footman From Harrenhal
'); INSERT INTO `Log` VALUES('300113 00:54:04 [81.218.90.82] - Added ship to Redwyne Straits
'); INSERT INTO `Log` VALUES('300113 03:53:14 [132.77.138.101] - Harrenhal now belongs to Baratheon
'); INSERT INTO `Log` VALUES('300113 00:53:53 [81.218.90.82] - Added siege engine to Oldtown
'); INSERT INTO `Log` VALUES('290113 17:38:43 [213.57.41.123] - Added footman to Crackclaw Point
'); INSERT INTO `Log` VALUES('300113 00:53:41 [81.218.90.82] - Added knight to Sunspear
'); INSERT INTO `Log` VALUES('300113 00:53:30 [81.218.90.82] - Added footman to Highgarden
'); INSERT INTO `Log` VALUES('290113 17:38:26 [213.57.41.123] - Added knight to Kings Landing
'); INSERT INTO `Log` VALUES('290113 17:37:04 [213.57.41.123] - Added knight to Harrenhal
'); INSERT INTO `Log` VALUES('280113 05:02:49 [137.43.50.86] - Added knight to Riverrun
'); INSERT INTO `Log` VALUES('280113 05:02:21 [137.43.50.86] - Removed knight From Pyke
'); INSERT INTO `Log` VALUES('280113 05:02:35 [137.43.50.86] - Added knight to Lannisport
'); INSERT INTO `Log` VALUES('280113 05:01:52 [137.43.50.86] - Added knight to Pyke
'); INSERT INTO `Log` VALUES('280113 05:02:08 [137.43.50.86] - Added knight to Pyke
'); INSERT INTO `Log` VALUES('280113 04:59:34 [132.77.141.62] - Added footman to White Harbor
'); INSERT INTO `Log` VALUES('280113 05:01:37 [137.43.50.86] - Added footman to Flints Finger
'); INSERT INTO `Log` VALUES('280113 04:59:24 [132.77.141.62] - Added footman to Storms End
'); INSERT INTO `Log` VALUES('280113 04:59:12 [132.77.141.62] - Added footman to Dragonstone
'); INSERT INTO `Log` VALUES('280113 01:38:26 [2.54.229.68] - Turn was set to 6
'); INSERT INTO `Log` VALUES('280113 04:58:55 [132.77.141.62] - Added footman to Dragonstone
'); INSERT INTO `Log` VALUES('280113 01:39:08 [2.54.229.68] - Bidding was started
'); INSERT INTO `Log` VALUES('280113 01:37:56 [2.54.229.68] -
Adjusted PowerOnHand track:
Baratheon 12, Lannister 15, Stark 17, Greyjoy 8, Tyrell 14, Martell 12
'); INSERT INTO `Log` VALUES('280113 01:38:13 [2.54.229.68] - All territories orders and all houses tactics have been reset
'); INSERT INTO `Log` VALUES('270113 15:43:33 [2.54.229.68] -
Adjusted PowerOnHand track:
Baratheon 12, Lannister 15, Stark 17, Greyjoy 8, Tyrell 13, Martell 12
'); INSERT INTO `Log` VALUES('270113 15:33:33 [213.57.41.123] - Added knight to Stoney Sept
'); INSERT INTO `Log` VALUES('270113 15:38:18 [89.150.144.32] - Order in Sea of Dorne was changed.
'); INSERT INTO `Log` VALUES('270113 15:31:00 [84.111.184.34] - Order in The Eyrie was changed.
'); INSERT INTO `Log` VALUES('270113 15:30:54 [84.111.184.34] - Removed footman From The Eyrie
'); INSERT INTO `Log` VALUES('270113 15:30:30 [84.111.184.34] - House Stark has changed his house cards in hand.
'); INSERT INTO `Log` VALUES('270113 14:31:30 [213.57.41.123] - House cards revealed: Baratheon plays Lannister plays Ser Ilyn Payne Stark plays Reek Greyjoy plays Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('270113 14:30:36 [213.57.41.123] - Added knight to Stoney Sept
'); INSERT INTO `Log` VALUES('270113 14:31:18 [213.57.41.123] - House Lannister has picked a card for battle
'); INSERT INTO `Log` VALUES('260113 15:05:34 [84.111.184.34] - Moved knight from The Mountains of the Moon to The Twins
'); INSERT INTO `Log` VALUES('260113 15:05:13 [84.111.184.34] - House Stark has picked a card for battle
'); INSERT INTO `Log` VALUES('260113 15:04:53 [84.111.184.34] - Stark has started a battle with Lannister
'); INSERT INTO `Log` VALUES('260113 14:48:51 [137.43.68.30] - Order in Pyke was changed.
'); INSERT INTO `Log` VALUES('260113 14:48:45 [137.43.68.30] - Moved siege engine from Pyke to Riverrun
'); INSERT INTO `Log` VALUES('260113 14:48:11 [137.43.68.30] - Riverrun now belongs to Greyjoy
'); INSERT INTO `Log` VALUES('260113 14:23:35 [84.229.179.219] - All units in Riverrun have been removed
'); INSERT INTO `Log` VALUES('260113 11:34:09 [79.179.172.148] - House cards revealed: Baratheon plays Lannister plays Qyburn Stark plays Greyjoy plays Asha Greyjoy Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('260113 11:33:35 [79.179.172.148] - House Lannister has picked a card for battle
'); INSERT INTO `Log` VALUES('240113 09:30:45 [82.166.188.73] - Order in Searoad Marches was changed.
'); INSERT INTO `Log` VALUES('240113 09:30:38 [82.166.188.73] - Moved knight from Searoad Marches to Salt Shore
'); INSERT INTO `Log` VALUES('240113 09:30:18 [82.166.188.73] - Moved knight from Searoad Marches to The Reach
'); INSERT INTO `Log` VALUES('240113 09:29:51 [82.166.188.73] - Salt Shore now belongs to Tyrell
'); INSERT INTO `Log` VALUES('240113 09:29:12 [82.166.188.73] - Salt Shore now belongs to
'); INSERT INTO `Log` VALUES('240113 09:29:39 [82.166.188.73] - The Reach now belongs to Tyrell
'); INSERT INTO `Log` VALUES('240113 09:29:00 [82.166.188.73] - The Reach now belongs to
'); INSERT INTO `Log` VALUES('240113 09:03:44 [132.77.141.1] - Control over Riverrun has been removed
'); INSERT INTO `Log` VALUES('240113 09:02:56 [132.77.141.1] - Control over Salt Shore has been removed
'); INSERT INTO `Log` VALUES('240113 09:02:42 [132.77.141.1] - Control over The Reach has been removed
'); INSERT INTO `Log` VALUES('240113 08:21:05 [137.43.68.150] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('240113 08:20:48 [137.43.68.150] - Map has started a battle with Lannister
'); INSERT INTO `Log` VALUES('240113 06:51:22 [132.77.4.43] - Order in Stoney Sept was changed.
'); INSERT INTO `Log` VALUES('240113 06:51:11 [132.77.4.43] - Moved knight from Stoney Sept to Riverrun
'); INSERT INTO `Log` VALUES('240113 06:50:44 [132.77.4.43] - Riverrun now belongs to Lannister
'); INSERT INTO `Log` VALUES('240113 06:50:59 [132.77.4.43] - Moved knight from Stoney Sept to Riverrun
'); INSERT INTO `Log` VALUES('220113 19:37:49 [89.150.144.32] - Moved siege engine from Salt Shore to Yronwood
'); INSERT INTO `Log` VALUES('220113 19:37:31 [89.150.144.32] - Yronwood now belongs to Martell
'); INSERT INTO `Log` VALUES('220113 19:37:07 [89.150.144.32] - House Martell has changed his house cards in hand.
'); INSERT INTO `Log` VALUES('220113 14:25:42 [109.67.203.144] - House Tyrell has changed his house cards in hand.
'); INSERT INTO `Log` VALUES('220113 14:25:25 [109.67.203.144] - Yronwood now belongs to Martell
'); INSERT INTO `Log` VALUES('220113 14:23:47 [109.67.203.144] - Added routed knight to Sunspear
'); INSERT INTO `Log` VALUES('220113 14:23:35 [109.67.203.144] - Added routed footman to Sunspear
'); INSERT INTO `Log` VALUES('210113 15:53:52 [77.126.91.94] - All units in Yronwood have been removed
'); INSERT INTO `Log` VALUES('210113 15:51:21 [77.126.91.94] - Order in Starfall was changed.
'); INSERT INTO `Log` VALUES('210113 15:51:09 [77.126.91.94] - Order in Sea of Dorne was changed.
'); INSERT INTO `Log` VALUES('210113 15:50:40 [77.126.91.94] - Order in East Summer Sea was changed.
'); INSERT INTO `Log` VALUES('210113 15:50:27 [77.126.91.94] - Order in West Summer Sea was changed.
'); INSERT INTO `Log` VALUES('210113 15:50:11 [77.126.91.94] - Order in The Arbor was changed.
'); INSERT INTO `Log` VALUES('210113 15:49:52 [77.126.91.94] - Order in Oldtown was changed.
'); INSERT INTO `Log` VALUES('210113 15:49:21 [77.126.91.94] - Order in Searoad Marches was changed.
'); INSERT INTO `Log` VALUES('210113 15:49:03 [77.126.91.94] - Order in Stoney Sept was changed.
'); INSERT INTO `Log` VALUES('210113 15:48:47 [77.126.91.94] - Order in Blackwater was changed.
'); INSERT INTO `Log` VALUES('210113 15:48:32 [77.126.91.94] - Order in Harrenhal was changed.
'); INSERT INTO `Log` VALUES('210113 15:48:17 [77.126.91.94] - Order in Shipbreaker Bay was changed.
'); INSERT INTO `Log` VALUES('210113 15:47:41 [77.126.91.94] - Order in The Eyrie was changed.
'); INSERT INTO `Log` VALUES('210113 15:47:32 [77.126.91.94] - Order in The Mountains of the Moon was changed.
'); INSERT INTO `Log` VALUES('210113 15:47:21 [77.126.91.94] - Order in Pyke was changed.
'); INSERT INTO `Log` VALUES('210113 15:47:06 [77.126.91.94] - Order in Ironmans Bay was changed.
'); INSERT INTO `Log` VALUES('210113 15:46:22 [77.126.91.94] - Order in The Golden Sound was changed.
'); INSERT INTO `Log` VALUES('210113 15:46:00 [77.126.91.94] - Order in Sunset Sea was changed.
'); INSERT INTO `Log` VALUES('210113 15:45:25 [77.126.91.94] - Order in The Twins was changed.
'); INSERT INTO `Log` VALUES('210113 15:45:08 [77.126.91.94] - Order in Castle Black was changed.
'); INSERT INTO `Log` VALUES('210113 15:44:56 [84.111.184.34] - Added routed knight to Greywater Watch
'); INSERT INTO `Log` VALUES('210113 15:44:46 [84.111.184.34] - Removed knight From Greywater Watch
'); INSERT INTO `Log` VALUES('210113 15:44:22 [84.111.184.34] - Added routed knight to Moat Calin
'); INSERT INTO `Log` VALUES('210113 15:39:59 [37.26.146.227] - All territories orders and all houses tactics have been reset
'); INSERT INTO `Log` VALUES('210113 15:31:20 [77.126.91.94] - All houses Waiting for Bid/Card/Orders and all actual selected bids and cards have been reset
'); INSERT INTO `Log` VALUES('210113 15:31:15 [77.126.91.94] - All territories orders and all houses tactics have been reset
'); INSERT INTO `Log` VALUES('210113 15:03:35 [89.150.144.32] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('210113 14:57:29 [89.150.144.32] - Map has started a battle with Tyrell
'); INSERT INTO `Log` VALUES('210113 14:44:10 [2.55.115.89] - Removed order in Winterfell
'); INSERT INTO `Log` VALUES('210113 14:43:42 [2.55.115.89] - Moved footman from Storms End to White Harbor
'); INSERT INTO `Log` VALUES('210113 14:43:27 [2.55.115.89] - Removed order in Storms End
'); INSERT INTO `Log` VALUES('210113 14:42:26 [2.55.115.89] - All units in Winterfell have been removed
'); INSERT INTO `Log` VALUES('210113 14:42:48 [2.55.115.89] - White Harbor now belongs to Baratheon
'); INSERT INTO `Log` VALUES('210113 14:40:29 [2.55.115.89] - House cards revealed: Baratheon plays Stannis Baratheon Lannister plays Stark plays Steelshanks Walton Greyjoy plays Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('210113 14:40:15 [2.55.115.89] - House Baratheon has picked a card for battle
'); INSERT INTO `Log` VALUES('210113 13:15:45 [37.26.146.238] - House Stark has picked a card for battle
'); INSERT INTO `Log` VALUES('210113 12:55:03 [2.55.115.89] - Baratheon has started a battle with Stark
'); INSERT INTO `Log` VALUES('210113 12:39:50 [2.55.115.89] - Added routed knight to Dragonstone
'); INSERT INTO `Log` VALUES('210113 12:39:30 [2.55.115.89] - Could not remove routed knight from Dragonstone!
'); INSERT INTO `Log` VALUES('210113 12:38:41 [2.55.115.89] - White Harbor now belongs to Stark
'); INSERT INTO `Log` VALUES('210113 12:38:13 [2.55.115.89] - Removed order in White Harbor
'); INSERT INTO `Log` VALUES('210113 12:37:58 [2.55.115.89] - All units in White Harbor have been removed
'); INSERT INTO `Log` VALUES('210113 10:50:49 [132.77.138.185] - House cards revealed: Baratheon plays Ser Davos Seaworth Lannister plays Stark plays Ramsay Bolton Greyjoy plays Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('210113 10:50:42 [132.77.138.185] - House Baratheon has picked a card for battle
'); INSERT INTO `Log` VALUES('200113 16:16:10 [137.43.68.128] - Order in Riverrun was changed.
'); INSERT INTO `Log` VALUES('200113 16:15:48 [137.43.68.128] - Added siege engine to Seagard
'); INSERT INTO `Log` VALUES('200113 16:15:39 [137.43.68.128] - Removed siege engine From Riverrun
'); INSERT INTO `Log` VALUES('200113 16:15:22 [137.43.68.128] - Seagard now belongs to Greyjoy
'); INSERT INTO `Log` VALUES('200113 11:20:06 [84.111.184.34] - Removed knight From Seagard
'); INSERT INTO `Log` VALUES('200113 11:19:53 [84.111.184.34] - Order in Seagard was changed.
'); INSERT INTO `Log` VALUES('200113 11:19:42 [84.111.184.34] - Added routed knight to Greywater Watch
'); INSERT INTO `Log` VALUES('200113 11:19:09 [84.111.184.34] - House Stark has picked a card for battle
'); INSERT INTO `Log` VALUES('200113 11:19:05 [84.111.184.34] - House Stark has changed his house cards in hand.
'); INSERT INTO `Log` VALUES('200113 11:18:52 [84.111.184.34] - Stark has started a battle with Baratheon
'); INSERT INTO `Log` VALUES('200113 11:03:36 [195.166.51.5] - House cards revealed: Baratheon plays Lannister plays Stark plays Reek Greyjoy plays Rodrik The Reader Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('200113 11:03:09 [195.166.51.5] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('200113 10:59:20 [84.111.184.34] - House Stark has picked a card for battle
'); INSERT INTO `Log` VALUES('200113 10:59:15 [195.166.51.5] - Map has established control over Riverrun
'); INSERT INTO `Log` VALUES('200113 10:58:59 [195.166.51.5] - Greyjoy has started a battle with Stark
'); INSERT INTO `Log` VALUES('200113 06:02:48 [82.166.188.73] - Order in Sunspear was changed.
'); INSERT INTO `Log` VALUES('200113 06:02:17 [82.166.188.73] - Moved all units from Sunspear to Yronwood
'); INSERT INTO `Log` VALUES('200113 06:01:36 [82.166.188.73] - Yronwood now belongs to Tyrell
'); INSERT INTO `Log` VALUES('200113 05:52:49 [89.150.144.32] - Order in Yronwood was changed.
'); INSERT INTO `Log` VALUES('200113 05:52:40 [89.150.144.32] - Removed knight From Yronwood
'); INSERT INTO `Log` VALUES('200113 05:52:26 [89.150.144.32] - Removed footman From Yronwood
'); INSERT INTO `Log` VALUES('200113 05:51:32 [89.150.144.32] - Added routed knight to Princes Pass
'); INSERT INTO `Log` VALUES('200113 05:51:19 [89.150.144.32] - Added routed footman to Princes Pass
'); INSERT INTO `Log` VALUES('200113 05:48:55 [89.150.144.32] - House cards revealed: Baratheon plays Lannister plays Stark plays Greyjoy plays Tyrell plays Willas Tyrell Martell plays Doran Martell
'); INSERT INTO `Log` VALUES('200113 05:48:46 [89.150.144.32] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('200113 03:14:03 [82.166.188.73] - House Tyrell has picked a card for battle
'); INSERT INTO `Log` VALUES('190113 13:52:13 [79.183.195.205] - Map has established control over Sunspear
'); INSERT INTO `Log` VALUES('190113 13:46:59 [79.183.195.205] - Tyrell has started a battle with Martell
'); INSERT INTO `Log` VALUES('170113 12:56:08 [84.228.118.111] - Removed order in Kings Landing
'); INSERT INTO `Log` VALUES('170113 12:55:54 [84.228.118.111] - Control over Crackclaw Point has been removed
'); INSERT INTO `Log` VALUES('170113 11:55:38 [132.77.4.43] - Moved knight from Kings Landing to Crackclaw Point
'); INSERT INTO `Log` VALUES('170113 11:55:03 [132.77.4.43] - Crackclaw Point now belongs to Lannister
'); INSERT INTO `Log` VALUES('170113 05:09:40 [132.77.141.108] - Removed order in The Shivering Sea
'); INSERT INTO `Log` VALUES('170113 05:09:30 [132.77.141.108] - Removed order in The Narrow Sea
'); INSERT INTO `Log` VALUES('150113 15:29:24 [84.228.118.111] - Removed order in Blackwater Bay
'); INSERT INTO `Log` VALUES('150113 15:29:09 [84.228.118.111] - Removed order in Lannisport
'); INSERT INTO `Log` VALUES('150113 15:29:02 [84.228.118.111] - Removed order in Port of Winterfell
'); INSERT INTO `Log` VALUES('150113 15:26:59 [84.228.118.111] - Removed order in Kingswood
'); INSERT INTO `Log` VALUES('150113 15:26:50 [84.228.118.111] - Removed order in The Boneway
'); INSERT INTO `Log` VALUES('150113 02:02:40 [82.166.188.73] - Order in East Summer Sea was changed.
'); INSERT INTO `Log` VALUES('140113 12:21:37 [84.228.141.124] - Wildlings has been set to 2
'); INSERT INTO `Log` VALUES('140113 10:48:18 [132.77.4.43] - Order in Stoney Sept was changed.
'); INSERT INTO `Log` VALUES('140113 10:49:14 [132.77.4.43] - Order in Blackwater was changed.
'); INSERT INTO `Log` VALUES('140113 10:49:47 [132.77.4.43] - Order in Harrenhal was changed.
'); INSERT INTO `Log` VALUES('140113 10:50:04 [132.77.4.43] - Order in Kings Landing was changed.
'); INSERT INTO `Log` VALUES('140113 10:53:49 [132.77.4.43] - Order in Kingswood was changed.
'); INSERT INTO `Log` VALUES('140113 10:55:20 [132.77.4.43] - House Lannister has assigned orders for turn
'); INSERT INTO `Log` VALUES('140113 10:59:06 [2.55.113.90] - Turn 5 Orders
Castle Black : Consolidate
Karhold : Raid
The Shivering Sea : Raid*
Winterfell : March
The Stony Shore : Raid
Bay Of Ice : Raid
White Harbor : March
Widows Watch : Raid
Moat Calin : Raid
Greywater Watch : Raid
Flints Finger : Raid
Seagard : Defend+2*
The Twins : Support
The Fingers : Raid
The Mountains of the Moon : March-1
The Eyrie : Defend+1
Riverrun : March-1
Lannisport : Raid
Stoney Sept : March
Harrenhal : Support+1*
Crackclaw Point : Raid
Shipbreaker Bay : Support
Dragonstone : Raid
Blackwater Bay : Raid
Kings Landing : March-1
Blackwater : Support
Searoad Marches : March
Ironmans Bay : Support
Pyke : March
Sunset Sea : Defend+1
The Golden Sound : Support
Highgarden : Raid
The Reach : Raid
Kingswood : Raid
Storms End : March-1
The Boneway : Support
Dornish Marches : Raid
Oldtown : Consolidate*
Redwyne Straits : Raid
Three Towers : Raid
Princes Pass : Raid
Yronwood : Support+1*
Sunspear : March-1
Salt Shore : March
Starfall : Defend+2*
The Arbor : Consolidate
West Summer Sea : Support+1*
East Summer Sea : Raid*
Sea of Dorne : March-1
Port of Winterfell : Raid
Port of White Harbor : Consolidate
Port of Pyke : Raid
Port of Lannisport : Raid
Port of Dragonstone : Raid
Port of Oldtown : Raid
Port of Storms End : Raid
Port of Sunspear : Raid
The Narrow Sea : Raid

Tactic Baratheon : none
Tactic Lannister : none
Tactic Stark : none
Tactic Greyjoy : none
Tactic Tyrell : none
Tactic Martell : none

Power Baratheon : 12
Power Lannister : 15
Power Stark : 17
Power Greyjoy : 9
Power Tyrell : 12
Power Martell : 12

'); INSERT INTO `Log` VALUES('120113 13:00:51 [79.182.242.225] - Order in East Summer Sea was changed.
'); INSERT INTO `Log` VALUES('120113 13:00:10 [79.182.242.225] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('120113 12:59:56 [79.182.242.225] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('120113 12:59:45 [79.182.242.225] - Added ship to East Summer Sea
'); INSERT INTO `Log` VALUES('120113 12:59:33 [79.182.242.225] - House Tyrell has assigned orders for turn
'); INSERT INTO `Log` VALUES('120113 12:59:25 [79.182.242.225] - All units in East Summer Sea have been removed
'); INSERT INTO `Log` VALUES('120113 12:58:30 [79.182.242.225] - Order in The Arbor was changed.
'); INSERT INTO `Log` VALUES('120113 12:58:19 [79.182.242.225] - Order in Oldtown was changed.
'); INSERT INTO `Log` VALUES('120113 12:58:04 [79.182.242.225] - Order in Searoad Marches was changed.
'); INSERT INTO `Log` VALUES('120113 12:57:54 [79.182.242.225] - Order in Sunspear was changed.
'); INSERT INTO `Log` VALUES('120113 12:57:25 [79.182.242.225] - Order in West Summer Sea was changed.
'); INSERT INTO `Log` VALUES('120113 12:57:09 [79.182.242.225] - Order in East Summer Sea was changed.
'); INSERT INTO `Log` VALUES('120113 10:02:56 [89.150.144.32] - Order in Sea of Dorne was changed.
'); INSERT INTO `Log` VALUES('120113 09:59:48 [89.150.144.32] - Order in Sea of Dorne was changed.
'); INSERT INTO `Log` VALUES('120113 03:42:15 [84.228.141.124] - Garrison Sunspears neutral strength/garrison is now hidden
'); INSERT INTO `Log` VALUES('120113 00:41:19 [23.16.102.185] - House Greyjoy has assigned orders for turn
'); INSERT INTO `Log` VALUES('120113 00:35:14 [23.16.102.185] - Order in Sunset Sea was changed.
'); INSERT INTO `Log` VALUES('120113 00:34:01 [23.16.102.185] - Order in Pyke was changed.
'); INSERT INTO `Log` VALUES('120113 00:33:49 [23.16.102.185] - Order in Sunset Sea was changed.
'); INSERT INTO `Log` VALUES('120113 00:33:11 [23.16.102.185] - Order in Ironmans Bay was changed.
'); INSERT INTO `Log` VALUES('120113 00:32:55 [23.16.102.185] - Order in Lannisport was changed.
'); INSERT INTO `Log` VALUES('120113 00:32:49 [23.16.102.185] - Order in Lannisport was changed.
'); INSERT INTO `Log` VALUES('120113 00:32:35 [23.16.102.185] - Order in The Golden Sound was changed.
'); INSERT INTO `Log` VALUES('110113 15:29:24 [89.150.144.32] - Order in The Boneway was changed.
'); INSERT INTO `Log` VALUES('120113 00:32:26 [23.16.102.185] - Order in Riverrun was changed.
'); INSERT INTO `Log` VALUES('110113 15:25:28 [89.150.144.32] - House Martell has assigned orders for turn
'); INSERT INTO `Log` VALUES('110113 14:29:46 [2.54.229.106] - House Baratheon has assigned orders for turn
'); INSERT INTO `Log` VALUES('110113 14:29:13 [2.54.229.106] - Order in Storms End was changed.
'); INSERT INTO `Log` VALUES('110113 14:28:56 [2.54.229.106] - Order in Blackwater Bay was changed.
'); INSERT INTO `Log` VALUES('110113 14:28:35 [2.54.229.106] - Order in Shipbreaker Bay was changed.
'); INSERT INTO `Log` VALUES('110113 14:28:20 [2.54.229.106] - Order in The Narrow Sea was changed.
'); INSERT INTO `Log` VALUES('110113 14:27:59 [2.54.229.106] - Order in Port of White Harbor was changed.
'); INSERT INTO `Log` VALUES('110113 14:27:33 [2.54.229.106] - Order in White Harbor was changed.
'); INSERT INTO `Log` VALUES('110113 14:21:59 [2.54.229.106] -
Adjusted PowerOnHand track:
Baratheon 12, Lannister 15, Stark 17, Greyjoy 9, Tyrell 12, Martell 12
'); INSERT INTO `Log` VALUES('110113 11:08:55 [89.150.144.32] - Order in Sea of Dorne was changed.
'); INSERT INTO `Log` VALUES('110113 11:07:58 [89.150.144.32] - Order in Yronwood was changed.
'); INSERT INTO `Log` VALUES('110113 11:07:33 [89.150.144.32] - Order in The Boneway was changed.
'); INSERT INTO `Log` VALUES('110113 11:07:13 [89.150.144.32] - Order in Starfall was changed.
'); INSERT INTO `Log` VALUES('110113 11:06:55 [89.150.144.32] - Order in Salt Shore was changed.
'); INSERT INTO `Log` VALUES('110113 11:05:55 [109.64.192.157] - House Stark has assigned orders for turn
'); INSERT INTO `Log` VALUES('110113 11:05:41 [109.64.192.157] - Order in Port of Winterfell was changed.
'); INSERT INTO `Log` VALUES('110113 11:05:29 [109.64.192.157] - Order in Castle Black was changed.
'); INSERT INTO `Log` VALUES('110113 11:05:18 [109.64.192.157] - Order in The Eyrie was changed.
'); INSERT INTO `Log` VALUES('110113 11:05:04 [109.64.192.157] - Order in The Twins was changed.
'); INSERT INTO `Log` VALUES('110113 11:04:53 [109.64.192.157] - Order in Seagard was changed.
'); INSERT INTO `Log` VALUES('110113 11:04:24 [109.64.192.157] - Order in The Mountains of the Moon was changed.
'); INSERT INTO `Log` VALUES('110113 11:04:03 [109.64.192.157] - Order in Winterfell was changed.
'); INSERT INTO `Log` VALUES('110113 11:03:52 [109.64.192.157] - Order in The Shivering Sea was changed.
'); INSERT INTO `Log` VALUES('110113 10:36:25 [84.228.141.124] -
Adjusted PowerOnHand track:
Baratheon 12, Lannister 15, Stark 17, Greyjoy 9, Tyrell 12, Martell 11
'); INSERT INTO `Log` VALUES('110113 10:35:15 [84.228.141.124] - Ordering has started for turn 5
'); INSERT INTO `Log` VALUES('110113 10:35:10 [84.228.141.124] - All territories orders and all houses tactics have been reset
'); INSERT INTO `Log` VALUES('110113 10:28:13 [84.228.141.124] - Turn was set to 5
'); INSERT INTO `Log` VALUES('110113 10:27:28 [84.228.141.124] -
Adjusted PowerOnHand track:
Baratheon 10, Lannister 13, Stark 12, Greyjoy 7, Tyrell 9, Martell 10
'); INSERT INTO `Log` VALUES('110113 09:45:54 [84.228.141.124] - Removed order in Harrenhal
'); INSERT INTO `Log` VALUES('110113 09:45:40 [84.228.141.124] - Removed order in The Twins
'); INSERT INTO `Log` VALUES('110113 09:45:32 [84.228.141.124] - Removed order in Castle Black
'); INSERT INTO `Log` VALUES('110113 09:44:53 [84.228.141.124] -
Adjusted PowerOnHand track:
Baratheon 10, Lannister 13, Stark 12, Greyjoy 7, Tyrell 8, Martell 10
'); INSERT INTO `Log` VALUES('110113 08:31:54 [109.64.192.157] - Order in Moat Calin was changed.
'); INSERT INTO `Log` VALUES('110113 08:31:47 [109.64.192.157] - Moved siege engine from Moat Calin to Winterfell
'); INSERT INTO `Log` VALUES('110113 03:20:46 [82.166.188.73] - Order in Highgarden was changed.
'); INSERT INTO `Log` VALUES('110113 03:20:26 [82.166.188.73] - Removed routed footman From Sunspear
'); INSERT INTO `Log` VALUES('110113 03:20:02 [82.166.188.73] - Moved all units from Highgarden to Sunspear
'); INSERT INTO `Log` VALUES('110113 03:19:27 [82.166.188.73] - Sunspear now belongs to Tyrell
'); INSERT INTO `Log` VALUES('110113 03:19:05 [82.166.188.73] - All units in Port of Sunspear have been removed
'); INSERT INTO `Log` VALUES('110113 03:14:54 [89.150.144.32] - House cards revealed: Baratheon plays Lannister plays Stark plays Greyjoy plays Tyrell plays Mace Tyrell Martell plays Nymeria Sand
'); INSERT INTO `Log` VALUES('110113 03:14:41 [89.150.144.32] - House Map has picked a card for battle
'); INSERT INTO `Log` VALUES('110113 02:59:35 [82.166.188.73] - House Tyrell has picked a card for battle
'); INSERT INTO `Log` VALUES('110113 02:59:21 [82.166.188.73] - Tyrell has started a battle with Martell
'); INSERT INTO `Log` VALUES('100113 04:23:15 [89.150.144.32] - Removed routed footman From Salt Shore
'); INSERT INTO `Log` VALUES('100113 04:22:57 [89.150.144.32] - Order in Sunspear was changed.
'); INSERT INTO `Log` VALUES('100113 04:22:48 [89.150.144.32] - Removed routed footman From Salt Shore
'); INSERT INTO `Log` VALUES('100113 04:22:27 [89.150.144.32] - Moved all units from Sunspear to Salt Shore
'); INSERT INTO `Log` VALUES('100113 03:46:03 [2.54.229.106] - Removed order in Dragonstone
'); INSERT INTO `Log` VALUES('100113 03:45:41 [2.54.229.106] - Removed knight From Dragonstone
'); INSERT INTO `Log` VALUES('100113 03:43:41 [212.68.144.42] - House cards revealed: Baratheon plays Jon Snow Lannister plays Stark plays Ramsay Bolton Greyjoy plays Tyrell plays Martell plays
'); INSERT INTO `Log` VALUES('100113 03:43:35 [212.68.144.42] - House Stark has picked a card for battle
'); INSERT INTO `Log` VALUES('100113 02:25:24 [132.77.141.35] - House Baratheon has picked a card for battle
'); INSERT INTO `Log` VALUES('100113 02:22:28 [132.77.141.35] - House Baratheon has picked a card for battle
'); INSERT INTO `Log` VALUES('090113 16:24:48 [2.54.229.106] - House Baratheon has picked a card for battle
'); INSERT INTO `Log` VALUES('090113 16:23:53 [2.54.229.106] - Baratheon has started a battle with Stark
'); INSERT INTO `Log` VALUES('080113 07:10:11 [84.111.184.34] - COULD NOT MOVE UNIT !!!
'); INSERT INTO `Log` VALUES('080113 06:35:43 [84.111.184.34] - Removed control from The Mountains of the Moon
'); INSERT INTO `Log` VALUES('080113 06:35:34 [84.111.184.34] - Order in The Eyrie was changed.
'); INSERT INTO `Log` VALUES('080113 06:35:29 [84.111.184.34] - Moved knight from The Eyrie to The Mountains of the Moon
'); INSERT INTO `Log` VALUES('080113 06:35:20 [84.111.184.34] - Moved knight from The Eyrie to The Mountains of the Moon
'); INSERT INTO `Log` VALUES('080113 06:35:08 [84.111.184.34] - The Mountains of the Moon now belongs to Stark
'); INSERT INTO `Log` VALUES('080113 06:34:53 [84.111.184.34] - The Mountains of the Moon now belongs to
'); -- -------------------------------------------------------- -- -- Table structure for table `MapInfo` -- CREATE TABLE `MapInfo` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Owner` int(11) NOT NULL DEFAULT '0', `Name` text COLLATE latin1_german2_ci NOT NULL, `Control` int(11) NOT NULL DEFAULT '0', `ActualOrder` int(11) NOT NULL DEFAULT '0', `Unit1` int(11) NOT NULL DEFAULT '0', `Unit2` int(11) NOT NULL DEFAULT '0', `Unit3` int(11) NOT NULL DEFAULT '0', `Unit4` int(11) NOT NULL DEFAULT '0', `Unit5` int(11) NOT NULL DEFAULT '0', `Leader1` int(11) NOT NULL DEFAULT '0', `Leader2` int(11) NOT NULL DEFAULT '0', `Leader3` int(11) NOT NULL DEFAULT '0', `Leader4` int(11) NOT NULL DEFAULT '0', `Leader5` int(11) NOT NULL DEFAULT '0', `Leader6` int(11) NOT NULL DEFAULT '0', `Mustering` int(11) NOT NULL DEFAULT '0', `Consolidate` int(11) NOT NULL DEFAULT '0', `Supply` int(11) NOT NULL DEFAULT '0', `Sea` int(11) NOT NULL, `Port` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=77 ; -- -- Dumping data for table `MapInfo` -- INSERT INTO `MapInfo` VALUES(1, 2, 'Castle Black', 0, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(2, 0, 'Karhold', 0, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(3, 2, 'The Shivering Sea', 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(4, 2, 'Winterfell', 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(5, 3, 'The Stony Shore', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(6, 3, 'Bay Of Ice', 0, 13, 4, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(7, 0, 'White Harbor', 0, 0, 1, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(8, 2, 'Widows Watch', 1, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(9, 2, 'Moat Calin', 1, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(10, 2, 'Greywater Watch', 1, 0, 2, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(11, 3, 'Flints Finger', 1, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(12, 3, 'Seagard', 0, 10, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(13, 2, 'The Twins', 0, 13, 1, 2, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(14, 0, 'The Fingers', 1, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(15, 2, 'The Mountains of the Moon', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(16, 2, 'The Eyrie', 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(17, 3, 'Riverrun', 0, 0, 3, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(18, 3, 'Lannisport', 0, 9, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 2, 0, 0); INSERT INTO `MapInfo` VALUES(19, 1, 'Stoney Sept', 1, 6, 2, 2, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(20, 1, 'Harrenhal', 1, 7, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(21, 1, 'Crackclaw Point', 0, 15, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(22, 0, 'Shipbreaker Bay', 0, 13, 4, 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(23, 0, 'Dragonstone', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(24, 0, 'Blackwater Bay', 0, 15, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(25, 1, 'Kings Landing', 1, 5, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0); INSERT INTO `MapInfo` VALUES(26, 1, 'Blackwater', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0); INSERT INTO `MapInfo` VALUES(27, 4, 'Searoad Marches', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(28, 3, 'Ironmans Bay', 0, 13, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(29, 3, 'Pyke', 0, 6, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(30, 3, 'Sunset Sea', 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(31, 3, 'The Golden Sound', 0, 15, 4, 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(32, 4, 'Highgarden', 0, 13, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 2, 0, 0); INSERT INTO `MapInfo` VALUES(33, 4, 'The Reach', 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(34, 1, 'Kingswood', 0, 13, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(35, 0, 'Storms End', 1, 6, 1, 1, 0, 0, 5, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(36, 5, 'The Boneway', 1, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(37, 4, 'Dornish Marches', 1, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(38, 4, 'Oldtown', 1, 4, 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(39, 4, 'Redwyne Straits', 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(40, 4, 'Three Towers', 1, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(41, 5, 'Princes Pass', 1, 13, 1, 2, 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(42, 4, 'Yronwood', 0, 0, 0, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0); INSERT INTO `MapInfo` VALUES(43, 4, 'Sunspear', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 0, 0); INSERT INTO `MapInfo` VALUES(44, 4, 'Salt Shore', 0, 13, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(45, 5, 'Starfall', 1, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0); INSERT INTO `MapInfo` VALUES(46, 4, 'The Arbor', 1, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0); INSERT INTO `MapInfo` VALUES(47, 4, 'West Summer Sea', 0, 0, 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(48, 4, 'East Summer Sea', 0, 0, 4, 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(49, 5, 'Sea of Dorne', 0, 0, 4, 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); INSERT INTO `MapInfo` VALUES(50, 2, 'Port of Winterfell', 0, 10, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(51, 0, 'Port of White Harbor', 0, 10, 4, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(52, 3, 'Port of Pyke', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(53, 3, 'Port of Lannisport', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(54, 0, 'Port of Dragonstone', 0, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(55, 255, 'Port of Oldtown', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(56, 255, 'Port of Storms End', 0, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(57, 5, 'Port of Sunspear', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); INSERT INTO `MapInfo` VALUES(58, 0, 'The Narrow Sea', 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `Neutrals` -- CREATE TABLE `Neutrals` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` text COLLATE latin1_german2_ci NOT NULL, `Display` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=22 ; -- -- Dumping data for table `Neutrals` -- INSERT INTO `Neutrals` VALUES(1, 'The Eyrie 6P', 0); INSERT INTO `Neutrals` VALUES(2, 'Garrison Storms End', 1); INSERT INTO `Neutrals` VALUES(3, 'Garrison Winterfell', 1); INSERT INTO `Neutrals` VALUES(4, 'Garrison Pyke', 1); INSERT INTO `Neutrals` VALUES(5, 'Garrison Dragonstone', 1); INSERT INTO `Neutrals` VALUES(6, 'Garrison Lannisport', 0); INSERT INTO `Neutrals` VALUES(7, 'Garrison Highgarden', 1); INSERT INTO `Neutrals` VALUES(8, 'Garrison Sunspear', 0); INSERT INTO `Neutrals` VALUES(9, 'Garrison Oldtown', 1); -- -------------------------------------------------------- -- -- Table structure for table `PickHouse` -- CREATE TABLE `PickHouse` ( `ID` int(11) NOT NULL, `Assigned` int(11) NOT NULL, `RandomAssignment` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `PickHouse` -- INSERT INTO `PickHouse` VALUES(1, 1, 1); INSERT INTO `PickHouse` VALUES(4, 0, 2); INSERT INTO `PickHouse` VALUES(5, 1, 3); INSERT INTO `PickHouse` VALUES(0, 1, 4); INSERT INTO `PickHouse` VALUES(2, 1, 5); INSERT INTO `PickHouse` VALUES(3, 0, 6);