diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_04_00_world.sql | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_04_00_world.sql b/sql/updates/world/master/2017_05_04_00_world.sql new file mode 100644 index 00000000000..b5aad2daa30 --- /dev/null +++ b/sql/updates/world/master/2017_05_04_00_world.sql @@ -0,0 +1,57 @@ +DELETE FROM `quest_template` WHERE `ID` IN (47007 /*-Unknown-*/, 46766 /*-Unknown-*/, 46105 /*-Unknown-*/, 46104 /*-Unknown-*/, 45921 /*-Unknown-*/, 45805 /*-Unknown-*/, 45776 /*-Unknown-*/); +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`, `Expansion`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(47007, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 237137, 0, 0, 237135, 0, 0, 0, 0, 1, 0, 39846144, 8192, 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, 6, 'Boon of the Mage Tower', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46766, 3, -1, 0, 98, 7558, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242337, 0, 0, 0, 0, 0, 0, 37290240, 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, 1883, 1894, 0, 0, 0, 4, 4, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 335, 6, 'Ulgthax', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46105, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 235672, 0, 0, 0, 0, 0, 0, 37290240, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5131, 0, -1, 340, 6, 'Arachnid Superiority', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46104, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 235670, 0, 0, 0, 0, 0, 0, 37290240, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5131, 0, -1, 356, 6, 'Arachnid Toxicity', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45921, 3, -1, 0, 98, 7558, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242336, 0, 0, 0, 0, 0, 0, 37290240, 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, 1883, 1894, 0, 0, 0, 4, 4, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 335, 6, 'Thal''xur', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45805, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234487, 0, 0, 0, 0, 0, 0, 37290240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 143924, 0, 0, 0, 100, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5093, 0, -1, 340, 6, 'The Burning Keys', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45776, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234485, 0, 0, 0, 0, 0, 0, 37290240, 8192, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5093, 0, -1, 356, 6, 'Keys are a Crutch', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown- + +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44015; -- WANTED: Mal'Dreth the Corruptor +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41610; -- Huge Cursed Queenfish +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41495; -- Brilliant Leystone Seams +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41026; -- Back to the Shadows +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8460; -- [DEPRECATED]Timbermaw Ally +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8156; -- Arathi Basin Resources! +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4005; -- Aquementas +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3635; -- Gnome Engineering + +DELETE FROM `quest_objectives` WHERE `ID` IN (289572 /*289572*/, 289700 /*289700*/, 288899 /*288899*/, 289699 /*289699*/, 288898 /*288898*/, 288733 /*288733*/, 288581 /*288581*/, 288485 /*288485*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289572, 46766, 0, 0, 120310, 1, 1, 0, 0, '', 23911), -- 289572 +(289700, 46105, 0, 1, 120236, 1, 0, 0, 0, '', 23911), -- 289700 +(288899, 46105, 1, 0, 147206, 8, 0, 1, 0, '', 23911), -- 288899 +(289699, 46104, 0, 1, 120236, 1, 0, 0, 0, '', 23911), -- 289699 +(288898, 46104, 0, 0, 118733, 6, 0, 0, 0, 'Legionfall Soldier detoxed', 23911), -- 288898 +(288733, 45921, 0, 0, 118016, 1, 1, 0, 0, '', 23911), -- 288733 +(288581, 45805, 0, 0, 118021, 10, 0, 0, 0, 'Prisoners rescued', 23911), -- 288581 +(288485, 45776, 0, 0, 118021, 10, 0, 0, 0, 'Cage Locks picked', 23911); -- 288485 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286113; -- 286113 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282565; -- 282565 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282444; -- 282444 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281675; -- 281675 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281717; -- 281717 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281716; -- 281716 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281715; -- 281715 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281673; -- 281673 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281672; -- 281672 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255719; -- 255719 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255718; -- 255718 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255717; -- 255717 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259225; -- 259225 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257608; -- 257608 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257493; -- 257493 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=289700 AND `Index`=0) OR (`ID`=289699 AND `Index`=0) OR (`ID`=288581 AND `Index`=4) OR (`ID`=288581 AND `Index`=3) OR (`ID`=288581 AND `Index`=2) OR (`ID`=288581 AND `Index`=1) OR (`ID`=288581 AND `Index`=0) OR (`ID`=288485 AND `Index`=1) OR (`ID`=288485 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(289700, 0, 2101, 23911), +(289699, 0, 2101, 23911), +(288581, 4, 7034, 23911), +(288581, 3, 7025, 23911), +(288581, 2, 7024, 23911), +(288581, 1, 6760, 23911), +(288581, 0, 6759, 23911), +(288485, 1, 6760, 23911), +(288485, 0, 6759, 23911); |