From 2562a4651f94e2dc40ccce108a2497c2c26bfff6 Mon Sep 17 00:00:00 2001
From: azazel <none@none>
Date: Fri, 6 Aug 2010 23:03:43 +0600
Subject: Moved Pain and Suffering (47948) script effect to spell script.

--HG--
branch : trunk
---
 sql/base/world_database.sql                   | 1 +
 sql/updates/9199_world_spell_script_names.sql | 2 ++
 2 files changed, 3 insertions(+)
 create mode 100644 sql/updates/9199_world_spell_script_names.sql

(limited to 'sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 8e769eb010e..656f1ead05c 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14731,6 +14731,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 31231, 'spell_rog_cheat_death'),
 ( 51662, 'spell_rog_hunger_for_blood'),
 -- priest
+( 47948, 'spell_pri_pain_and_suffering_proc'),
 (-47540, 'spell_pri_penance'),
 -- death knight
 -- shaman
diff --git a/sql/updates/9199_world_spell_script_names.sql b/sql/updates/9199_world_spell_script_names.sql
new file mode 100644
index 00000000000..0ba1b525fbc
--- /dev/null
+++ b/sql/updates/9199_world_spell_script_names.sql
@@ -0,0 +1,2 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=47948 AND `ScriptName`='spell_pri_pain_and_suffering_proc';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (47948, 'spell_pri_pain_and_suffering_proc');
\ No newline at end of file
-- 
cgit v1.2.3