diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_08_00_world.sql | 103 |
1 files changed, 103 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_08_00_world.sql b/sql/updates/world/master/2017_05_08_00_world.sql new file mode 100644 index 00000000000..a2244c70d19 --- /dev/null +++ b/sql/updates/world/master/2017_05_08_00_world.sql @@ -0,0 +1,103 @@ +DELETE FROM `quest_template` WHERE `ID` IN (46904 /*-Unknown-*/, 46869 /*-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- +(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`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44193; -- DANGER: Sea King Tidross +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, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41501; -- Leystone Basilisks +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`=41439; -- Exquisite Leystone Deposits +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41273; -- Buoy Fishing +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32895; -- The Road to War +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32006; -- A Worthy Challenge: Flameweaver Koegler +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=375000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=31530; -- Mission: The Hozen Dozen +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30765; -- Regaining Honor +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30490; -- Yakity Yak +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30231; -- Pomfruit Pickup +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=10000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30195; -- Blooming Blossoms +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=10000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30194; -- Encroaching Storm +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30193; -- Meating Expectations +UPDATE `quest_template` SET `RewardMoney`=194000, `RewardBonusMoney`=182850, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=27802; -- Arrest the Infiltrators +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=14420; -- The Deathstalkers +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=13914; -- Searing Roc Feathers +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=11517; -- Report to Nasuun +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=11401; -- Call the Headless Horseman +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=11321; -- Did Someone Say "Souvenir?" +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10833; -- Becoming a Shadoweave Tailor +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10790; -- Return to Mordak Darkfist +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9449; -- Call of Earth +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=8553; -- The Captain's Cutlass +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8194; -- Apprentice Angler +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8189; -- Presence of Sight +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8185; -- Syncretist's Sigil +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8184; -- Presence of Might +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7629; -- Imp Delivery +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6821; -- Eye of the Emberseer +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=6148; -- The Scarlet Oracle, Demetria +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5145; -- Dragonscale Leatherworking +UPDATE `quest_template` SET `RewardMoney`=7500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=3914; -- Linken's Sword +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=3454; -- The Torch of Retribution +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=3124; -- Hippogryph Muisek +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestDescription`='Although Galvan left Booty Bay many years ago, members of the order still remain in town, hoping to one day find another worthy of Galvan''s tutelage.$B$BTake this insignia and present it to McGavan in Booty Bay.$B$BIf you actually make it that far, he''ll know that you are worthy. I have faith, $n!', `VerifiedBuild`=23911 WHERE `ID`=2759; -- In Search of Galvan +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1124; -- Wasteland +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=657; -- Hints of a New Plague? +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=592; -- Saving Yenniku +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 + +DELETE FROM `quest_objectives` WHERE `ID` IN (289795 /*289795*/, 289794 /*289794*/, 288734 /*288734*/, 253602 /*253602*/); +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 +(288734, 45922, 0, 0, 117039, 1, 1, 0, 0, '', 23911), -- 288734 +(253602, 2759, 1, 0, 8663, 1, 0, 0, 0, '', 23911); -- 253602 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286374; -- 286374 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286131; -- 286131 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282451; -- 282451 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282432; -- 282432 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282379; -- 282379 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282153; -- 282153 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269353; -- 269353 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268682; -- 268682 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258940; -- 258940 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252964; -- 252964 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256244; -- 256244 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251623; -- 251623 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251622; -- 251622 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251621; -- 251621 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263333; -- 263333 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263332; -- 263332 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251971; -- 251971 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264808; -- 264808 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256309; -- 256309 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254648; -- 254648 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262157; -- 262157 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260407; -- 260407 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259670; -- 259670 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259669; -- 259669 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260077; -- 260077 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260076; -- 260076 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259639; -- 259639 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259638; -- 259638 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259388; -- 259388 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259387; -- 259387 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257581; -- 257581 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258772; -- 258772 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255945; -- 255945 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255944; -- 255944 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255943; -- 255943 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=257677; -- 257677 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256476; -- 256476 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256475; -- 256475 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254781; -- 254781 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=253633; -- 253633 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286131; -- 286131 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286374 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`=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`=256244 AND `Index`=0); |