aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-01-07 11:41:53 -0600
committermegamage <none@none>2009-01-07 11:41:53 -0600
commitfd07b66887e3a99ab7eeca9d00df12e57750558b (patch)
treea85d6100d3e33181978064c2505c928da543e9c9 /sql
parentcaac00a2ab437e8fcfa642614d0de75cf398819c (diff)
*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
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/7044_01_mangos_spell_proc_event.sql17
-rw-r--r--sql/updates/TBC-WLK_world.sql4
2 files changed, 21 insertions, 0 deletions
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),