diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_03_27_02_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_27_02_world.sql b/sql/updates/world/master/2017_03_27_02_world.sql new file mode 100644 index 00000000000..333bc9c5175 --- /dev/null +++ b/sql/updates/world/master/2017_03_27_02_world.sql @@ -0,0 +1,10 @@ +-- Blood Elf Broken Quest +UPDATE `quest_template` SET `RewardChoiceItemID1` = 23265, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 23266, `RewardChoiceItemQuantity2` = 1, `RewardChoiceItemID3` = 23267, `RewardChoiceItemQuantity3` = 1, `RewardChoiceItemID4` = 131252, `RewardChoiceItemQuantity4` = 1 WHERE `quest_template`.`ID` = 9363; -- Quest: Warning Fairbreeze Village, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 22964, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 22965, `RewardChoiceItemQuantity2` = 1, `RewardChoiceItemID3` = 22966, `RewardChoiceItemQuantity3` = 1, `RewardChoiceItemID4` = 131240, `RewardChoiceItemQuantity4` = 1 WHERE `quest_template`.`ID` = 9076; -- Quest: Wretched Ringleader, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 24241, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 23367, `RewardChoiceItemQuantity2` = 1, `RewardChoiceItemID3` = 27552, `RewardChoiceItemQuantity3` = 1, `RewardChoiceItemID4` = 131237, `RewardChoiceItemQuantity4` = 1 WHERE `quest_template`.`ID` = 8472; -- Quest: Major Malfunction, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 22951, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 22953, `RewardChoiceItemQuantity2` = 1, `RewardChoiceItemID3` = 22952, `RewardChoiceItemQuantity3` = 1, `RewardChoiceItemID4` = 131239, `RewardChoiceItemQuantity4` = 1 WHERE `quest_template`.`ID` = 8491; -- Quest: Pelt Collection, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 23375, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 23376, `RewardChoiceItemQuantity2` = 1, `RewardChoiceItemID3` = 23377, `RewardChoiceItemQuantity3` = 1, `RewardChoiceItemID4` = 131238, `RewardChoiceItemQuantity4` = 1 WHERE `quest_template`.`ID` = 8475; -- Quest: The Dead Scar, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 22958, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 22959, `RewardChoiceItemQuantity2` = 1, `RewardChoiceItemID3` = 22963, `RewardChoiceItemQuantity2` = 1 WHERE `quest_template`.`ID` = 8477; -- Quest: The Spearcrafters Hammer, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 20996, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 20995, `RewardChoiceItemQuantity2` = 1, `RewardChoiceItemID3` = 131235, `RewardChoiceItemQuantity2` = 1 WHERE `quest_template`.`ID` = 8330; -- Quest: Solanians Belongings, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 159, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 4536, `RewardChoiceItemQuantity2` = 1 WHERE `quest_template`.`ID` = 8350; -- Quest: Completing the Delivery, Blood Elf +UPDATE `quest_template` SET `RewardChoiceItemID1` = 22969, `RewardChoiceItemQuantity1` = 1, `RewardChoiceItemID2` = 22971, `RewardChoiceItemQuantity2` = 1 WHERE `quest_template`.`ID` = 8479; -- Quest: Zul,Marosh, Blood Elf |