From 1e15c577eb53c1ef84c6a32e961673ed2318735d Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 2 Jul 2014 09:53:30 +0200 Subject: DB/Misc: Fix some runtime errors/incorrect triggers By dr-j --- sql/updates/world/2014_07_02_00_world_misc.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2014_07_02_00_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2014_07_02_00_world_misc.sql b/sql/updates/world/2014_07_02_00_world_misc.sql new file mode 100644 index 00000000000..03c2df0347d --- /dev/null +++ b/sql/updates/world/2014_07_02_00_world_misc.sql @@ -0,0 +1,5 @@ +-- +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=32790 AND `source_type`=0 AND `id`=1 AND `link`=2; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=30630 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- The below is also related to same quest for moonglade portal and return from moonglade portal same quest, these gained trigger flags resulting in the portals becoming non clickable. +UPDATE`creature_template` SET `flags_extra`=0 WHERE `entry`IN(32790,32788); -- cgit v1.2.3