1 ALTER TABLE db_version CHANGE COLUMN required_8608_01_mangos_mangos_string required_8608_02_mangos_battleground_events bit;
3 DELETE FROM battleground_events WHERE map = 30;
4 INSERT INTO battleground_events (map, event1, event2, description) VALUES
8 (30, 0, 0, 'Firstaid Station - Alliance assaulted'),
9 (30, 0, 1, 'Firstaid Station - ALliance control'),
10 (30, 0, 2, 'Firstaid Station - Horde assaulted'),
11 (30, 0, 3, 'Firstaid Station - Horde control'),
13 (30, 1, 0, 'Stormpike Grave - Alliance assaulted'),
14 (30, 1, 1, 'Stormpike Grave - ALliance control'),
15 (30, 1, 2, 'Stormpike Grave - Horde assaulted'),
16 (30, 1, 3, 'Stormpike Grave - Horde control'),
18 (30, 2, 0, 'Stoneheart Grave - Alliance assaulted'),
19 (30, 2, 1, 'Stoneheart Grave - ALliance control'),
20 (30, 2, 2, 'Stoneheart Grave - Horde assaulted'),
21 (30, 2, 3, 'Stoneheart Grave - Horde control'),
23 (30, 3, 0, 'Snowfall Grave - Alliance assaulted'),
24 (30, 3, 1, 'Snowfall Grave - ALliance control'),
25 (30, 3, 2, 'Snowfall Grave - Horde assaulted'),
26 (30, 3, 3, 'Snowfall Grave - Horde control'),
27 (30, 3, 5, 'Snowfall Grave - Neutral control'),
29 (30, 4, 0, 'Iceblood Grave - Alliance assaulted'),
30 (30, 4, 1, 'Iceblood Grave - ALliance control'),
31 (30, 4, 2, 'Iceblood Grave - Horde assaulted'),
32 (30, 4, 3, 'Iceblood Grave - Horde control'),
34 (30, 5, 0, 'Frostwolf Grave - Alliance assaulted'),
35 (30, 5, 1, 'Frostwolf Grave - ALliance control'),
36 (30, 5, 2, 'Frostwolf Grave - Horde assaulted'),
37 (30, 5, 3, 'Frostwolf Grave - Horde control'),
39 (30, 6, 0, 'Frostwolf Hut - Alliance assaulted'),
40 (30, 6, 1, 'Frostwolf Hut - ALliance control'),
41 (30, 6, 2, 'Frostwolf Hut - Horde assaulted'),
42 (30, 6, 3, 'Frostwolf Hut - Horde control'),
44 -- (30, 7, 0, 'Dunbaldar South - Alliance assaulted'),
45 (30, 7, 1, 'Dunbaldar South - ALliance control'),
46 (30, 7, 2, 'Dunbaldar South - Horde assaulted'),
47 (30, 7, 3, 'Dunbaldar South - Horde control'),
49 -- (30, 8, 0, 'Dunbaldar North - Alliance assaulted'),
50 (30, 8, 1, 'Dunbaldar North - ALliance control'),
51 (30, 8, 2, 'Dunbaldar North - Horde assaulted'),
52 (30, 8, 3, 'Dunbaldar North - Horde control'),
54 -- (30, 9, 0, 'Icewing Bunker - Alliance assaulted'),
55 (30, 9, 1, 'Icewing Bunker - ALliance control'),
56 (30, 9, 2, 'Icewing Bunker - Horde assaulted'),
57 (30, 9, 3, 'Icewing Bunker - Horde control'),
59 -- (30, 10, 0, 'Stoneheart Bunker - Alliance assaulted'),
60 (30, 10, 1, 'Stoneheart Bunker - ALliance control'),
61 (30, 10, 2, 'Stoneheart Bunker - Horde assaulted'),
62 (30, 10, 3, 'Stoneheart Bunker - Horde control'),
64 (30, 11, 0, 'Iceblood Tower - Alliance assaulted'),
65 (30, 11, 1, 'Iceblood Tower - ALliance control'),
66 -- (30, 11, 2, 'Iceblood Tower - Horde assaulted'),
67 (30, 11, 3, 'Iceblood Tower - Horde control'),
69 (30, 12, 0, 'Tower Point - Alliance assaulted'),
70 (30, 12, 1, 'Tower Point - ALliance control'),
71 -- (30, 12, 2, 'Tower Point - Horde assaulted'),
72 (30, 12, 3, 'Tower Point - Horde control'),
74 (30, 13, 0, 'Frostwolf east Tower - Alliance assaulted'),
75 (30, 13, 1, 'Frostwolf east Tower - ALliance control'),
76 -- (30, 13, 2, 'Frostwolf east Tower - Horde assaulted'),
77 (30, 13, 3, 'Frostwolf east Tower - Horde control'),
79 (30, 14, 0, 'Frostwolf west Tower - Alliance assaulted'),
80 (30, 14, 1, 'Frostwolf west Tower - ALliance control'),
81 -- (30, 14, 2, 'Frostwolf west Tower - Horde assaulted'),
82 (30, 14, 3, 'Frostwolf west Tower - Horde control'),
85 (30, 15, 0, 'Firstaid Station - Alliance Defender Quest0'),
86 (30, 15, 1, 'Firstaid Station - Alliance Defender Quest1'),
87 (30, 15, 2, 'Firstaid Station - Alliance Defender Quest2'),
88 (30, 15, 3, 'Firstaid Station - Alliance Defender Quest3'),
89 (30, 15, 4, 'Firstaid Station - Horde Defender Quest0'),
90 (30, 15, 5, 'Firstaid Station - Horde Defender Quest1'),
91 (30, 15, 6, 'Firstaid Station - Horde Defender Quest2'),
92 (30, 15, 7, 'Firstaid Station - Horde Defender Quest3'),
94 (30, 16, 0, 'Stormpike Grave - Alliance Defender Quest0'),
95 (30, 16, 1, 'Stormpike Grave - Alliance Defender Quest1'),
96 (30, 16, 2, 'Stormpike Grave - Alliance Defender Quest2'),
97 (30, 16, 3, 'Stormpike Grave - Alliance Defender Quest3'),
98 (30, 16, 4, 'Stormpike Grave - Horde Defender Quest0'),
99 (30, 16, 5, 'Stormpike Grave - Horde Defender Quest1'),
100 (30, 16, 6, 'Stormpike Grave - Horde Defender Quest2'),
101 (30, 16, 7, 'Stormpike Grave - Horde Defender Quest3'),
103 (30, 17, 0, 'Stoneheart Grave - Alliance Defender Quest0'),
104 (30, 17, 1, 'Stoneheart Grave - Alliance Defender Quest1'),
105 (30, 17, 2, 'Stoneheart Grave - Alliance Defender Quest2'),
106 (30, 17, 3, 'Stoneheart Grave - Alliance Defender Quest3'),
107 (30, 17, 4, 'Stoneheart Grave - Horde Defender Quest0'),
108 (30, 17, 5, 'Stoneheart Grave - Horde Defender Quest1'),
109 (30, 17, 6, 'Stoneheart Grave - Horde Defender Quest2'),
110 (30, 17, 7, 'Stoneheart Grave - Horde Defender Quest3'),
112 (30, 18, 0, 'Snowfall Grave - Alliance Defender Quest0'),
113 (30, 18, 1, 'Snowfall Grave - Alliance Defender Quest1'),
114 (30, 18, 2, 'Snowfall Grave - Alliance Defender Quest2'),
115 (30, 18, 3, 'Snowfall Grave - Alliance Defender Quest3'),
116 (30, 18, 4, 'Snowfall Grave - Horde Defender Quest0'),
117 (30, 18, 5, 'Snowfall Grave - Horde Defender Quest1'),
118 (30, 18, 6, 'Snowfall Grave - Horde Defender Quest2'),
119 (30, 18, 7, 'Snowfall Grave - Horde Defender Quest3'),
121 (30, 19, 0, 'Iceblood Grave - Alliance Defender Quest0'),
122 (30, 19, 1, 'Iceblood Grave - Alliance Defender Quest1'),
123 (30, 19, 2, 'Iceblood Grave - Alliance Defender Quest2'),
124 (30, 19, 3, 'Iceblood Grave - Alliance Defender Quest3'),
125 (30, 19, 4, 'Iceblood Grave - Horde Defender Quest0'),
126 (30, 19, 5, 'Iceblood Grave - Horde Defender Quest1'),
127 (30, 19, 6, 'Iceblood Grave - Horde Defender Quest2'),
128 (30, 19, 7, 'Iceblood Grave - Horde Defender Quest3'),
130 (30, 20, 0, 'Frostwolf Grave - Alliance Defender Quest0'),
131 (30, 20, 1, 'Frostwolf Grave - Alliance Defender Quest1'),
132 (30, 20, 2, 'Frostwolf Grave - Alliance Defender Quest2'),
133 (30, 20, 3, 'Frostwolf Grave - Alliance Defender Quest3'),
134 (30, 20, 4, 'Frostwolf Grave - Horde Defender Quest0'),
135 (30, 20, 5, 'Frostwolf Grave - Horde Defender Quest1'),
136 (30, 20, 6, 'Frostwolf Grave - Horde Defender Quest2'),
137 (30, 20, 7, 'Frostwolf Grave - Horde Defender Quest3'),
139 (30, 21, 0, 'Frostwolf Hut - Alliance Defender Quest0'),
140 (30, 21, 1, 'Frostwolf Hut - Alliance Defender Quest1'),
141 (30, 21, 2, 'Frostwolf Hut - Alliance Defender Quest2'),
142 (30, 21, 3, 'Frostwolf Hut - Alliance Defender Quest3'),
143 (30, 21, 4, 'Frostwolf Hut - Horde Defender Quest0'),
144 (30, 21, 5, 'Frostwolf Hut - Horde Defender Quest1'),
145 (30, 21, 6, 'Frostwolf Hut - Horde Defender Quest2'),
146 (30, 21, 7, 'Frostwolf Hut - Horde Defender Quest3'),
149 (30, 46, 0, 'North Mine - Alliance Boss'),
150 (30, 46, 1, 'North Mine - Horde Boss'),
151 (30, 46, 2, 'North Mine - Neutral Boss'),
152 (30, 47, 0, 'South Mine - Alliance Boss'),
153 (30, 47, 1, 'South Mine - Horde Boss'),
154 (30, 47, 2, 'South Mine - Neutral Boss'),
156 (30, 48, 0, 'Alliance Captain'),
157 (30, 49, 0, 'Horde Captain'),
159 (30, 50, 0, 'North Mine - Alliance Control'),
160 (30, 50, 1, 'North Mine - Horde Control'),
161 (30, 50, 2, 'North Mine - Neutral Control'),
162 (30, 51, 0, 'South Mine - Alliance Control'),
163 (30, 51, 1, 'South Mine - Horde Control'),
164 (30, 51, 2, 'South Mine - Neutral Control'),
166 (30, 52, 0, 'Alliance Marshal - Dunbaldar South'),
167 (30, 53, 0, 'Alliance Marshal - Dunbaldar North'),
168 (30, 54, 0, 'Alliance Marshal - Icewing Bunker'),
169 (30, 55, 0, 'Alliance Marshal - Stoneheart Bunker'),
171 (30, 56, 0, 'Horde Marshal - Iceblood Tower'),
172 (30, 57, 0, 'Horde Marshal - Towerpoint'),
173 (30, 58, 0, 'Horde Marshal - East Frostwolf Tower'),
174 (30, 59, 0, 'Horde Marshal - West Frostwolf Tower'),
176 (30, 60, 0, 'Herald - that guy who yells all the time ;)'),
178 (30, 61, 0, 'Alliance - Boss'),
179 (30, 62, 0, 'Horde - Boss'),
181 (30, 63, 0, 'Alliance - Captain Dead'),
182 (30, 64, 0, 'Horde - Captain Dead');