aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-09-29 19:24:24 +0200
committerGitHub <noreply@github.com>2016-09-29 19:24:24 +0200
commit5441f2a3be6b9dda7804e4a8cfa380d393db828b (patch)
tree1d04db9336c03d41bfc014477c9aea36d852387a
parente1bafd62a76d83c841006265a0fe08b7e5e66eb7 (diff)
DB/Creature: Botanist Taerix:
- Fix gossip text depending on quest 'What Must Be Done...' completion status. - Correct chaining for the same quest.
-rw-r--r--sql/updates/world/3.3.5/2016_09_29_00_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_09_29_00_world.sql b/sql/updates/world/3.3.5/2016_09_29_00_world.sql
new file mode 100644
index 00000000000..2be21762492
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_09_29_00_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7304;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14, 7304, 8666, 0, 0, 8, 0, 9293, 0, 0, 0, 0, 0, "", "Show text 8666 if player has quest 'What Must Be Done...' rewarded");
+
+UPDATE `quest_template` SET `RewardNextQuest`=9294 WHERE `ID`=9293;