· 8 years ago · Aug 07, 2018, 09:32 AM
1diff --git a/sql/mangos.sql b/sql/mangos.sql
2index 5e23a6e..9a12159 100644
3--- a/sql/mangos.sql
4+++ b/sql/mangos.sql
5@@ -14846,7 +14846,7 @@ CREATE TABLE `spell_chain` (
6
7 LOCK TABLES `spell_chain` WRITE;
8 /*!40000 ALTER TABLE `spell_chain` DISABLE KEYS */;
9-INSERT INTO spell_chain VALUES
10+INSERT INTO `spell_chain` VALUES
11 -- ------------------
12 -- (0) Not associated with skills
13 -- ------------------
14@@ -14954,7 +14954,7 @@ INSERT INTO spell_chain VALUES
15 (42198,42213,42208,7,0),
16 (42937,42198,42208,8,0),
17 (42938,42937,42208,9,0),
18-/* ConeofCold */
19+/* Cone of Cold */
20 (120,0,120,1,0),
21 (8492,120,120,2,0),
22 (10159,8492,120,3,0),
23@@ -14963,18 +14963,18 @@ INSERT INTO spell_chain VALUES
24 (27087,10161,120,6,0),
25 (42930,27087,120,7,0),
26 (42931,42930,120,8,0),
27-/* FrostArmor */
28+/* Frost Armor */
29 (168,0,168,1,0),
30 (7300,168,168,2,0),
31 (7301,7300,168,3,0),
32-/* FrostNova */
33+/* Frost Nova */
34 (122,0,122,1,0),
35 (865,122,122,2,0),
36 (6131,865,122,3,0),
37 (10230,6131,122,4,0),
38 (27088,10230,122,5,0),
39 (42917,27088,122,6,0),
40-/* FrostWard */
41+/* Frost Ward */
42 (6143,0,6143,1,0),
43 (8461,6143,6143,2,0),
44 (8462,8461,6143,3,0),
45@@ -14999,14 +14999,14 @@ INSERT INTO spell_chain VALUES
46 (38697,27072,116,14,0),
47 (42841,38697,116,15,0),
48 (42842,42841,116,16,0),
49-/* IceArmor */
50+/* Ice Armor */
51 (7302,0,7302,1,0),
52 (7320,7302,7302,2,0),
53 (10219,7320,7302,3,0),
54 (10220,10219,7302,4,0),
55 (27124,10220,7302,5,0),
56 (43008,27124,7302,6,0),
57-/* IceBarrier */
58+/* Ice Barrier */
59 (11426,0,11426,1,0),
60 (13031,11426,11426,2,0),
61 (13032,13031,11426,3,0),
62@@ -15015,14 +15015,14 @@ INSERT INTO spell_chain VALUES
63 (33405,27134,11426,6,0),
64 (43038,33405,11426,7,0),
65 (43039,43038,11426,8,0),
66-/* IceLance */
67+/* Ice Lance */
68 (30455,0,30455,1,0),
69 (42913,30455,30455,2,0),
70 (42914,42913,30455,3,0),
71 -- ------------------
72 -- (8)Fire
73 -- ------------------
74-/*Blast Wave*/
75+/* Blast Wave */
76 (11113,0,11113,1,0),
77 (13018,11113,11113,2,0),
78 (13019,13018,11113,3,0),
79@@ -15146,7 +15146,7 @@ INSERT INTO spell_chain VALUES
80 (20190,20043,20043,2,0),
81 (27045,20190,20043,3,0),
82 (49071,27045,20043,4,0),
83-/* MendPet */
84+/* Mend Pet */
85 (136,0,136,1,0),
86 (3111,136,136,2,0),
87 (3661,3111,136,3,0),
88@@ -15164,7 +15164,7 @@ INSERT INTO spell_chain VALUES
89 -- ------------------
90 -- (51)Survival
91 -- ------------------
92-/*Black Arrow*/
93+/* Black Arrow */
94 (3674,0,3674,1,0),
95 (63668,3674,3674,2,0),
96 (63669,63668,3674,3,0),
97@@ -15456,7 +15456,7 @@ INSERT INTO spell_chain VALUES
98 (32996,32379,32379,2,0),
99 (48157,32996,32379,3,0),
100 (48158,48157,32379,4,0),
101-/* ShadowWord:Pain */
102+/* Shadow Word: Pain */
103 (589,0,589,1,0),
104 (594,589,589,2,0),
105 (970,594,589,3,0),
106@@ -15532,7 +15532,7 @@ INSERT INTO spell_chain VALUES
107 (27016,25295,1978,10,0),
108 (49000,27016,1978,11,0),
109 (49001,49000,1978,12,0),
110-/* SteadyShot */
111+/* Steady Shot */
112 (56641,0,56641,1,0),
113 (34120,56641,56641,2,0),
114 (49051,34120,56641,3,0),
115@@ -15577,7 +15577,7 @@ INSERT INTO spell_chain VALUES
116 -- ------------------
117 -- (184) Retribution (Paladin)
118 -- ------------------
119-/* Blessingof Might */
120+/* Blessing of Might */
121 (19740,0,19740,1,0),
122 (19834,19740,19740,2,0),
123 (19835,19834,19740,3,0),
124@@ -15701,10 +15701,10 @@ INSERT INTO spell_chain VALUES
125 (10054,10053,759,4,0),
126 (27101,10054,759,5,0),
127 (42985,27101,759,6,0),
128-/* ConjureRefreshment */
129+/* Conjure Refreshment */
130 (42955,0,42955,1,0),
131 (42956,42955,42955,2,0),
132-/* ConjureWater */
133+/* Conjure Water */
134 (5504,0,5504,1,0),
135 (5505,5504,5504,2,0),
136 (5506,5505,5504,3,0),
137@@ -15718,7 +15718,7 @@ INSERT INTO spell_chain VALUES
138 (61024,0,61024,1,27126),
139 /* Dalaran Brilliance */
140 (61316,0,61316,1,27127),
141-/* DampenMagic */
142+/* Dampen Magic */
143 (604,0,604,1,0),
144 (8450,604,604,2,0),
145 (8451,8450,604,3,0),
146@@ -15726,14 +15726,14 @@ INSERT INTO spell_chain VALUES
147 (10174,10173,604,5,0),
148 (33944,10174,604,6,0),
149 (43015,33944,604,7,0),
150-/* MageArmor */
151+/* Mage Armor */
152 (6117,0,6117,1,0),
153 (22782,6117,6117,2,0),
154 (22783,22782,6117,3,0),
155 (27125,22783,6117,4,0),
156 (43023,27125,6117,5,0),
157 (43024,43023,6117,6,0),
158-/* ManaShield */
159+/* Mana Shield */
160 (1463,0,1463,1,0),
161 (8494,1463,1463,2,0),
162 (8495,8494,1463,3,0),
163@@ -15748,13 +15748,13 @@ INSERT INTO spell_chain VALUES
164 (12824,118,118,2,0),
165 (12825,12824,118,3,0),
166 (12826,12825,118,4,0),
167-/* RitualofRefreshment */
168+/* Ritual of Refreshment */
169 (43987,0,43987,1,0),
170 (58659,43987,43987,2,0),
171 -- ------------------
172 -- (267) Protection (Paladin)
173 -- ------------------
174-/* Avenger'sShield */
175+/* Avenger's Shield */
176 (31935,0,31935,1,0),
177 (32699,31935,31935,2,0),
178 (32700,32699,31935,3,0),
179@@ -15766,12 +15766,12 @@ INSERT INTO spell_chain VALUES
180 /* Greater Blessing of Sanctuary */
181 (20911,0,20911,1,0),
182 (25899,20911,20911,2,0),
183-/* HammerofJustice */
184+/* Hammer of Justice */
185 (853,0,853,1,0),
186 (5588,853,853,2,0),
187 (5589,5588,853,3,0),
188 (10308,5589,853,4,0),
189-/* HandofProtection */
190+/* Hand of Protection */
191 (1022,0,1022,1,0),
192 (5599,1022,1022,2,0),
193 (10278,5599,1022,3,0),
194@@ -15791,7 +15791,7 @@ INSERT INTO spell_chain VALUES
195 /* Banish */
196 (710,0,710,1,0),
197 (18647,710,710,2,0),
198-/* CreateFirestone */
199+/* Create Firestone */
200 (6366,0,6366,1,0),
201 (17951,6366,6366,2,0),
202 (17952,17951,6366,3,0),
203@@ -15799,7 +15799,7 @@ INSERT INTO spell_chain VALUES
204 (27250,17953,6366,5,0),
205 (60219,27250,6366,6,0),
206 (60220,60219,6366,7,0),
207-/* CreateHealthstone */
208+/* Create Healthstone */
209 (6201,0,6201,1,0),
210 (6202,6201,6201,2,0),
211 (5699,6202,6201,3,0),
212@@ -15808,7 +15808,7 @@ INSERT INTO spell_chain VALUES
213 (27230,11730,6201,6,0),
214 (47871,27230,6201,7,0),
215 (47878,47871,6201,8,0),
216-/* CreateSoulstone */
217+/* Create Soulstone */
218 (693,0,693,1,0),
219 (20752,693,693,2,0),
220 (20755,20752,693,3,0),
221@@ -15816,14 +15816,14 @@ INSERT INTO spell_chain VALUES
222 (20757,20756,693,5,0),
223 (27238,20757,693,6,0),
224 (47884,27238,693,7,0),
225-/* CreateSpellstone */
226+/* Create Spellstone */
227 (2362,0,2362,1,0),
228 (17727,2362,2362,2,0),
229 (17728,17727,2362,3,0),
230 (28172,17728,2362,4,0),
231 (47886,28172,2362,5,0),
232 (47888,47886,2362,6,0),
233-/* DemonArmor */
234+/* Demon Armor */
235 (706,0,706,1,0),
236 (1086,706,706,2,0),
237 (11733,1086,706,3,0),
238@@ -15832,20 +15832,20 @@ INSERT INTO spell_chain VALUES
239 (27260,11735,706,6,0),
240 (47793,27260,706,7,0),
241 (47889,47793,706,8,0),
242-/* DemonSkin */
243+/* Demon Skin */
244 (687,0,687,1,0),
245 (696,687,687,2,0),
246-/* EnslaveDemon */
247+/* Enslave Demon */
248 (1098,0,1098,1,0),
249 (11725,1098,1098,2,0),
250 (11726,11725,1098,3,0),
251 (61191,11726,1098,4,0),
252-/* FelArmor */
253+/* Fel Armor */
254 (28176,0,28176,1,0),
255 (28189,28176,28176,2,0),
256 (47892,28189,28176,3,0),
257 (47893,47892,28176,4,0),
258-/* HealthFunnel */
259+/* Health Funnel */
260 (755,0,755,1,0),
261 (3698,755,755,2,0),
262 (3699,3698,755,3,0),
263@@ -15855,10 +15855,10 @@ INSERT INTO spell_chain VALUES
264 (11695,11694,755,7,0),
265 (27259,11695,755,8,0),
266 (47856,27259,755,9,0),
267-/* RitualofSouls */
268+/* Ritual of Souls */
269 (29893,0,29893,1,0),
270 (58887,29893,29893,2,0),
271-/* ShadowWard */
272+/* Shadow Ward */
273 (6229,0,6229,1,0),
274 (11739,6229,6229,2,0),
275 (11740,11739,6229,3,0),
276@@ -15913,7 +15913,7 @@ INSERT INTO spell_chain VALUES
277 (30909,27224,702,8,0),
278 (50511,30909,702,9,0),
279 /* Dark Pact */
280-(18220,0, 18220,1,0),
281+(18220,0,18220,1,0),
282 (18937,18220,18220,2,0),
283 (18938,18937,18220,3,0),
284 (27265,18938,18220,4,0),
285@@ -16076,7 +16076,7 @@ INSERT INTO spell_chain VALUES
286 (25528,25361,8075,6,0),
287 (57622,25528,8075,7,0),
288 (58643,57622,8075,8,0),
289-/* WindfuryWeapon */
290+/* Windfury Weapon */
291 (8232,0,8232,1,0),
292 (8235,8232,8232,2,0),
293 (10486,8235,8232,3,0),
294@@ -16088,7 +16088,7 @@ INSERT INTO spell_chain VALUES
295 -- ------------------
296 -- (374) Restoration (Shaman)
297 -- ------------------
298-/* AncestralSpirit */
299+/* Ancestral Spirit */
300 (2008,0,2008,1,0),
301 (20609,2008,2008,2,0),
302 (20610,20609,2008,3,0),
303@@ -16096,7 +16096,7 @@ INSERT INTO spell_chain VALUES
304 (20777,20776,2008,5,0),
305 (25590,20777,2008,6,0),
306 (49277,25590,2008,7,0),
307-/* ChainHeal */
308+/* Chain Heal */
309 (1064,0,1064,1,0),
310 (10622,1064,1064,2,0),
311 (10623,10622,1064,3,0),
312@@ -16104,20 +16104,20 @@ INSERT INTO spell_chain VALUES
313 (25423,25422,1064,5,0),
314 (55458,25423,1064,6,0),
315 (55459,55458,1064,7,0),
316-/* EarthShield */
317+/* Earth Shield */
318 (974,0,974,1,0),
319 (32593,974,974,2,0),
320 (32594,32593,974,3,0),
321 (49283,32594,974,4,0),
322 (49284,49283,974,5,0),
323-/* EarthlivingWeapon */
324+/* Earthliving Weapon */
325 (51730,0,51730,1,0),
326 (51988,51730,51730,2,0),
327 (51991,51988,51730,3,0),
328 (51992,51991,51730,4,0),
329 (51993,51992,51730,5,0),
330 (51994,51993,51730,6,0),
331-/* HealingStreamTotem */
332+/* Healing Stream Totem */
333 (5394,0,5394,1,0),
334 (6375,5394,5394,2,0),
335 (6377,6375,5394,3,0),
336@@ -16127,7 +16127,7 @@ INSERT INTO spell_chain VALUES
337 (58755,25567,5394,7,0),
338 (58756,58755,5394,8,0),
339 (58757,58756,5394,9,0),
340-/* HealingWave */
341+/* Healing Wave */
342 (331,0,331,1,0),
343 (332,331,331,2,0),
344 (547,332,331,3,0),
345@@ -16142,7 +16142,7 @@ INSERT INTO spell_chain VALUES
346 (25396,25391,331,12,0),
347 (49272,25396,331,13,0),
348 (49273,49272,331,14,0),
349-/* LesserHealingWave */
350+/* Lesser Healing Wave */
351 (8004,0,8004,1,0),
352 (8008,8004,8004,2,0),
353 (8010,8008,8004,3,0),
354@@ -16291,12 +16291,12 @@ INSERT INTO spell_chain VALUES
355 -- ------------------
356 -- (573)Restoration
357 -- ------------------
358-/* GiftoftheWild */
359+/* Gift of the Wild */
360 (21849,0,21849,1,0),
361 (21850,21849,21849,2,0),
362 (26991,21850,21849,3,0),
363 (48470,26991,21849,4,0),
364-/* HealingTouch */
365+/* Healing Touch */
366 (5185,0,5185,1,0),
367 (5186,5185,5185,2,0),
368 (5187,5186,5185,3,0),
369@@ -16316,7 +16316,7 @@ INSERT INTO spell_chain VALUES
370 (33763,0,33763,1,0),
371 (48450,33763,33763,2,0),
372 (48451,48450,33763,3,0),
373-/* MarkoftheWild */
374+/* Mark of the Wild */
375 (1126,0,1126,1,0),
376 (5232,1126,1126,2,0),
377 (6756,5232,1126,3,0),
378@@ -16395,7 +16395,7 @@ INSERT INTO spell_chain VALUES
379 -- ------------------
380 -- (574)Balance
381 -- ------------------
382-/* EntanglingRoots */
383+/* Entangling Roots */
384 (339,0,339,1,0),
385 (1062,339,339,2,0),
386 (5195,1062,339,3,0),
387@@ -16404,7 +16404,7 @@ INSERT INTO spell_chain VALUES
388 (9853,9852,339,6,0),
389 (26989,9853,339,7,0),
390 (53308,26989,339,8,0),
391-/* Nature'sGrasp */
392+/* Nature's Grasp */
393 (16689,0,16689,1,339),
394 (16810,16689,16689,2,1062),
395 (16811,16810,16689,3,5195),
396@@ -16615,7 +16615,7 @@ INSERT INTO spell_chain VALUES
397 (30414,30413,30283,3,0),
398 (47846,30414,30283,4,0),
399 (47847,47846,30283,5,0),
400-/* SoulFire */
401+/* Soul Fire */
402 (6353,0,6353,1,0),
403 (17924,6353,6353,2,0),
404 (27211,17924,6353,3,0),
405@@ -16725,10 +16725,10 @@ INSERT INTO spell_chain VALUES
406 -- ------------------
407 -- (613)Discipline
408 -- ------------------
409-/* DispelMagic */
410+/* Dispel Magic*/
411 (527,0,527,1,0),
412 (988,527,527,2,0),
413-/* DivineSpirit */
414+/* Divine Spirit */
415 (14752,0,14752,1,0),
416 (14818,14752,14752,2,0),
417 (14819,14818,14752,3,0),
418@@ -16760,7 +16760,7 @@ INSERT INTO spell_chain VALUES
419 (52983,47750,47750,2,0),
420 (52984,52983,47750,3,0),
421 (52985,52984,47750,4,0),
422-/* PowerWord:Fortitude */
423+/* Power Word: Fortitude */
424 (1243,0,1243,1,0),
425 (1244,1243,1243,2,0),
426 (1245,1244,1243,3,0),
427@@ -16769,7 +16769,7 @@ INSERT INTO spell_chain VALUES
428 (10938,10937,1243,6,0),
429 (25389,10938,1243,7,0),
430 (48161,25389,1243,8,0),
431-/* PowerWord:Shield */
432+/* Power Word: Shield */
433 (17,0,17,1,0),
434 (592,17,17,2,0),
435 (600,592,17,3,0),
436@@ -16784,7 +16784,7 @@ INSERT INTO spell_chain VALUES
437 (25218,25217,17,12,0),
438 (48065,25218,17,13,0),
439 (48066,48065,17,14,0),
440-/* PrayerofFortitude */
441+/* Prayer of Fortitude */
442 (21562,0,21562,1,0),
443 (21564,21562,21562,2,0),
444 (25392,21564,21562,3,0),
445@@ -16793,7 +16793,7 @@ INSERT INTO spell_chain VALUES
446 (27681,14752,14752,2,0),
447 (32999,27681,14752,3,0),
448 (48074,32999,14752,4,0),
449-/* ShackleUndead */
450+/* Shackle Undead */
451 (9484,0,9484,1,0),
452 (9485,9484,9484,2,0),
453 (10955,9485,9484,3,0),
454@@ -16809,7 +16809,7 @@ INSERT INTO spell_chain VALUES
455 -- ------------------
456 -- (771)Frost
457 -- ------------------
458-/* HornofWinter */
459+/* Horn of Winter */
460 (57330,0,57330,1,0),
461 (57623,57330,57330,2,0),
462 /* Howling Blast */
463@@ -17123,6 +17123,7 @@ UNLOCK TABLES;
464 --
465 -- Table structure for table `spell_proc_event`
466 --
467+
468 DROP TABLE IF EXISTS `spell_proc_event`;
469 CREATE TABLE `spell_proc_event` (
470 `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',