From 848c10e581a45e962045827092e1bd68ef2c52f0 Mon Sep 17 00:00:00 2001
From: Nyeriah <sarah.trysan@live.com>
Date: Wed, 29 Oct 2014 21:58:16 -0200
Subject: Scripts/Ulduar: Fix Ignis' Slag Pot periodic ticks and enable
 achievement "Hot Pocket"

(cherry picked from commit 21820b425b0b573229f683a2d45b23d8a42c888d)
---
 sql/updates/world/2014_10_29_01_world.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sql/updates/world/2014_10_29_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/2014_10_29_01_world.sql b/sql/updates/world/2014_10_29_01_world.sql
new file mode 100644
index 00000000000..f29b6745133
--- /dev/null
+++ b/sql/updates/world/2014_10_29_01_world.sql
@@ -0,0 +1,7 @@
+-- Spell difficulty entry for Slag Pot Damage spell
+DELETE FROM `spelldifficulty_dbc` WHERE `id` = 65722;
+INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`, `spellid2`, `spellid3`) VALUES
+(65722, 65722, 65723, 0, 0);
+
+-- Clean up unneeded criteria data, enables achievement Hot Pocket
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (10430, 10431) AND `type` = 18;
-- 
cgit v1.2.3