diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-28 23:28:38 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-07-28 23:28:38 +0200 |
| commit | 48091257d325f55889d120fdb4967e7c4bcb8c09 (patch) | |
| tree | faf632b347605ea8e683ccc15ba35f20390c3a6a | |
| parent | 55ec3bd73fd2618e4de199c147bbddcb99d11b19 (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
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_28_04_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_28_04_world.sql b/sql/updates/world/3.3.5/2019_07_28_04_world.sql new file mode 100644 index 00000000000..86cb0a3d6f7 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |