diff options
| author | offl <offl@users.noreply.github.com> | 2020-09-16 15:54:08 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-09-16 15:54:08 +0300 |
| commit | 3f9ac8bad204ad184c91b56f2fb45ee09ef774e5 (patch) | |
| tree | c6c78ad7372f93b80021fc98beb228330d63f771 | |
| parent | 29b119cf911951a85ae60c39ee6dda2ee7bfaed2 (diff) | |
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
| -rw-r--r-- | sql/updates/world/3.3.5/2020_09_16_01_world.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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; |