From c66d3714f16d68edf57973e8bb4de295bfd81294 Mon Sep 17 00:00:00 2001 From: sirikfoll Date: Fri, 4 Mar 2016 20:45:28 +0100 Subject: Core/Scripts: Fixed Yogg-Saron Portals Closes #16390 Closes #16708 (cherry picked from commit c4e4ee3ae10b1276b214c8b1da1281aba23ae57a) --- sql/updates/world/2016_04_08_25_world_2016_03_04_03_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2016_04_08_25_world_2016_03_04_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/2016_04_08_25_world_2016_03_04_03_world.sql b/sql/updates/world/2016_04_08_25_world_2016_03_04_03_world.sql new file mode 100644 index 00000000000..4d148adde55 --- /dev/null +++ b/sql/updates/world/2016_04_08_25_world_2016_03_04_03_world.sql @@ -0,0 +1,4 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceEntry` IN (63989,63997,63998); +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=34072; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(34072, 51347, 3, 0); -- cgit v1.2.3