aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-18 22:33:39 +0200
committerGitHub <noreply@github.com>2016-10-18 22:33:39 +0200
commit489e5b60dbe2faeb3fc0c7f4c359d2e75a1c9472 (patch)
treeb90fa2bf5a480a55e5b4ef113b2686a99866cdf7
parentf3dcdc4e647ef3e573c9e8892109dd36bc0b11f4 (diff)
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.
-rw-r--r--sql/updates/world/3.3.5/2016_10_18_02_world.sql5
1 files changed, 5 insertions, 0 deletions
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");