aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2020-12-24 15:31:11 +0100
committerShauren <shauren.trinity@gmail.com>2020-12-24 15:55:30 +0100
commit041ceeed1a6c2a1f4418d348631fd051056ff5c0 (patch)
tree62b41a1583abe6f55e9744ee417da217a53b067f /sql
parentcafa00b5d09b56f3a4e4c4859ac0572a9341ca4b (diff)
Core/Spells: Ice Lance
* fixed secondary target damage with Splitting Ice talent * fixed dropping 2 charges of Fingers of Frost with Splitting Ice
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2020_12_24_01_world.sql13
-rw-r--r--sql/updates/world/master/9999_99_99_30455_world.sql3
2 files changed, 13 insertions, 3 deletions
diff --git a/sql/updates/world/master/2020_12_24_01_world.sql b/sql/updates/world/master/2020_12_24_01_world.sql
new file mode 100644
index 00000000000..5a9c83377f5
--- /dev/null
+++ b/sql/updates/world/master/2020_12_24_01_world.sql
@@ -0,0 +1,13 @@
+-- Fingers of Frost
+DELETE FROM `spell_proc` WHERE `SpellId`=44544;
+INSERT INTO `spell_proc` (`SpellId`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`SpellFamilyMask3`,`ProcFlags`,`SpellTypeMask`,`SpellPhaseMask`,`HitMask`,`AttributesMask`,`DisableEffectsMask`,`ProcsPerMinute`,`Chance`,`Cooldown`,`Charges`) VALUES
+(44544,0,3,0,0,0,0x100,0x10000,0,0x4,0x3FFF,0,0,0,100,0,0); -- PROC_FLAG_DONE_SPELL_MAGIC_DMG_CLASS_NEG; PROC_SPELL_PHASE_FINISH; PROC_HIT_MASK_ALL
+
+-- mage ice lance
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_fingers_of_frost';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_ice_lance';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_ice_lance_damage';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(44544,'spell_mage_fingers_of_frost'),
+(30455,'spell_mage_ice_lance'),
+(228598,'spell_mage_ice_lance_damage');
diff --git a/sql/updates/world/master/9999_99_99_30455_world.sql b/sql/updates/world/master/9999_99_99_30455_world.sql
deleted file mode 100644
index 3be259985a6..00000000000
--- a/sql/updates/world/master/9999_99_99_30455_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- mage ice lance
-DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_ice_lance';
-INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (30455, 'spell_mage_ice_lance');