diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-10-18 22:33:39 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-10-15 15:22:28 +0200 |
| commit | be1a3884bc4004406e87d9a89a7b5443c5490188 (patch) | |
| tree | 63e945cde417f6edb56c9b61f2c9836fdd4a5b11 /sql | |
| parent | 595bd609fce4d82e47dd9f1a6cb39c078219a2d0 (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.
(cherry picked from commit 489e5b60dbe2faeb3fc0c7f4c359d2e75a1c9472)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_10_15_02_world_2016_10_18_02_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_10_15_02_world_2016_10_18_02_world.sql b/sql/updates/world/master/2017_10_15_02_world_2016_10_18_02_world.sql new file mode 100644 index 00000000000..041f8dd60b6 --- /dev/null +++ b/sql/updates/world/master/2017_10_15_02_world_2016_10_18_02_world.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `quest_template_addon` WHERE `ID`=8312; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=23 AND `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"); |