/
Spell.sql
209 lines (184 loc) · 43.8 KB
/
Spell.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
INSERT INTO spell_template(Id, Attributes, AttributesEx,AttributesEx2,AttributesEx3,ProcFlags,ProcChance,DurationIndex,Effect1,EffectImplicitTargetA1,EffectImplicitTargetB1,EffectRadiusIndex1,EffectApplyAuraName1,EffectMiscValue1,EffectMiscValueB1,EffectTriggerSpell1,IsServerSide,SpellName) VALUES
('11756','384','268435456','0','0','0','101','4','76','47','0','15','0','144064','0','0','1','Summon Gordunni chest (COBALT)'),
('17694','256','268435456','0','0','0','101','4','28','47','0','9','0','11296','61','0','1','Summon Darrowshire Poltergeist (DND)'),
('19394','384','268435456','0','0','0','101','4','76','47','0','15','0','177681','0','0','1','Summon Gordunni chest (JUNK)'),
('21387','320','268435456','0','0','40','15','21','6','1','0','0','42','0','0','21388','1','Melt-Weapon trigger aura related used by Ragnaros'),
('21883','384','268435456','0','0','0','101','225','76','22','0','0','0','178904','0','0','1','Summon Healed Celebrian Vine'),
('23363','256','0','0','0','0','101','21','76','18','0','0','0','179804','0','0','1','Summon Drakonid Corpse Trigger'),
('23408','256','8388864','0','0','0','101','5','76','32','0','15','0','179832','0','0','1','Drop Pillow DND'),
('23770','612368640','268435592','1','1048576','0','101','367','6','25','0','0','4','0','0','0','1','Sayge''s timer - Darkmoon Faire'),
('25192','256','0','4','0','0','101','21','76','18','0','0','0','180619','0','0','1','Summon Ossirian Crystal'),
('26096','8388864','0','1','0','0','101','21','76','32','0','7','0','180794','0','0','1','Jandice Drops Journal'),
('26133','256','0','0','0','0','101','21','76','18','0','0','0','180795','0','0','1','Summon Sandworm Base'),
('27627','256','0','0','0','0','101','21','76','32','0','14','0','181068','0','0','1','Drop Obsidian'),
('27630','256','0','0','0','0','101','21','76','32','0','14','0','181069','0','0','1','Drop Obsidian'),
('31338','384','0','0','0','0','101','3','28','32','0','8','0','18120','64','0','1','Summon Ogre'),
('33242','384','0','4','0','0','101','21','28','18','0','7','0','19259','64','0','1','summon Infernal Invader'),
('34810','0','0','0','0','0','101','21','28','42','0','8','0','20083','64','0','1','Summon Summoned Bloodwarder Mender behind of the caster'),
('34817','0','0','0','0','0','101','21','28','44','0','8','0','20078','64','0','1','Summon Summoned Bloodwarder Reservist right of the caster'),
('34818','0','0','0','0','0','101','21','28','43','0','8','0','20078','64','0','1','Summon Summoned Bloodwarder Reservist left of the caster'),
('34819','0','0','0','0','0','101','21','28','41','0','8','0','20078','64','0','1','Summon Summoned Bloodwarder Reservist front of the caster'),
('37264','384','0','4','0','0','101','21','28','18','0','7','0','21729','64','0','1','Power Converters: Summon Electromental (from cata)'),
('37278','384','0','4','0','0','101','21','28','18','0','1','0','21737','64','0','1','Power Converters: Summon Mini-Electromental (from cata)'),
('37365','384','0','4','0','0','101','21','28','18','0','1','0','21757','64','0','1','Power Converters: Summon Big Flavor Electromental (from cata)'),
('38854','384','0','0','0','0','101','3','28','18','0','0','0','22339','64','0','1','summon Redeemet Hatchling'),
('38865','384','0','0','0','0','101','3','28','18','0','0','0','22337','64','0','1','summon Malevolent Hatchling'),
('43388','150995328','32','0','268435456','0','0','0','0','0','0','0','0','0','0','0','1','Suicide, No Blood, No Logging'),
('44920','0','0','0','0','0','101','21','6','1','0','0','56','24941','0','0','1','Model - Shattered Sun Marksman - BE Male Tier 4'),
('44924','0','0','0','0','0','101','21','6','1','0','0','56','24945','0','0','1','Model - Shattered Sun Marksman - BE Female Tier 4'),
('44928','0','0','0','0','0','101','21','6','1','0','0','56','24949','0','0','1','Model - Shattered Sun Marksman - Draenei Male Tier 4'),
('44932','0','0','0','0','0','101','21','6','1','0','0','56','24953','0','0','1','Model - Shattered Sun Marksman - Draenei Female Tier 4'),
('45158','0','0','0','0','0','101','21','6','1','0','0','56','25119','0','0','1','Model - Shattered Sun Warrior - BE Female Tier 4'),
('45162','0','0','0','0','0','101','21','6','1','0','0','56','25123','0','0','1','Model - Shattered Sun Warrior - BE Male Tier 4'),
('45166','0','0','0','0','0','101','21','6','1','0','0','56','25127','0','0','1','Model - Shattered Sun Warrior - Draenei Female Tier 4'),
('45170','0','0','0','0','0','101','21','6','1','0','0','56','25131','0','0','1','Model - Shattered Sun Warrior - Draenei Male Tier 4'),
('50574','256','0','0','0','0','101','0','90','25','0','11','0','28042','0','0','1','Captain Brandon Kill Credit'),
('58630','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Mal''Ganis'),
('59046','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Tribunal of Ages'),
('59450','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - The Four Horsemen'),
('62388','0','0','0','0','0','101','21','6','1','0','0','4','0','0','0','1','Aura required for Demonic Circle 48020'),
('64899','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Hodir'),
('64985','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Thorim'),
('65074','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Freya'),
('65195','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Assembly of Iron'),
('68184','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Faction Champions'),
('68523','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Trial of the Crusader - Not One, But Two Jormungars'),
('68572','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Grand Champions'),
('68574','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Confessor Paletress'),
('68575','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Eadric the Pure'),
('68620','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Trial of the Crusader - Resilience Will Fix It'),
('72827','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Icecrown Citadel - Full House'),
('72845','8388992','0','5','0','0','101','37','6','22','7','28','4','0','0','0','1','Achievement check - Pit of Saron - Don''t Look Up');
INSERT INTO spell_template (Id, Attributes, AttributesEx, AttributesEx2, AttributesEx3, procFlags, procChance, DurationIndex, RangeIndex, Effect1, EffectImplicitTargetA1, EffectImplicitTargetB1, EffectRadiusIndex1, EffectApplyAuraName1, EffectMiscValue1, EffectMiscValueB1, EffectTriggerSpell1, SpellIconID, SpellName, DmgMultiplier1) VALUES
(38096, 384, 0, 9, 0, 0, 101, 21, 96, 6, 38, 0, 0, 4, 0, 0, 0, 1, '[DND]Destroy Sun Gate Portal Controller', 1);
-- To Legion Hold(q.10596) -H (q.10563) -A
INSERT INTO spell_template (Id, Attributes, AttributesEx, ProcChance, DurationIndex, Effect1, Effect2, EffectImplicitTargetA1,EffectApplyAuraName1,EffectMiscValue2,IsServerSide,SpellName) VALUES
('37492','384','268435456','101','3','6','61','1','12','13852','1','Crate Disguise Subspell');
-- trap used to tame bear is no longer present in TBC/WOTLK yet still present in trap data
INSERT INTO spell_template (Id, Attributes, CastingTimeIndex, ProcChance, SpellLevel, RangeIndex, EquippedItemClass, Effect1, EffectDieSides1, EffectBaseDice1, EffectImplicitTargetA1, SpellIconID, SpellName, MaxTargetLevel, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('9439', '256', '1', '101', '1', '12', '-1', '3', '1', '1', '38', '1', 'Bear Captured in Trap', '60', '1', '1', '1', '1');
-- Feed Captured Animal for q.9440 'Little Morsels' - prevent LOS from cage gameobjects
UPDATE spell_template SET AttributesEx2=AttributesEx2|4 WHERE id IN (29916, 29917);
-- generic proc double attack used in a lot of TBC instances based on sniffs
INSERT INTO spell_template (Id, Category, Attributes, CastingTimeIndex, ProcChance, BaseLevel, SpellLevel, RangeIndex, EquippedItemClass, Effect1, EffectDieSides1, EffectBaseDice1, EffectImplicitTargetA1, SpellIconID, SpellName, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('18941', '65', '262416', '1', '101', '14', '14', '1', '-1', '19', '1', '1', '1', '108', 'Double Attack', '2', '2', '1', '1', '1', '1');
-- Spells used in Ragnaros encounter
INSERT INTO `spell_template` (`Id`,`Attributes`,`CastingTimeIndex`,`ProcChance`,`DurationIndex`,`RangeIndex`,`EquippedItemClass`,`Effect1`,`EffectImplicitTargetA1`,`EffectRadiusIndex1`,`EffectMiscValue1`,`SpellIconID`,`SpellName`,`DmgMultiplier1`) VALUES
('21108','256','1','101','0','13','-1','3','0','16','0','876','Summon Sons of Flame','1'),
('21110','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame B','1'),
('21111','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame C','1'),
('21112','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame D','1'),
('21113','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame E','1'),
('21114','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame F','1'),
('21115','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame G','1'),
('21116','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame H','1'),
('21117','256','1','101','30','13','-1','28','17','16','12143','876','Summon Son of Flame A','1'),
('21908','256','1','101','0','1','-1','3','1','0','0','1','Lava Burst Randomizer','1');
-- ServerSide 'Fire Shield'
INSERT INTO spell_template (Id,Dispel,Attributes,CastingTimeIndex,ProcChance,BaseLevel,SpellLevel,DurationIndex,RangeIndex,EquippedItemClass,EquippedItemSubClassMask,Effect1,EffectDieSides1,EffectBaseDice1,EffectImplicitTargetA1,EffectApplyAuraName1,EffectAmplitude1,EffectTriggerSpell1,DmgMultiplier1,DmgMultiplier2,DmgMultiplier3,SchoolMask,IsServerSide,SpellName) VALUES
('13377','1','2512','1','101','40','40','21','1','-1','-1','6','1','1','21','23','3000','13376','1','1','1','2','1','Fire Shield');
-- ServerSide 'Hate to 90%'
INSERT INTO spell_template (Id,Attributes,CastingTimeIndex,ProcFlags,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectDieSides1,EffectImplicitTargetA1,EffectApplyAuraName1,EffectTriggerSpell1,DmgMultiplier1,DmgMultiplier2,DmgMultiplier3,SchoolMask,IsServerSide,SpellName) VALUES
('19195','464','1','20','100','21','1','-1','6','1','1','42','9204','1','1','1','1','1','Hate to 90%');
-- ServerSide 'Frenzy'
INSERT INTO spell_template (Id,AttributesEx2,AttributesEx3,CastingTimeIndex,ProcChance,BaseLevel,SpellLevel,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('19515','4','268435456','1','101','62','62','0','13','-1','3','38','1','1','1','Frenzy');
-- ServerSide 'Firesworn Eruption Trigger'
INSERT INTO spell_template (Id,Attributes, AttributesEx,CastingTimeIndex,ProcChance,BaseLevel,SpellLevel,DurationIndex,RangeIndex,EquippedItemClass,Effect1,Effect2,EffectDieSides1,EffectImplicitTargetA1,EffectImplicitTargetA2,EffectApplyAuraName1,EffectMiscValue1,EffectMiscValue2,DmgClass,PreventionType,DmgMultiplier1,DmgMultiplier2,SchoolMask,IsServerSide,SpellName) VALUES
('20482','128','268468224','1','101','62','62','21','13','-1','6','108','1','38','38','77','18','18','1','1','1','1','1','1','Firesworn Eruption Trigger');
-- ServerSide 'Immunity'
INSERT INTO spell_template (Id,Attributes, AttributesEx, AttributesEx2, CastingTimeIndex,ProcChance,BaseLevel,SpellLevel,DurationIndex,RangeIndex,StackAmount,EquippedItemClass,Effect1,Effect2,EffectDieSides1,EffectBaseDice1,EffectImplicitTargetA1,EffectImplicitTargetA2,EffectImplicitTargetB1,EffectImplicitTargetB2,EffectRadiusIndex1,EffectRadiusIndex2,EffectApplyAuraName1,EffectApplyAuraName2,EffectMiscValue1,EffectMiscValue2,DmgClass,PreventionType,DmgMultiplier1,DmgMultiplier2,SchoolMask,IsServerSide,SpellName) VALUES
('21087','256','268468360','4','1','101','62','62','30','1','10','-1','6','6','1','5','22','22','7','7','12','12','77','38','17','5','1','1','1','1','1','1','Immunity');
-- ServerSide 'Summon Lava Burst A'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21886','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst A');
-- ServerSide 'Summon Lava Burst B'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21900','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst B');
-- ServerSide 'Summon Lava Burst C'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21901','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst C');
-- ServerSide 'Summon Lava Burst D'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21902','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst D');
-- ServerSide 'Summon Lava Burst E'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21903','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst E');
-- ServerSide 'Summon Lava Burst F'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21904','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst F');
-- ServerSide 'Summon Lava Burst G'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21905','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst G');
-- ServerSide 'Summon Lava Burst H'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21906','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst H');
-- ServerSide 'Summon Lava Burst I'
INSERT INTO spell_template (Id,AttributesEx2,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectImplicitTargetA1,EffectMiscValue1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('21907','4','1','101','27','13','-1','76','17','178088','1','1','1','Summon Lava Burst I');
-- ServerSide 'Spawn Vekniss Hatchlings'
INSERT INTO spell_template (Id,Attributes,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectDieSides1,EffectBaseDice1,EffectImplicitTargetA1,EffectRadiusIndex1,EffectMiscValue1,EffectMiscValueB1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('26630','256','1','101','25','1','-1','28','1','3','17','15','15962','64','1','1','1','Spawn Vekniss Hatchlings');
-- ServerSide 'Spawn Vekniss Hatchlings'
INSERT INTO spell_template (Id,Attributes,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectDieSides1,EffectBaseDice1,EffectImplicitTargetA1,EffectRadiusIndex1,EffectMiscValue1,EffectMiscValueB1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('26631','256','1','101','25','1','-1','28','1','3','17','15','15962','64','1','1','1','Spawn Vekniss Hatchlings');
-- ServerSide 'Spawn Vekniss Hatchlings'
INSERT INTO spell_template (Id,Attributes,CastingTimeIndex,ProcChance,DurationIndex,RangeIndex,EquippedItemClass,Effect1,EffectDieSides1,EffectBaseDice1,EffectImplicitTargetA1,EffectRadiusIndex1,EffectMiscValue1,EffectMiscValueB1,DmgMultiplier1,SchoolMask,IsServerSide,SpellName) VALUES
('26632','256','1','101','25','1','-1','28','1','3','17','15','15962','64','1','1','1','Spawn Vekniss Hatchlings');
-- Note: Changing effect is 99.99999% of the time not supposed to be done.
-- Reason why in this case its done, is because the spell is a Party aura, with no radius and single target target, and also not exhibiting any party area aura behaviour on retail suggesting wrong data
-- in case someone finds evidence to disprove this claim message Killerwife
UPDATE spell_template SET Effect1=6 WHERE id IN(46012);
-- add removed serverside spell
INSERT INTO spell_template(Id, SchoolMask, Category, Dispel, Mechanic, Attributes, AttributesEx, AttributesEx2, AttributesEx3, AttributesEx4, Stances, StancesNot, Targets, TargetCreatureType, RequiresSpellFocus, CasterAuraState, TargetAuraState, CastingTimeIndex, RecoveryTime, CategoryRecoveryTime, InterruptFlags, AuraInterruptFlags, ChannelInterruptFlags, ProcFlags, ProcChance, ProcCharges, MaxLevel, BaseLevel, SpellLevel, DurationIndex, PowerType, ManaCost, ManaCostPerlevel, ManaPerSecond, ManaPerSecondPerLevel, RangeIndex, Speed, StackAmount, Totem1, Totem2, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, EquippedItemClass, EquippedItemSubClassMask, EquippedItemInventoryTypeMask, Effect1, Effect2, Effect3, EffectDieSides1, EffectDieSides2, EffectDieSides3, EffectBaseDice1, EffectBaseDice2, EffectBaseDice3, EffectRealPointsPerLevel1, EffectRealPointsPerLevel2, EffectRealPointsPerLevel3, EffectMechanic1, EffectMechanic2, EffectMechanic3, EffectImplicitTargetA1, EffectImplicitTargetA2, EffectImplicitTargetA3, EffectImplicitTargetB1, EffectImplicitTargetB2, EffectImplicitTargetB3, EffectRadiusIndex1, EffectRadiusIndex2, EffectRadiusIndex3, EffectApplyAuraName1, EffectApplyAuraName2, EffectApplyAuraName3, EffectAmplitude1, EffectAmplitude2, EffectAmplitude3, EffectMultipleValue1, EffectMultipleValue2, EffectMultipleValue3, EffectChainTarget1, EffectChainTarget2, EffectChainTarget3, EffectItemType1, EffectItemType2, EffectItemType3, EffectMiscValue1, EffectMiscValue2, EffectMiscValue3, EffectTriggerSpell1, EffectTriggerSpell2, EffectTriggerSpell3, EffectPointsPerComboPoint1, EffectPointsPerComboPoint2, EffectPointsPerComboPoint3, SpellVisual, SpellIconID, ActiveIconID, SpellPriority, SpellName, SpellName2, SpellName3, SpellName4, SpellName5, SpellName6, SpellName7, SpellName8, Rank, Rank2, Rank3, Rank4, Rank5, Rank6, Rank7, Rank8, ManaCostPercentage, StartRecoveryCategory, StartRecoveryTime, MaxTargetLevel, SpellFamilyName, SpellFamilyFlags, MaxAffectedTargets, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('25676', '32','0', '0', '0', '536871168', '136', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '13', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '77', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0','0', '0', '0', '22', '0', '0', '15', '0', '0', '12', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'Drain Mana', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0');
-- missing dummy
INSERT INTO spell_template(Id,Attributes,rangeIndex,Effect1,EffectImplicitTargetA1,EffectRadiusIndex1,SpellIconID,SpellName,DmgMultiplier1) VALUES
(30023,384,1,3,1,16,1,'Periodic Trigger Dummy',1);
-- Missing vanilla dummy
INSERT INTO spell_template(Id, Category, Dispel, Mechanic, Attributes, AttributesEx, AttributesEx2, AttributesEx3, AttributesEx4, Stances, StancesNot, Targets, TargetCreatureType, RequiresSpellFocus, CasterAuraState, TargetAuraState, CastingTimeIndex, RecoveryTime, CategoryRecoveryTime, InterruptFlags, AuraInterruptFlags, ChannelInterruptFlags, ProcFlags, ProcChance, ProcCharges, MaxLevel, BaseLevel, SpellLevel, DurationIndex, PowerType, ManaCost, ManaCostPerlevel, ManaPerSecond, ManaPerSecondPerLevel, RangeIndex, Speed, StackAmount, Totem1, Totem2, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, EquippedItemClass, EquippedItemSubClassMask, EquippedItemInventoryTypeMask, Effect1, Effect2, Effect3, EffectDieSides1, EffectDieSides2, EffectDieSides3, EffectBaseDice1, EffectBaseDice2, EffectBaseDice3, EffectRealPointsPerLevel1, EffectRealPointsPerLevel2, EffectRealPointsPerLevel3, EffectMechanic1, EffectMechanic2, EffectMechanic3, EffectImplicitTargetA1, EffectImplicitTargetA2, EffectImplicitTargetA3, EffectImplicitTargetB1, EffectImplicitTargetB2, EffectImplicitTargetB3, EffectRadiusIndex1, EffectRadiusIndex2, EffectRadiusIndex3, EffectApplyAuraName1, EffectApplyAuraName2, EffectApplyAuraName3, EffectAmplitude1, EffectAmplitude2, EffectAmplitude3, EffectMultipleValue1, EffectMultipleValue2, EffectMultipleValue3, EffectChainTarget1, EffectChainTarget2, EffectChainTarget3, EffectItemType1, EffectItemType2, EffectItemType3, EffectMiscValue1, EffectMiscValue2, EffectMiscValue3, EffectTriggerSpell1, EffectTriggerSpell2, EffectTriggerSpell3, EffectPointsPerComboPoint1, EffectPointsPerComboPoint2, EffectPointsPerComboPoint3, SpellVisual, SpellIconID, ActiveIconID, SpellPriority, SpellName, SpellName2, SpellName3, SpellName4, SpellName5, SpellName6, SpellName7, SpellName8, Rank, Rank2, Rank3, Rank4, Rank5, Rank6, Rank7, Rank8, ManaCostPercentage, StartRecoveryCategory, StartRecoveryTime, MaxTargetLevel, SpellFamilyName, SpellFamilyFlags, MaxAffectedTargets, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('24019', '0', '0', '0', '256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '22', '0', '0', '15', '0', '0', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1474', '0', '0', 'Axe Flurry', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0');
-- Removes aura interrupt flag by sitting for spells that do not make a creature sit, all seem to be copypasted for unknown reasons
UPDATE spell_template SET AuraInterruptFlags=AuraInterruptFlags&~0x00040000 WHERE Id IN(6606,14915,16093,46765);
-- Mechano-Lord Capacitus - summon spells
INSERT INTO spell_template(Id,SchoolMask,Attributes,AttributesEx,AttributesEx3,AttributesEx4,DurationIndex,rangeIndex,Effect1,EffectDieSides1,EffectBaseDice1,EffectImplicitTargetA1,EffectRadiusIndex1,EffectMiscValue1,EffectMiscValueB1,SpellIconID,SpellName,DmgMultiplier1,DmgMultiplier2) VALUES
(35153,32,384,136,512,128,18,1,28,1,1,41,13,20405,64,143,'Summon Nether Charge NE',1,1),
(35904,32,384,136,512,128,18,1,28,1,1,44,13,20405,64,143,'Summon Nether Charge NW',1,1),
(35905,32,384,136,512,128,18,1,28,1,1,42,13,20405,64,143,'Summon Nether Charge SE',1,1),
(35906,32,384,136,512,128,18,1,28,1,1,43,13,20405,64,143,'Summon Nether Charge SW',1,1);
-- missing vanilla spell used in scripts
INSERT INTO spell_template(Id, Category, Dispel, Mechanic, Attributes, AttributesEx, AttributesEx2, AttributesEx3, AttributesEx4, Stances, StancesNot, Targets, TargetCreatureType, RequiresSpellFocus, CasterAuraState, TargetAuraState, CastingTimeIndex, RecoveryTime, CategoryRecoveryTime, InterruptFlags, AuraInterruptFlags, ChannelInterruptFlags, ProcFlags, ProcChance, ProcCharges, MaxLevel, BaseLevel, SpellLevel, DurationIndex, PowerType, ManaCost, ManaCostPerlevel, ManaPerSecond, ManaPerSecondPerLevel, RangeIndex, Speed, StackAmount, Totem1, Totem2, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, EquippedItemClass, EquippedItemSubClassMask, EquippedItemInventoryTypeMask, Effect1, Effect2, Effect3, EffectDieSides1, EffectDieSides2, EffectDieSides3, EffectBaseDice1, EffectBaseDice2, EffectBaseDice3, EffectRealPointsPerLevel1, EffectRealPointsPerLevel2, EffectRealPointsPerLevel3, EffectMechanic1, EffectMechanic2, EffectMechanic3, EffectImplicitTargetA1, EffectImplicitTargetA2, EffectImplicitTargetA3, EffectImplicitTargetB1, EffectImplicitTargetB2, EffectImplicitTargetB3, EffectRadiusIndex1, EffectRadiusIndex2, EffectRadiusIndex3, EffectApplyAuraName1, EffectApplyAuraName2, EffectApplyAuraName3, EffectAmplitude1, EffectAmplitude2, EffectAmplitude3, EffectMultipleValue1, EffectMultipleValue2, EffectMultipleValue3, EffectChainTarget1, EffectChainTarget2, EffectChainTarget3, EffectItemType1, EffectItemType2, EffectItemType3, EffectMiscValue1, EffectMiscValue2, EffectMiscValue3, EffectTriggerSpell1, EffectTriggerSpell2, EffectTriggerSpell3, EffectPointsPerComboPoint1, EffectPointsPerComboPoint2, EffectPointsPerComboPoint3, SpellVisual, SpellIconID, ActiveIconID, SpellPriority, SpellName, SpellName2, SpellName3, SpellName4, SpellName5, SpellName6, SpellName7, SpellName8, Rank, Rank2, Rank3, Rank4, Rank5, Rank6, Rank7, Rank8, ManaCostPercentage, StartRecoveryCategory, StartRecoveryTime, MaxTargetLevel, SpellFamilyName, SpellFamilyFlags, MaxAffectedTargets, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('24087', '0', '0', '0', '256', '268435456', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '18', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '23', '0', '0', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '24086', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'Growth', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO spell_template(Id, Category, Dispel, Mechanic, Attributes, AttributesEx, AttributesEx2, AttributesEx3, AttributesEx4, Stances, StancesNot, Targets, TargetCreatureType, RequiresSpellFocus, CasterAuraState, TargetAuraState, CastingTimeIndex, RecoveryTime, CategoryRecoveryTime, InterruptFlags, AuraInterruptFlags, ChannelInterruptFlags, ProcFlags, ProcChance, ProcCharges, MaxLevel, BaseLevel, SpellLevel, DurationIndex, PowerType, ManaCost, ManaCostPerlevel, ManaPerSecond, ManaPerSecondPerLevel, RangeIndex, Speed, StackAmount, Totem1, Totem2, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, EquippedItemClass, EquippedItemSubClassMask, EquippedItemInventoryTypeMask, Effect1, Effect2, Effect3, EffectDieSides1, EffectDieSides2, EffectDieSides3, EffectBaseDice1, EffectBaseDice2, EffectBaseDice3, EffectRealPointsPerLevel1, EffectRealPointsPerLevel2, EffectRealPointsPerLevel3, EffectMechanic1, EffectMechanic2, EffectMechanic3, EffectImplicitTargetA1, EffectImplicitTargetA2, EffectImplicitTargetA3, EffectImplicitTargetB1, EffectImplicitTargetB2, EffectImplicitTargetB3, EffectRadiusIndex1, EffectRadiusIndex2, EffectRadiusIndex3, EffectApplyAuraName1, EffectApplyAuraName2, EffectApplyAuraName3, EffectAmplitude1, EffectAmplitude2, EffectAmplitude3, EffectMultipleValue1, EffectMultipleValue2, EffectMultipleValue3, EffectChainTarget1, EffectChainTarget2, EffectChainTarget3, EffectItemType1, EffectItemType2, EffectItemType3, EffectMiscValue1, EffectMiscValue2, EffectMiscValue3, EffectTriggerSpell1, EffectTriggerSpell2, EffectTriggerSpell3, EffectPointsPerComboPoint1, EffectPointsPerComboPoint2, EffectPointsPerComboPoint3, SpellVisual, SpellIconID, ActiveIconID, SpellPriority, SpellName, SpellName2, SpellName3, SpellName4, SpellName5, SpellName6, SpellName7, SpellName8, Rank, Rank2, Rank3, Rank4, Rank5, Rank6, Rank7, Rank8, ManaCostPercentage, StartRecoveryCategory, StartRecoveryTime, MaxTargetLevel, SpellFamilyName, SpellFamilyFlags, MaxAffectedTargets, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('24086', '0', '0', '0', '256', '268435456', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '225', '0', '0', '0', '0', '0', '1', '0', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '6', '0', '1', '1', '0', '24', '24', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '79', '61', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'Growth', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0'),
('26404', '0', '0', '0', '142606592', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '38', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'Despawn Tent Port', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0'),
('29327', '0', '0', '0', '320', '268435456', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '21', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '23', '0', '0', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '29328', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'Sapphiron\'s Wing Buffet', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0');
-- Missing Elemental Shield spell from Classic (BWL)
INSERT INTO `spell_template` (`Id`, `Attributes`, `AttributesEx`, `AttributesEx3`, `AttributesEx4`, `CastingTimeIndex`, `ProcChance`, `DurationIndex`, `rangeIndex`, `Effect1`, `EffectDieSides1`, `EffectBaseDice1`, `EffectImplicitTargetA1`, `EffectRadiusIndex1`, `EffectMiscValue1`, `SpellIconID`, `SpellName`, `DmgMultiplier1`, `DmgMultiplier2`) VALUES
(22276, 272, 0, 0, 0, 1, 101, 0, 1, 3, 1, 1, 1, 0, 0, 459, 'Elemental Shield', 1, 0);
-- spell from classic - needed for proper script
INSERT INTO spell_template(Id, Category, Dispel, Mechanic, Attributes, AttributesEx, AttributesEx2, AttributesEx3, AttributesEx4, Stances, StancesNot, Targets, TargetCreatureType, RequiresSpellFocus, CasterAuraState, TargetAuraState, CastingTimeIndex, RecoveryTime, CategoryRecoveryTime, InterruptFlags, AuraInterruptFlags, ChannelInterruptFlags, procFlags, procChance, procCharges, maxLevel, baseLevel, spellLevel, DurationIndex, powerType, manaCost, manaCostPerlevel, manaPerSecond, manaPerSecondPerLevel, rangeIndex, speed, StackAmount, Totem1, Totem2, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, EquippedItemClass, EquippedItemSubClassMask, EquippedItemInventoryTypeMask, Effect1, Effect2, Effect3, EffectDieSides1, EffectDieSides2, EffectDieSides3, EffectBaseDice1, EffectBaseDice2, EffectBaseDice3, EffectRealPointsPerLevel1, EffectRealPointsPerLevel2, EffectRealPointsPerLevel3, EffectMechanic1, EffectMechanic2, EffectMechanic3, EffectImplicitTargetA1, EffectImplicitTargetA2, EffectImplicitTargetA3, EffectImplicitTargetB1, EffectImplicitTargetB2, EffectImplicitTargetB3, EffectRadiusIndex1, EffectRadiusIndex2, EffectRadiusIndex3, EffectApplyAuraName1, EffectApplyAuraName2, EffectApplyAuraName3, EffectAmplitude1, EffectAmplitude2, EffectAmplitude3, EffectMultipleValue1, EffectMultipleValue2, EffectMultipleValue3, EffectChainTarget1, EffectChainTarget2, EffectChainTarget3, EffectItemType1, EffectItemType2, EffectItemType3, EffectMiscValue1, EffectMiscValue2, EffectMiscValue3, EffectTriggerSpell1, EffectTriggerSpell2, EffectTriggerSpell3, EffectPointsPerComboPoint1, EffectPointsPerComboPoint2, EffectPointsPerComboPoint3, SpellVisual, SpellIconID, activeIconID, spellPriority, SpellName, SpellName2, SpellName3, SpellName4, SpellName5, SpellName6, SpellName7, SpellName8, Rank, Rank2, Rank3, Rank4, Rank5, Rank6, Rank7, Rank8, ManaCostPercentage, StartRecoveryCategory, StartRecoveryTime, MaxTargetLevel, SpellFamilyName, SpellFamilyFlags, MaxAffectedTargets, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('21914', '0', '0', '0', '256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'Celebras Quit Escort', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0');
-- Songflower Serenade should not work on targets above level 63
UPDATE spell_template SET MaxTargetLevel=63 WHERE id IN(15366);
-- Watchkeeper Gargolmar - Mortal Wound should stack to 50/100%
UPDATE `spell_template` SET `StackAmount` = 10 WHERE `id` IN (30641, 36814);
-- Add spells used in Vanilla scripts and 28874 used on netherspite
INSERT INTO spell_template(Id, Category, Dispel, Mechanic, Attributes, AttributesEx, AttributesEx2, AttributesEx3, AttributesEx4, Stances, StancesNot, Targets, TargetCreatureType, RequiresSpellFocus, CasterAuraState, TargetAuraState, CastingTimeIndex, RecoveryTime, CategoryRecoveryTime, InterruptFlags, AuraInterruptFlags, ChannelInterruptFlags, ProcFlags, ProcChance, ProcCharges, MaxLevel, BaseLevel, SpellLevel, DurationIndex, PowerType, ManaCost, ManaCostPerlevel, ManaPerSecond, ManaPerSecondPerLevel, RangeIndex, Speed, StackAmount, Totem1, Totem2, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, EquippedItemClass, EquippedItemSubClassMask, EquippedItemInventoryTypeMask, Effect1, Effect2, Effect3, EffectDieSides1, EffectDieSides2, EffectDieSides3, EffectBaseDice1, EffectBaseDice2, EffectBaseDice3, EffectRealPointsPerLevel1, EffectRealPointsPerLevel2, EffectRealPointsPerLevel3, EffectMechanic1, EffectMechanic2, EffectMechanic3, EffectImplicitTargetA1, EffectImplicitTargetA2, EffectImplicitTargetA3, EffectImplicitTargetB1, EffectImplicitTargetB2, EffectImplicitTargetB3, EffectRadiusIndex1, EffectRadiusIndex2, EffectRadiusIndex3, EffectApplyAuraName1, EffectApplyAuraName2, EffectApplyAuraName3, EffectAmplitude1, EffectAmplitude2, EffectAmplitude3, EffectMultipleValue1, EffectMultipleValue2, EffectMultipleValue3, EffectChainTarget1, EffectChainTarget2, EffectChainTarget3, EffectItemType1, EffectItemType2, EffectItemType3, EffectMiscValue1, EffectMiscValue2, EffectMiscValue3, EffectTriggerSpell1, EffectTriggerSpell2, EffectTriggerSpell3, EffectPointsPerComboPoint1, EffectPointsPerComboPoint2, EffectPointsPerComboPoint3, SpellVisual, SpellIconID, ActiveIconID, SpellPriority, SpellName, SpellName2, SpellName3, SpellName4, SpellName5, SpellName6, SpellName7, SpellName8, Rank, Rank2, Rank3, Rank4, Rank5, Rank6, Rank7, Rank8, ManaCostPercentage, StartRecoveryCategory, StartRecoveryTime, MaxTargetLevel, SpellFamilyName, SpellFamilyFlags, MaxAffectedTargets, DmgClass, PreventionType, DmgMultiplier1, DmgMultiplier2, DmgMultiplier3, IsServerSide) VALUES
('5302', '0', '0', '0', '536871312', '1024', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', 'Defensive State', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '0'),
('22282', '0', '0', '0', '400', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '3', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '458', '0', '0', 'Brood Power', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0'),
('22283', '0', '0', '0', '400', '136', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '20', '40', '0', '0', '0', '0', '21', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '42', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '22284', '0', '0', '0', '0', '0', '0', '458', '0', '0', 'Brood Power: Red', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0'),
('22285', '0', '0', '0', '400', '136', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '20', '40', '0', '0', '0', '0', '21', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '42', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '22290', '0', '0', '0', '0', '0', '0', '458', '0', '0', 'Brood Power: Blue', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0'),
('22286', '0', '0', '0', '400', '136', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '20', '40', '0', '0', '0', '0', '21', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '42', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '22291', '0', '0', '0', '0', '0', '0', '458', '0', '0', 'Brood Power: Bronze', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0'),
('22287', '0', '0', '0', '400', '136', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '20', '40', '0', '0', '0', '0', '21', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '42', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '22312', '0', '0', '0', '0', '0', '0', '458', '0', '0', 'Brood Power: Black', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0'),
('22288', '0', '0', '0', '400', '136', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '20', '40', '0', '0', '0', '0', '21', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '42', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '22289', '0', '0', '0', '0', '0', '0', '458', '0', '0', 'Brood Power: Green', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0'),
('28874', '0', '0', '0', '384', '268435456', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '101', '0', '0', '0', '0', '21', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '6', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '23', '0', '0', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28865', '0', '0', '0', '0', '0', '0', '1', '0', '0', 'Consumption', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0');
-- Fumping summoning spells
INSERT INTO spell_template(Id, Attributes, DurationIndex,rangeIndex,Effect1,EffectDieSides1,EffectBaseDice1,EffectImplicitTargetA1,EffectRadiusIndex1,EffectMiscValue1,EffectMiscValueB1,SpellIconID,SpellName,DmgMultiplier1,DmgMultiplier2,DmgMultiplier3) VALUES
(39240,384,4,3,28,0,0,18,29,22483,64,1,'Summon Sand Gnome',1,1,1),
(39241,384,4,3,28,0,0,18,29,22482,64,1,'Summon Mature Bone Sifter',1,1,1),
(39245,384,4,3,28,2,1,18,29,22482,64,1,'Summon Mature Bone Sifter',1,1,1),
(39247,384,4,3,28,2,1,18,29,22483,64,1,'Summon Sand Gnome',1,1,1);
-- Stonescythe Whelp serverside
INSERT INTO spell_template(Id,Attributes,AttributesEx,baseLevel,spellLevel,DurationIndex,rangeIndex,Effect2,Effect3,EffectImplicitTargetA2,EffectImplicitTargetA3,EffectApplyAuraName2,EffectApplyAuraName3,SpellIconID,spellPriority,SpellName,StartRecoveryCategory,DmgClass,PreventionType,DmgMultiplier1,DmgMultiplier2,DmgMultiplier3) VALUES
(33897,67109248,268435456,20,20,21,5,6,6,1,1,60,26,2153,50,'Desperate Defense',133,1,1,1,1,1); -- tooltip Rooted. Not attacking.