From 59f95b757260be9b60b112d8297e70eb0710f879 Mon Sep 17 00:00:00 2001 From: Wyrserth Date: Sun, 28 Jul 2019 23:28:38 +0200 Subject: 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) --- .../master/2021_12_17_23_world_2019_07_28_04_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/master/2021_12_17_23_world_2019_07_28_04_world.sql (limited to 'sql') 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; -- cgit v1.2.3