From c26399a96804cf4231dd6ec2e6f4e3ec437aac64 Mon Sep 17 00:00:00 2001
From: Anubisss <none@none>
Date: Sun, 16 May 2010 16:53:56 +0200
Subject: Remove spell 23602 from spell_proc_event because it's triggered by
 the talent, so not need an entry in the table.

--HG--
branch : trunk
---
 sql/updates/8213_world_spell_proc_event.sql | 1 +
 sql/world.sql                               | 1 -
 2 files changed, 1 insertion(+), 1 deletion(-)
 create mode 100644 sql/updates/8213_world_spell_proc_event.sql

(limited to 'sql')

diff --git a/sql/updates/8213_world_spell_proc_event.sql b/sql/updates/8213_world_spell_proc_event.sql
new file mode 100644
index 00000000000..75c07b90223
--- /dev/null
+++ b/sql/updates/8213_world_spell_proc_event.sql
@@ -0,0 +1 @@
+DELETE FROM spell_proc_event WHERE entry = 23602;
diff --git a/sql/world.sql b/sql/world.sql
index f16d97b6f84..2c42e2658b8 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -6367,7 +6367,6 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
 ( 23572, 0x00,  11, 0x000000C0, 0x00000000, 0x00000000, 0x00000000, 0x00000000,   0,   0,   0), -- Mana Surge
 ( 23578, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,   2,   0,   0), -- Expose Weakness
 ( 23581, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,   2,   0,   0), -- Bloodfang
-( 23602, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000040,   0,   0,   0), -- Shield Specialization (Rank 1)
 ( 23686, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,   2,   0,   0), -- Lightning Strike
 ( 23688, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000,   0,   0,   0), -- Aura of the Blue Dragon
 ( 23689, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,   4,   0,   0), -- Heroism
-- 
cgit v1.2.3