aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorsirikfoll <sirikfoll@hotmail.com>2016-03-04 20:45:28 +0100
committerjoschiwald <joschiwald.trinity@gmail.com>2016-03-04 20:45:28 +0100
commitc4e4ee3ae10b1276b214c8b1da1281aba23ae57a (patch)
treea667b59c67a4262d7ec012bc5ff3ba5f7e37457a /sql/updates
parentf46a0e7eb3ba362b5ae6f84d569b84d30173818c (diff)
Core/Scripts: Fixed Yogg-Saron Portals
Closes #16390 Closes #16708
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2016_03_04_03_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2016_03_04_03_world.sql b/sql/updates/world/2016_03_04_03_world.sql
new file mode 100644
index 00000000000..4d148adde55
--- /dev/null
+++ b/sql/updates/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);