diff options
| -rw-r--r-- | sql/updates/world/master/2017_02_25_00_world.sql | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_25_00_world.sql b/sql/updates/world/master/2017_02_25_00_world.sql new file mode 100644 index 00000000000..aa9bfa90331 --- /dev/null +++ b/sql/updates/world/master/2017_02_25_00_world.sql @@ -0,0 +1,42 @@ +DELETE FROM `quest_template` WHERE `ID`=31877; +INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `QuestPackageID`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardDisplaySpell1`, `RewardDisplaySpell2`, `RewardDisplaySpell3`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `QuestRewardID`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(31877, 2, 90, 0, 85, 5981, 0, 0, 0, 1, 1, 11400, 1, 1, 170, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 32904, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'The Inkmasters of the Arboretum', 'Speak with Inkmaster Wei at the Arboretum in the Jade Forest.', 'I have heard that the Inkmasters at the Arboretum are in need of aid from a scribe of great skill. You should speak with Inkmaster Wei, if you wish to help.', '', 'Speak with Inkmaster Wei at the Arboretum in the Jade Forest.', 402, 0, 0, 0, 1, 0, 0, 0, '', '', '', '', 890, 878, 23420); -- -Unknown- + +UPDATE `quest_template` SET `RewardBonusMoney`=11150, `VerifiedBuild`=23420 WHERE `ID`=37277; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=11150, `VerifiedBuild`=23420 WHERE `ID`=37264; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=32813; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=850, `VerifiedBuild`=23420 WHERE `ID`=31243; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=30206; -- -Unknown- +UPDATE `quest_template` SET `RewardNextQuest`=0, `Flags`=540672, `FlagsEx`=64, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=24962; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=91500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=9673; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=33555378, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8919; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='$n, our worst fears have come. Legend speaks of the Soulflayer ruling the ancient troll world through evil and terror, and his power was absolute. If he cannot be stopped now, then his new reign may spread across all of Azeroth!$B$BThere is a contingent of Zandalarian trolls who may help us stem this tide of darkness. They have camped on Yojamba Isle, off the coast of Stranglethorn, west of the ruins of Zul''Kunda. Speak with their leader, Molthor, and pray he knows how to defeat Hakkar.', `VerifiedBuild`=23420 WHERE `ID`=8182; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8153; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=274350, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=7647; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=91500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='You now have the power to tame a pet, but you must also gain the skills to train it.$B$BTravel to Thunder Bluff. There you must speak to one of our most revered hunters, Holt Thunderhorn. If he deems you worthy, he will give you the ability to train your new pet.$B$BHolt has bested the most powerful and feared beasts of Azeroth, and commands many strong creatures of his own. His ties to the Earthmother are strong, and you can learn much from him. Good luck, $n.\n', `VerifiedBuild`=23420 WHERE `ID`=6089; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='It be time for you to meet with Ur''kyo, $n. He be in the Valley of Spirits in the orc city. Go there and speak to him. It is time you learn more of the old ways of our kind. It time you be brought into the circle and made a true priest of our tribe.', `VerifiedBuild`=23420 WHERE `ID`=5654; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=4961; -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (260915 /*260915*/, 260914 /*260914*/, 260913 /*260913*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(260915, 8919, 8, -1, 0, 200000, 0, 0, 0, '', 23420), -- 260915 +(260914, 8919, 1, 1, 16703, 1, 0, 0, 0, '', 23420), -- 260914 +(260913, 8919, 1, 0, 22381, 15, 0, 1, 0, '', 23420); -- 260913 + +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=268229; -- 268229 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255781; -- 255781 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252606; -- 252606 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254032; -- 254032 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=258615; -- 258615 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259381; -- 259381 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256787; -- 256787 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257033; -- 257033 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257134; -- 257134 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255194; -- 255194 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255750; -- 255750 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254626; -- 254626 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253755; -- 253755 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253469; -- 253469 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255838; -- 255838 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255837; -- 255837 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255032; -- 255032 |