diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-28 23:28:38 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-17 21:50:19 +0100 |
| commit | 59f95b757260be9b60b112d8297e70eb0710f879 (patch) | |
| tree | 971407ee9cc603b4475346061294285e55579de4 | |
| parent | 0e13ed412a304e91a24eded6c31842dbb7ea53de (diff) | |
DB/Quest: fix item rewards for the following quests:
- Nolkai's Words
- Ally of the Netherwing
- He Will Walk The Earth...
- Hero of the Mag'har
(cherry picked from commit 48091257d325f55889d120fdb4967e7c4bcb8c09)
| -rw-r--r-- | sql/updates/world/master/2021_12_17_23_world_2019_07_28_04_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_17_23_world_2019_07_28_04_world.sql b/sql/updates/world/master/2021_12_17_23_world_2019_07_28_04_world.sql new file mode 100644 index 00000000000..ea37fccdd2f --- /dev/null +++ b/sql/updates/world/master/2021_12_17_23_world_2019_07_28_04_world.sql @@ -0,0 +1,13 @@ +-- Nolkai's Words +UPDATE `gameobject_template` SET `AIName`="" WHERE `entry`=181758; +DELETE FROM `smart_scripts` WHERE `entryorguid`=181758 AND `source_type`=1; +UPDATE `quest_template` SET `RewardItem1`=23846, `RewardAmount1`=1 WHERE `ID`=9561; + +-- Ally of the Netherwing +-- UPDATE `quest_template` SET `RewardChoiceItemID1`=31492, `RewardChoiceItemID2`=31491, `RewardChoiceItemID3`=31490, `RewardChoiceItemID4`=31494, `RewardChoiceItemID5`=31493, `RewardChoiceItemQuantity1`=1, `RewardChoiceItemQuantity2`=1, `RewardChoiceItemQuantity3`=1, `RewardChoiceItemQuantity4`=1, `RewardChoiceItemQuantity5`=1 WHERE `ID`=10870; + +-- He Will Walk The Earth... +-- UPDATE `quest_template` SET `RewardChoiceItemID1`=25574, `RewardChoiceItemID2`=25575, `RewardChoiceItemID3`=25576, `RewardChoiceItemQuantity1`=1, `RewardChoiceItemQuantity2`=1, `RewardChoiceItemQuantity3`=1 WHERE `ID`=9866; + +-- Hero of the Mag'har +UPDATE `quest_template` SET `RewardItem1`=28168, `RewardAmount1`=1, `RewardChoiceItemID1`=28173, `RewardChoiceItemID2`=28169, `RewardChoiceItemID3`=28172, `RewardChoiceItemID4`=28175, `RewardChoiceItemQuantity1`=1, `RewardChoiceItemQuantity2`=1, `RewardChoiceItemQuantity3`=1, `RewardChoiceItemQuantity4`=1 WHERE `ID`=10212; |