aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShocker <none@none>2010-08-26 05:53:52 +0300
committerShocker <none@none>2010-08-26 05:53:52 +0300
commitaa768001a766cc25d3944bb80a80e4deb6c2c429 (patch)
tree817344166c011b9f10160fb8e22ebcef826570ff
parent89eb544bd802a390e62c437c818cf3d214c95aa9 (diff)
Fix Item - Icecrown Dungeon Melee Trinket (Needle-Encrusted Scorpion), fixes issue #3599
--HG-- branch : trunk
-rw-r--r--sql/base/world_database.sql3
-rw-r--r--sql/updates/9595_world_spell_proc_event.sql3
2 files changed, 5 insertions, 1 deletions
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