aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-06-22 21:22:28 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-06-22 21:22:28 +0200
commit288b016e317cde04e739879aff9ecbd3311957d9 (patch)
treedecf7c99c7673a9c4353feecdfd7307a2d5e87a2
parent74d57fa1c0e90847dc3232b95e4e037e7bc3ba61 (diff)
DB/Quest: The Story Thus Far...
By untaught, closes #11417
-rw-r--r--sql/updates/world/2014_06_22_06_world_misc.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_06_22_06_world_misc.sql b/sql/updates/world/2014_06_22_06_world_misc.sql
new file mode 100644
index 00000000000..207072a6989
--- /dev/null
+++ b/sql/updates/world/2014_06_22_06_world_misc.sql
@@ -0,0 +1,6 @@
+--
+UPDATE `creature_template` SET `npcflag`=`npcflag`|1 WHERE `entry`=29344;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9806;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15,9806,0,0,0,9,0,12807,0,0,0,0,0,'','Show gossip menu option only if player has quest(12807) ''The Story Thus Far...''');