From 577ae1f8e0aa520e5a673f06f9c408548471bbc9 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Sun, 22 Sep 2024 12:01:01 +0200 Subject: DB: fixed sql file name added in c10a57318c9cd3b6c22f18384656f9a04ad2a06b --- .../world/cata_classic/2024_09_22_00_world.sql | 19 +++++++++++++++++++ .../world/cata_classic/2924_09_22_00_world.sql | 19 ------------------- 2 files changed, 19 insertions(+), 19 deletions(-) create mode 100644 sql/updates/world/cata_classic/2024_09_22_00_world.sql delete mode 100644 sql/updates/world/cata_classic/2924_09_22_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/cata_classic/2024_09_22_00_world.sql b/sql/updates/world/cata_classic/2024_09_22_00_world.sql new file mode 100644 index 00000000000..4844e08c441 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_09_22_00_world.sql @@ -0,0 +1,19 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN +('spell_dru_wrath', +'spell_dru_starfire', +'spell_dru_starsurge', +'spell_dru_eclipse_solar', +'spell_dru_eclipse_lunar', +'spell_dru_eclipse_mastery_driver_passive'); + +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(5176, 'spell_dru_wrath'), +(2912, 'spell_dru_starfire'), +(78674, 'spell_dru_starsurge'), +(48517, 'spell_dru_eclipse_solar'), +(48518, 'spell_dru_eclipse_lunar'), +(79577, 'spell_dru_eclipse_mastery_driver_passive'); + +DELETE FROM `spell_proc` WHERE `SpellId`= 79577; +INSERT INTO `spell_proc` (`SpellId`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `SpellFamilyMask3`, `SpellTypeMask`, `SpellPhaseMask`) VALUES +(79577, 7, 0x1 | 0x4, 0x0, 0x2000000, 0x0, 0x1, 0x2); diff --git a/sql/updates/world/cata_classic/2924_09_22_00_world.sql b/sql/updates/world/cata_classic/2924_09_22_00_world.sql deleted file mode 100644 index 4844e08c441..00000000000 --- a/sql/updates/world/cata_classic/2924_09_22_00_world.sql +++ /dev/null @@ -1,19 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName` IN -('spell_dru_wrath', -'spell_dru_starfire', -'spell_dru_starsurge', -'spell_dru_eclipse_solar', -'spell_dru_eclipse_lunar', -'spell_dru_eclipse_mastery_driver_passive'); - -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(5176, 'spell_dru_wrath'), -(2912, 'spell_dru_starfire'), -(78674, 'spell_dru_starsurge'), -(48517, 'spell_dru_eclipse_solar'), -(48518, 'spell_dru_eclipse_lunar'), -(79577, 'spell_dru_eclipse_mastery_driver_passive'); - -DELETE FROM `spell_proc` WHERE `SpellId`= 79577; -INSERT INTO `spell_proc` (`SpellId`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `SpellFamilyMask3`, `SpellTypeMask`, `SpellPhaseMask`) VALUES -(79577, 7, 0x1 | 0x4, 0x0, 0x2000000, 0x0, 0x1, 0x2); -- cgit v1.2.3