From 7e9a0414708ed1f9373c4c0e87ade501d3f7bc98 Mon Sep 17 00:00:00 2001 From: tkrokli Date: Wed, 7 Jun 2017 04:44:38 +0200 Subject: 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 --- sql/updates/world/master/2017_06_07_00_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2017_06_07_00_world.sql (limited to 'sql') 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; -- cgit v1.2.3