From aa768001a766cc25d3944bb80a80e4deb6c2c429 Mon Sep 17 00:00:00 2001 From: Shocker Date: Thu, 26 Aug 2010 05:53:52 +0300 Subject: Fix Item - Icecrown Dungeon Melee Trinket (Needle-Encrusted Scorpion), fixes issue #3599 --HG-- branch : trunk --- sql/base/world_database.sql | 3 ++- sql/updates/9595_world_spell_proc_event.sql | 3 +++ 2 files changed, 5 insertions(+), 1 deletion(-) create mode 100644 sql/updates/9595_world_spell_proc_event.sql (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 3ab2e377478..05ecfed7e10 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -7471,7 +7471,8 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam ( 71645, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Dislodged Foreign Object (Heroic) ( 72417, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 60), -- Item - Icecrown Reputation Ring Caster Trigger ( 72413, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 60), -- Item - Icecrown Reputation Ring Melee -( 72419, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 60); -- Item - Icecrown Reputation Ring Healer Trigger +( 72419, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 60), -- Item - Icecrown Reputation Ring Healer Trigger +( 71404, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 45); -- Item - Icecrown Dungeon Melee Trinket /*!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/9595_world_spell_proc_event.sql b/sql/updates/9595_world_spell_proc_event.sql new file mode 100644 index 00000000000..c4377433e48 --- /dev/null +++ b/sql/updates/9595_world_spell_proc_event.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE entry = 71404; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(71404, 0, 0, 0, 0, 0, 0, 2, 0, 0, 45); \ No newline at end of file -- cgit v1.2.3