From 951d0f579480773f4f9f2c9dca8ec0a97ac680a2 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 11 Jun 2016 18:58:48 +0200 Subject: DB/Quest: Earth Sapta By tkrokli Closes #17334 --- sql/updates/world/3.3.5/2016_06_11_09_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_06_11_09_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2016_06_11_09_world.sql b/sql/updates/world/3.3.5/2016_06_11_09_world.sql new file mode 100644 index 00000000000..71368bfb9c2 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_06_11_09_world.sql @@ -0,0 +1,7 @@ +-- +UPDATE `quest_template_addon` SET `SpecialFlags`=1 WHERE `id`=1463; +DELETE FROM `conditions` WHERE `SourceEntry`=1463 AND `SourceTypeOrReferenceId` IN (20, 19) AND `ConditionTypeOrReference` IN (2); +INSERT INTO `conditions` VALUES +(19, 0, 1463, 0, 0, 2, 0, 6635, 1, 1, 1, 0, 0, "", "Show quest 'Earth Sapta' only if the item 'earth-sapta' is not in player's bags or bank"), +(20, 0, 1463, 0, 0, 2, 0, 6635, 1, 1, 1, 0, 0, "", "Show question mark for quest 'Earth Sapta' only if the item 'earth-sapta' is not in player's bags or bank"); +UPDATE `quest_request_items` SET `CompletionText`="I give you one in good faith. You already proved yourself once, but me tinkin' you should be more careful in the future." WHERE `ID`= 1463; -- cgit v1.2.3