DB/Quests: Updated quest_template data for 7.2.5 part 4

1 files changed, 144 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_07_05_00_world.sql b/sql/updates/world/master/2017_07_05_00_world.sql
new file mode 100644
index 00000000000..de58e5d3979
--- /dev/null
+++ b/sql/updates/world/master/2017_07_05_00_world.sql
@@ -0,0 +1,144 @@
+DELETE FROM `quest_template` WHERE `ID`=46500;
+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
+(46500, 3, 110, 0, 110, 8524, 141, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193152, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5218, 0, -1, 16, 6, 'Tomb of Sargeras: Legend of the Deep', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330); -- -Unknown-
+
+UPDATE `quest_template` SET `Flags`=37290304, `VerifiedBuild`=24330 WHERE `ID`=46188; -- Orgrokk
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=46046; -- Life's a Lich
+UPDATE `quest_template` SET `Flags`=37290304, `VerifiedBuild`=24330 WHERE `ID`=45924; -- Abyssal Monstrosity
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44289; -- WANTED: Arru
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=43771; -- The Magic of Flight
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43632; -- WANTED: Theryssia
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42757; -- Maw of Souls: Menace of the Seas
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42744; -- Darkheart Thicket: Preserving the Preservers
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41838; -- WANTED: Slumber
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41766; -- Wildlife Protection Force
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41617; -- Huge Runescale Koi
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41553; -- Slab of Bacon
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41454; -- Luminous Leystone Outcropping
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41432; -- Fiery Leystone Deposits
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41352; -- Felslate Basilisks
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41343; -- Solid Crabshell Fragment
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41324; -- Silky Prowler Fur
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=39042; -- The Very Best
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37972; -- Pet Battles Not Active
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37751; -- Bounties Active
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32846; -- Modified Chomping Apparatus
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=24330 WHERE `ID`=32607; -- Extended Shore Leave
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32403; -- It Starts in the Sewers
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30765; -- Regaining Honor
+UPDATE `quest_template` SET `RewardBonusMoney`=675, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=4, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=30596; -- A Zandalari Troll?
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30067; -- The Shadow of Doubt
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27067; -- Moonfire
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27060; -- Unholy Cow
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11130; -- Oooh, Shinies!
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10218; -- Someone Else's Hard Work Pays Off
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9393; -- Hunter Training
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7844; -- Cannibalistic Cousins
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7841; -- Message to the Wildhammer
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7840; -- Lard Lost His Lunch
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7839; -- Vilebranch Hooligans
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7830; -- Avenging the Fallen
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7829; -- Hunt the Savages
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7828; -- Stalking the Stalkers
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7816; -- Gammerita, Mon!
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7815; -- Snapjaws, Mon!
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7042; -- Stolen Winter Veil Treats
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3561; -- Delivery to Archmage Xylem
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3542; -- Delivery to Andron Gant
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2934; -- Undamaged Venom Sac
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2882; -- Cuergo's Gold
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1838; -- Brutal Armor
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1800; -- Lordaeron Throne Room
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1274; -- The Missing Diplomat
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=911; -- Gateway to the Frontier
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=910; -- Down at the Docks
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=687; -- Theldurin the Lost
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=592; -- Saving Yenniku
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=383; -- Vital Intelligence
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8; -- A Rogue's Deal
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41838; -- WANTED: Slumber
+UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42757; -- Maw of Souls: Menace of the Seas
+
+DELETE FROM `quest_objectives` WHERE `ID`=289318;
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(289318, 46500, 0, 0, 120022, 1, 0, 0, 0, 'Deepmaw slain', 24330); -- 289318
+
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289059; -- 289059
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288837; -- 288837
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288836; -- 288836
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288736; -- 288736
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286513; -- 286513
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285778; -- 285778
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285569; -- 285569
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284711; -- 284711
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284710; -- 284710
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286780; -- 286780
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284675; -- 284675
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282903; -- 282903
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282775; -- 282775
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282572; -- 282572
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282507; -- 282507
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282403; -- 282403
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282371; -- 282371
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282243; -- 282243
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282234; -- 282234
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282217; -- 282217
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=279135; -- 279135
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270514; -- 270514
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270251; -- 270251
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270250; -- 270250
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269786; -- 269786
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258940; -- 258940
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253734; -- 253734
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=251808; -- 251808
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266654; -- 266654
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266653; -- 266653
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253403; -- 253403
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253402; -- 253402
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252269; -- 252269
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259673; -- 259673
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259672; -- 259672
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260411; -- 260411
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260410; -- 260410
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260409; -- 260409
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260408; -- 260408
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259301; -- 259301
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259377; -- 259377
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260175; -- 260175
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259403; -- 259403
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259277; -- 259277
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259276; -- 259276
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259367; -- 259367
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259354; -- 259354
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257604; -- 257604
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257332; -- 257332
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256425; -- 256425
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256664; -- 256664
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256039; -- 256039
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256038; -- 256038
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256037; -- 256037
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256036; -- 256036
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253633; -- 253633
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253263; -- 253263
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=251785; -- 251785
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282903; -- 282903
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284711; -- 284711
+UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284710; -- 284710
+
+DELETE FROM `quest_visual_effect` WHERE (`ID`=289318 AND `Index`=0);
+INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES
+(289318, 0, 2101, 24330);
+
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288837 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285778 AND `Index`=1);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285778 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=284711 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=284710 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=286780 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=284675 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282403 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270251 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270250 AND `Index`=1);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270250 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=284711 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=284710 AND `Index`=0);