aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2016-05-01 00:09:01 +0200
committerShauren <shauren.trinity@gmail.com>2016-05-01 00:09:01 +0200
commitd9f7692c2e1e647271f4b857a98f41236b9a8c34 (patch)
treec67f30f376135b612317a99a7edce7ae16b7fd1b /sql
parent0fbcddcb4f8fda8498faa76c7e7d92d9c7c1c3f8 (diff)
Core/Spells: Updated existing shaman spell scripts
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/6.x/2016_05_01_00_world.sql36
1 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_05_01_00_world.sql b/sql/updates/world/6.x/2016_05_01_00_world.sql
new file mode 100644
index 00000000000..b5af5b75596
--- /dev/null
+++ b/sql/updates/world/6.x/2016_05_01_00_world.sql
@@ -0,0 +1,36 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_ancestral_awakening';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_ancestral_awakening_proc';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_earthbind_totem';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_earthen_power';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_feedback';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_flame_shock';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_mana_tide_totem';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_rolling_thunder';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_telluric_currents';
+
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_flametongue';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_fulmination';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_healing_stream_totem';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_healing_stream_totem_heal';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_lava_lash_spread_flame_shock';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_lava_surge';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_nature_guardian';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_tidal_waves';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_windfury';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(10400,'spell_sha_flametongue'),
+(88766,'spell_sha_fulmination'),
+(5394,'spell_sha_healing_stream_totem'),
+(52042,'spell_sha_healing_stream_totem_heal'),
+(105792,'spell_sha_lava_lash_spread_flame_shock'),
+(77756,'spell_sha_lava_surge'),
+(30884,'spell_sha_nature_guardian'),
+(51564,'spell_sha_tidal_waves'),
+(33757,'spell_sha_windfury');
+
+DELETE FROM `spell_proc_event` WHERE `entry` IN (77756,88766,33757,10400);
+INSERT INTO `spell_proc_event` (`entry`,`procFlags`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`SpellFamilyMask3`) VALUES
+(77756,0x00040000,0x00000000,0x00000000,0x00000000,0x00000000),
+(88766,0x00000000,0x00000003,0x00001000,0x00000000,0x00000004),
+(33757,0x00400000,0x00000000,0x00000000,0x00000000,0x00000000),
+(10400,0x00800000,0x00000000,0x00000000,0x00000000,0x00000000);