diff options
| author | tkrokli <tkrokli@users.noreply.github.com> | 2017-06-07 04:44:38 +0200 |
|---|---|---|
| committer | tkrokli <tkrokli@users.noreply.github.com> | 2017-06-07 04:44:38 +0200 |
| commit | 7e9a0414708ed1f9373c4c0e87ade501d3f7bc98 (patch) | |
| tree | bfbf13b5735b6bcf37f9162dfe9a082abe230fa7 | |
| parent | 151441697febb99048908c9a4ddcbf8080de4145 (diff) | |
DB/Quests: make starter quest rewards available (26799 & 26800)
Quests: Those That Couldn't Be Saved (26799) & Recruitment (26800)
Issue: Quest can not be completed due to missing DB info for reward items
Detail: Cloth items can be rewarded, but not leather, mail, plate or cape
Solution: Add DB item info to those quests where core blocks the rewards.
Closes #19849
| -rw-r--r-- | sql/updates/world/master/2017_06_07_00_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_06_07_00_world.sql b/sql/updates/world/master/2017_06_07_00_world.sql new file mode 100644 index 00000000000..e4d7159f3c2 --- /dev/null +++ b/sql/updates/world/master/2017_06_07_00_world.sql @@ -0,0 +1,4 @@ +-- Quests: Those That Couldn't Be Saved (26799) / Recruitment (26800) +-- make the quest rewards selectable for all classes, not only some of them +UPDATE `quest_template` SET `RewardChoiceItemID1`= 3275, `RewardChoiceItemQuantity1`=1, `RewardChoiceItemID2`=11847, `RewardChoiceItemQuantity2`=1 WHERE `ID`=26799; +UPDATE `quest_template` SET `RewardChoiceItemID1`=11848, `RewardChoiceItemQuantity1`=1, `RewardChoiceItemID2`=11849, `RewardChoiceItemQuantity2`=1, `RewardChoiceItemID3`=11850, `RewardChoiceItemQuantity3`=1 WHERE `ID`=26800; |