aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-07-02 09:53:30 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-07-02 09:53:30 +0200
commit1e15c577eb53c1ef84c6a32e961673ed2318735d (patch)
treeb1e8aa6e1c954f32b3edf0490a2092ba94d0425d /sql
parent22113d1626ce475b03de3854d27969179e5ec897 (diff)
DB/Misc: Fix some runtime errors/incorrect triggers
By dr-j
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_07_02_00_world_misc.sql5
1 files changed, 5 insertions, 0 deletions
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);