From 3f9ac8bad204ad184c91b56f2fb45ee09ef774e5 Mon Sep 17 00:00:00 2001 From: offl Date: Wed, 16 Sep 2020 15:54:08 +0300 Subject: DB/Conditions: Make gossip options & texts visible if quest is taken or completed Previously condition CONDITION_QUESTTAKEN (9) was used (checks if quest is taken but NOT completed) while Blizzard always checks only if quest is taken. As result player can see gossip options and texts even if quest is completed but not yet rewarded Please use CONDITION_QUESTSTATE (47) with ConditionValue2 = 10 (taken or completed) in future to make gossip options or texts visible only if quest is taken --- sql/updates/world/3.3.5/2020_09_16_01_world.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_09_16_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_09_16_01_world.sql b/sql/updates/world/3.3.5/2020_09_16_01_world.sql new file mode 100644 index 00000000000..b3fb7124acc --- /dev/null +++ b/sql/updates/world/3.3.5/2020_09_16_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `conditions` SET `ConditionTypeOrReference` = 47, `ConditionValue2` = 10 WHERE `SourceTypeOrReferenceId` IN (14,15) AND `ConditionTypeOrReference` = 9; -- cgit v1.2.3