aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorTeleqraph <nyrdeveloper@gmail.com>2023-08-10 22:49:19 +0200
committerGitHub <noreply@github.com>2023-08-10 22:49:19 +0200
commitfa9ffc912187ee5f104ba8f2b04e89fc1f0f5fd4 (patch)
tree898c27da8b46e18a76bc89efa77903ec0fb2808d /sql/updates
parent6e42596374ef7e530055fcdba82a63cb6ffb311e (diff)
Scripts/Spells: Implement Epiphany and update Prayer of Mending's related talents (#29169)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2023_08_10_01_world.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_08_10_01_world.sql b/sql/updates/world/master/2023_08_10_01_world.sql
new file mode 100644
index 00000000000..7e0f6e5e7c1
--- /dev/null
+++ b/sql/updates/world/master/2023_08_10_01_world.sql
@@ -0,0 +1,15 @@
+DELETE FROM `spell_proc` WHERE `SpellId` IN (414553, 409479);
+INSERT INTO `spell_proc` (`SpellId`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`SpellFamilyMask3`,`ProcFlags`,`ProcFlags2`,`SpellTypeMask`,`SpellPhaseMask`,`HitMask`,`AttributesMask`,`DisableEffectsMask`,`ProcsPerMinute`,`Chance`,`Cooldown`,`Charges`) VALUES
+(414553,0x00,6,0x10200400,0x00000000,0x00000020,0x00000000,0x0,0x0,0x3,0x2,0x403,0x0,0x0,0,0,0,0), -- Epiphany
+(409479,0x00,6,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x0,0x0,0x0,0x8,0x0,0,0,0,1); -- Inspired Word
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_pri_prayer_of_mending_heal', 'spell_pri_benediction', 'spell_pri_divine_service', 'spell_pri_focused_mending',
+'spell_pri_epiphany', 'spell_pri_holy_10_1_class_set_2pc_chooser', 'spell_pri_holy_10_1_class_set_4pc', 'spell_pri_holy_10_1_class_set_4pc_aura');
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(33110, 'spell_pri_benediction'), -- Benediction
+(33110, 'spell_pri_divine_service'), -- Divine Service
+(33110, 'spell_pri_focused_mending'), -- Focused Mending
+(414553, 'spell_pri_epiphany'), -- Epiphany
+(411097, 'spell_pri_holy_10_1_class_set_2pc_chooser'), -- Priest Holy 10.1 Class Set 2pc (Chooser)
+(155793, 'spell_pri_holy_10_1_class_set_4pc'), -- Priest Holy 10.1 Class Set 4pc
+(41635, 'spell_pri_holy_10_1_class_set_4pc_aura'); -- Priest Holy 10.1 Class Set 4pc