From fd07b66887e3a99ab7eeca9d00df12e57750558b Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Wed, 7 Jan 2009 11:41:53 -0600
Subject: *Mangos [7042] Fixed typo in
 SpellMgr::GetSpellAllowedInLocationError. This should fix problems with
 flasks and elixirs using. By Turk3y. *Mangos [7043] Remove not need code. By
 DiSlord. *Mangos [7044] Fix some priest spell (48110, 48111, 48112, 48113)
 crash. By DiSlord.

--HG--
branch : trunk
---
 sql/updates/7044_01_mangos_spell_proc_event.sql | 17 +++++++++++++++++
 sql/updates/TBC-WLK_world.sql                   |  4 ++++
 2 files changed, 21 insertions(+)
 create mode 100644 sql/updates/7044_01_mangos_spell_proc_event.sql

(limited to 'sql')

diff --git a/sql/updates/7044_01_mangos_spell_proc_event.sql b/sql/updates/7044_01_mangos_spell_proc_event.sql
new file mode 100644
index 00000000000..576d5611aef
--- /dev/null
+++ b/sql/updates/7044_01_mangos_spell_proc_event.sql
@@ -0,0 +1,17 @@
+ALTER TABLE db_version CHANGE COLUMN required_7040_01_mangos_achievement_reward required_7044_01_mangos_spell_proc_event bit;
+
+-- (48110) Prayer of Mending (Rank 2)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (48110);
+INSERT INTO `spell_proc_event` VALUES (48110, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000, 0);
+
+-- (48112) Prayer of Mending (Rank 2)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (48112);
+INSERT INTO `spell_proc_event` VALUES (48112, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000, 0);
+
+-- (48111) Prayer of Mending (Rank 3)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (48111);
+INSERT INTO `spell_proc_event` VALUES (48111, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000, 0);
+
+-- (48113) Prayer of Mending (Rank 3)
+DELETE FROM `spell_proc_event` WHERE `entry` IN (48113);
+INSERT INTO `spell_proc_event` VALUES (48113, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000, 0); 
\ No newline at end of file
diff --git a/sql/updates/TBC-WLK_world.sql b/sql/updates/TBC-WLK_world.sql
index 6a549ed4132..c60b4a02cb5 100644
--- a/sql/updates/TBC-WLK_world.sql
+++ b/sql/updates/TBC-WLK_world.sql
@@ -6751,6 +6751,10 @@ INSERT INTO `spell_proc_event` VALUES
 (47580, 0x00000000,  6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
 (47581, 0x00000000,  6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
 (47582, 0x00000000,  6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
+(48110, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000,  0),
+(48111, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000,  0),
+(48112, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000,  0),
+(48113, 0x00000000,  0, 0x00000000, 0x00000000, 0x00000000, 0x000A02A8, 0x00000000, 0.000000, 0.000000,  0),
 (48159, 0x00000000,  6, 0x00002000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
 (48160, 0x00000000,  6, 0x00002000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
 (48483, 0x00000000,  7, 0x00008800, 0x00000440, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000,  0),
-- 
cgit v1.2.3