# MySQL dump 8.12 # # Host: localhost Database: wot #-------------------------------------------------------- # Server version 3.23.32 # # Table structure for table 'artist' # CREATE TABLE artist ( id_artist int(10) unsigned NOT NULL auto_increment, artist varchar(30) default NULL, PRIMARY KEY (id_artist) ) TYPE=MyISAM; # # Dumping data for table 'artist' # INSERT INTO artist VALUES (1,'April Lee'); INSERT INTO artist VALUES (2,'Bill O\'Conner'); INSERT INTO artist VALUES (3,'Chris Arneson'); INSERT INTO artist VALUES (4,'Clyde Caldwell'); INSERT INTO artist VALUES (5,'Darrell Sweet'); INSERT INTO artist VALUES (6,'David Cherry'); INSERT INTO artist VALUES (7,'David Monette'); INSERT INTO artist VALUES (8,'David Pavlec'); INSERT INTO artist VALUES (9,'Denise Harris'); INSERT INTO artist VALUES (10,'Dennis Calero'); INSERT INTO artist VALUES (11,'Diana Stein'); INSERT INTO artist VALUES (12,'Diana Vick'); INSERT INTO artist VALUES (13,'Ed Beard'); INSERT INTO artist VALUES (14,'Ellisa Mitchell'); INSERT INTO artist VALUES (15,'Eric Anderson'); INSERT INTO artist VALUES (16,'Heather Bruton'); INSERT INTO artist VALUES (17,'Jeff Menges'); INSERT INTO artist VALUES (18,'Jim Halloway'); INSERT INTO artist VALUES (19,'Jim Holloway'); INSERT INTO artist VALUES (20,'Jim Hoston'); INSERT INTO artist VALUES (21,'Jim Houston'); INSERT INTO artist VALUES (22,'Jim Pavelec'); INSERT INTO artist VALUES (23,'KC Lancaster'); INSERT INTO artist VALUES (24,'Kelly Freas'); INSERT INTO artist VALUES (25,'Kelly Goodeen'); INSERT INTO artist VALUES (26,'Kenneth Waters'); INSERT INTO artist VALUES (27,'Larry Elmore'); INSERT INTO artist VALUES (28,'Liz Danforth'); INSERT INTO artist VALUES (29,'Mark Poole'); INSERT INTO artist VALUES (30,'Mat Cavotta'); INSERT INTO artist VALUES (31,'Mat Innis'); INSERT INTO artist VALUES (32,'Matt Cavotta'); INSERT INTO artist VALUES (33,'Michael Phillippi'); INSERT INTO artist VALUES (34,'Mike Raabe'); INSERT INTO artist VALUES (35,'Nan Fredman'); INSERT INTO artist VALUES (36,'NŽNŽ Thomas'); INSERT INTO artist VALUES (37,'Nick Jainschigg'); INSERT INTO artist VALUES (38,'Pat Morrisey'); INSERT INTO artist VALUES (39,'Paul Carrick'); INSERT INTO artist VALUES (40,'Paul Herbert'); INSERT INTO artist VALUES (41,'Ran Ackels'); INSERT INTO artist VALUES (42,'Randy Asplund'); INSERT INTO artist VALUES (43,'Rob Carlos'); INSERT INTO artist VALUES (44,'Rob Carlos and Ran Ackels'); INSERT INTO artist VALUES (45,'Ron Rousselle'); INSERT INTO artist VALUES (46,'Ron Walotsky'); INSERT INTO artist VALUES (47,'Stephanie Law'); INSERT INTO artist VALUES (48,'Stephen Daniele'); INSERT INTO artist VALUES (49,'Steve Snyder'); INSERT INTO artist VALUES (50,'Theodor Black'); INSERT INTO artist VALUES (51,'Theresa Brandon'); INSERT INTO artist VALUES (52,'Thomas Manning'); INSERT INTO artist VALUES (53,'Tim Gerstmar'); INSERT INTO artist VALUES (54,'Tina Druce-Hoffman'); INSERT INTO artist VALUES (55,'Tony Moseley'); INSERT INTO artist VALUES (56,'Tony Mosely'); INSERT INTO artist VALUES (57,'Tony Szezudlo'); # # Table structure for table 'attribute' # CREATE TABLE attribute ( id_attribute int(10) unsigned NOT NULL auto_increment, attribute varchar(40) default NULL, PRIMARY KEY (id_attribute) ) TYPE=MyISAM; # # Dumping data for table 'attribute' # INSERT INTO attribute VALUES (1,'Accepted'); INSERT INTO attribute VALUES (2,'Band of the Red Hand'); INSERT INTO attribute VALUES (3,'Black Ajah'); INSERT INTO attribute VALUES (4,'Black Eyes'); INSERT INTO attribute VALUES (5,'Blue Ajah'); INSERT INTO attribute VALUES (6,'Bonded to Birgitte'); INSERT INTO attribute VALUES (7,'Bonded to Elayne Trakand'); INSERT INTO attribute VALUES (8,'Bonded to Ihvon'); INSERT INTO attribute VALUES (9,'Bonded to Lan Mandragoran'); INSERT INTO attribute VALUES (10,'Bonded to Moiraine Sedai'); INSERT INTO attribute VALUES (11,'Bonded to Owein'); INSERT INTO attribute VALUES (12,'Borderland'); INSERT INTO attribute VALUES (13,'Brown Ajah'); INSERT INTO attribute VALUES (14,'Capital of Andor'); INSERT INTO attribute VALUES (15,'Capital of Cairhien'); INSERT INTO attribute VALUES (16,'Capital of Illian'); INSERT INTO attribute VALUES (17,'Car\'a\'carn'); INSERT INTO attribute VALUES (18,'Chareen Aiel'); INSERT INTO attribute VALUES (19,'Clan Chief of the Codarra Aiel'); INSERT INTO attribute VALUES (20,'Clan Chief of the Daryne Aiel'); INSERT INTO attribute VALUES (21,'Clan Chief of the Goshien Aiel'); INSERT INTO attribute VALUES (22,'Clan Chief of the Miagoma Aiel'); INSERT INTO attribute VALUES (23,'Clan Chief of the Nakai Aiel'); INSERT INTO attribute VALUES (24,'Clan Chief of the Reyn Aiel'); INSERT INTO attribute VALUES (25,'Clan Chief of the Shaarad Aiel'); INSERT INTO attribute VALUES (26,'Clan Chief of the Shiande Aiel'); INSERT INTO attribute VALUES (27,'Clan Chief of the Taardad Aiel'); INSERT INTO attribute VALUES (28,'Clan Chief of the Tomanelle Aiel'); INSERT INTO attribute VALUES (29,'Contested Advantage'); INSERT INTO attribute VALUES (30,'Council of Nine'); INSERT INTO attribute VALUES (31,'Dark Nature'); INSERT INTO attribute VALUES (32,'Daughter-Heir'); INSERT INTO attribute VALUES (33,'Dragon Reborn'); INSERT INTO attribute VALUES (34,'Dreamwalker'); INSERT INTO attribute VALUES (35,'First Captain of the Companions'); INSERT INTO attribute VALUES (36,'First of Mayene'); INSERT INTO attribute VALUES (37,'Forsaken'); INSERT INTO attribute VALUES (38,'Gleeman'); INSERT INTO attribute VALUES (39,'Goshien Aiel'); INSERT INTO attribute VALUES (40,'Green Ajah'); INSERT INTO attribute VALUES (41,'Hero of the Horn'); INSERT INTO attribute VALUES (42,'High Inquisitor'); INSERT INTO attribute VALUES (43,'Hunter of the Horn'); INSERT INTO attribute VALUES (44,'Illuminator'); INSERT INTO attribute VALUES (45,'Inquisitor'); INSERT INTO attribute VALUES (46,'Keeper of the Chronicles'); INSERT INTO attribute VALUES (47,'King of Illian'); INSERT INTO attribute VALUES (48,'Light Nature'); INSERT INTO attribute VALUES (49,'Lord Captain'); INSERT INTO attribute VALUES (50,'Lord Captain Commander'); INSERT INTO attribute VALUES (51,'Maiden of the Spear'); INSERT INTO attribute VALUES (52,'Malkier'); INSERT INTO attribute VALUES (53,'Miagoma Aiel'); INSERT INTO attribute VALUES (54,'Monster'); INSERT INTO attribute VALUES (55,'Multiple'); INSERT INTO attribute VALUES (56,'Myrddraal'); INSERT INTO attribute VALUES (57,'Nakai Aiel'); INSERT INTO attribute VALUES (58,'Nation Contested Advantage'); INSERT INTO attribute VALUES (59,'Novice'); INSERT INTO attribute VALUES (60,'Ogier'); INSERT INTO attribute VALUES (61,'Peddler'); INSERT INTO attribute VALUES (62,'Prophecy'); INSERT INTO attribute VALUES (63,'Queen of Andor'); INSERT INTO attribute VALUES (64,'Red Ajah'); INSERT INTO attribute VALUES (65,'Red Shield'); INSERT INTO attribute VALUES (66,'Reinforcement'); INSERT INTO attribute VALUES (67,'Repeatable'); INSERT INTO attribute VALUES (68,'Reyn Aiel'); INSERT INTO attribute VALUES (69,'Roofmistress of Cold Rocks Hold'); INSERT INTO attribute VALUES (70,'Roofmistress of Comarda Hold'); INSERT INTO attribute VALUES (71,'Saldean'); INSERT INTO attribute VALUES (72,'Shaarad Aiel'); INSERT INTO attribute VALUES (73,'Shaido Aiel'); INSERT INTO attribute VALUES (74,'Shiande Aiel'); INSERT INTO attribute VALUES (75,'Spymaster'); INSERT INTO attribute VALUES (76,'Starting Advantage'); INSERT INTO attribute VALUES (77,'Starting Hero'); INSERT INTO attribute VALUES (78,'Starting Villain'); INSERT INTO attribute VALUES (79,'Stone Dog'); INSERT INTO attribute VALUES (80,'Taardad Aiel'); INSERT INTO attribute VALUES (81,'Ta\'veren'); INSERT INTO attribute VALUES (82,'Terrain'); INSERT INTO attribute VALUES (83,'The Amyrlin Seat'); INSERT INTO attribute VALUES (84,'Thief-Catcher'); INSERT INTO attribute VALUES (85,'Tomanelle Aiel'); INSERT INTO attribute VALUES (86,'Treesinger'); INSERT INTO attribute VALUES (87,'Trolloc'); INSERT INTO attribute VALUES (88,'Two Rivers'); INSERT INTO attribute VALUES (89,'Unique'); INSERT INTO attribute VALUES (90,'Warder'); INSERT INTO attribute VALUES (91,'Weapon'); INSERT INTO attribute VALUES (92,'Wise One'); INSERT INTO attribute VALUES (93,'Wolf'); INSERT INTO attribute VALUES (94,'Wolfbrother'); INSERT INTO attribute VALUES (95,'Yellow Ajah'); INSERT INTO attribute VALUES (96,'King of Cairhien'); INSERT INTO attribute VALUES (97,'Children of the Light'); INSERT INTO attribute VALUES (98,'Cairhien'); INSERT INTO attribute VALUES (99,'Clan Chief of the Chareen Aiel'); INSERT INTO attribute VALUES (100,'Aiel'); # # Table structure for table 'card_attribute' # CREATE TABLE card_attribute ( id_card int(10) unsigned default NULL, id_attribute int(10) unsigned default NULL ) TYPE=MyISAM; # # Dumping data for table 'card_attribute' # INSERT INTO card_attribute VALUES (4,55); INSERT INTO card_attribute VALUES (19,15); INSERT INTO card_attribute VALUES (20,34); INSERT INTO card_attribute VALUES (20,48); INSERT INTO card_attribute VALUES (20,93); INSERT INTO card_attribute VALUES (20,80); INSERT INTO card_attribute VALUES (21,58); INSERT INTO card_attribute VALUES (22,55); INSERT INTO card_attribute VALUES (22,66); INSERT INTO card_attribute VALUES (23,55); INSERT INTO card_attribute VALUES (24,55); INSERT INTO card_attribute VALUES (26,78); INSERT INTO card_attribute VALUES (26,37); INSERT INTO card_attribute VALUES (29,48); INSERT INTO card_attribute VALUES (29,51); INSERT INTO card_attribute VALUES (29,80); INSERT INTO card_attribute VALUES (30,51); INSERT INTO card_attribute VALUES (30,72); INSERT INTO card_attribute VALUES (32,78); INSERT INTO card_attribute VALUES (32,37); INSERT INTO card_attribute VALUES (33,36); INSERT INTO card_attribute VALUES (40,14); INSERT INTO card_attribute VALUES (41,58); INSERT INTO card_attribute VALUES (42,55); INSERT INTO card_attribute VALUES (43,66); INSERT INTO card_attribute VALUES (48,55); INSERT INTO card_attribute VALUES (50,51); INSERT INTO card_attribute VALUES (50,39); INSERT INTO card_attribute VALUES (53,55); INSERT INTO card_attribute VALUES (63,55); INSERT INTO card_attribute VALUES (64,54); INSERT INTO card_attribute VALUES (64,55); INSERT INTO card_attribute VALUES (64,66); INSERT INTO card_attribute VALUES (69,82); INSERT INTO card_attribute VALUES (72,54); INSERT INTO card_attribute VALUES (72,55); INSERT INTO card_attribute VALUES (72,66); INSERT INTO card_attribute VALUES (74,55); INSERT INTO card_attribute VALUES (77,49); INSERT INTO card_attribute VALUES (79,59); INSERT INTO card_attribute VALUES (79,48); INSERT INTO card_attribute VALUES (80,1); INSERT INTO card_attribute VALUES (80,34); INSERT INTO card_attribute VALUES (80,48); INSERT INTO card_attribute VALUES (81,64); INSERT INTO card_attribute VALUES (82,48); INSERT INTO card_attribute VALUES (82,32); INSERT INTO card_attribute VALUES (83,94); INSERT INTO card_attribute VALUES (87,54); INSERT INTO card_attribute VALUES (87,55); INSERT INTO card_attribute VALUES (87,56); INSERT INTO card_attribute VALUES (95,29); INSERT INTO card_attribute VALUES (96,55); INSERT INTO card_attribute VALUES (102,96); INSERT INTO card_attribute VALUES (103,48); INSERT INTO card_attribute VALUES (107,48); INSERT INTO card_attribute VALUES (107,79); INSERT INTO card_attribute VALUES (107,72); INSERT INTO card_attribute VALUES (108,49); INSERT INTO card_attribute VALUES (109,78); INSERT INTO card_attribute VALUES (109,37); INSERT INTO card_attribute VALUES (110,55); INSERT INTO card_attribute VALUES (112,54); INSERT INTO card_attribute VALUES (112,55); INSERT INTO card_attribute VALUES (112,56); INSERT INTO card_attribute VALUES (120,91); INSERT INTO card_attribute VALUES (132,55); INSERT INTO card_attribute VALUES (133,29); INSERT INTO card_attribute VALUES (133,89); INSERT INTO card_attribute VALUES (134,82); INSERT INTO card_attribute VALUES (135,55); INSERT INTO card_attribute VALUES (136,31); INSERT INTO card_attribute VALUES (136,55); INSERT INTO card_attribute VALUES (147,78); INSERT INTO card_attribute VALUES (147,37); INSERT INTO card_attribute VALUES (148,45); INSERT INTO card_attribute VALUES (150,48); INSERT INTO card_attribute VALUES (150,84); INSERT INTO card_attribute VALUES (152,48); INSERT INTO card_attribute VALUES (153,48); INSERT INTO card_attribute VALUES (155,31); INSERT INTO card_attribute VALUES (156,48); INSERT INTO card_attribute VALUES (157,90); INSERT INTO card_attribute VALUES (157,48); INSERT INTO card_attribute VALUES (157,10); INSERT INTO card_attribute VALUES (158,78); INSERT INTO card_attribute VALUES (158,37); INSERT INTO card_attribute VALUES (158,34); INSERT INTO card_attribute VALUES (160,3); INSERT INTO card_attribute VALUES (161,55); INSERT INTO card_attribute VALUES (165,86); INSERT INTO card_attribute VALUES (165,60); INSERT INTO card_attribute VALUES (166,91); INSERT INTO card_attribute VALUES (171,31); INSERT INTO card_attribute VALUES (172,31); INSERT INTO card_attribute VALUES (173,66); INSERT INTO card_attribute VALUES (174,31); INSERT INTO card_attribute VALUES (175,48); INSERT INTO card_attribute VALUES (176,81); INSERT INTO card_attribute VALUES (176,94); INSERT INTO card_attribute VALUES (176,66); INSERT INTO card_attribute VALUES (179,91); INSERT INTO card_attribute VALUES (180,81); INSERT INTO card_attribute VALUES (181,81); INSERT INTO card_attribute VALUES (184,78); INSERT INTO card_attribute VALUES (184,37); INSERT INTO card_attribute VALUES (184,34); INSERT INTO card_attribute VALUES (185,5); INSERT INTO card_attribute VALUES (185,48); INSERT INTO card_attribute VALUES (185,9); INSERT INTO card_attribute VALUES (187,48); INSERT INTO card_attribute VALUES (187,63); INSERT INTO card_attribute VALUES (189,29); INSERT INTO card_attribute VALUES (190,54); INSERT INTO card_attribute VALUES (190,87); INSERT INTO card_attribute VALUES (193,1); INSERT INTO card_attribute VALUES (193,48); INSERT INTO card_attribute VALUES (196,55); INSERT INTO card_attribute VALUES (197,50); INSERT INTO card_attribute VALUES (198,81); INSERT INTO card_attribute VALUES (198,94); INSERT INTO card_attribute VALUES (211,78); INSERT INTO card_attribute VALUES (211,37); INSERT INTO card_attribute VALUES (212,55); INSERT INTO card_attribute VALUES (212,66); INSERT INTO card_attribute VALUES (215,77); INSERT INTO card_attribute VALUES (215,33); INSERT INTO card_attribute VALUES (215,81); INSERT INTO card_attribute VALUES (216,77); INSERT INTO card_attribute VALUES (216,33); INSERT INTO card_attribute VALUES (216,81); INSERT INTO card_attribute VALUES (217,77); INSERT INTO card_attribute VALUES (217,33); INSERT INTO card_attribute VALUES (217,81); INSERT INTO card_attribute VALUES (218,77); INSERT INTO card_attribute VALUES (218,33); INSERT INTO card_attribute VALUES (218,81); INSERT INTO card_attribute VALUES (232,48); INSERT INTO card_attribute VALUES (232,27); INSERT INTO card_attribute VALUES (232,80); INSERT INTO card_attribute VALUES (238,55); INSERT INTO card_attribute VALUES (238,66); INSERT INTO card_attribute VALUES (245,55); INSERT INTO card_attribute VALUES (246,54); INSERT INTO card_attribute VALUES (248,29); INSERT INTO card_attribute VALUES (250,83); INSERT INTO card_attribute VALUES (250,48); INSERT INTO card_attribute VALUES (255,82); INSERT INTO card_attribute VALUES (259,91); INSERT INTO card_attribute VALUES (263,29); INSERT INTO card_attribute VALUES (264,55); INSERT INTO card_attribute VALUES (265,55); INSERT INTO card_attribute VALUES (265,66); INSERT INTO card_attribute VALUES (266,58); INSERT INTO card_attribute VALUES (267,66); INSERT INTO card_attribute VALUES (268,55); INSERT INTO card_attribute VALUES (269,55); INSERT INTO card_attribute VALUES (270,55); INSERT INTO card_attribute VALUES (274,82); INSERT INTO card_attribute VALUES (276,91); INSERT INTO card_attribute VALUES (276,89); INSERT INTO card_attribute VALUES (284,38); INSERT INTO card_attribute VALUES (289,54); INSERT INTO card_attribute VALUES (289,55); INSERT INTO card_attribute VALUES (290,54); INSERT INTO card_attribute VALUES (291,54); INSERT INTO card_attribute VALUES (291,55); INSERT INTO card_attribute VALUES (293,54); INSERT INTO card_attribute VALUES (293,55); INSERT INTO card_attribute VALUES (294,54); INSERT INTO card_attribute VALUES (294,55); INSERT INTO card_attribute VALUES (299,13); INSERT INTO card_attribute VALUES (299,48); INSERT INTO card_attribute VALUES (301,55); INSERT INTO card_attribute VALUES (307,55); INSERT INTO card_attribute VALUES (307,66); INSERT INTO card_attribute VALUES (307,93); INSERT INTO card_attribute VALUES (308,62); INSERT INTO card_attribute VALUES (308,67); INSERT INTO card_attribute VALUES (310,40); INSERT INTO card_attribute VALUES (310,8); INSERT INTO card_attribute VALUES (310,11); INSERT INTO card_attribute VALUES (312,48); INSERT INTO card_attribute VALUES (312,92); INSERT INTO card_attribute VALUES (312,72); INSERT INTO card_attribute VALUES (312,34); INSERT INTO card_attribute VALUES (315,48); INSERT INTO card_attribute VALUES (316,37); INSERT INTO card_attribute VALUES (319,55); INSERT INTO card_attribute VALUES (323,31); INSERT INTO card_attribute VALUES (323,95); INSERT INTO card_attribute VALUES (323,3); INSERT INTO card_attribute VALUES (324,55); INSERT INTO card_attribute VALUES (327,55); INSERT INTO card_attribute VALUES (329,82); INSERT INTO card_attribute VALUES (330,31); INSERT INTO card_attribute VALUES (330,73); INSERT INTO card_attribute VALUES (330,4); INSERT INTO card_attribute VALUES (332,82); INSERT INTO card_attribute VALUES (333,66); INSERT INTO card_attribute VALUES (336,48); INSERT INTO card_attribute VALUES (336,32); INSERT INTO card_attribute VALUES (336,1); INSERT INTO card_attribute VALUES (336,6); INSERT INTO card_attribute VALUES (337,54); INSERT INTO card_attribute VALUES (337,55); INSERT INTO card_attribute VALUES (337,56); INSERT INTO card_attribute VALUES (338,12); INSERT INTO card_attribute VALUES (338,71); INSERT INTO card_attribute VALUES (338,43); INSERT INTO card_attribute VALUES (339,66); INSERT INTO card_attribute VALUES (339,51); INSERT INTO card_attribute VALUES (340,2); INSERT INTO card_attribute VALUES (340,66); INSERT INTO card_attribute VALUES (341,97); INSERT INTO card_attribute VALUES (342,48); INSERT INTO card_attribute VALUES (345,37); INSERT INTO card_attribute VALUES (347,55); INSERT INTO card_attribute VALUES (347,66); INSERT INTO card_attribute VALUES (351,66); INSERT INTO card_attribute VALUES (351,93); INSERT INTO card_attribute VALUES (352,55); INSERT INTO card_attribute VALUES (353,58); INSERT INTO card_attribute VALUES (354,55); INSERT INTO card_attribute VALUES (355,55); INSERT INTO card_attribute VALUES (360,37); INSERT INTO card_attribute VALUES (363,98); INSERT INTO card_attribute VALUES (364,47); INSERT INTO card_attribute VALUES (366,37); INSERT INTO card_attribute VALUES (366,34); INSERT INTO card_attribute VALUES (369,5); INSERT INTO card_attribute VALUES (369,46); INSERT INTO card_attribute VALUES (370,66); INSERT INTO card_attribute VALUES (372,55); INSERT INTO card_attribute VALUES (372,66); INSERT INTO card_attribute VALUES (374,30); INSERT INTO card_attribute VALUES (375,30); INSERT INTO card_attribute VALUES (377,31); INSERT INTO card_attribute VALUES (378,48); INSERT INTO card_attribute VALUES (380,30); INSERT INTO card_attribute VALUES (381,30); INSERT INTO card_attribute VALUES (382,48); INSERT INTO card_attribute VALUES (382,30); INSERT INTO card_attribute VALUES (383,30); INSERT INTO card_attribute VALUES (384,30); INSERT INTO card_attribute VALUES (386,30); INSERT INTO card_attribute VALUES (388,81); INSERT INTO card_attribute VALUES (389,37); INSERT INTO card_attribute VALUES (389,51); INSERT INTO card_attribute VALUES (389,73); INSERT INTO card_attribute VALUES (391,37); INSERT INTO card_attribute VALUES (391,34); INSERT INTO card_attribute VALUES (392,82); INSERT INTO card_attribute VALUES (403,55); INSERT INTO card_attribute VALUES (404,37); INSERT INTO card_attribute VALUES (405,77); INSERT INTO card_attribute VALUES (405,33); INSERT INTO card_attribute VALUES (405,81); INSERT INTO card_attribute VALUES (406,77); INSERT INTO card_attribute VALUES (406,33); INSERT INTO card_attribute VALUES (406,81); INSERT INTO card_attribute VALUES (407,77); INSERT INTO card_attribute VALUES (407,33); INSERT INTO card_attribute VALUES (407,81); INSERT INTO card_attribute VALUES (408,42); INSERT INTO card_attribute VALUES (410,55); INSERT INTO card_attribute VALUES (411,78); INSERT INTO card_attribute VALUES (411,37); INSERT INTO card_attribute VALUES (412,75); INSERT INTO card_attribute VALUES (413,2); INSERT INTO card_attribute VALUES (417,55); INSERT INTO card_attribute VALUES (422,51); INSERT INTO card_attribute VALUES (425,16); INSERT INTO card_attribute VALUES (426,66); INSERT INTO card_attribute VALUES (429,62); INSERT INTO card_attribute VALUES (436,62); INSERT INTO card_attribute VALUES (440,29); INSERT INTO card_attribute VALUES (441,62); INSERT INTO card_attribute VALUES (442,62); INSERT INTO card_attribute VALUES (447,2); INSERT INTO card_attribute VALUES (448,54); INSERT INTO card_attribute VALUES (449,54); INSERT INTO card_attribute VALUES (450,62); INSERT INTO card_attribute VALUES (455,55); INSERT INTO card_attribute VALUES (455,90); INSERT INTO card_attribute VALUES (456,31); INSERT INTO card_attribute VALUES (458,94); INSERT INTO card_attribute VALUES (458,81); INSERT INTO card_attribute VALUES (458,66); INSERT INTO card_attribute VALUES (460,12); INSERT INTO card_attribute VALUES (460,52); INSERT INTO card_attribute VALUES (461,55); INSERT INTO card_attribute VALUES (462,92); INSERT INTO card_attribute VALUES (462,73); INSERT INTO card_attribute VALUES (462,31); INSERT INTO card_attribute VALUES (464,44); INSERT INTO card_attribute VALUES (467,55); INSERT INTO card_attribute VALUES (467,66); INSERT INTO card_attribute VALUES (468,91); INSERT INTO card_attribute VALUES (469,92); INSERT INTO card_attribute VALUES (471,21); INSERT INTO card_attribute VALUES (472,78); INSERT INTO card_attribute VALUES (472,37); INSERT INTO card_attribute VALUES (474,92); INSERT INTO card_attribute VALUES (474,73); INSERT INTO card_attribute VALUES (474,31); INSERT INTO card_attribute VALUES (475,90); INSERT INTO card_attribute VALUES (475,7); INSERT INTO card_attribute VALUES (475,41); INSERT INTO card_attribute VALUES (475,48); INSERT INTO card_attribute VALUES (476,23); INSERT INTO card_attribute VALUES (479,55); INSERT INTO card_attribute VALUES (482,76); INSERT INTO card_attribute VALUES (483,92); INSERT INTO card_attribute VALUES (483,53); INSERT INTO card_attribute VALUES (483,48); INSERT INTO card_attribute VALUES (485,76); INSERT INTO card_attribute VALUES (486,76); INSERT INTO card_attribute VALUES (488,92); INSERT INTO card_attribute VALUES (488,72); INSERT INTO card_attribute VALUES (488,48); INSERT INTO card_attribute VALUES (489,55); INSERT INTO card_attribute VALUES (489,31); INSERT INTO card_attribute VALUES (491,17); INSERT INTO card_attribute VALUES (491,31); INSERT INTO card_attribute VALUES (492,93); INSERT INTO card_attribute VALUES (492,66); INSERT INTO card_attribute VALUES (495,35); INSERT INTO card_attribute VALUES (496,51); INSERT INTO card_attribute VALUES (496,68); INSERT INTO card_attribute VALUES (498,24); INSERT INTO card_attribute VALUES (502,92); INSERT INTO card_attribute VALUES (502,73); INSERT INTO card_attribute VALUES (502,48); INSERT INTO card_attribute VALUES (503,51); INSERT INTO card_attribute VALUES (503,18); INSERT INTO card_attribute VALUES (504,505); INSERT INTO card_attribute VALUES (506,2); INSERT INTO card_attribute VALUES (508,54); INSERT INTO card_attribute VALUES (509,55); INSERT INTO card_attribute VALUES (509,2); INSERT INTO card_attribute VALUES (512,31); INSERT INTO card_attribute VALUES (512,61); INSERT INTO card_attribute VALUES (513,91); INSERT INTO card_attribute VALUES (514,28); INSERT INTO card_attribute VALUES (515,62); INSERT INTO card_attribute VALUES (516,62); INSERT INTO card_attribute VALUES (519,55); INSERT INTO card_attribute VALUES (521,19); INSERT INTO card_attribute VALUES (522,31); INSERT INTO card_attribute VALUES (522,61); INSERT INTO card_attribute VALUES (523,26); INSERT INTO card_attribute VALUES (524,25); INSERT INTO card_attribute VALUES (525,76); INSERT INTO card_attribute VALUES (526,51); INSERT INTO card_attribute VALUES (526,57); INSERT INTO card_attribute VALUES (529,76); INSERT INTO card_attribute VALUES (531,51); INSERT INTO card_attribute VALUES (531,18); INSERT INTO card_attribute VALUES (532,48); INSERT INTO card_attribute VALUES (532,69); INSERT INTO card_attribute VALUES (532,80); INSERT INTO card_attribute VALUES (533,76); INSERT INTO card_attribute VALUES (535,30); INSERT INTO card_attribute VALUES (538,76); INSERT INTO card_attribute VALUES (539,51); INSERT INTO card_attribute VALUES (539,85); INSERT INTO card_attribute VALUES (541,20); INSERT INTO card_attribute VALUES (542,79); INSERT INTO card_attribute VALUES (542,80); INSERT INTO card_attribute VALUES (544,48); INSERT INTO card_attribute VALUES (545,81); INSERT INTO card_attribute VALUES (545,66); INSERT INTO card_attribute VALUES (546,92); INSERT INTO card_attribute VALUES (546,73); INSERT INTO card_attribute VALUES (546,31); INSERT INTO card_attribute VALUES (547,92); INSERT INTO card_attribute VALUES (547,48); INSERT INTO card_attribute VALUES (547,34); INSERT INTO card_attribute VALUES (547,39); INSERT INTO card_attribute VALUES (548,55); INSERT INTO card_attribute VALUES (548,31); INSERT INTO card_attribute VALUES (551,92); INSERT INTO card_attribute VALUES (551,73); INSERT INTO card_attribute VALUES (553,51); INSERT INTO card_attribute VALUES (553,80); INSERT INTO card_attribute VALUES (556,54); INSERT INTO card_attribute VALUES (556,55); INSERT INTO card_attribute VALUES (556,56); INSERT INTO card_attribute VALUES (556,66); INSERT INTO card_attribute VALUES (560,94); INSERT INTO card_attribute VALUES (560,81); INSERT INTO card_attribute VALUES (560,66); INSERT INTO card_attribute VALUES (560,88); INSERT INTO card_attribute VALUES (561,77); INSERT INTO card_attribute VALUES (561,33); INSERT INTO card_attribute VALUES (561,81); INSERT INTO card_attribute VALUES (562,77); INSERT INTO card_attribute VALUES (562,33); INSERT INTO card_attribute VALUES (562,81); INSERT INTO card_attribute VALUES (562,100); INSERT INTO card_attribute VALUES (563,77); INSERT INTO card_attribute VALUES (563,33); INSERT INTO card_attribute VALUES (563,81); INSERT INTO card_attribute VALUES (565,62); INSERT INTO card_attribute VALUES (567,92); INSERT INTO card_attribute VALUES (567,73); INSERT INTO card_attribute VALUES (567,31); INSERT INTO card_attribute VALUES (569,37); INSERT INTO card_attribute VALUES (570,92); INSERT INTO card_attribute VALUES (570,48); INSERT INTO card_attribute VALUES (570,34); INSERT INTO card_attribute VALUES (570,57); INSERT INTO card_attribute VALUES (571,55); INSERT INTO card_attribute VALUES (572,92); INSERT INTO card_attribute VALUES (572,73); INSERT INTO card_attribute VALUES (572,70); INSERT INTO card_attribute VALUES (572,31); INSERT INTO card_attribute VALUES (574,31); INSERT INTO card_attribute VALUES (577,55); INSERT INTO card_attribute VALUES (577,48); INSERT INTO card_attribute VALUES (578,2); INSERT INTO card_attribute VALUES (579,92); INSERT INTO card_attribute VALUES (579,73); INSERT INTO card_attribute VALUES (579,31); INSERT INTO card_attribute VALUES (580,92); INSERT INTO card_attribute VALUES (580,18); INSERT INTO card_attribute VALUES (580,48); INSERT INTO card_attribute VALUES (582,76); INSERT INTO card_attribute VALUES (583,48); INSERT INTO card_attribute VALUES (584,66); INSERT INTO card_attribute VALUES (584,88); INSERT INTO card_attribute VALUES (586,55); INSERT INTO card_attribute VALUES (593,58); INSERT INTO card_attribute VALUES (595,29); INSERT INTO card_attribute VALUES (598,92); INSERT INTO card_attribute VALUES (598,73); INSERT INTO card_attribute VALUES (600,22); INSERT INTO card_attribute VALUES (601,92); INSERT INTO card_attribute VALUES (601,73); INSERT INTO card_attribute VALUES (604,54); INSERT INTO card_attribute VALUES (605,54); INSERT INTO card_attribute VALUES (605,55); INSERT INTO card_attribute VALUES (606,65); INSERT INTO card_attribute VALUES (606,68); INSERT INTO card_attribute VALUES (609,55); INSERT INTO card_attribute VALUES (612,94); INSERT INTO card_attribute VALUES (612,93); INSERT INTO card_attribute VALUES (612,55); # # Table structure for table 'card_subtype' # CREATE TABLE card_subtype ( id_card int(10) unsigned default NULL, id_subtype int(10) unsigned default NULL ) TYPE=MyISAM; # # Dumping data for table 'card_subtype' # INSERT INTO card_subtype VALUES (4,7); INSERT INTO card_subtype VALUES (5,10); INSERT INTO card_subtype VALUES (8,12); INSERT INTO card_subtype VALUES (9,5); INSERT INTO card_subtype VALUES (13,5); INSERT INTO card_subtype VALUES (15,10); INSERT INTO card_subtype VALUES (18,5); INSERT INTO card_subtype VALUES (19,12); INSERT INTO card_subtype VALUES (20,2); INSERT INTO card_subtype VALUES (21,15); INSERT INTO card_subtype VALUES (22,3); INSERT INTO card_subtype VALUES (23,3); INSERT INTO card_subtype VALUES (24,3); INSERT INTO card_subtype VALUES (26,7); INSERT INTO card_subtype VALUES (28,5); INSERT INTO card_subtype VALUES (29,2); INSERT INTO card_subtype VALUES (30,2); INSERT INTO card_subtype VALUES (32,7); INSERT INTO card_subtype VALUES (33,8); INSERT INTO card_subtype VALUES (36,5); INSERT INTO card_subtype VALUES (40,12); INSERT INTO card_subtype VALUES (41,15); INSERT INTO card_subtype VALUES (42,4); INSERT INTO card_subtype VALUES (43,4); INSERT INTO card_subtype VALUES (45,12); INSERT INTO card_subtype VALUES (48,11); INSERT INTO card_subtype VALUES (50,2); INSERT INTO card_subtype VALUES (52,5); INSERT INTO card_subtype VALUES (53,11); INSERT INTO card_subtype VALUES (54,5); INSERT INTO card_subtype VALUES (55,5); INSERT INTO card_subtype VALUES (59,6); INSERT INTO card_subtype VALUES (60,12); INSERT INTO card_subtype VALUES (61,12); INSERT INTO card_subtype VALUES (62,5); INSERT INTO card_subtype VALUES (63,7); INSERT INTO card_subtype VALUES (64,7); INSERT INTO card_subtype VALUES (72,7); INSERT INTO card_subtype VALUES (73,12); INSERT INTO card_subtype VALUES (74,8); INSERT INTO card_subtype VALUES (77,6); INSERT INTO card_subtype VALUES (79,1); INSERT INTO card_subtype VALUES (80,1); INSERT INTO card_subtype VALUES (81,1); INSERT INTO card_subtype VALUES (82,3); INSERT INTO card_subtype VALUES (83,11); INSERT INTO card_subtype VALUES (84,5); INSERT INTO card_subtype VALUES (87,7); INSERT INTO card_subtype VALUES (89,5); INSERT INTO card_subtype VALUES (94,12); INSERT INTO card_subtype VALUES (95,15); INSERT INTO card_subtype VALUES (96,11); INSERT INTO card_subtype VALUES (99,10); INSERT INTO card_subtype VALUES (100,12); INSERT INTO card_subtype VALUES (102,4); INSERT INTO card_subtype VALUES (103,3); INSERT INTO card_subtype VALUES (104,10); INSERT INTO card_subtype VALUES (107,2); INSERT INTO card_subtype VALUES (108,6); INSERT INTO card_subtype VALUES (109,7); INSERT INTO card_subtype VALUES (110,7); INSERT INTO card_subtype VALUES (112,7); INSERT INTO card_subtype VALUES (116,14); INSERT INTO card_subtype VALUES (118,5); INSERT INTO card_subtype VALUES (120,5); INSERT INTO card_subtype VALUES (121,12); INSERT INTO card_subtype VALUES (123,13); INSERT INTO card_subtype VALUES (124,13); INSERT INTO card_subtype VALUES (125,13); INSERT INTO card_subtype VALUES (126,13); INSERT INTO card_subtype VALUES (127,13); INSERT INTO card_subtype VALUES (128,5); INSERT INTO card_subtype VALUES (129,13); INSERT INTO card_subtype VALUES (130,13); INSERT INTO card_subtype VALUES (132,11); INSERT INTO card_subtype VALUES (133,15); INSERT INTO card_subtype VALUES (135,4); INSERT INTO card_subtype VALUES (136,11); INSERT INTO card_subtype VALUES (141,10); INSERT INTO card_subtype VALUES (143,12); INSERT INTO card_subtype VALUES (144,5); INSERT INTO card_subtype VALUES (145,10); INSERT INTO card_subtype VALUES (146,10); INSERT INTO card_subtype VALUES (147,7); INSERT INTO card_subtype VALUES (148,7); INSERT INTO card_subtype VALUES (148,6); INSERT INTO card_subtype VALUES (149,5); INSERT INTO card_subtype VALUES (150,13); INSERT INTO card_subtype VALUES (152,3); INSERT INTO card_subtype VALUES (153,3); INSERT INTO card_subtype VALUES (154,4); INSERT INTO card_subtype VALUES (155,3); INSERT INTO card_subtype VALUES (156,3); INSERT INTO card_subtype VALUES (157,1); INSERT INTO card_subtype VALUES (158,7); INSERT INTO card_subtype VALUES (160,7); INSERT INTO card_subtype VALUES (160,1); INSERT INTO card_subtype VALUES (161,11); INSERT INTO card_subtype VALUES (165,8); INSERT INTO card_subtype VALUES (166,5); INSERT INTO card_subtype VALUES (167,7); INSERT INTO card_subtype VALUES (167,4); INSERT INTO card_subtype VALUES (168,4); INSERT INTO card_subtype VALUES (169,13); INSERT INTO card_subtype VALUES (170,5); INSERT INTO card_subtype VALUES (171,3); INSERT INTO card_subtype VALUES (172,3); INSERT INTO card_subtype VALUES (173,4); INSERT INTO card_subtype VALUES (174,3); INSERT INTO card_subtype VALUES (175,3); INSERT INTO card_subtype VALUES (176,8); INSERT INTO card_subtype VALUES (177,4); INSERT INTO card_subtype VALUES (179,14); INSERT INTO card_subtype VALUES (180,8); INSERT INTO card_subtype VALUES (181,8); INSERT INTO card_subtype VALUES (182,8); INSERT INTO card_subtype VALUES (184,7); INSERT INTO card_subtype VALUES (185,1); INSERT INTO card_subtype VALUES (186,12); INSERT INTO card_subtype VALUES (187,3); INSERT INTO card_subtype VALUES (188,5); INSERT INTO card_subtype VALUES (189,15); INSERT INTO card_subtype VALUES (190,7); INSERT INTO card_subtype VALUES (193,1); INSERT INTO card_subtype VALUES (195,7); INSERT INTO card_subtype VALUES (196,6); INSERT INTO card_subtype VALUES (197,6); INSERT INTO card_subtype VALUES (198,8); INSERT INTO card_subtype VALUES (204,10); INSERT INTO card_subtype VALUES (206,10); INSERT INTO card_subtype VALUES (210,3); INSERT INTO card_subtype VALUES (211,7); INSERT INTO card_subtype VALUES (212,2); INSERT INTO card_subtype VALUES (215,8); INSERT INTO card_subtype VALUES (216,8); INSERT INTO card_subtype VALUES (217,8); INSERT INTO card_subtype VALUES (218,8); INSERT INTO card_subtype VALUES (219,8); INSERT INTO card_subtype VALUES (222,12); INSERT INTO card_subtype VALUES (223,12); INSERT INTO card_subtype VALUES (224,12); INSERT INTO card_subtype VALUES (225,10); INSERT INTO card_subtype VALUES (226,10); INSERT INTO card_subtype VALUES (230,12); INSERT INTO card_subtype VALUES (231,12); INSERT INTO card_subtype VALUES (232,2); INSERT INTO card_subtype VALUES (236,5); INSERT INTO card_subtype VALUES (237,5); INSERT INTO card_subtype VALUES (238,2); INSERT INTO card_subtype VALUES (240,5); INSERT INTO card_subtype VALUES (241,12); INSERT INTO card_subtype VALUES (245,11); INSERT INTO card_subtype VALUES (246,7); INSERT INTO card_subtype VALUES (248,15); INSERT INTO card_subtype VALUES (250,1); INSERT INTO card_subtype VALUES (256,10); INSERT INTO card_subtype VALUES (257,10); INSERT INTO card_subtype VALUES (258,10); INSERT INTO card_subtype VALUES (259,14); INSERT INTO card_subtype VALUES (260,10); INSERT INTO card_subtype VALUES (262,12); INSERT INTO card_subtype VALUES (263,15); INSERT INTO card_subtype VALUES (264,1); INSERT INTO card_subtype VALUES (265,1); INSERT INTO card_subtype VALUES (266,15); INSERT INTO card_subtype VALUES (267,13); INSERT INTO card_subtype VALUES (268,13); INSERT INTO card_subtype VALUES (269,13); INSERT INTO card_subtype VALUES (270,13); INSERT INTO card_subtype VALUES (272,5); INSERT INTO card_subtype VALUES (273,8); INSERT INTO card_subtype VALUES (275,12); INSERT INTO card_subtype VALUES (276,5); INSERT INTO card_subtype VALUES (277,12); INSERT INTO card_subtype VALUES (280,10); INSERT INTO card_subtype VALUES (281,5); INSERT INTO card_subtype VALUES (283,12); INSERT INTO card_subtype VALUES (284,8); INSERT INTO card_subtype VALUES (285,12); INSERT INTO card_subtype VALUES (286,12); INSERT INTO card_subtype VALUES (287,14); INSERT INTO card_subtype VALUES (289,7); INSERT INTO card_subtype VALUES (290,7); INSERT INTO card_subtype VALUES (291,7); INSERT INTO card_subtype VALUES (292,5); INSERT INTO card_subtype VALUES (293,7); INSERT INTO card_subtype VALUES (294,7); INSERT INTO card_subtype VALUES (297,3); INSERT INTO card_subtype VALUES (298,10); INSERT INTO card_subtype VALUES (299,1); INSERT INTO card_subtype VALUES (301,11); INSERT INTO card_subtype VALUES (304,5); INSERT INTO card_subtype VALUES (307,11); INSERT INTO card_subtype VALUES (308,12); INSERT INTO card_subtype VALUES (310,1); INSERT INTO card_subtype VALUES (311,8); INSERT INTO card_subtype VALUES (312,2); INSERT INTO card_subtype VALUES (314,12); INSERT INTO card_subtype VALUES (315,9); INSERT INTO card_subtype VALUES (316,7); INSERT INTO card_subtype VALUES (317,9); INSERT INTO card_subtype VALUES (318,12); INSERT INTO card_subtype VALUES (319,4); INSERT INTO card_subtype VALUES (320,4); INSERT INTO card_subtype VALUES (321,4); INSERT INTO card_subtype VALUES (322,12); INSERT INTO card_subtype VALUES (323,1); INSERT INTO card_subtype VALUES (324,6); INSERT INTO card_subtype VALUES (325,12); INSERT INTO card_subtype VALUES (326,12); INSERT INTO card_subtype VALUES (330,2); INSERT INTO card_subtype VALUES (333,13); INSERT INTO card_subtype VALUES (334,12); INSERT INTO card_subtype VALUES (336,1); INSERT INTO card_subtype VALUES (336,3); INSERT INTO card_subtype VALUES (337,7); INSERT INTO card_subtype VALUES (338,8); INSERT INTO card_subtype VALUES (339,2); INSERT INTO card_subtype VALUES (340,8); INSERT INTO card_subtype VALUES (341,3); INSERT INTO card_subtype VALUES (342,3); INSERT INTO card_subtype VALUES (344,10); INSERT INTO card_subtype VALUES (345,7); INSERT INTO card_subtype VALUES (346,5); INSERT INTO card_subtype VALUES (347,6); INSERT INTO card_subtype VALUES (348,12); INSERT INTO card_subtype VALUES (349,13); INSERT INTO card_subtype VALUES (350,13); INSERT INTO card_subtype VALUES (351,11); INSERT INTO card_subtype VALUES (352,2); INSERT INTO card_subtype VALUES (353,15); INSERT INTO card_subtype VALUES (354,9); INSERT INTO card_subtype VALUES (355,9); INSERT INTO card_subtype VALUES (356,9); INSERT INTO card_subtype VALUES (357,9); INSERT INTO card_subtype VALUES (360,7); INSERT INTO card_subtype VALUES (361,6); INSERT INTO card_subtype VALUES (362,6); INSERT INTO card_subtype VALUES (363,8); INSERT INTO card_subtype VALUES (364,9); INSERT INTO card_subtype VALUES (365,4); INSERT INTO card_subtype VALUES (366,7); INSERT INTO card_subtype VALUES (368,5); INSERT INTO card_subtype VALUES (369,1); INSERT INTO card_subtype VALUES (370,6); INSERT INTO card_subtype VALUES (371,8); INSERT INTO card_subtype VALUES (372,6); INSERT INTO card_subtype VALUES (373,12); INSERT INTO card_subtype VALUES (374,9); INSERT INTO card_subtype VALUES (375,9); INSERT INTO card_subtype VALUES (376,5); INSERT INTO card_subtype VALUES (377,3); INSERT INTO card_subtype VALUES (378,4); INSERT INTO card_subtype VALUES (379,8); INSERT INTO card_subtype VALUES (380,9); INSERT INTO card_subtype VALUES (381,9); INSERT INTO card_subtype VALUES (382,9); INSERT INTO card_subtype VALUES (383,9); INSERT INTO card_subtype VALUES (384,9); INSERT INTO card_subtype VALUES (385,4); INSERT INTO card_subtype VALUES (386,9); INSERT INTO card_subtype VALUES (388,8); INSERT INTO card_subtype VALUES (389,2); INSERT INTO card_subtype VALUES (390,12); INSERT INTO card_subtype VALUES (391,7); INSERT INTO card_subtype VALUES (394,10); INSERT INTO card_subtype VALUES (395,11); INSERT INTO card_subtype VALUES (397,12); INSERT INTO card_subtype VALUES (398,8); INSERT INTO card_subtype VALUES (401,14); INSERT INTO card_subtype VALUES (402,12); INSERT INTO card_subtype VALUES (403,6); INSERT INTO card_subtype VALUES (404,7); INSERT INTO card_subtype VALUES (405,8); INSERT INTO card_subtype VALUES (406,8); INSERT INTO card_subtype VALUES (407,8); INSERT INTO card_subtype VALUES (408,6); INSERT INTO card_subtype VALUES (410,11); INSERT INTO card_subtype VALUES (411,7); INSERT INTO card_subtype VALUES (412,6); INSERT INTO card_subtype VALUES (413,8); INSERT INTO card_subtype VALUES (415,5); INSERT INTO card_subtype VALUES (417,11); INSERT INTO card_subtype VALUES (418,12); INSERT INTO card_subtype VALUES (422,2); INSERT INTO card_subtype VALUES (423,12); INSERT INTO card_subtype VALUES (424,13); INSERT INTO card_subtype VALUES (425,12); INSERT INTO card_subtype VALUES (426,9); INSERT INTO card_subtype VALUES (428,10); INSERT INTO card_subtype VALUES (429,12); INSERT INTO card_subtype VALUES (430,12); INSERT INTO card_subtype VALUES (431,8); INSERT INTO card_subtype VALUES (432,10); INSERT INTO card_subtype VALUES (433,12); INSERT INTO card_subtype VALUES (434,10); INSERT INTO card_subtype VALUES (435,12); INSERT INTO card_subtype VALUES (436,12); INSERT INTO card_subtype VALUES (438,10); INSERT INTO card_subtype VALUES (439,8); INSERT INTO card_subtype VALUES (440,15); INSERT INTO card_subtype VALUES (441,12); INSERT INTO card_subtype VALUES (442,12); INSERT INTO card_subtype VALUES (443,10); INSERT INTO card_subtype VALUES (444,12); INSERT INTO card_subtype VALUES (445,5); INSERT INTO card_subtype VALUES (446,1); INSERT INTO card_subtype VALUES (447,8); INSERT INTO card_subtype VALUES (448,7); INSERT INTO card_subtype VALUES (449,7); INSERT INTO card_subtype VALUES (450,12); INSERT INTO card_subtype VALUES (451,12); INSERT INTO card_subtype VALUES (454,2); INSERT INTO card_subtype VALUES (455,1); INSERT INTO card_subtype VALUES (456,3); INSERT INTO card_subtype VALUES (457,6); INSERT INTO card_subtype VALUES (458,8); INSERT INTO card_subtype VALUES (459,5); INSERT INTO card_subtype VALUES (460,1); INSERT INTO card_subtype VALUES (461,2); INSERT INTO card_subtype VALUES (462,2); INSERT INTO card_subtype VALUES (464,11); INSERT INTO card_subtype VALUES (465,3); INSERT INTO card_subtype VALUES (466,8); INSERT INTO card_subtype VALUES (467,6); INSERT INTO card_subtype VALUES (468,5); INSERT INTO card_subtype VALUES (469,2); INSERT INTO card_subtype VALUES (470,5); INSERT INTO card_subtype VALUES (471,2); INSERT INTO card_subtype VALUES (472,7); INSERT INTO card_subtype VALUES (473,12); INSERT INTO card_subtype VALUES (474,2); INSERT INTO card_subtype VALUES (475,1); INSERT INTO card_subtype VALUES (476,2); INSERT INTO card_subtype VALUES (477,5); INSERT INTO card_subtype VALUES (479,4); INSERT INTO card_subtype VALUES (482,12); INSERT INTO card_subtype VALUES (483,2); INSERT INTO card_subtype VALUES (484,2); INSERT INTO card_subtype VALUES (485,12); INSERT INTO card_subtype VALUES (486,12); INSERT INTO card_subtype VALUES (487,2); INSERT INTO card_subtype VALUES (488,2); INSERT INTO card_subtype VALUES (489,7); INSERT INTO card_subtype VALUES (491,2); INSERT INTO card_subtype VALUES (492,11); INSERT INTO card_subtype VALUES (493,5); INSERT INTO card_subtype VALUES (494,2); INSERT INTO card_subtype VALUES (495,9); INSERT INTO card_subtype VALUES (496,2); INSERT INTO card_subtype VALUES (498,2); INSERT INTO card_subtype VALUES (502,2); INSERT INTO card_subtype VALUES (503,2); INSERT INTO card_subtype VALUES (504,2); INSERT INTO card_subtype VALUES (506,8); INSERT INTO card_subtype VALUES (508,7); INSERT INTO card_subtype VALUES (509,8); INSERT INTO card_subtype VALUES (510,5); INSERT INTO card_subtype VALUES (511,2); INSERT INTO card_subtype VALUES (512,11); INSERT INTO card_subtype VALUES (513,5); INSERT INTO card_subtype VALUES (514,2); INSERT INTO card_subtype VALUES (515,12); INSERT INTO card_subtype VALUES (516,12); INSERT INTO card_subtype VALUES (517,8); INSERT INTO card_subtype VALUES (518,13); INSERT INTO card_subtype VALUES (519,9); INSERT INTO card_subtype VALUES (521,2); INSERT INTO card_subtype VALUES (522,11); INSERT INTO card_subtype VALUES (523,2); INSERT INTO card_subtype VALUES (524,2); INSERT INTO card_subtype VALUES (525,12); INSERT INTO card_subtype VALUES (526,2); INSERT INTO card_subtype VALUES (527,5); INSERT INTO card_subtype VALUES (528,4); INSERT INTO card_subtype VALUES (529,12); INSERT INTO card_subtype VALUES (530,12); INSERT INTO card_subtype VALUES (531,2); INSERT INTO card_subtype VALUES (532,2); INSERT INTO card_subtype VALUES (533,12); INSERT INTO card_subtype VALUES (535,9); INSERT INTO card_subtype VALUES (536,8); INSERT INTO card_subtype VALUES (538,12); INSERT INTO card_subtype VALUES (539,2); INSERT INTO card_subtype VALUES (540,5); INSERT INTO card_subtype VALUES (541,2); INSERT INTO card_subtype VALUES (542,2); INSERT INTO card_subtype VALUES (543,12); INSERT INTO card_subtype VALUES (544,3); INSERT INTO card_subtype VALUES (545,8); INSERT INTO card_subtype VALUES (546,2); INSERT INTO card_subtype VALUES (547,2); INSERT INTO card_subtype VALUES (548,2); INSERT INTO card_subtype VALUES (549,2); INSERT INTO card_subtype VALUES (551,2); INSERT INTO card_subtype VALUES (552,2); INSERT INTO card_subtype VALUES (553,2); INSERT INTO card_subtype VALUES (556,7); INSERT INTO card_subtype VALUES (557,6); INSERT INTO card_subtype VALUES (558,10); INSERT INTO card_subtype VALUES (560,8); INSERT INTO card_subtype VALUES (561,8); INSERT INTO card_subtype VALUES (562,8); INSERT INTO card_subtype VALUES (563,8); INSERT INTO card_subtype VALUES (565,12); INSERT INTO card_subtype VALUES (566,2); INSERT INTO card_subtype VALUES (567,2); INSERT INTO card_subtype VALUES (568,12); INSERT INTO card_subtype VALUES (569,7); INSERT INTO card_subtype VALUES (570,2); INSERT INTO card_subtype VALUES (571,2); INSERT INTO card_subtype VALUES (572,2); INSERT INTO card_subtype VALUES (573,2); INSERT INTO card_subtype VALUES (574,2); INSERT INTO card_subtype VALUES (575,2); INSERT INTO card_subtype VALUES (577,2); INSERT INTO card_subtype VALUES (578,8); INSERT INTO card_subtype VALUES (579,2); INSERT INTO card_subtype VALUES (580,2); INSERT INTO card_subtype VALUES (582,12); INSERT INTO card_subtype VALUES (583,2); INSERT INTO card_subtype VALUES (584,8); INSERT INTO card_subtype VALUES (585,10); INSERT INTO card_subtype VALUES (586,13); INSERT INTO card_subtype VALUES (587,5); INSERT INTO card_subtype VALUES (588,5); INSERT INTO card_subtype VALUES (589,5); INSERT INTO card_subtype VALUES (590,12); INSERT INTO card_subtype VALUES (592,15); INSERT INTO card_subtype VALUES (593,15); INSERT INTO card_subtype VALUES (595,12); INSERT INTO card_subtype VALUES (598,2); INSERT INTO card_subtype VALUES (600,2); INSERT INTO card_subtype VALUES (601,2); INSERT INTO card_subtype VALUES (602,10); INSERT INTO card_subtype VALUES (603,2); INSERT INTO card_subtype VALUES (604,7); INSERT INTO card_subtype VALUES (605,7); INSERT INTO card_subtype VALUES (606,2); INSERT INTO card_subtype VALUES (607,5); INSERT INTO card_subtype VALUES (609,9); INSERT INTO card_subtype VALUES (612,11); # # Table structure for table 'cards' # CREATE TABLE cards ( id_card int(10) unsigned NOT NULL auto_increment, id_rarity int(10) unsigned default NULL, id_distro int(10) unsigned default NULL, id_type int(10) unsigned default NULL, id_artist int(10) unsigned default NULL, quantity int(10) unsigned default NULL, cardnum varchar(4) default NULL, name varchar(30) default NULL, effect text, lore text, p_ability int(10) unsigned default NULL, i_ability int(10) unsigned default NULL, op_ability int(10) unsigned default NULL, c_ability int(10) unsigned default NULL, p_cost int(10) unsigned default NULL, i_cost int(10) unsigned default NULL, op_cost int(10) unsigned default NULL, c_cost int(10) unsigned default NULL, errata text, PRIMARY KEY (id_card) ) TYPE=MyISAM; # # Dumping data for table 'cards' # INSERT INTO cards VALUES (1,5,1,4,3,1,'P03','Battle Fury','Target a character or troop. The target automatically generates a [Skull Icon] when participating in a challenge.','\"Perrin could see those misshapen faces, contorted with rage and frenzy, as clearly as if they were right on top of him.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (2,5,1,4,48,0,'P02','Filled With Power','Target a character with the One Power abilitiy. The target gains +1 One Power.','\"The Power boiled in her till she thought she must burst; her knees quivered with the effort of standing.\"\"\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (3,5,1,2,3,0,'P01','Night Raid','\"Target another player. If you succeed, the target must convert one of his Pattern tokens to a neutral token.\"','\"Trollocs poured out of the night, snouted faces and horned heads, towering over the humans, howling and swingning scythe-curved swords, stabbing with hooked spears and barbed tridents, hacking with spiked axes.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (4,5,1,3,28,0,'P04','Friend of the Dark','\"Pay any ability symbol generated by a non-monster character with the Dark One allegiance you control to recruit this character. As an event, rotate and target a non-Monster character you control with the Dark One allegiance. The target gains +1 to all non-zero, non-One Power printed abilities until the end of the turn.\"','\"Yes, Great Master. It shall be as you say. Yes. Yes.\"',0,2,0,0,0,0,0,0,''); INSERT INTO cards VALUES (5,5,1,4,34,0,'P05','Moment of Transition','Convert a Pattern. Draw 3 cards.','And you really think I can learn? I can become an Aes Sedai?',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (6,5,1,4,34,0,'P06','Pitched Battle','\"During a card-based challenge, you may pay [Damage] generated by a character or troop you control to generate either a [Support] or [Opposition].\"','\"Lan\'s sword accounted for those who escaped Moiraine\'s fire. The Warder had blood on both sides of his face, yet he flowed through the forms as coolly as if practicing before a mirror.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (7,5,1,4,4,0,'P07','Power Play','\"Target a character you control. The target may pay [One Power] to generate either [2x Politics], [2x Intrigue], or [2x Combat]. These symbols may only be used for recruiting or for paying the cost of events.\"','\"As quiet as they had been, the words \"\"Aes Sedai\"\"\"\" ran through the crowd in tones ranging from awe to fear to outrage.\"\"\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (8,5,1,1,48,0,'P08','Things Yet to Come','\"During a Last Battle challenge, as an event, you may discard a limited event, advantage, or challenge from your hand to generate [Support] [Opposition] in the challenge.\"','\"On Tremalking, one of the Sea Folk\'s isles, there be a stone hand fifty feet high sticking out of a hill, clutching a crystal sphere as big as this vessel.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (9,5,1,1,13,0,'P09','Uncontrolled Rage','\"Target a character you control that has the Combat ability. While participating in a non-Last Battle challenge, all [Politics] generated by the target are converted into [Damage].\"','\"They will pay, Lews Therin growled. I am the Lord of the Morning.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (10,5,1,4,13,0,'P10','Unravel the Pattern','Play immediately after any player plays Balefire. Remove half (round up) of the neutral pattern tokens from the game.','\"The ripples were incalculable. The Pattern itself nearly unraveled. It could have been the destruction of everything. World, time, Creation itself.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (11,6,2,4,56,0,'1','A Beginning','Play when you have at least 4 cards in your hand. Discard your entire hand and draw 4 cards.','The wind was not the beginning. There are neither beginnings nor endings to the turning of the Wheel of Time. But it was a beginning.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (12,3,2,4,22,0,'2','A Murder of Ravens','\"This card may only be played by a Villain player. Target another player and name a card. If the named card is in the target\'s hand, he must discard one copy of it. If it is not in his hand, he must show you his hand.\"','\"The fox\'s jaws snapped at them, but they darted in, and darted away untouched, black beaks glistening wetly.\"',0,0,0,0,0,2,0,0,''); INSERT INTO cards VALUES (13,1,2,1,49,0,'3','A Second Chance','\"Target a character you control. Immediately after you roll the target\'s dice, you may discard this advantage from play to reroll up to two of those dice, or up to three of those dice if the target is a Ta\'veren. The original dice results are ignored.\"','He spilled the dice onto the tabletop. They bounced oddly. He felt - something - shifting.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (14,3,2,4,54,0,'4','A Sign of Hope','\"Target a non-Hero, non-Villain character in your killed pile. Convert one of your Pattern tokens to a neutral token. Move the target to your discard pile.\"','\"Thom Merrilin\'s alive. And he\'s here, in Cairhein.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (15,3,2,4,21,0,'5','A Stroke of Luck','\"If a character you control rolled three or more dice of the same ability but rolled no symbols of that ability, add one to your pool.\"','She can\'t have!',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (16,3,2,2,13,0,'6','A Time of Decision','\"Target a character you have in play. If you succeed, retrieve a replacement version of the character from your deck and place it in your hand.\"','\"All he wanted was to be a blacksmith, to go home, and see his family again, and work at the smithy. But it was not to be; he knew that.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (17,6,2,4,38,0,'7','A Time of Peace','No player may initiate a card-based challenge on the next turn.','\"There was a time, before the Breaking, known as the Age of Legend, when there were no wars.\"',0,0,0,0,3,0,0,0,''); INSERT INTO cards VALUES (18,4,2,1,39,0,'8','Advanced Scout','\"When assigning damage from your opponent\'s character damage pool, this character must be assigned a point. While this character is participating in a challenge, all events you play in that challenge have their combat symbol costs reduced by one.\"','\"There\'s bloody something moving down there. Some of the others nodded and murmered, too.\"',0,0,0,0,0,0,0,2,''); INSERT INTO cards VALUES (19,6,2,1,19,0,'9','Al\'cair\'rahienallen','\"While you control the Cairhien contested advantage by 5 or more, when Cairhien characters you control generate any [Intrigue Icon], they also generate an equal number of [Skull Icon].\"','\"You take Cairhien. They city\'s proper name is Al\'cair\'rahienallen, Hill of the Golden Dawn.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (20,4,2,3,2,0,'10','Amys','Rotate Amys as an event and target an Aiel character with a Politics ability lower than hers (including none). Rotate the target for no effect.','\"In Rhuidean you will find three rings, arranged so. Step through any one. You will see your future laid before you, again and again, in variation.\"',2,1,2,0,2,0,1,0,''); INSERT INTO cards VALUES (21,4,2,1,14,0,'11','Andor','\"If you control Andor during the ready round, choose one allegiance. All Andor characters you control gain that allegiance until the end of the turn.\"','\"Andor has always had a queen, and it still does. Elayne was Daughter-Heir. With her mother dead, she\'s queen.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (22,1,2,5,19,0,'12','Andor Cavalry','','\"A proud line of cavalry thundered across the field, moving briskly and in tight formation beneath the fluttering banners of Andor.\"',0,0,0,4,1,0,0,1,''); INSERT INTO cards VALUES (23,1,2,5,19,0,'13','Andor Infantry','','\"...red uniformed men burst into sight, breastplates catching the sun as they dashed up the path. Others came like breaking waves of scarlet and polished steel...\"',0,0,0,4,2,0,0,0,''); INSERT INTO cards VALUES (24,4,2,5,19,0,'14','Andoran Spearmen','\"The cost to recruit this card is [Politics Icon] or [Combat Icon]. During the Coming to Grips step in which this card is participating, you may rotate and kill this card to add two tokens to your troop damage pool.\"','\"A thousand spears are held fast beneath Andor\'s banner, the white lion rampant on a field of red.\"',0,0,0,2,0,0,0,0,''); INSERT INTO cards VALUES (25,4,2,4,1,0,'15','Animate Stone','\"Target a challenge during its Opening Moves step. This card becomes a character, participating in that challenge, with one Combat ability for each [One Power Icon] you pay. Roll its dice immediately add the results to your pool. Discard this card after the challenge resolves.\"','\"Suddenly the benches shifted, flowed, changed into faceless manshapes, still as white and hard-looking as the stone.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (26,6,2,3,6,0,'16','Asmodean','\"Immediately after Asmodean rotates, he generates an additional ability symbol of your choice. That symbol can only be used for recruiting characters and troops with the Dark One allegiance.\"','\"Asmodean saw him at the same moment and gave a start ... and suddenly a huge sheet of fire, like a thin slice from monstrous flame, swept back toward Rand, a mile high and a mile wide.\"',0,1,4,0,0,0,0,0,''); INSERT INTO cards VALUES (27,4,2,2,49,0,'17','Assassination Attempt','\"Target a non-Hero, non-Villain character. Only Intrigue and One Power may be rolled in this challenge. For every 3 by which you succeed, do one point of damage to the target.\"','\"A bolt from a crossbow. A few dark strands from her hair were tangled in the four heavy prongs, meant for punching through armor.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (28,4,2,1,13,0,'18','Aura of Death','\"The next time the targeted character takes damage, he takes one additional point of damage. When he takes this extra damage, discard this advantage.\"','\"A slender woman with black hair falling to her waist... wore a sickly brown halo, shriveled and split by rotting fissures that fell in and widened as they decayed.\"',0,0,0,0,0,0,0,0,'Add the following line: May not target a Ta\'veren unless he has 1 or more damage token(s) on him.'); INSERT INTO cards VALUES (29,4,2,3,49,0,'19','Aviendha','Symbols generated by this character may not be used for recruiting. Aviendha gains +1 Combat while participating in a challenge.','\"I am Far Dareis Mai, A Maiden of the Spear ... In your lands, you have women much like our Wise Ones, the women called Aes Sedai.\"',0,0,0,3,0,0,0,1,''); INSERT INTO cards VALUES (30,3,2,3,46,0,'20','Bain','Symbols generated by this character may not be used for recruiting.','\"When we wed the spear, we pledge to be bound to no man or child. Some do give up the spear, for a man or child, but once given up, the spear cannot be taken back.\"',0,0,0,3,0,0,0,1,''); INSERT INTO cards VALUES (31,3,2,1,46,0,'21','Battle Hardened','\"Target a character or troop you control. When determining how many ability dice to roll for the target, ignore all damage on him.\"','\"...screaming defiance with the last breath, to spit in Sightblinder\'s eye on the last day.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (32,6,2,3,6,0,'22','Be\'lal','\"You may only recruit one character and one troop per turn. If the Dragon Reborn initiates the Callandor challenge and fails to succeed, place the Callandor advantage on Be\'lal instead.\"','\"In A Study of the War of Shadow, Moilin daughter of Hamada daughter of Juendan called Be\'lal the Netweaver ...\"',0,1,4,4,0,0,0,0,''); INSERT INTO cards VALUES (33,6,2,3,27,0,'23','Berelain','Politics ability symbols generated by Berelain have all alegiances for recruiting purposes.','\"É a tall young woman of regal bearing entered the room, wearing a coronet with a golden hawk in flight above her brows.\"',3,1,0,0,3,0,0,0,''); INSERT INTO cards VALUES (34,6,2,4,3,0,'24','Bitter Fighting','Target a troop you control and another player\'s troop participating in the same challenge. Both troops roll their dice and apply damage (other results are ignored). Both troops continue rolling their dice and applying damage until one troop is killed.','The Defenders in the anteroom were fighting for their lives beneath the gilded lamps ...',0,0,0,0,0,0,0,1,''); INSERT INTO cards VALUES (35,3,2,4,15,0,'25','Blood Tide','Target a challenge. Each [Combat Icon] you roll while participating in the challenge is converted into a [Damage Icon] instead.','\"For three days they fought, and though the land became a butcher\'s yard, no crossing of the Tarendrelle did they yield.\"',0,0,0,0,0,0,0,2,''); INSERT INTO cards VALUES (36,1,2,1,25,0,'26','Bodyguards','\"When the targeted character takes damage, apply it to this card instead. Discard this advantage when it has taken two points of damage and apply any extra damage to the targeted character.\"','\"Facing every direction as they did, they were supposed to keep all intruders from the current lord of the Stone.\"',1,0,0,1,0,0,0,0,''); INSERT INTO cards VALUES (37,4,2,2,46,0,'27','Border Clash','\"Politics cannot be rolled in this challenge. Reinforcement cannot be used in this challenge. If you succeed, move a token from the neutral section of the Pattern to your section, and you may add a token to a nation contested advantage.\"','\"Whatever they did not steal, they burned, and drove us out to starve.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (38,4,2,4,5,0,'28','Broken Ground','\"For each [Combat Icon] spent, target one troop participating in the same challenge. The targeted cards do not ready next turn.\"','\"When the shadows lengthen, they must stop or begin breaking wheels and mules\' legs.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (39,3,2,4,13,0,'29','Bubble of Evil','\"This card may only be played by a Villain player. Target a character participating in a challenge. The target may choose not to roll his dice this turn. If he does roll, he takes one point of damage for each ability symbol he rolls.\"','\"The weapon thrashed like a thing alive, a thing with a malevolent will.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (40,6,2,1,19,0,'30','Caemlyn','\"While you control the Andor contested advantage by 5 or more, all Andor characters you control may use their Politics in the Last Battle. This allows your Andor characters with only Politics to participate in the Last Battle.\"','Words died in his mouth as his eyes fell on Caemlyn... this was more than he would have believed.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (41,4,2,1,14,0,'31','Cairhien','\"For each token by which you control Cairhien, you may use one [Intrigue Icon] as a [Politics Icon] or [Combat Icon] to recruit. (These symbols retain their original allegiance.)\"','\"Yet the people seemed open and friendly enough, pausing to nod to each other as they hurried about their last chores before nightfall.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (42,3,2,5,15,0,'32','Cairhien Footmen','\"As an event, any player may target this troop and pay any amount of [Intrigue Icon]. For each [Intrigue Icon] paid, this troop rolls one less Combat die for the rest of the turn.\"','\"Most of them wore plain breastplates, and where there was gilt or silverwork, it was battered as though a drunken smith had been at it.\"',0,0,0,5,1,0,0,1,''); INSERT INTO cards VALUES (43,4,2,5,25,0,'33','Cairhien Horsemen','\"As an event, rotate this troop and target a troop you control. The targeted troop gains Reinforcement until the end of the turn.\"','\"The smell of death wafted up toward the fresh horses, which pranced nervously as the cavalrymen awaited orders.\"',0,0,0,2,1,0,0,0,''); INSERT INTO cards VALUES (44,6,2,2,57,0,'34','Callandor','\"Can only be initiated by the Dragon Reborn. If you succeed by five or more, this card becomes a sa\'angreal character advantage on the Dragon Reborn. While the target participates in a challenge, you may place two tokens on this card to roll One Power dice equal to the target\'s current One Power ability. Unless the target rolls more [One Power Icon] in the challenge than tokens on this card, you must apply damage on your participating cards equal to his One Power ability.\"','The Sword That is Not a Sword.',0,0,0,0,0,0,0,0,'\"Callandor is a Sa\'angreal, and uses the same mechanics as the Saidar Angreal and the Saidin Angreal, which appear in the Premier Edition. You roll the dice for the Callandor character advantage at the same time you are rolling the One Power dice for the target character, and those dice are considered to be from the target character.\"'); INSERT INTO cards VALUES (45,4,2,1,49,0,'35','Called to War','\"You may initiate a challenge each turn targeting a nation contested advantage. There is automatically 5 opposition to the challenge. For every two by which you succeed, add a token to the targeted advantage.\"','The armies of Tear are to march.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (46,4,2,2,45,0,'36','Car\'a\'carn','\"Only the Dragon Reborn may initiate this challenge. If you succeed, this challenge becomes a character advantage on the Dragon Reborn giving him the Aiel allegiance. For each point by which you succeed, place a follower token on the advantage. You may remove one follower token to reduce the cost of an Aiel character or troop by one ability of your choice.\"','\"Of the blood, but not raised by the blood, he will come from Rhuidean at dawn, and tie you together with bonds you cannot break.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (47,6,2,4,38,0,'37','Carpe Fatum','The symbols used to pay for this card must all come from the same character. Add one token to your section of the Pattern.','You\'re right. How did you know? It has to work for me sooner or later...',0,0,0,0,0,0,4,0,''); INSERT INTO cards VALUES (48,4,2,5,40,0,'38','Catapults','\"When participating in a challenge, Catapults add one point of damage to your troop damage pool during the Opening Moves step.\"','\"Beside the rode behind the stakes stood a contraption of wood and thick, twisted rope, with a nearby pile of stones bigger than a man\'s head.\"',0,0,0,1,0,0,0,1,''); INSERT INTO cards VALUES (49,3,2,4,50,0,'39','Charge','\"Play this card during the Coming to Grips step of a challenge. For each [Combat Icon x2] you pay, target one troop you control. Rotate the target troops, roll their dice, and add the results to your pool.\"','\"His horse leaped forward as he dug in his heels, and he heard the roar as the legion, as much of it still lived, followed.\"',0,0,0,0,0,0,0,0,'\"Should read \"\"Play this card during the Opening Moves step of a challenge. For each (2 Combat) you pay, target one troop you control participating in that challenge. Rotate the target troops, roll their dice, and add the results to your pool.\"'); INSERT INTO cards VALUES (50,4,2,3,3,0,'40','Chiad','Symbols generated by this character may not be used for recruiting.','\"I am Chiad, of the Sones River sept of the Goshien Aiel.\"',0,1,0,3,1,0,0,1,''); INSERT INTO cards VALUES (51,4,2,4,1,0,'41','Civil Unrest','\"Target a nation contested advantage. Each player rolls a Combat die for each token they have on that advantage. For each [Skull Icon] rolled, they may remove a token of their choice from the target advantage.\"','\"...as one they surged forward, howling and rabid, waving pitchforks and swords, axes and clubs, anything that could be taken to hand for a weapon.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (52,6,2,1,25,0,'42','Combat Reserves','You may pay [Combat Icon] as a limited event to place a reserve token on this card. You may remove two reserve tokens as a limited event to add one [Combat Icon] to your pool. This symbol has the allegiance(s) of your starting character.','\"The soldiers still appeared uneasy... but they formed into lines to either side of the gates, bow deeply as Rand rode through.\"',0,0,0,0,0,0,0,2,''); INSERT INTO cards VALUES (53,1,2,3,19,0,'43','Commander','','\"Even smiling, his face was hard...\"',0,0,0,2,1,0,0,1,''); INSERT INTO cards VALUES (54,6,2,1,3,0,'44','Compulsion','\"Only a Villain player may play this card. Target a character that you could control whose cost is less than the number of tokens on your section of the Patrn. As an event, they player who played Compulsion may pay one more [One Power Icon] than the One Power ability of the target to take control of that character for the following turn.\"','She seemed unable to look at anything but his dark eyes; her skin tingled as if an icy wind were blowing through the courtyard.',0,0,0,0,0,0,2,0,'\"For you to play Compulsion, you must have more pattern than the number of symbols you would have to pay to recruit that character. This includes any doubling for allegiance, Light Nature, etc. Generally, no discounts (like paying Pattern) can be applied to this. You control the character for the whole turn following the turn you pay for Compulsion. Control allows you to treat the character as if it were a character in your faction for all intents and purposes. Note there are restrictions on what cards a player can control; if a player could not normally control a character, he may not use Compulsion to do so.\"'); INSERT INTO cards VALUES (55,6,2,1,1,0,'45','Concealed Dagger','Discard this advantage as an event while the target is participating in a challenge and pay [Intrigue Icon] to add a point of damage to another character (of your choice) participating in the same challenge.','\"The slim-bladed knife came up swiftly, all her remaining strength behind it...\"',0,0,0,0,0,1,0,0,''); INSERT INTO cards VALUES (56,1,2,2,17,0,'46','Confrontation','\"If you succeed by five or more, add two tokens to your section of the Pattern.\"','\"Shienar will ride to Tarwin\'s Gap alone, and we will be outnumbered at least ten to one.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (57,3,2,4,49,0,'47','Connections','Draw two cards.','This is a fine party. You have many friendsÉ',0,0,0,0,1,0,0,0,''); INSERT INTO cards VALUES (58,6,2,2,7,0,'48','Cut Supply Lines','\"Target another player. If you succeed, this challenge becomes a player advantage targeting him. His maximum hand size is decreased by 2.\"','\"Even the small things are bad. The war in Arad Doman has stopped trade from Saldaea, and the pinch is making unrest in Maradon.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (59,3,2,3,3,0,'49','Dain Bornhald','','\"My name is Dain Bornhald! Remember it, Darkfriends! I will make you fear my name! Remember my name!\"',1,0,0,1,1,0,0,0,''); INSERT INTO cards VALUES (60,6,2,1,13,0,'50','Dangerous Liaisons','You may pay [Intrigue Icon] as a limited event to place a reserve token on this card. You may remove two reserve tokens as a limited event to add one [Intrigue Icon] to your pool. This symbol has the allegiance(s) of your starting character.','\"I know a secluded pool, where this head might be escaped. A sheltered pool, where nothing would disturb us.\"',0,0,0,0,0,2,0,0,''); INSERT INTO cards VALUES (61,6,2,1,38,0,'51','Dark Dreams','This card may only be played by a Villain player. You may discard this card as an event and target a card-based challenge. It gains 2 additional opposition.','\"It had been a dream, then, like a nightmare in the Winespring Inn the day of Bel Tine ...\"',0,0,0,0,0,0,1,0,''); INSERT INTO cards VALUES (62,1,2,1,51,0,'52','Darkfriend','Target a character you control with a dark nature. He gains the Dark One allegiance.','\"You will have honored places if you come to the Great Lord of your own free will, but as long as you run, there will be pursuit, and who can tell what will happen then?\"',0,0,0,0,0,1,0,0,''); INSERT INTO cards VALUES (63,4,2,5,53,0,'53','Darkfriend Band','\"The Darkfriend Band is recruited into your battleground, and has Reinforcement on the turn it is recruited.\"','\"Men fought alongside the Trollocs, too, in rough coats, with swords, shouting desperately as they died among the thorn bushes.\"',0,0,0,2,0,1,0,0,''); INSERT INTO cards VALUES (64,6,2,3,57,0,'54','Darkhound Pack','You cannot control more than one Darkhound pack at a time. Symbols generated by this character may not be used for recruiting. This character cannot be the target of advantages. Any character that takes damage from a Darkhound Pack and is not completely healed by the end of the turn is killed.','A Darkhound leaves no mark on dirt É but stone is another matter.',0,0,0,3,0,0,2,2,''); INSERT INTO cards VALUES (65,1,2,2,49,0,'55','Debt of Honor','\"Target a character you control. If you succeed, this challenge becomes a character advantage targeting him. While the target of the advantage is ready, your starting Hero or Villain gains the target\'s allegiance(s). If you do not succeed, your starting Hero or Villain takes one point of damge, and the target is killed.\"','\"May you always find water and shade, Perrin Aybara.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (66,1,2,4,39,0,'56','Decisive Tactics','\"Play this card during the Opening Moves or Coming to Grips step of a challenge. For each [Combat Icon x2] you pay, apply one [Sword Icon] or [Shield Icon] to the challenge.\"','\"Slowly, inexorably, the Two Rivers line bulged inward at a dozen places. If it broke, anywhere...\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (67,3,2,4,52,0,'57','Defensive Measures','\"Target one or more ready troops you control that are participating in the same challenge. Pay [Combat Icon x2] for each target. For each [Shield Icon] the roll, they generate an additional [Shield].\"','\"The road passed a half a dozen farms... ending at the heavy wooden gates bound with wide straps of black iron. They were closed tight, even if the sun was not down yet.\"',0,0,0,0,0,0,0,0,'\"Add the following last line to the effect text, \"\"Defense Measures may not be used in the Last Battle. Defense Measures may be played in the Action Round. It may be played during one challenge while targeting troops in a different challenge. It cannot be played during the Comign to Grips step.\"\"\"'); INSERT INTO cards VALUES (68,3,2,4,43,0,'58','Dense Fog','\"Target a challenge. For each [One Power Icon] you pay, all players except you must remove one token from their character damage pools and from their troop damage pools during each step of the challenge.\"','\"The thickness of it muffled the sound of their hooves to dullness, and cries from overhead seemed to come through a wall.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (69,1,2,4,1,0,'59','Dense Forest','\"Target a card-based challenge. Only one terrain event may target each challenge. No cards may reinforce the challenge. Before damage is applied, remove two points of damage from all player\'s character damage pools.\"','\"Scattered clumps of evergreens, willows and firs, dotted the far bank, and there seemed to be fewer trees altogether than on her side.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (70,3,2,4,25,0,'60','Disband','Discard a troop you control. Add a number of symbols to your pools equal to the recruit cost of the discarded troop. These symbols have the same allegiance as the discarded troop.','\"From the two nearest tower tops men watched them approach. Just a few men on each, peering curiously through the crenels.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (71,3,2,4,15,0,'61','Distractions','\"Target a troop participating in a challenge. For each [Intrigue Icon] you pay, it must roll one die less than normal.\"','Veiled Shaido turning to fight wolves had only moments to realize they were not the only threat...',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (72,6,2,3,13,0,'62','Draghkar','You must have 5 pattern to recruit a Draghkar. This character cannot be the target of advantages. Whenever Draghkar rolls dice ignore all results. Whenever Draghkar rolls dice he generates [Damage Icon] [Damage Icon].','\"I have never liked Draghkar, we should have never have made them. Give them an order, and they still sometimes kill whatever is closest.\"',0,0,0,2,0,0,1,1,''); INSERT INTO cards VALUES (73,6,2,1,5,0,'63','Dragon Banner','Can only target a Hero player. Pay [Politics Icon] as a limited event and target a character you control. The target permanently gains the Dragon allegiance. Each of your Dragon characters participating in a challenge initiated by the Horn of Valere contested advantage automatically generate one additional support.','\"A banner most men would not know if they saw it, but would fear when they learned its name.\"',0,0,0,0,0,0,2,0,''); INSERT INTO cards VALUES (74,6,2,5,19,0,'64','Dragonsworn','There is no cost to bring the Dragonsworn into play.','\"They\'re down there, on Almoth Plain, and the Light alone knows where else. Hundreds of them. Thousands. They declared for the Dragon Reborn because I raised that banner.\"',0,0,0,2,0,0,0,0,''); INSERT INTO cards VALUES (75,6,2,4,49,0,'65','Driven','\"Target one or more trolloc troops you control that are participating in the same challenge. For each troop targeted, put a damage token on it and it generates one [Support icon].\"','\"The Trollocs still ran less than fifty paces backÉ A fade rode behind them now, and they seemed to flee the halfman as much as to pursueÉ\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (76,3,2,4,2,0,'66','Duel','Target a ready character. Select a character you control with the same allegiance as the target. Each character rolls his dice and applies any [Skull Icon] (other results are ignored). The target can rotate for no effect to ignore this card.','You are young. Let us see what it required to earn the heron...',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (77,4,2,3,13,0,'67','Eamon Valda','Rotate Eamon Valda to remove one token from a contested advantage.','\"Every bit as much the picture of a Lord Captain... the dark man\'s face was hard, as ever, and he had a sword in his hands...\"',1,2,0,3,1,1,0,2,''); INSERT INTO cards VALUES (78,4,2,4,21,0,'68','Earth Blast','Play this card during the Opening Moves or Coming to Grips step of a challenge. Target a character participating in that challenge. The target takes a point of damage and may not ready next turn.','\"With a roar the ground in front of him erupted in a narrow fountain of dirt and rocks higher than his head. Screaming, his horse reared, and he rolled out of his saddle like a sack.\"',0,0,0,0,0,0,2,0,''); INSERT INTO cards VALUES (79,1,2,3,6,0,'69','Egwene al\'Vere','\"If Egwene rolls a number of [One Power Icon] equal to her permanent One Power ability, she gains +1 One Power permanently, to a maximum of three.\"','No ... I\'m not afraid. I do want to become an Aes Sedai.',0,0,1,0,0,0,1,0,''); INSERT INTO cards VALUES (80,6,2,3,21,0,'70','Egwene the Accepted','\"Replace Egwene al\'Vere when she has a permanent One Power of at least two. If Egwene rolls a number of [One Power Icon] equal to her permanent One Power ability, she gains +1 One Power permanently, to a maximum of three.\"','\"You are washed clean of Egwene al\'Vere from Emond\'s Field... You are Egwene al\'Vere, Accepted of the White Tower. You belong to us now.\"',1,2,2,0,0,0,0,0,NULL); INSERT INTO cards VALUES (81,6,2,3,16,0,'71','Elaida Sedai','\"If Elaida rolls a number of [One Power Icon] equal to her permanent One Power ability, she must look at the top five cards of any players\' deck; reveal two of them to all players, and place them back on top of the deck in the same order.\"','\"The Dark One stirs in Shayol Ghul. The Shadow lies across the Pattern, and the future is balanced on the point of a pin.\"',2,2,3,0,1,1,2,0,NULL); INSERT INTO cards VALUES (82,1,2,3,6,0,'72','Elayne Trakand','The Dragon Reborn does not cause an allegiance penalty when paying any of the cost to recruit Elayne.','\"She was completely different from Egwene in height and face and body, but every bit as beautiful.\"',2,0,1,0,2,0,0,0,NULL); INSERT INTO cards VALUES (83,6,2,3,52,0,'73','Elyas','Elyas cannot be controlled by a Villain player. Rotate Elyas to retrieve a Wolf troop from your deck and place it in your hand.','\"Elyas moved with the lazy grace of a wolf, only emphasized by his skins and fur hat, radiating danger as naturally as a fire radiated heat.\"',0,1,0,3,1,0,0,2,NULL); INSERT INTO cards VALUES (84,4,2,1,28,0,'74','Establish Contacts','Target a Forsaken character. He gains +1 Intrigue.','\"This world is very changed from the world I... went to sleep in... What I know of what lies where, I have learned since waking.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (85,4,2,2,11,0,'75','Exiled','\"Target a character and select an allegiance of that character. Only characters of the selected allegiance may participate in this challenge. If you succeed by at least the character\'s cost or highest ability, whichever is greater, remove that allegiance from the target.\"','You exiled them from the city last spring...',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (86,3,2,4,23,0,'76','Expendable Troops','Target a challenge. This event acts as if it were a mercenary troop participating in that challenge with 2 Combat ability. Discard this card after the challenge resolves.','I need them yet. I can use them.',0,0,0,0,0,0,0,1,NULL); INSERT INTO cards VALUES (87,2,2,3,48,0,'77','Fade','This card cannot participate in challenges until there are at least four tokens on your section of the Pattern.','\"Dead black clothes and cloak, hardly seeming to stir as it moved, made its maggot-white skin appear ever paler. It had no eyes ...\"',0,1,0,3,0,1,0,1,NULL); INSERT INTO cards VALUES (88,3,2,4,43,0,'78','Fall Back','\"Target a character you control. Put a number of recovery tokens on the target equal to the number of damage tokens on him, then remove all damage from the target. Rotate the target for no effect. The target cannot ready while recovery tokens remain on him. Remove one recovery token at the end of each ready round.\"','Arin! Dar! Get out here and help me open the gate. There\'s people want to leave. Don\'t argue. Just do it.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (89,3,2,1,57,0,'79','Far Reaching Influence','\"Target a character with Politics. The target gains +1 Politics. If the target ever participates in a card-based challenge you initiate but do not succeed at, discard this advantage.\"','\"No one refuses an audience with the Amyrlin Seat, sheepherder. Not the Lord Captain Commander of the Whitecloaks himself.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (90,1,2,4,49,0,'80','Fireball','Play this card during the Opening Moves or Coming to Grips step of a challenge. Target a character or troop participating in that challenge. Put one point of damage on the target.','\"Flame enveloped Trollocs, then burst with a roar that left misshapen forms unmoving on the ground.\"',0,0,0,0,0,0,1,0,NULL); INSERT INTO cards VALUES (91,4,2,2,23,0,'81','Flanking Maneuvers','\"Only cards with Reinforcement may participate in this challenge. No cards can reinforce this challenge. If you succeed by three or more, add one token to your section of the Pattern.\"','They\'re behind us! Rally to me!',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (92,3,2,2,11,0,'82','Flowing Coffers','\"If you succeed, this challenge becomes a player advantage targeting you. For each point by which you succeed, place a wealth token on this card. You may remove one wealth token to reduce the cost of a mercenary character or troop by one ability of your choice. Discard the advantage when there are no tokens remaining.\"','\"It\'s a bad precedent, my Lord Dragon, lowering taxes ...\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (93,3,2,2,27,0,'83','Forced Back','\"Target a non-Hero, non-Villain character you do not control. If you succeed, this challenge becomes a character advantage on the target. The effect text of the target is ignored.\"','\"He felt as weak as the worst wrought iron, ready to bend at any pressure.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (94,6,2,1,43,0,'84','Forced March','\"When you recruit a troop, you may pay [Combat Icon] in addition to its cost to bring that troop into play in your battleground 9rather than in your home front). You may pay an additional [Combat Icon] to give the troop Reinforcement until the end of the turn.\"','\"He cound not eat, except what he could scavenge while he hunted youÉ nor could he stop until exhaustion collapsed him like an empty sack.\"',0,0,0,0,0,0,0,2,NULL); INSERT INTO cards VALUES (95,6,2,1,22,0,'85','Fortress of Light','\"Cards with only the Dark One or Aes Sedai allegiances (or both) cannot participate in challenges initiated with this advantage. While you control the this card, any event targeting you that requires One Power requires an additional One Power, and you have an extra Pattern token for each contested advantage you control.\"','É a huge sunburst set into the floor held enough gold to make most men stare.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (96,4,2,5,13,0,'86','Forward Scouts','\"While participating in a challenge, this card may rotate as an event to give another troop Reinforcement. That troop may only reinforce the challenge in which this card is participating.\"','\"Checking the arrow nocked to his longbow, he peered down the valley running off to the west, widening as it fell away.\"',0,0,0,1,0,0,0,1,''); INSERT INTO cards VALUES (97,4,2,2,39,0,'87','From the Shadows','\"Only Intrigue may be rolled in this challenge. If you succeed, add a token to your section of the Pattern.\"','\"Paradox child. The Dark One is the embodiment of paradox and chaos, the destroyer of reason and logic, the breaker of balance, the unmaker of order.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (98,3,2,1,17,0,'88','Further Demands','Target a mercenary character or troop. Rotate the target for no effect. It may not ready. The controller of the card may discard this advantage by paying the cost of the targeted card as a limited event.','The Murandians hardly count; they\'re just there for whatever advantage they can wring out of the situation...',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (99,6,2,4,39,0,'89','Further Goals','\"Target a card-based challenge you initiated. If you win the challenge by 7 or more, add a token to your section of the Pattern.\"','Another seal on the Dark One\'s prison.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (100,6,2,1,40,0,'90','Future Returns','Pay any ability symbol as an event to place an investment token on this card. Remove 5 investment tokens to draw a card.','\"There is more grain in the granaries now than Tear could sell, and the farmers will harvest as much more this year.\"',0,0,0,0,1,1,1,1,'\"Should read \"\"Pay any ability symbol as a limited event to place an investment token on this card. Rotate this card and remove 5 investment tokens to draw a card.\"\"\"'); INSERT INTO cards VALUES (101,1,2,2,40,0,'91','Gaining An Advantage','\"If you succeed, this challenge becomes a player advantage targeting you. You may discard it as an event to generate [Politics Icon] [Intrigue Icon] [Combat Icon]. These symbols have all allegiances.\"','\"He had them off balance now. If he could keep them that way, they would be too busy watching each other, and too afraid of being watched in turn, to trouble him.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (102,6,2,3,19,0,'92','Galldrian su Riatin Rie','\"You must have 5 Pattern to recruit Galldrian. While you control Galldrian, all Cairhien characters you control gain +1 Intrigue.\"','\"Let the vile miscreant himself be hanged immediately, that his Shadow-spawned villainy no longer taint the Light.\"',3,3,0,1,2,3,0,0,''); INSERT INTO cards VALUES (103,6,2,3,35,0,'93','Gareth Byrne','\"While you control Gareth Byrne, Andor troops you control gain +1 combat.\"','\"A bluff blocky man stood bareheaded by the Queen\'s right hand... His temples were heavy with gray, but he looked as strong and immovable as a rock.\"',2,1,0,3,3,0,0,2,''); INSERT INTO cards VALUES (104,4,2,4,53,0,'94','Gateway','\"Target one character or troop per [One Power Icon x2] you pay. Each target is readied, moved to the battleground and gains Reinforcement (until the end of the turn).\"','\"Seizing the source, Rand made a gateway between the posts, four paces by four, and ran through as he tied off the weave... into a great open square surrounded by huge white columns, each topped with a marble wreath of olive branches.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (105,1,2,2,15,0,'95','Gather Allies','\"No troops may participate in this challenge. If you succeed, add one token to your section of the Pattern.\"','Come. I\'m sure you would like to speak with the Sitters. Let formality go.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (106,3,2,2,15,0,'96','Gather Support','\"Choose Politics, Intrigue or Combat. For each one by which you succeed, one symbol of that type is added to your pool at the beginning of the next action round. The symbols added have no allegiance.\"','\"...the Andoran nobles swept out of the colonnades, a rainbow of silks crowding around Rand, dabbling at sweaty faces with lace-trimmed handkerchiefs.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (107,4,2,3,48,0,'97','Gaul','Symbols generated by this character may not be used for recruiting. Gaul gains +1 Combat while he is damaged. Gaul generates one [Combat Icon] when he participates in a challenge.','\"I am Gaul, of the Imran sept of the Shaarad Aiel, wetlander. I am Shaeen M\'taal, a Stone Dog. My water is yours.\"',0,0,0,3,0,1,0,1,''); INSERT INTO cards VALUES (108,6,2,3,3,0,'98','Geofram Bornhald','Rotate Geofram to find the top challenge card in your deck and place it in your hand.','\"You avoid my questions. What evil is in you that you do not answer me?\"\"\"',2,0,0,3,2,0,0,2,''); INSERT INTO cards VALUES (109,6,2,3,49,0,'99','Graendal','Any character you recruit gains the Dark One allegiance.','\"In any other company but Lanfears, Graendal would have been accounted a stunningly beautiful woman, lush and ripe É\"',2,1,4,0,0,0,0,0,''); INSERT INTO cards VALUES (110,4,2,3,49,0,'100','Gray Man','\"You cannot use ability symbols rolled by Gray Man to recruit. Gray Man\'s abilities cannot be increased. As an event, rotate Gray Man and target a character. Roll Gray Man\'s dice and apply any [Damage Icon] to the target. The target may then roll his dice and apply any [Damage Icon] to Gray Man.\"','\"The Soulless, The Gray Men, give up their souls to serve the Dark One as assassins.\"',0,1,0,1,0,1,1,0,''); INSERT INTO cards VALUES (111,6,2,4,5,0,'101','Guarded by Fate','Target a character who has damage greater than or equal to his highest ability. Remove damage from the target until it has one less damage than its highest ability.','\"I\'m a ta\'veren, and today it seems to be working in my favor for a change.\"',0,0,0,0,0,0,0,0,'\"Replace the word \"\"ability\"\" with \"\"permanent ability\"\".\"'); INSERT INTO cards VALUES (112,6,2,3,57,0,'102','Halfman','All trolloc troops you control participating in the same challenge as the Halfman gain +1 Combat. You can only use this bonus from one Halfman for each 3 tokens you have on your section of the Pattern.','\"Myrddraal galloped up and down on midnight horses, raven-black cloaks hanging undisturbed as they whirled their mounts.\"',0,0,0,2,0,1,0,2,NULL); INSERT INTO cards VALUES (113,3,2,4,40,0,'103','Hampered','Target a ready character or troop card controlled by another player. The target cannot use its effect text this turn.','\"Days of baking sun and searing winds, nights of boneshaking cold. Whatever grew seemed to have thorns or spines, or else a touch itched like fury.\"',0,0,0,0,0,1,0,0,NULL); INSERT INTO cards VALUES (114,3,2,4,5,0,'104','Harassment','Target one character or troop with Reinforcement for each [Intrigue Icon] you pay. The targets lose their Reinforcement ability.','Suddenly warning cries rose in the dark beyond the tents.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (115,1,2,4,38,0,'105','Healing','\"Remove one point of damage from a troop card, or all damage from a character card.\"','\"In the Age of Legends, some Aes Sedai could fan life and health to flame if only the smallest spark remained.\"',0,0,0,0,0,0,1,0,NULL); INSERT INTO cards VALUES (116,3,2,1,13,0,'106','Heavy Armor','\"As an event, rotate this card to remove one point of damage from the opponent\'s troop damage pool in any challenge in which the target is participating.\"','\"Breastplate, steel gauntlets, knee and elbow cups, and half-plate for shoulders and arms and legs.\"',0,0,0,0,0,0,0,1,NULL); INSERT INTO cards VALUES (117,3,2,4,17,0,'107','Heavy Fighting','Target a challenge. All troops participating in that challenge gain +1 Combat ability until the challenge is resolved.','',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (118,4,2,1,43,0,'108','Herb Bag','Rotate this advantage as a limited event while the target is at the home front and select a character you control at the home front. Remove 1 point of damage from the selected character.','Flatwort tea and andilay root are best for fatigue. They clear the head and dim the burn in tired muscles.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (119,1,2,4,53,0,'109','Heroic Efforts','\"Remove any number of tokens from your character damage pool. For each token removed, add one token to your troop damage pool.\"','Perrin hacked down a Shaido in his way and leaped over the man as he fell. They had to reach Rand; everything rested on that.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (120,6,2,1,5,0,'110','Heron-Mark Blade','\"Target a non-Aiel, non-monster character with 4 or more Combat ability, or the Dragon Reborn. That character gains +1 Politics ability, and may rotate this advantage while he is participating in a challenge to add one point of damage to your character damage pool.\"','\"A heron stood on the black blade, too, a bird so dark as to be nearly invisible.\"',0,0,0,0,0,0,0,2,NULL); INSERT INTO cards VALUES (121,6,2,1,54,0,'111','Hidden Discoveries','\"As an event, name a specific type of advantage (such as player advantage), rotate this card, and pay [One Power Icon]. Find the top advantage of that type in your deck and place it in your hand.\"','\"That leaves whatever might lie buried in ancient ruins or forgotten in an attic. If you want to count on finding something by chance, do so.\"',0,0,0,0,1,1,1,1,NULL); INSERT INTO cards VALUES (122,3,2,4,43,0,'112','Hidden Spies','This card may only be played by a Villain player. Target another player. Look at the top 5 cards of his deck. You may then shuffle his deck.','\"The Dark One\'s minions often find spies among the creatures that feed on death. Ravens and crows, mainly. Rats, in the cities, sometimes.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (123,4,2,3,49,0,'113','High Lady Alteima','Pay [Intrigue Icon] and target a player. That player must shuffle his deck.','\"The High Lady Alteima was far more dangerous than her husband or her lover, both of whom she had manipulated without either knowing it.\"',2,2,0,0,2,0,0,0,NULL); INSERT INTO cards VALUES (124,3,2,3,49,0,'114','High Lady Estanda','','\"Estanda smiled, a tight smile of triumph.\"',2,2,0,0,1,1,0,0,NULL); INSERT INTO cards VALUES (125,4,2,3,49,0,'115','High Lord Aracome','\"Each Ready round while you control High Lord Aracome, you may target a troop you control. That troop gains Reinforcement until you target another troop or rotate High Lord Aracome.\"','Illian shall fall! Illian shall fall! Illian shall fall! Illian shall fall!',2,1,0,1,2,0,0,1,NULL); INSERT INTO cards VALUES (126,3,2,3,16,0,'116','High Lord Geuyam','','The High Lords and Ladies were arrayed in a thick hollow circle under the great dome at the chamber\'s heart with the lesser nobles ranked behind.',2,1,0,2,2,0,0,1,NULL); INSERT INTO cards VALUES (127,6,2,3,16,0,'117','High Lord Meilan','\"While participating in a challenge, any ability symbols rolled by High Lord Meilan are ignored. For each [Sword Icon] or [Shield Icon] High Lord Meilan rolls, he generates an additional symbol of the same type.\"','\"Meilan was tall for a Tairen, only a hand shorter than Rand, and hard as any Defender.\"',2,3,0,1,2,2,0,0,NULL); INSERT INTO cards VALUES (128,4,2,1,41,0,'118','High Lord Samon','May only target Be\'lal. Be\'lal gains the Tear allegiance.','One of the Forsaken is in Tear. The High Lord Samon is Be\'lal.',0,0,0,0,0,0,0,0,'\"Add \"\"Be\'lal gains the trait High Lord\"\".\"'); INSERT INTO cards VALUES (129,3,2,3,16,0,'119','High Lord Torean','You may use any [Intrigue Icon] rolled by High Lord Torean as a [Politics Icon] instead.','\"Prophecy has been fulfilled, and Tear has fulfilled its place in that prophecy. Perhaps the Dragon Reborn will lead Tear to a still greater destiny.\"',1,2,0,0,1,1,0,0,''); INSERT INTO cards VALUES (130,6,2,3,19,0,'120','High Lord Weiramon','\"While participating in a challenge, High Lord Weiramon may only roll his Combat dice if one or more Tear troops you control are participating in that challenge. For each [Combat Icon] he rolls in a challenge, you must place a point of damage on one of your participating troops.\"','\"Weiramon was still sending charges against the fort when I left, and Sammael cuts every one to rags...\"',2,0,0,3,1,0,0,1,''); INSERT INTO cards VALUES (131,6,2,4,21,0,'121','High Stakes','Play this event during the ready round. The player who wins the Pattern challenge may also move a neutral token to his section of the Pattern.','\"We do not run. We dare not run. Worlds and time rest on Rand, on the Dragon Reborn. This time, we fight.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (132,3,2,3,23,0,'122','Hired Agent','','\"Fine silks and perfumes did little to hide the uncouth manner of the man, a greedy businessman dealing in death and purchased loyalties.\"',0,1,0,0,0,1,0,0,''); INSERT INTO cards VALUES (133,6,2,1,57,0,'123','Horn of Valere','\"The first player to control this advantage by 20 or more adds two tokens to his section of the Pattern and places it on a character they control as a character advantage. If you control this advantage during the Last Battle, each [Sword Icon] you roll also counts as a [Skull Icon].\"','\"In the last, lorn fight gainst the fall of long night, the mountains stand guard, and the dead shall be ward, for the grave is no bar to my call.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (134,3,2,4,40,0,'124','Hostile Terrain','\"Target a card-based challenge. Only one terrain event may target each challenge. A player must pay [Combat Icon] for each troop he wishes to use its Reinforcement trait. If any troop takes damage during the challenge, it takes an additional point of damage after the challenge is resolved.\"','The Three-Fold Land can be a dangerous place for those who do not know it.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (135,6,2,5,1,0,'125','House Guards','\"If a Cairhien character you control takes any damage while participating in a challenge with House Guards, you may apply the damage to this card instead. You cannot use this effect while this card has damage greater than or equal to its Combat ability.\"','\"An escort will be welcome, Captain.\"',0,0,0,3,1,1,0,0,'\"Replace the word \"\"ability\"\" with \"\"permanent ability\"\".\"'); INSERT INTO cards VALUES (136,1,2,5,24,0,'126','Human Rabble','Human Rabble may participate in challenges with monster characters and troops you control.','\"Assembled in haste and poorly trained, the disorderly troop displayed a broad mix of armor and arms, including rusty swords, cudgels and pitchforks.\"',0,0,0,2,0,1,0,0,''); INSERT INTO cards VALUES (137,3,2,2,56,0,'127','Hunting Trollocs','\"Target a monster troop. If you succeed by at least the current Combat ability of the target, discard it.\"','\"Gaul pivoted smoothly to slide a spear into the black-mailed chest of a wolf-snouted Trolloc ... More came behind it, though, all goatsnouts and boar\'s tusks, cruel beaks and twisted horns ...\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (138,4,2,4,38,0,'128','Illusion','\"Play this card during the Opening Moves step of a challenge and target another player. For each [One Power Icon] you pay, you may remove one token from the target\'s support, opposition or character damage pool.\"','\"The mind plays tricks in the night, the eye sees what is not there.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (139,3,2,4,25,0,'129','In Harm\'s Way','Target a character you control who is participating in a challenge. Put one point of damage on the target. He gains +3 Combat.','It is said that a Borderlander will take a dagger\'s wound to avoid harm to a woman and count it a fair trade.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (140,3,2,4,43,0,'130','Incentives','You may ignore the light nature or dark nature trait on the next character you recruit this turn.','Gold glinted in the lamp light as the Warder counted out coins one by one into the other\'s palm.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (141,3,2,4,38,0,'131','Infighting','\"Target two or more trolloc troops participating in the same challenge. If each target\'s controller does not pay [Combat Icon] from a character before the challenge is resolved, that target troop takes one point of damage. Draw one card.\"','\"Trollocs, the Twisted Ones, made during the War of the Shadow from melding men and animals ...\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (142,3,2,4,56,0,'132','Infiltration','\"While participating in a challenge, pay any amount of [Intrigue Icon]. For each [Intrigue Icon x2] you pay, add a point of damage to a troop participating in the same challenge.\"','\"If the night had not been so still, the faint sound might not have seemed furtive, but it was and it did.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (143,4,2,1,49,0,'133','Inner Strength','Rotate this advantage as an event and target a character you control. Add one ability symbol of any type to your pool. You may only use that symbol to pay effect text cost on the targeted character.','He could never handle the instrument without a pang of sadness. Touching its gold-and-silver scrollwork was like touching Thom\'s memory.',0,0,0,0,1,1,0,0,''); INSERT INTO cards VALUES (144,6,2,1,56,0,'134','Inspirational Leader','\"Whenever you roll the target\'s dice, you may replace all of his Politics dice with Combat dice. (This does not change the target\'s abilities.) This can allow him to participate in the Last Battle.\"','Until yesterday I have followed men of other lands because I must. You I will follow because I want to.',0,0,0,0,1,0,0,1,''); INSERT INTO cards VALUES (145,4,2,4,7,0,'135','Into the Fight','The next character you recruit has minus one to the cost of one ability of your choice. This character is placed in the battleground (instead of your home front) and gains Reinforcement (for the rest of the turn).','\"Trollocs poured in out of the night, snouted faces and horned heads, towering over the humans...\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (146,3,2,4,7,0,'136','Intolerance','Target a player. All cards with an allegiance different from his Hero or Villain character cause the allegiance penalty when being recruited.','\"When the Children of the Light ask questions, you grey-eyed bumpkin, we expect answers...\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (147,6,2,3,6,0,'137','Ishamael','\"Ishamael may roll an extra Intrigue die while you have more Pattern tokens than any other player. Unless a Hero player has at least 4 Pattern, all [Skull Icon] rolled by Ishamael are ignored.\"','\"You only have on salvation, Rand al\'Thor. Lews Therin Kinslayer, I am your only salvation. Serve me, and I will give you the world. Resist, and I will destroy you...\"',1,2,4,1,0,0,0,0,''); INSERT INTO cards VALUES (148,6,2,3,2,0,'138','Jaichim Carridin','\"Jaichim has the Children of the Light allegiance. When Jaichim rotates to generate symbols at the beginning of the action round, he automatically generates a [Politics Icon].\"','\"And he did not blink under the silent study of the Lord Captain Commander ... But then, it was said that Jaichim Carridin could outwait a stone.\"',1,2,0,1,1,2,0,0,''); INSERT INTO cards VALUES (149,4,2,1,28,0,'139','Jasin Natael','May only target Asmodean. He gains +1 Intrigue and Gleeman. You may rotate this advantage as a limited event to look at the top card in another player\'s deck.','\"What stories can I make with the sights your eyes have seen? I will even make you the hero, if you wish.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (150,6,2,3,35,0,'140','Juilin Sandar','\"Rotate Juilin and target a character in play. The target\'s Intrigue is reduced by Juilin\'s Intrigue. If this effect would kill a character, he is discarded but is not considered killed.\"','\"My name is Juilin Sandar and I am a thief-catcher, and I would know why you are on the rooftops, staring at the Stone.\"',0,2,0,2,2,0,0,0,'Juilin Snadar may not target a Staring Hero or Starting Villain'); INSERT INTO cards VALUES (151,3,2,4,35,0,'141','Knowledge is Power','\"Pay any number of [Intrigue Icon]. For each [Intrigue Icon] you pay, target one player. Look at the top card of each target\'s deck. You may discard any of the cards you view.\"','\"I\'m afraid the Lord Dragon doesn\'t always take me into his confidence, my Lady, and when he does, you wouldn\'t expect me to break that confidence.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (152,1,2,3,51,0,'142','Lady Aemlyn','\"While participating in a challenge, Lady Aemlyn can convert any ability symbol she rolls into a [Sword Icon].\"','\"Aemlyn, a plump woman wrapped in dark wool, nodded in agreement with him...\"',1,1,0,1,2,0,0,1,''); INSERT INTO cards VALUES (153,1,2,3,16,0,'143','Lady Arathelle','','\"Arathelle\'s voice held tones of authority, unsurprising in the High Seat of a powerful house.\"',2,0,0,0,1,0,0,0,''); INSERT INTO cards VALUES (154,4,2,3,1,0,'144','Lady Colavaere','Lady Colavaere gains +1 Intrigue while there are no other Cairhien characters in play with Politics or Intrigue greater than 2.','\"A more than handsome woman in her middle years, with dark ivory lace ... and horizontal slashes of color from high lace collar to her knees ...\"',2,2,0,0,1,1,0,0,''); INSERT INTO cards VALUES (155,1,2,3,28,0,'145','Lady Elenia','You may rotate Lady Elenia as a limited event to have her cease participating in a challenge.','\"... of House Sarand, shrewish, honey-haired, Elenia.\"',1,1,0,0,1,0,0,0,''); INSERT INTO cards VALUES (156,1,2,3,28,0,'146','Lady Ellorien','','\"Morgase nodded dully ... Ellorien, now one of her closest friends. At least, she had been. Elayne had been named after Ellorian\'s grandmother.\"',2,1,0,0,2,0,0,0,''); INSERT INTO cards VALUES (157,1,2,3,5,0,'147','Lan Mandragoran','Lan cannot be controlled by a Villain player. Lan may pay [Combat Icon x2] to generate either a [Politics Icon] or a [Intrigue Icon].','The rose petal floats on the water ... The kingfisher flashes above the pond. Live and beauty swirl in the midst of death.',0,1,0,4,1,0,0,2,''); INSERT INTO cards VALUES (158,6,2,3,49,0,'148','Lanfear','\"Whenever Lanfear rolls at least [One Power x3], she may rotate the Dragon Reborn for no effect.\"','\"I serve. I have served the Lord of the Twilight long. Long did I lie imprisoned for my service, in an endless, dreamless sleep ... Now I am free again, and I will use what is mine.\"',2,2,4,0,0,0,0,0,''); INSERT INTO cards VALUES (159,3,2,2,17,0,'149','Learning From The Past','\"Only Politics and Intrigue may be rolled in this challenge. If you succeed, this challenge becomes a player advantage targeting you. You may discard the advantage to pay for the ability symbol cost of playing an advantage.\"','\"Surprising what you can dig out of books if you read long enough, isn\'t it?\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (160,6,2,3,6,0,'150','Liandrin Sedai','\"Liandrin has the Aes Sedai allegiance, and is considered to be Red Ajah. Rotate Liandrin as an event to look at a random card in another player\'s hand. If the card has any [One Power Icon] in its cost, discard it.\"','\"... false Dragons ravage the land. The while, you Blues smile and talk of nothing, and try to hold on to the past.\"',2,3,2,0,1,2,1,0,''); INSERT INTO cards VALUES (161,2,2,5,15,0,'151','Light Cavalry','\"If you succeed at a challenge in which this troop participated and if this card has less than 2 damage, you may put one point of damage on another player\'s troop that participated, after all normal damage is applied.\"','\"Light cavalry is best for harrying. Bite at the flanks, keep them running, and never let them settle to fight.\"',0,0,0,2,1,0,0,1,''); INSERT INTO cards VALUES (162,4,2,4,19,0,'152','Lightning','\"Play this card during the Opening Moves or Coming to Grips step of a challenge. Target a character or troop participating in that challenge. Pay [One Power Icon] [One Power Icon] to put one point of damage on the target. For each additional [One Power Icon] [One Power Icon] you pay, you may put a point of damage on a different participating character or troop.\"','\"Like rapid beats on a giant drum, bolt followed boltÉ\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (163,4,2,2,3,0,'153','Limit the Opposition','\"If you succeed, this challenge becomes a player advantage targeting you. Place a limit token on the advantage for each two by which you succeed. During the ready round you may remove a limit token to target another player. The target cannot draw more than two cards during that turn.\"','\"I wouldn\'t think an inn with the Dragon\'s Fang on its door would get much custom. Might have trouble with fire, with that on your door.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (164,3,2,4,24,0,'154','Local Aid','\"For each [Combat Icon x2] you pay, remove one token from your opponent\'s troop damage pool.\"','\"You are welcome to our fires. There will be hot water, and bandages and poultices.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (165,6,2,3,3,0,'155','Loial','\"Whenever Loial participates in a challenge, draw one card during the Opening Moves step of that challenge.\"','\"His eyes were the size of saucers, with thick eyebrows that dangled like moustaches to his cheeks, and his ears poked up through long hair in tufted points.\"',2,0,0,1,2,0,0,0,''); INSERT INTO cards VALUES (166,6,2,1,27,0,'156','Longbow','\"Target a character with the Combat ability. While the target is participating in a challenge, rotate him as a limited event, select a non-Hero, non-Villain character participating in the same challenge, and roll the target\'s dice. Apply any damage on the character selected. Other results are ignored.\"','\"Rand was not aware of raising his bow, or drawing the fletching against his cheek, to his ear.\"',0,0,0,0,0,0,0,2,''); INSERT INTO cards VALUES (167,6,2,3,50,0,'157','Lord Barthanes','\"Barthanes has the Cairhien allegiance. While participating in a challenge, all Intrigue ability symbols Barthanes rolls are converted into damage symbols.\"','\"And this one the personal seat of Lord Barthanes, who is next to the King himself in power.\"',2,3,0,1,2,2,0,0,''); INSERT INTO cards VALUES (168,4,2,3,19,0,'158','Lord Daricain','','É and Lieutenant Lord Daricain of House Annallin.',2,1,0,2,1,0,0,2,''); INSERT INTO cards VALUES (169,3,2,3,35,0,'159','Lord Edorion','\"If Lord Edorion\'s cost is payed for by a Tear High Lord or Tear High Lady, this card\'s cost is [Politics Icon].\"','What\'s the matter? Did I say something?',1,1,0,1,2,0,0,0,''); INSERT INTO cards VALUES (170,1,2,1,41,0,'160','Lord Gaebril','May only target Rahvin. Rahvin gains the Andor allegiance.','\"Gaebril was still speaking, and every lord and lady seemed to hang on his words. Morgase was frowning as she listened, yet she nodded as much as any other.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (171,1,2,3,28,0,'161','Lord Jarid','\"If Lord Jarid rolls three ability symbols during a turn, draw one card.\"','Dark square-faced Jarid of House Sarand ...',2,0,0,1,2,0,0,0,''); INSERT INTO cards VALUES (172,1,2,3,50,0,'162','Lord Lir','\"During the Opening Moves step of a challenge in which Lord Lir is participating, you may add one point of damage to Lord Lir to add a token to your character damage pool.\"','\"... and Lir of House Baryn, a whip of a man, wearing a sword of all things ...\"',2,1,0,1,2,0,0,1,'\"Lord Lir\'s ability may be used a maximum of once per turn. You may use his ability during the Opening Moves step, regardless of how much damage is on Lord Lir.\"'); INSERT INTO cards VALUES (173,4,2,3,46,0,'163','Lord Meresin','','Lieutenant Lord Meresin of House Daganred',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (174,1,2,3,28,0,'164','Lord Nasin','','\"... and bony, goat-faced Nasin of House Caeren\"',2,1,0,2,2,1,0,0,''); INSERT INTO cards VALUES (175,1,2,3,27,0,'165','Lord Pelivar','\"As an event, Lord Pelivar may pay [Combat Icon] to remove one point of damage from an opponent\'s character damage pool in a challenge in which this card is participating.\"','\"If I must die to defend my lands and my people, then better here than where my lands and people die, too.\"',2,0,0,2,2,0,0,1,''); INSERT INTO cards VALUES (176,6,2,3,27,0,'166','Lord Perrin','\"You must have 4 Pattern to replace Perrin Aybara. Perrin gains +1 Combat while participating in a challenge against monster characters. When applying his damage while participating in a challenge, Perrin can choose which applicable character any damage he has generated is applied to.\"','Goldeneyes! Lord Perrin! Goldeneyes!',2,1,0,3,0,0,0,0,''); INSERT INTO cards VALUES (177,4,2,3,27,0,'167','Lord Talmanes','\"When Lord Talmanes participates in a challenge, you may target a troop participating in the same challenge. It may not ready on the next ready round.\"','É he led these Cairhienin although there were older men and even gray hair present.',1,1,0,3,1,1,0,2,''); INSERT INTO cards VALUES (178,6,2,4,31,0,'168','Lucky Find','Choose a type of advantage (such as a player advantage). Find the top advantage of that type in your deck and place it in your hand.','There could be treasure...',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (179,4,2,1,2,0,'169','Marksmen','\"Target a troop you control. The target\'s Combat ability is reduced by two. While participating in a challenge, the target rolls its dice and applies the results in the Opening Moves step instead of the Coming to Grips step (any damage generated is still considered troop damage).\"','\"The snap of bowstrings was lost in the Trolloc roar, but a goose-fletched hail streaked the sky as it arced out, plunging down into the black-mailed horde.\"',0,0,0,0,0,0,0,2,''); INSERT INTO cards VALUES (180,1,2,3,6,0,'170','Mat Cauthon','\"You may reroll one of Mat\'s dice each turn (immediately after making his initial roll, the old result is ignored).\"','Mat\'s brown eyes twinkled with mischief ... Few people had escaped his pranks.',0,2,0,1,2,0,0,0,''); INSERT INTO cards VALUES (181,6,2,3,56,0,'171','Mat the Warrior','\"You must have 4 Pattern to replace Mat Cauthon. You may reroll one of Mat\'s dice each turn (immediately after making his initial roll, the old result is ignored). Mat may participate in challenges as a troop. Symbols Mat generates have all allegiances when they are used to recruit troops.\"','\"It was as if he could remember dances and battles and streets and cities, none of which he had ever really seen... like a hundred pieces of memory from a hundred different men.\"',1,2,0,4,0,0,0,0,''); INSERT INTO cards VALUES (182,6,2,3,45,0,'172','Min','\"Rotate Min as an event and target a character you control. Retrieve a replacement character for the target from your deck and place it in your hand. If Min is ever killed, you must convert one of your Pattern tokens into a neutral token.\"','A shepherd with a heron-mark sword. That\'s enough to make me believe anything. What trouble are you in country boy?',1,1,0,0,1,1,0,0,'\"Replace the 2nd line of her effect text with \"\"Retrieve a replacement character with a Pattern requirement for the target from your deck and place it in your hand.\"\"\"'); INSERT INTO cards VALUES (183,3,2,4,24,0,'173','Misdirection','\"Pay [One Power Icon] to target a troop whose recruit cost is two or less. For each additional [One Power Icon x2] you pay, you may target another troop whose recruit cost is two or less. Rotate the targets for no effect.\"','Abruptly Moiraine thrust the staff out to the west. Dead leaves whirled into the air and branches whipped as if a dust devil ran along the line she pointed to.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (184,6,2,3,49,0,'174','Moghedien','\"Whenever Moghedien rolls at least [One Power Icon x3], you do not have to reveal your challenge card on the next turn until after the Challenge Round is over. You must announce any participation restrictions on a hidden challenge card.\"','\"Let other fools leap about in full view. They can be brought low by a spider hiding in the cracks, a spider they never see until it is too late.\"',0,3,4,0,0,0,0,0,''); INSERT INTO cards VALUES (185,1,2,3,5,0,'175','Moiraine Sedai','\"Moiraine cannot be controlled by a Villain player. If the Dragon Reborn pays any of Moiraine\'s recruit cost, you may pay exactly [Politics Icon x2] [One Power Icon] to recruit her.\"','\"Her only apparent weapon was a switch, but where she slashed a Trolloc, a line of flame grew on its flesh.\"',2,2,2,0,2,1,1,0,''); INSERT INTO cards VALUES (186,4,2,1,39,0,'176','Momentum','\"If you gain a token from the Pattern challenge, you gain 2 support or opposition (your choice) in every other challenge that takes place that turn.\"','\"Not even slowing, the front rank of Trollocs ran onto the sharp stakes É howling as they were impaled, driven down by more huge shapes scrambling up over their backsÉ\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (187,6,2,3,6,0,'177','Morgase Trakand','You must have 4 Pattern to recruit Morgase. You may rotate Morgase to add two tokens to the Andor contested advantage.','\"Morgase had her daughter\'s beauty, matured and ripened. Her face and figure, her presence, filled the room like a light.\"',4,1,0,0,4,0,0,0,''); INSERT INTO cards VALUES (188,6,2,1,5,0,'178','Mount','The targeted character gains Reinforcement.','With himself and his stallion Mandarb - he said it meant Blade in the Old Tongue - he was not so sparing. The Warder covered twice as much ground as they did...',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (189,4,2,1,31,0,'179','Nae\'blis','\"Only cards controlled by a Villain player may participate in challenges initiated by this challenge. If any Villain player wins the Last Battle, the Villain controller of this advantage wins instead.\"','\"Nae\'blis. The one who would stand only a step below the Great Lord, commanding all others.\"',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (190,3,2,3,40,0,'180','Narg','','Others go away. Narg stay. Narg smart.',0,1,0,1,0,0,0,1,''); INSERT INTO cards VALUES (191,4,2,4,23,0,'181','Narrow Escape','\"Play when a (non-Hero, non-Villain) character you control is killed. Convert one of your Pattern tokens into a neutral token to place that character in your hand. He is not considered killed.\"','I left Whitebridge sure you were dead.',0,0,0,0,0,0,0,0,''); INSERT INTO cards VALUES (192,6,2,2,1,0,'182','Noble Allies','\"If you succeed, this challenge becomes a player advantage targeting you. The advantage increases your maximum hand size by 2.\"','\"Besides, if you die, I don\'t think our Andoran friends will maintain their warm welcome for me and my men.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (193,6,2,3,6,0,'183','Nynaeve al\'Meara','\"If Nynaeve rolls a number of [One Power Icon] equal to her permanent One Power ability, she gains +1 One Power permanently, to a maximum of four. When Nynaeve rolls One Power dice, the results are ignored unless she rolls at least one [One Power Icon].\"','They said you learned quickly. And they said it took your temper burning to get to the heart of what you can do.',1,0,2,0,2,0,0,0,NULL); INSERT INTO cards VALUES (194,1,2,4,53,0,'184','Overrun','\"Remove any number of tokens from your troop damage pool. For each token removed, add one token to your character damage pool.\"','\"Banners and con waving, the Cairhienin charged downhill with him, shouting battle cries.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (195,1,2,3,3,0,'185','Padan Fain','Padan Fain gains +1 Intrigue while participating in a challenge. Padan Fain may reinforce any challenge in which the Dragon Reborn is participating.','\"There is much yet hidden about Padan Fain, much I must learn. The evil goes deeper in him, and stronger, than in many I have seen.\"',0,1,0,0,0,1,0,0,NULL); INSERT INTO cards VALUES (196,4,2,5,21,0,'186','Patrol','\"While participating in a challenge, this card may act as either a character or as a troop.\"','\"The Children of the Light hold sway wherever men walk in the Light. Only where the Shadow of the Dark One reigns are the Children denied, yes?\"',0,0,0,2,1,0,0,0,NULL); INSERT INTO cards VALUES (197,6,2,3,49,0,'187','Pedron Niall','\"While you control Pedron Niall, Children of the Light troops you control gain +1 Combat. You may draw an additional card during the draw round.\"','Niall\'s skin was as thin as scraped parchment É but there was nothing of frailty about him.',3,3,0,2,4,2,0,2,NULL); INSERT INTO cards VALUES (198,1,2,3,6,0,'188','Perrin Aybara','\"When applying his damage while participating in a challenge, Perrin can choose which applicable character any damage he has generated is applied to.\"','\"... the curly-haired blacksmith\'s apprentice was so stocky as to seem a man and a half wide, with arms and shoulders thick enough to rival those of Master Luhhan.\"',1,0,0,2,2,0,0,0,NULL); INSERT INTO cards VALUES (199,1,2,4,5,0,'189','Personal Growth','Target a character you control who rolled at least one ability symbol during a challenge. Pay one of those symbols. This card becomes a character advantage giving the target character +1 to that ability.','Twice and twice shall he be marked.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (200,1,2,4,23,0,'190','Plots','Play during a challenge. Roll two Politics dice and add the results to your pools.','It is no treason which must be done. And even blasphemy can be tolerated for a cause.',0,0,0,0,0,1,0,0,NULL); INSERT INTO cards VALUES (201,3,2,2,28,0,'191','Political Isolation','\"Target a player. If you succeed, the target may not roll any Politics dice next turn.\"','This was hardly the first time they had tried to secure their own places by casting suspicion on any lord or lady not standing with them...',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (202,3,2,2,50,0,'192','Political Maneuvering','\"Only Politics dice may be rolled in this challenge. If successful, add a token to your section of the Pattern.\"','More praise for Rand\'s wisdom flowed from Lord Henren... and nearly a dozen others who had held their tongues while those more powerful spoke.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (203,6,2,2,15,0,'193','Political Prisoner','\"Target a non-Hero, non-Villain character. For each two by which you succeed, place a prisoner token on the target. The target is rotated and may not ready while any prisoner tokens remain on him. Remove one prisoner token for each [Politics Icon] paid by any player as a limited event.\"','\"Rand turned his eyes back to the rafters. Six Aes Sedai sat in chairs around the cage, sustaining the shield on him.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (204,4,2,4,31,0,'194','Portal Stone','\"Target one or more characters you control. Roll one of the target\'s One Power dice. For each [One Power Icon] rolled, two of the target characters of your choice become participants in one challenge of your choice. Each targeted participant generates one additional [Sword Icon] in that challenge. All target characters who do not participate in that challenge rotate for no effect.\"','The symbols at the bottom indicate Stones at other places.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (205,6,2,4,38,0,'195','Power Suppression','\"For each [One Power Icon x2] you pay, target a rotated character. The targeted characters may not ready during the next ready round.\"','\"As he pushed himself to his feet, sight began to return, watery and painful at first.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (206,3,2,4,22,0,'196','Prepared Defense','Target a challenge. Only events that have at least one [One Power Icon] in their cost may be played while resolving that challenge.','\"Those walls themselves made a perfect square, with one side hard along the river. In just as exact a pattern, towers rose within the wallsÉ\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (207,6,2,2,35,0,'197','Prolonged Campaign','\"Requires four Pattern to initiate. If you succeed, add a token to your section of the Pattern. If you succeed by 4 or more, add an additional token to your section of the pattern. If your opponent generated no opposition to the challenge, add an additional token to your section of the Pattern. Participants in this challenge do not ready on the following turn.\"','What remains of the Shaido are retreating north ... but Rand al\'Thor seems to have forgotten them. He is sending the spears south toward Tear.',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (208,4,2,4,5,0,'198','Prophecy','May only be played by a Hero player. Name a card. Reveal the top five cards of your deck. Put any cards with that name into your hand. Shuffle the rest back into your deck.','The Wheel of Time and the wheel of a man\'s life turn alike without pity or mercyÉ',0,0,0,0,0,0,1,0,NULL); INSERT INTO cards VALUES (209,4,2,4,45,0,'199','Pull of the Pattern','','',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (210,6,2,5,57,0,'200','Queen\'s Guard','\"For each [Skull Icon] this troop rolls, it generates an additional [Skull Icon] if you control the Queen of Andor.\"','\"Thin red streamers fluttered beneath the heads of their lances, every lance held at the same angle.\"',0,0,0,5,2,0,0,1,NULL); INSERT INTO cards VALUES (211,1,2,3,6,0,'201','Rahvin','\"As an event, Rahvin may pay [One Power Icon x3] that he rolled to cause one point of damage to any character or troop in play.\"','\"Snatching at saidin, he filled himself with the Power, the taint on the male half of the True Source rolling off the protection of his bonds and oaths ...\"',0,1,4,1,0,0,0,0,NULL); INSERT INTO cards VALUES (212,4,2,5,39,0,'202','Raiding Party','The Raiding Party gains +1 Combat ability while participating in a card-based challenge you initiate.','\"They seemed all shadow, colors that blended with the darkness too well to see them clearly...\"',0,1,0,2,1,0,0,1,NULL); INSERT INTO cards VALUES (213,4,2,2,13,0,'203','Rallying Cry','\"If you succeed, this challenge becomes a player advantage targeting you. Whenever you succeed at a challenge, add a rallying token to this card. Remove one rallying token to reduce the cost of a troop by one ability of your choice.\"','Carai an Caldazar! Carai an Ellisande! Al Ellisande!',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (214,1,2,2,3,0,'204','Rampage','\"Only the Villain player may initiate this challenge. Target another player. For each point by which you succeed, the target must discard a random card from his hand.\"','\"Splintered, broken wood littered the room; not a single piece of furniture remained whole.\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (215,1,2,3,5,0,'208','Rand al\'Thor (I) Fixed','\"If Rand pays any of the cost to recruit a Dragon or light nature character, apply -1 to the cost of each ability (after all other modifications). If Rand rolls at least [One Power Icon x2], he permanently gains +1 One Power, to a maximum of four.\"','I am Rand al\'Thor! ...I am the Dragon Reborn!',1,0,2,1,0,0,0,0,NULL); INSERT INTO cards VALUES (216,6,2,3,5,0,'206','Rand al\'Thor (II) Musician','\"If Rand pays any of the cost for any events requiring One Power, the One Power cost for the card is decreased by 1. If Rand rolls at least [One Power Icon x2], he permanently gains +1 One Power, to a maximum of five.\"','\"Wrap a shoufa aorund your head, Rand, and you would be the image of an Aielman.\"',1,0,3,0,0,0,0,0,NULL); INSERT INTO cards VALUES (217,6,2,3,5,0,'207','Rand al\'Thor (III) Shepherd','\"Select a non-Dark One allegiance at the beginning of the game. Rand has that allegiance. If Rand rolls at least [One Power Icon x2], he permanently gains +1 One Power, to a maximum of four.\"','It is a name not spoken except among the clan chiefs and the Wise Ones... the Aiel are the People of the Dragon.',1,1,2,1,0,0,0,0,NULL); INSERT INTO cards VALUES (218,6,2,3,5,0,'205','Rand al\'Thor (IV) Nation','\"While you control a nation contested advantage, Rand gains the allegiance of that nation. If Rand rolls at least [One Power Icon x2], he permanently gains +1 One Power, to a maximum of four.\"','\"If the only way I can find time and peace for the world is to impose it, I will.\"',1,0,2,2,0,0,0,0,NULL); INSERT INTO cards VALUES (219,6,2,3,5,0,'209','Rand the King','Replace a Dragon Reborn character when you have 8 Pattern. Rand the King gains the allegiances of all characters he controls.','\"The Light illumine Rand al\'Thor, King of Illian.\"',4,2,5,3,0,0,0,0,NULL); INSERT INTO cards VALUES (220,3,2,4,49,0,'210','Rapid Recovery','All characters you control that rotate to heal this turn remove two points of damage instead of one.','\"A dark-haired, youngish man in a red coat, with a bandage wound around his temples, was making his way down the stairs at the side of the common room using padded crutches...\"',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (221,3,2,4,43,0,'211','Ravens Watching','This card may only be played by a Villain player. Target a card-based challenge. Hero players must pay [Intrigue Icon] in addition to any other costs to play each event while resolving that challenge.','In the Borderlands there was a bounty on Ravens; no one there ever dared assume any raven was just a bird...',0,0,0,0,0,0,0,0,NULL); INSERT INTO cards VALUES (222,6,2,1,6,0,'212','Raw Recruits','Rotate