Scripts/Ulduar: Fix Ignis' Slag Pot periodic ticks and enable achievement "Hot Pocket"

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2014_10_29_00_world.sql b/sql/updates/world/2014_10_29_00_world.sql
new file mode 100644
index 00000000000..f29b6745133
--- /dev/null
+++ b/sql/updates/world/2014_10_29_00_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;