From e9d963760c1f4be95e655ecd50f1c6aceecdc1dd Mon Sep 17 00:00:00 2001 From: Aqua Deus <95978183+aquadeus@users.noreply.github.com> Date: Fri, 19 Sep 2025 14:49:21 +0200 Subject: Scripts/Spells: Implement mage talent "Pyrotechnics" (#31254) --- sql/updates/world/master/2025_09_19_00_world.sql | 2 +- sql/updates/world/master/2025_09_19_01_world.sql | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/master/2025_09_19_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2025_09_19_00_world.sql b/sql/updates/world/master/2025_09_19_00_world.sql index bbd96bbd1f4..761d1f93686 100644 --- a/sql/updates/world/master/2025_09_19_00_world.sql +++ b/sql/updates/world/master/2025_09_19_00_world.sql @@ -6,5 +6,5 @@ INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES DELETE FROM `spell_proc` WHERE `SpellId` IN (44448,48108); INSERT INTO `spell_proc` (`SpellId`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`SpellFamilyMask3`,`ProcFlags`,`ProcFlags2`,`SpellTypeMask`,`SpellPhaseMask`,`HitMask`,`AttributesMask`,`DisableEffectsMask`,`ProcsPerMinute`,`Chance`,`Cooldown`,`Charges`) VALUES -(44448,0x04,3,0x00C00013,0x00100000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x2,0x0,0x0,0,0,0,0), -- Pyroblast Clearcasting Driver +(44448,0x04,3,0x00C00013,0x00100000,0x00000000,0x00000000,0x0,0x0,0x1,0x2,0x0,0x0,0x0,0,0,0,0), -- Pyroblast Clearcasting Driver (48108,0x00,3,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x4,0x0,0x0,0x0,0x8,0x0,0,0,0,1); -- Hot Streak! diff --git a/sql/updates/world/master/2025_09_19_01_world.sql b/sql/updates/world/master/2025_09_19_01_world.sql new file mode 100644 index 00000000000..1076d300f02 --- /dev/null +++ b/sql/updates/world/master/2025_09_19_01_world.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_proc` WHERE `SpellId` IN (157642); +INSERT INTO `spell_proc` (`SpellId`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`SpellFamilyMask3`,`ProcFlags`,`ProcFlags2`,`SpellTypeMask`,`SpellPhaseMask`,`HitMask`,`AttributesMask`,`DisableEffectsMask`,`ProcsPerMinute`,`Chance`,`Cooldown`,`Charges`) VALUES +(157642,0x0,3,0x00000001,0x00000000,0x00000000,0x00000000,0x0,0x0,0x0,0x2,0x0,0x0,0x0,0,0,0,0); -- Pyrotechnics + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mage_pyrotechnics'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(157642, 'spell_mage_pyrotechnics'); -- cgit v1.2.3