From 489e5b60dbe2faeb3fc0c7f4c359d2e75a1c9472 Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Tue, 18 Oct 2016 22:33:39 +0200 Subject: DB/Quest: Hallow's End Treats for Spoops! should not be repeatable. Also the item Hallow's End Pumpkin Treat should only be available from vendor after turning in that quest. --- sql/updates/world/3.3.5/2016_10_18_02_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_10_18_02_world.sql diff --git a/sql/updates/world/3.3.5/2016_10_18_02_world.sql b/sql/updates/world/3.3.5/2016_10_18_02_world.sql new file mode 100644 index 00000000000..f0a9902846c --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_18_02_world.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `quest_template_addon` WHERE `ID`=8312; +DELETE FROM `conditions` WHERE `SourceGroup`=15354 AND `SourceEntry`=20557; +INSERT INTO `conditions` VALUES +(23, 15354, 20557, 0, 0, 8, 0, 8312, 0, 0, 0, 0, 0, "", "Item Hallow's End Pumpkin Treat sold by Rachelle Gothena requires quest Hallow's End Treats for Spoops! rewarded"); -- cgit v1.2.3