diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_21_00_world.sql | 134 |
1 files changed, 134 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_21_00_world.sql b/sql/updates/world/master/2017_05_21_00_world.sql new file mode 100644 index 00000000000..8fffbb5d8c6 --- /dev/null +++ b/sql/updates/world/master/2017_05_21_00_world.sql @@ -0,0 +1,134 @@ +DELETE FROM `quest_template` WHERE `ID` IN (46844 /*-Unknown-*/, 46769 /*-Unknown-*/, 46187 /*-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 +(46844, 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: Mistress of Blades', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46769, 2, 110, 0, 110, -428, 0, 0, 0, 0, 1, 388000, 6, 1, 0, 0, 0, 0, 239972, 0, 0, 0, 0, 1, 0, 2097160, 0, 0, 0, 0, 0, 147811, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Relieved of Their Valuables', 'Find $1oa Hidden Wyrmtongue Caches on the Broken Shore.', 'Not all demons on this shore stomp around in the open. Some slink about in the shadows, finding more subtle ways to advance the Legion''s cause.\n\nI have been observing the behavior of smaller demons, these wyrmtongues. They seem to spend considerable time acquiring objects of power. We cannot allow them to use these items against us.\n\nThe wyrmtongues stash their goods in chests spread around the Broken Shore. I suggest you relieve them of their ill-gotten gain.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46187, 3, -1, 0, 98, 7503, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242340, 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, 1828, 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, 'Larthogg', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown- + +UPDATE `quest_template` SET `RewardCurrencyID1`=0, `RewardCurrencyQty1`=0, `VerifiedBuild`=23911 WHERE `ID`=45756; -- Pearl of Fathoms +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43629; -- WANTED: Kiranys Duskwhisper +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionValue1`=1, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43475; -- Experimental Potion: Test Subjects Needed +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42795; -- WANTED: Sanaar +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42064; -- It's Illid... Wait. +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41601; -- Lively Mossgill Perch +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41554; -- Slab of Bacon +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41518; -- Felwort +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41447; -- Burning Felslate Deposits +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41354; -- Shattered Felslate Seams +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41347; -- Extra-Rancid Felhound Hide +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41346; -- Velvety Stalker Hide +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41262; -- Slab of Bacon +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=39042; -- The Very Best +UPDATE `quest_template` SET `RewardBonusMoney`=11150, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=5, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=37271; -- A Worthy Challenge: Teron'gor +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32846; -- Modified Chomping Apparatus +UPDATE `quest_template` SET `RewardBonusMoney`=2100, `RewardFactionValue1`=6, `RewardFactionOverride1`=20000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32561; -- Competing Magic +UPDATE `quest_template` SET `RewardBonusMoney`=3400, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32001; -- A Worthy Challenge: Sha of Hatred +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=31524; -- A Worthy Challenge: Raigonn +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=27066; -- Learning the Word +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26904; -- Corruption +UPDATE `quest_template` SET `RewardMoney`=146000, `RewardBonusMoney`=137150, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=25347; -- The Doomsday Plan +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=24873; -- Residue Rendezvous +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=13917; -- Gorishi Grub +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=11172; -- [DEPRECATED]The Zeppelin Crash +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=10794; -- Rogues of the Shattered Hand +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9837; -- Return to Khadgar +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9610; -- [DEPRECATED]Pool of Tears +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9224; -- Epic Armaments of Battle - Honored Amongst the Dawn +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9223; -- Superior Armaments of Battle - Honored Amongst the Dawn +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8429; -- Battle of Warsong Gulch +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8413; -- Da Voodoo +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=8331; -- Aurel Goldleaf +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6805; -- Stormers and Rumblers +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6804; -- Poisoned Water +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=6402; -- Stormwind Rendezvous +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6025; -- Unfinished Business +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=5730; -- Hidden Enemies +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5204; -- [DEPRECATEDRetribution of the Light +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5162; -- Wrath of the Blue Flight +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5081; -- Maxwell's Mission +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5022; -- Better Late Than Never +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3787; -- Jonespyre's Request +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2996; -- Seeking Strahad +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1532; -- Call of Air +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1320; -- [DEPRECATED]The Black Shield +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42795; -- WANTED: Sanaar +UPDATE `quest_template` SET `RewardCurrencyID1`=0, `RewardCurrencyQty1`=0, `VerifiedBuild`=23911 WHERE `ID`=45756; -- Pearl of Fathoms +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionValue1`=1, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43475; -- Experimental Potion: Test Subjects Needed +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42064; -- It's Illid... Wait. +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41601; -- Lively Mossgill Perch +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41554; -- Slab of Bacon +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41518; -- Felwort +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41347; -- Extra-Rancid Felhound Hide +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41346; -- Velvety Stalker Hide +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41262; -- Slab of Bacon +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=39042; -- The Very Best +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionValue1`=1, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43475; -- Experimental Potion: Test Subjects Needed +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42064; -- It's Illid... Wait. +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41518; -- Felwort + +DELETE FROM `quest_objectives` WHERE `ID` IN (289750 /*289750*/, 289749 /*289749*/, 289574 /*289574*/, 289058 /*289058*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289750, 46844, 0, 1, 116944, 1, 0, 0, 0, 'Mephistroth Slain', 23911), -- 289750 +(289749, 46844, 0, 0, 120712, 1, 0, 0, 0, 'Larithia Slain', 23911), -- 289749 +(289574, 46769, 0, 0, 120317, 10, 0, 0, 0, 'Hidden Wyrmtongue Caches found', 23911), -- 289574 +(289058, 46187, 0, 0, 117962, 1, 1, 0, 0, '', 23911); -- 289058 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288454; -- 288454 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285566; -- 285566 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284766; -- 284766 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283481; -- 283481 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282556; -- 282556 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282508; -- 282508 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282474; -- 282474 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282387; -- 282387 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282245; -- 282245 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282238; -- 282238 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282237; -- 282237 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282141; -- 282141 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=279135; -- 279135 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=276055; -- 276055 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270514; -- 270514 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270079; -- 270079 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269348; -- 269348 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268670; -- 268670 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266664; -- 266664 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266663; -- 266663 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254494; -- 254494 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254493; -- 254493 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=253072; -- 253072 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263735; -- 263735 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=273866; -- 273866 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261543; -- 261543 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260943; -- 260943 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260942; -- 260942 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260348; -- 260348 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260347; -- 260347 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257322; -- 257322 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259657; -- 259657 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259656; -- 259656 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259655; -- 259655 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258299; -- 258299 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258298; -- 258298 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257674; -- 257674 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257673; -- 257673 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257178; -- 257178 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257750; -- 257750 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257341; -- 257341 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257340; -- 257340 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257339; -- 257339 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257282; -- 257282 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284766; -- 284766 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288454; -- 288454 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283481; -- 283481 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282556; -- 282556 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282508; -- 282508 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282474; -- 282474 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282238; -- 282238 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282237; -- 282237 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282141; -- 282141 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=279135; -- 279135 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283481; -- 283481 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282474; -- 282474 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282141 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270079 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282141 AND `Index`=0); |