DB/Quests: Updated quest_template data for 7.2.0 part 17

1 files changed, 86 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_05_11_03_world.sql b/sql/updates/world/master/2017_05_11_03_world.sql
new file mode 100644
index 00000000000..b0203bfc1b6
--- /dev/null
+++ b/sql/updates/world/master/2017_05_11_03_world.sql
@@ -0,0 +1,86 @@
+DELETE FROM `quest_template` WHERE `ID` IN (46904 /*-Unknown-*/, 46869 /*-Unknown-*/, 46252 /*-Unknown-*/, 46161 /*-Unknown-*/, 46014 /*-Unknown-*/, 45922 /*-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
+(46904, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 240989, 0, 0, 240685, 0, 0, 0, 0, 1, 0, 39845888, 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 Command Center', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown-
+(46869, 3, 110, 0, 110, 8527, 145, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193088, 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, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5206, 0, -1, 358, 6, 'Cathedral of Eternal Night: Temptress of Pain', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown-
+(46252, 2, 110, 0, 110, -428, 0, 0, 0, 0, 1, 388000, 6, 1, 0, 0, 0, 0, 239972, 0, 0, 0, 0, 1, 0, 35651592, 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, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 150000, 0, 0, 0, 0, 0, 0, 0, -1, 0, 6, 'Intolerable Infestation', 'Slay 100 demons in Faronaar or Felsoul Hold.', 'While we purge Legion filth from the Broken Shore, the fiends maintain their hold on nearby lands. Their presence can no longer be tolerated.\n\nThe fetid strongholds of Faronaar and Felsoul Hold infest Azsuna and Suramar. Choose an attack point and cut a swath through their insidious ranks.\n\nReturn to me with demon blood on your hands, then we can resume our campaign to drive Kil''jaeden from the Tomb.', '', '', 1226, 0, 0, 0, 2000, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown-
+(46161, 3, -1, 0, 98, 7334, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242349, 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, 1900, 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, 'Felcaller Thalezra', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown-
+(46014, 3, -1, 0, 98, 7541, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242339, 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, 1948, 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, 'Gelthrog', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown-
+(45922, 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, 'Agmozuul', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown-
+
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44030; -- WANTED: Guardian Thor'el
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43802; -- Watery Graves
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43614; -- WANTED: Vorthax
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41616; -- Huge Runescale Koi
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41599; -- Lively Cursed Queenfish
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41562; -- Felhide
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41513; -- Felwort
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41481; -- Brimstone Destroyer
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41440; -- Magnificent Leystone Deposits
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41439; -- Exquisite Leystone Deposits
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41283; -- The Angler Mangler
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41273; -- Buoy Fishing
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41259; -- Slab of Bacon
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32564; -- Zandalari on the Rise
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30490; -- Yakity Yak
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=25198; -- Winnoa Pineforest
+UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=11195; -- Playin' With Dolls
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7401; -- Wanted: DWARVES!
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6824; -- Hands of the Enemy
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5639; -- Desperate Prayer
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5463; -- Menethil's Gift
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2936; -- The Spider God
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2744; -- The Demon Hunter
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2460; -- The Shattered Salute
+UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1687; -- Spooky Lighthouse
+UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1558; -- The Stonewrought Dam
+UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1479; -- The Bough of the Eternals
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1124; -- Wasteland
+UPDATE `quest_template` SET `RewardMoney`=12500, `RewardMoneyDifficulty`=6, `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=49; -- Sweet Amber
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (289795 /*289795*/, 289794 /*289794*/, 289281 /*289281*/, 289008 /*289008*/, 288800 /*288800*/, 288734 /*288734*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(289795, 46869, 0, 1, 116944, 1, 0, 0, 0, 'Mephistroth Slain', 23911), -- 289795
+(289794, 46869, 0, 0, 120717, 1, 0, 0, 0, 'Dominix Slain', 23911), -- 289794
+(289281, 46252, 14, 0, 57693, 1, 0, 0, 0, 'Demons slain', 23911), -- 289281
+(289008, 46161, 0, 0, 117056, 1, 1, 0, 0, '', 23911), -- 289008
+(288800, 46014, 0, 0, 117048, 1, 1, 0, 0, '', 23911), -- 288800
+(288734, 45922, 0, 0, 117039, 1, 1, 0, 0, '', 23911); -- 288734
+
+UPDATE `quest_objectives` SET `Amount`=8 WHERE `ID`=289563; -- 289563
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286131; -- 286131
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285821; -- 285821
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285820; -- 285820
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285551; -- 285551
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282571; -- 282571
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282554; -- 282554
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282519; -- 282519
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282469; -- 282469
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282432; -- 282432
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282380; -- 282380
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282379; -- 282379
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282163; -- 282163
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282153; -- 282153
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282138; -- 282138
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270145; -- 270145
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252964; -- 252964
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=256563; -- 256563
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259457; -- 259457
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252977; -- 252977
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252976; -- 252976
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252975; -- 252975
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252974; -- 252974
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=255842; -- 255842
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254781; -- 254781
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=252371; -- 252371
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=252370; -- 252370
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=252369; -- 252369
+
+
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282571 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282432 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282163 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282153 AND `Index`=2);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282153 AND `Index`=1);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282153 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282138 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270145 AND `Index`=0);