From dcc26dd801aa548794728a9a5b3b851f08f6809e Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Tue, 9 Nov 2010 11:26:01 +0100 Subject: Core/Spells: Fix Sword Specialization (warrior) proc on abilities Author: Dr.Tenma Fixes issue #4032 --HG-- branch : trunk --- sql/base/world_database.sql | 7 ++++++- sql/updates/10393_world_spell_proc_event.sql | 7 +++++++ 2 files changed, 13 insertions(+), 1 deletion(-) create mode 100644 sql/updates/10393_world_spell_proc_event.sql (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 5c6865b0ed0..716b4cfe12e 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -19378,7 +19378,12 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam ( 75474, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Charred Twilight Scale (Heroic) ( 75465, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Charred Twilight Scale ( 75457, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Sharpened Twilight Scale (Heroic) -( 75455, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45); -- Sharpened Twilight Scale +( 75455, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Sharpened Twilight Scale +( 12281, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 1) +( 12812, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 2) +( 12813, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 3) +( 12814, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 4) +( 12815, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6); -- Sword Specialization (Rank 5) /*!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/10393_world_spell_proc_event.sql b/sql/updates/10393_world_spell_proc_event.sql new file mode 100644 index 00000000000..11e9f7a184b --- /dev/null +++ b/sql/updates/10393_world_spell_proc_event.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (12281, 12812, 12813, 12814, 12815); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +( 12281, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 1) +( 12812, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 2) +( 12813, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 3) +( 12814, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 4) +( 12815, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6); -- Sword Specialization (Rank 5) \ No newline at end of file -- cgit v1.2.3