1 ALTER TABLE db_version CHANGE COLUMN required_8548_02_mangos_gameobject_battleground required_8549_03_mangos_battleground_events bit;
3 DROP TABLE IF EXISTS `battleground_events`;
4 CREATE TABLE `battleground_events` (
5 `map` smallint(5) NOT NULL,
6 `event1` tinyint(3) unsigned NOT NULL,
7 `event2` tinyint(3) unsigned NOT NULL,
8 `description` varchar(255) NOT NULL,
9 PRIMARY KEY (`map`,`event1`,`event2`)
10 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
21 INSERT INTO battleground_events (map, event1, event2, description) VALUES
22 (@WS_MAP, 0, 0, 'Alliance Flag'),
23 (@WS_MAP, 1, 0, 'Horde Flag'),
24 (@WS_MAP, 2, 0, 'Spirit Guides'),
25 (@WS_MAP, 254, 0, 'Doors'),
28 (@AB_MAP, 0, 0, 'Stables - neutral'),
29 (@AB_MAP, 0, 1, 'Stables - alliance contested'),
30 (@AB_MAP, 0, 2, 'Stables - horde contested'),
31 (@AB_MAP, 0, 3, 'Stables - alliance owned'),
32 (@AB_MAP, 0, 4, 'Stables - horde owned'),
34 (@AB_MAP, 1, 0, 'Blacksmith - neutral'),
35 (@AB_MAP, 1, 1, 'Blacksmith - alliance contested'),
36 (@AB_MAP, 1, 2, 'Blacksmith - horde contested'),
37 (@AB_MAP, 1, 3, 'Blacksmith - alliance owned'),
38 (@AB_MAP, 1, 4, 'Blacksmith - horde owned'),
40 (@AB_MAP, 2, 0, 'Farm - neutral'),
41 (@AB_MAP, 2, 1, 'Farm - alliance contested'),
42 (@AB_MAP, 2, 2, 'Farm - horde contested'),
43 (@AB_MAP, 2, 3, 'Farm - alliance owned'),
44 (@AB_MAP, 2, 4, 'Farm - horde owned'),
46 (@AB_MAP, 3, 0, 'Lumber Mill - neutral'),
47 (@AB_MAP, 3, 1, 'Lumber Mill - alliance contested'),
48 (@AB_MAP, 3, 2, 'Lumber Mill - horde contested'),
49 (@AB_MAP, 3, 3, 'Lumber Mill - alliance owned'),
50 (@AB_MAP, 3, 4, 'Lumber Mill - horde owned'),
52 (@AB_MAP, 4, 0, 'Gold Mine - neutral'),
53 (@AB_MAP, 4, 1, 'Gold Mine - alliance contested'),
54 (@AB_MAP, 4, 2, 'Gold Mine - horde contested'),
55 (@AB_MAP, 4, 3, 'Gold Mine - alliance owned'),
56 (@AB_MAP, 4, 4, 'Gold Mine - horde owned'),
58 (@AB_MAP, 254, 0, 'doors'),
60 (@EY_MAP, 0, 0, 'Fel Reaver - alliance'),
61 (@EY_MAP, 0, 1, 'Fel Reaver - horde'),
62 (@EY_MAP, 0, 2, 'Fel Reaver - neutral'),
64 (@EY_MAP, 1, 0, 'Blood Elf - alliance'),
65 (@EY_MAP, 1, 1, 'Blood Elf - horde'),
66 (@EY_MAP, 1, 2, 'Blood Elf - neutral'),
68 (@EY_MAP, 2, 0, 'Draenei Ruins - alliance'),
69 (@EY_MAP, 2, 1, 'Draenei Ruins - horde'),
70 (@EY_MAP, 2, 2, 'Draenei Ruins - neutral'),
72 (@EY_MAP, 3, 0, 'Mage Tower - alliance'),
73 (@EY_MAP, 3, 1, 'Mage Tower - horde'),
74 (@EY_MAP, 3, 2, 'Mage Tower - neutral'),
76 (@EY_MAP, 4, 0, 'capture flag - Fel Reaver'),
77 (@EY_MAP, 4, 1, 'capture flag - Blood Elf'),
78 (@EY_MAP, 4, 2, 'capture flag - Draenei Ruins'),
79 (@EY_MAP, 4, 3, 'capture flag - Mage Tower'),
80 (@EY_MAP, 4, 4, 'capture flag - center'),
82 (@EY_MAP, 254, 0, 'doors'),
85 (@NA_MAP, 253, 0, 'buffs'),
86 (@NA_MAP, 254, 0, 'doors'),
88 (@RL_MAP, 253, 0, 'buffs'),
89 (@RL_MAP, 254, 0, 'doors'),
91 (@BE_MAP, 253, 0, 'buffs'),
92 (@BE_MAP, 254, 0, 'doors');