Scripts/Spells: fixed mage Arcane Missiles

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_09_21_01_world.sql b/sql/updates/world/cata_classic/2024_09_21_01_world.sql
new file mode 100644
index 00000000000..067ef98ba22
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_09_21_01_world.sql
@@ -0,0 +1,9 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_mage_offensive_state_dnd', 'spell_mage_arcane_missiles');
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(79684, 'spell_mage_offensive_state_dnd'),
+(79683, 'spell_mage_arcane_missiles');
+
+DELETE FROM `spell_proc` WHERE `SpellId` IN (79684, 79683);
+INSERT INTO `spell_proc` (`SpellId`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellPhaseMask`, `Charges`) VALUES
+(79684, 3, 0x0, 0x1, 0),
+(79683, 3, 0x800, 0x1, 1);