diff options
author | vincent-michael <vincent_michael@gmx.de> | 2017-07-08 20:31:51 +0200 |
---|---|---|
committer | vincent-michael <vincent_michael@gmx.de> | 2017-07-08 20:31:51 +0200 |
commit | fc8f0fbc2d6f903f7e742dbfb0d5315470f5414d (patch) | |
tree | 12437c2631ef50cfa9c2c32dcb56f036b71eef36 | |
parent | 23ab9be91029cade74c0fcc9a6613b5a1f410d47 (diff) |
DB/Quests: Updated quest_template data for 7.2.5 part 6
-rw-r--r-- | sql/updates/world/master/2017_07_08_00_world.sql | 582 |
1 files changed, 582 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_07_08_00_world.sql b/sql/updates/world/master/2017_07_08_00_world.sql new file mode 100644 index 00000000000..9fce87ef001 --- /dev/null +++ b/sql/updates/world/master/2017_07_08_00_world.sql @@ -0,0 +1,582 @@ +DELETE FROM `quest_template` WHERE `ID` IN (48651 /*-Unknown-*/, 48650 /*-Unknown-*/, 48649 /*-Unknown-*/, 48648 /*-Unknown-*/, 48647 /*-Unknown-*/, 48646 /*-Unknown-*/, 48645 /*-Unknown-*/, 48644 /*-Unknown-*/, 48643 /*-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 +(48651, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48650, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48649, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48648, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48647, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48646, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48645, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48644, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330), -- -Unknown- +(48643, 2, 0, 0, 0, 8025, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330); -- -Unknown- + +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=47054; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=47045; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=47040; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=47016; -- -Unknown- +UPDATE `quest_template` SET `Flags`=37290304, `VerifiedBuild`=24330 WHERE `ID`=46187; -- -Unknown- +UPDATE `quest_template` SET `Flags`=37290304, `VerifiedBuild`=24330 WHERE `ID`=46185; -- Iroxus +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45072; -- Barrels o' Fun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45070; -- Barrels o' Fun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45068; -- Barrels o' Fun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45047; -- Like the Wind +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45046; -- Like the Wind +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45032; -- Like the Wind +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44122; -- DANGER: Sorallus +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43777; -- The Magic of Flight +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43755; -- The Magic of Flight +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43640; -- The Arcway: Creeping Suspicions +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43626; -- WANTED: Thane Irglov +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=43625; -- WANTED: Nameless King +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43460; -- WANTED: Kiranys Duskwhisper +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43098; -- DANGER: Marblub the Massive +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42964; -- DANGER: Lagertha +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42620; -- WANTED: Arcavellus +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41826; -- WANTED: Crawshuk the Hungry +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41571; -- Felhide +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41565; -- Felhide +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41532; -- Bushy Dreamleaf +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41525; -- Wispy Foxflower +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41516; -- Felwort +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41484; -- Brimstone Destroyer +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardArtifactCategoryID`=0, `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41339; -- Supplies Needed: Stonehide Leather +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41279; -- Lively Runescale Koi +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41260; -- Slab of Bacon +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41232; -- Thick Ironhorn Hide +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41093; -- DANGER: Durguth +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41090; -- Lords of the Hills +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41024; -- Dirge of the Dead +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=39520; -- Ashran Dominance +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=38040; -- Bleeding the Bleeding Hollow +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37838; -- My Garona +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=36206; -- The Dragon's Tale +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32819; -- Battlefield: Barrens +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32410; -- Krasus' Landing +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32409; -- The Kirin Tor's True Colors +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32406; -- A Tactical Assault +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32405; -- Hand of the Silver Covenant +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32404; -- Violence in the Arena +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32004; -- A Worthy Challenge: Wing Leader Ner'onok +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32001; -- A Worthy Challenge: Sha of Hatred +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30818; -- A New Fate +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30817; -- The Healing of Shen-zin Su +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=29429; -- The Creepy Crate +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27027; -- Primal Strike +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27015; -- Consecrated Note +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26974; -- The False Champion +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26958; -- Your First Lesson +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26904; -- Corruption +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26201; -- The Power of a Warlock +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24965; -- Magic Training +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=24330 WHERE `ID`=24879; -- Blood Quickening +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24778; -- The Arts of a Hunter +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=14199; -- Proof of Demise: The Black Knight +UPDATE `quest_template` SET `RewardBonusMoney`=180, `VerifiedBuild`=24330 WHERE `ID`=13997; -- If You're Reading This While I'm In Combat... +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=13733; -- A Champion Rises +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=13254; -- Proof of Demise: Anub'arak +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=13246; -- Proof of Demise: Keristrasza +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=13002; -- Gem Perfection +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=12817; -- Investigate the Scourge of Exodar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11517; -- Report to Nasuun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11492; -- Hard to Kill +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11222; -- [DEPRECATED]Proof of Treachery +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11164; -- Tuskin' Raiders +UPDATE `quest_template` SET `RewardMoney`=9000, `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=11152; -- [DEPRECATED]Peace at Last +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11022; -- Speak with Mog'dorg +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=1, `VerifiedBuild`=24330 WHERE `ID`=10960; -- When I Grow Up... +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10902; -- Master of Elixirs +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10593; -- Ancient Evil +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10178; -- Find Spy To'gun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10095; -- Into the Heart of the Labyrinth +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9876; -- Failed Incursion +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9633; -- The Way to Auberdine +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9447; -- Administering the Salve +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9443; -- The So-Called Mark of the Lightbringer +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9425; -- Report to Tarren Mill +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=9191; -- Craftsman's Writ - Runecloth Bag +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9189; -- Delivery to the Sepulcher +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9131; -- Binding the Dreadnaught +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9128; -- The Elemental Equation +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9124; -- Cryptstalker Armor Doesn't Make Itself... +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9121; -- The Dread Citadel - Naxxramas +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8922; -- A Supernatural Device +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=18875469, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=8909; -- An Earnest Proposition +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8563; -- Warlock Training +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=8538; -- The Four Dukes +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8430; -- Battle of Warsong Gulch +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8428; -- Battle of Warsong Gulch +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8426; -- Battle of Warsong Gulch +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8412; -- [DEPRECATED] Spirit Totem +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8286; -- What Tomorrow Brings +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8185; -- Syncretist's Sigil +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=8112; -- Enchanted South Seas Kelp +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=8111; -- Enchanted South Seas Kelp +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=8110; -- Enchanted South Seas Kelp +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7850; -- Dark Vessels +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7849; -- Separation Anxiety +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7725; -- Again With the Zapped Giants +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7721; -- Fuel for the Zapping +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7637; -- Emphasis on Sacrifice +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=7500; -- The Arcanist's Cookbook +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7489; -- Lethtendris's Web +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7441; -- Pusillin and the Elder Azj'Tordin +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionValue2`=7, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=24330 WHERE `ID`=7366; -- The Archbishop's Mercy +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7362; -- Ally of the Tauren +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6823; -- Agent of Hydraxis +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6805; -- Stormers and Rumblers +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6562; -- Trouble in the Deeps +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6502; -- Drakefire Amulet +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6421; -- Boulderslide Ravine +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6402; -- Stormwind Rendezvous +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6401; -- Kaya's Alive +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=6389; -- A Plague Upon Thee +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6187; -- Order Must Be Restored +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6185; -- The Eastern Plagues +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6141; -- Brother Anton +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6133; -- The Ranger Lord's Behest +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6128; -- Gathering the Cure +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6004; -- Unfinished Business +UPDATE `quest_template` SET `RewardBonusMoney`=18350, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=5926; -- Heeding the Call +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5802; -- Fire Plume Forged +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5781; -- Of Forgotten Memories +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5763; -- Hunting in Stranglethorn +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5673; -- Elune's Grace +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5629; -- Returning Home +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5537; -- Skeletal Fragments +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5461; -- The Human, Ras Frostwhisper +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5384; -- Kirtonos the Herald +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5381; -- Hand of Iruxos +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5301; -- The Art of the Armorsmith +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5281; -- The Restless Souls +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5247; -- Fragments of the Past +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5246; -- Fragments of the Past +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5217; -- Return to Chillwind Camp +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5181; -- Villains of Darrowshire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5168; -- Heroes of Darrowshire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5163; -- [DEPRECATED]Are We There, Yeti? +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5158; -- [DEPRECATED]Seeking Spiritual Aid +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5102; -- General Drakkisath's Demise +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5065; -- The Lost Tablets of Mosh'aru +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5055; -- Brumeran of the Chillwind +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5001; -- Bijou's Belongings +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4788; -- The Final Tablets +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=4642; -- Melding of Influences +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4507; -- Pawn Captures Queen +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4496; -- Bungle in the Jungle +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4282; -- A Shred of Hope +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4267; -- Rise of the Silithid +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4147; -- Marvon's Workshop +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4146; -- Zapper Fuel +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4142; -- A Visit to Gregan +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4134; -- Lost Thunderbrew Recipe +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4120; -- The Strength of Corruption +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3923; -- [DEPRECATED] Rilli Greasygob +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3801; -- Dark Iron Legacy +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3643; -- Show Your Work +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3627; -- Uniting the Shattered Amulet +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3568; -- Seeping Corruption +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3541; -- Delivery to Jes'rimon +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3527; -- The Prophecy of Mosh'aru +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=3379; -- Shadoweaver +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3365; -- Bring Back the Mug +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3121; -- A Strange Request +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3117; -- Etched Sigil +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2987; -- Gordunni Cobalt +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2983; -- Call of Fire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2979; -- Dark Ceremony +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2879; -- The Stave of Equinex +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2766; -- Find OOX-22/FE! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2764; -- Galvan's Finest Pupil +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2744; -- The Demon Hunter +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2721; -- Kirith +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2378; -- Find the Shattered Hand +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2360; -- Mathias and the Defias +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2283; -- Necklace Recovery +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2238; -- Simple Subterfugin' +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2202; -- Uldaman Reagent Run +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2200; -- Back to Uldaman +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1998; -- Fenwick Thatros +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1919; -- Report to Jennea +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1818; -- Speak with Dillinger +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1718; -- The Islander +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1715; -- The Slaughtered Lamb +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1687; -- Spooky Lighthouse +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1654; -- The Test of Righteousness +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1650; -- The Tome of Valor +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1558; -- The Stonewrought Dam +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1536; -- Call of Water +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1522; -- Call of Fire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1503; -- Forged Steel +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1479; -- The Bough of the Eternals +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1476; -- Hearts of the Pure +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1467; -- Reagents for Reclaimers Inc. +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1444; -- Return to Fel'Zerul +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1362; -- The Kolkar of Desolace +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1187; -- Razzeric's Tweaking +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1159; -- Test of Lore +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1147; -- The Swarm Grows +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1019; -- The New Frontier +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1015; -- The New Frontier +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=993; -- A Lost Master +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=978; -- Moontouched Wildkin +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=974; -- Finding the Source +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=966; -- The Tower of Althalaxx +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=900; -- Samophlange +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=813; -- Finding the Antidote +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=812; -- Need for a Cure +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=752; -- A Humble Task +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=750; -- The Hunt Continues +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=719; -- A Dwarf and His Tools +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=632; -- The Thandol Span +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=625; -- Cortello's Riddle +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=624; -- Cortello's Riddle +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=613; -- Cracking Maury's Foot +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=507; -- [DEPRECATED] Lord Aliden Perenolde +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=502; -- [DEPRECATED] Elixir of Pain +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=442; -- Assault on Fenris Isle +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=414; -- Stout to Kadrell +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=385; -- Crocolisk Hunting +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=306; -- In Search of The Excavation Team +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=277; -- Fire Taboo +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=276; -- Tramping Paws +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=250; -- A Dark Threat Looms +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=224; -- In Defense of the King's Lands +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=105; -- Alas, Andorhal +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=77; -- A Sticky Situation +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=39; -- Deliver Thomas' Report +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7637; -- Emphasis on Sacrifice +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45068; -- Barrels o' Fun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43777; -- The Magic of Flight +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45070; -- Barrels o' Fun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43755; -- The Magic of Flight +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41516; -- Felwort +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42620; -- WANTED: Arcavellus + +DELETE FROM `quest_objectives` WHERE `ID` IN (261106 /*261106*/, 261105 /*261105*/, 261104 /*261104*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(261106, 8909, 8, -1, 0, 200000, 0, 0, 0, '', 24330), -- 261106 +(261105, 8909, 1, 1, 16697, 1, 0, 0, 0, '', 24330), -- 261105 +(261104, 8909, 1, 0, 21928, 15, 0, 1, 0, '', 24330); -- 261104 + +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289058; -- 289058 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289056; -- 289056 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287486; -- 287486 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287484; -- 287484 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287482; -- 287482 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287409; -- 287409 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288969; -- 288969 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287408; -- 287408 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288967; -- 288967 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287400; -- 287400 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288963; -- 288963 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286294; -- 286294 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285783; -- 285783 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285755; -- 285755 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285584; -- 285584 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285583; -- 285583 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285563; -- 285563 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285562; -- 285562 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285292; -- 285292 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285041; -- 285041 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284924; -- 284924 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284473; -- 284473 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282892; -- 282892 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282528; -- 282528 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282522; -- 282522 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282489; -- 282489 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282482; -- 282482 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282472; -- 282472 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282435; -- 282435 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282230; -- 282230 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282159; -- 282159 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282139; -- 282139 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282085; -- 282085 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281827; -- 281827 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281824; -- 281824 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281823; -- 281823 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281667; -- 281667 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281723; -- 281723 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281722; -- 281722 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281721; -- 281721 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281666; -- 281666 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281665; -- 281665 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=279669; -- 279669 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=279668; -- 279668 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=278738; -- 278738 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277591; -- 277591 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277439; -- 277439 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277438; -- 277438 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277437; -- 277437 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277436; -- 277436 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277432; -- 277432 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277363; -- 277363 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277362; -- 277362 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277361; -- 277361 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277359; -- 277359 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=274435; -- 274435 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=275006; -- 275006 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=275005; -- 275005 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=276211; -- 276211 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=275004; -- 275004 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=275003; -- 275003 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270484; -- 270484 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270486; -- 270486 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270485; -- 270485 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270483; -- 270483 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269867; -- 269867 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269791; -- 269791 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269790; -- 269790 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269789; -- 269789 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269788; -- 269788 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269787; -- 269787 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269351; -- 269351 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269348; -- 269348 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264103; -- 264103 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255940; -- 255940 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255939; -- 255939 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267254; -- 267254 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257430; -- 257430 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267070; -- 267070 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267069; -- 267069 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254494; -- 254494 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254493; -- 254493 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264719; -- 264719 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264718; -- 264718 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256114; -- 256114 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256113; -- 256113 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265315; -- 265315 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265382; -- 265382 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265381; -- 265381 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264123; -- 264123 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264857; -- 264857 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263953; -- 263953 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263994; -- 263994 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263308; -- 263308 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263307; -- 263307 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263306; -- 263306 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263382; -- 263382 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263381; -- 263381 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=262631; -- 262631 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256886; -- 256886 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256968; -- 256968 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261123; -- 261123 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261122; -- 261122 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261121; -- 261121 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261120; -- 261120 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=251676; -- 251676 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260902; -- 260902 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=262536; -- 262536 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259626; -- 259626 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259625; -- 259625 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259666; -- 259666 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261751; -- 261751 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261750; -- 261750 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260009; -- 260009 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260699; -- 260699 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260678; -- 260678 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261101; -- 261101 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257047; -- 257047 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257046; -- 257046 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257045; -- 257045 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257044; -- 257044 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257043; -- 257043 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260928; -- 260928 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260068; -- 260068 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260067; -- 260067 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260066; -- 260066 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260065; -- 260065 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260199; -- 260199 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257416; -- 257416 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257324; -- 257324 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259708; -- 259708 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259707; -- 259707 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258340; -- 258340 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260077; -- 260077 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260076; -- 260076 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258345; -- 258345 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258278; -- 258278 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258984; -- 258984 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258609; -- 258609 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258608; -- 258608 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259215; -- 259215 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259204; -- 259204 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258951; -- 258951 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259099; -- 259099 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258776; -- 258776 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258816; -- 258816 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258178; -- 258178 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257774; -- 257774 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258469; -- 258469 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258299; -- 258299 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258298; -- 258298 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258443; -- 258443 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257382; -- 257382 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257381; -- 257381 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=24330 WHERE `ID`=258856; -- 258856 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258406; -- 258406 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258592; -- 258592 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258591; -- 258591 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258590; -- 258590 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258589; -- 258589 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256560; -- 256560 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256559; -- 256559 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256558; -- 256558 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256557; -- 256557 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258710; -- 258710 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258709; -- 258709 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258808; -- 258808 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258807; -- 258807 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258806; -- 258806 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258805; -- 258805 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259159; -- 259159 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258743; -- 258743 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260101; -- 260101 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257557; -- 257557 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255873; -- 255873 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258066; -- 258066 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258016; -- 258016 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258015; -- 258015 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256842; -- 256842 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256841; -- 256841 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256840; -- 256840 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257987; -- 257987 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257986; -- 257986 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257985; -- 257985 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258150; -- 258150 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257763; -- 257763 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257580; -- 257580 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257579; -- 257579 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257656; -- 257656 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257655; -- 257655 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257535; -- 257535 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257534; -- 257534 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257533; -- 257533 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257532; -- 257532 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257672; -- 257672 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257632; -- 257632 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257645; -- 257645 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257644; -- 257644 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257432; -- 257432 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257372; -- 257372 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258669; -- 258669 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258668; -- 258668 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258172; -- 258172 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257724; -- 257724 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257817; -- 257817 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257816; -- 257816 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258667; -- 258667 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258666; -- 258666 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258487; -- 258487 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258258; -- 258258 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258257; -- 258257 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257999; -- 257999 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258468; -- 258468 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255393; -- 255393 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255392; -- 255392 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257852; -- 257852 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257203; -- 257203 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257202; -- 257202 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257201; -- 257201 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257285; -- 257285 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257284; -- 257284 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257283; -- 257283 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257153; -- 257153 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257152; -- 257152 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257151; -- 257151 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257150; -- 257150 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257142; -- 257142 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257348; -- 257348 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257347; -- 257347 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257524; -- 257524 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257167; -- 257167 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256997; -- 256997 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257051; -- 257051 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256984; -- 256984 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256983; -- 256983 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257028; -- 257028 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256498; -- 256498 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256532; -- 256532 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256423; -- 256423 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252673; -- 252673 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256133; -- 256133 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254353; -- 254353 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254352; -- 254352 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254351; -- 254351 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254350; -- 254350 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255860; -- 255860 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255685; -- 255685 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255579; -- 255579 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255578; -- 255578 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255433; -- 255433 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255503; -- 255503 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254553; -- 254553 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254552; -- 254552 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254551; -- 254551 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254625; -- 254625 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254669; -- 254669 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254618; -- 254618 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254617; -- 254617 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254817; -- 254817 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254191; -- 254191 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254190; -- 254190 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254189; -- 254189 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254701; -- 254701 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254703; -- 254703 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254734; -- 254734 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254210; -- 254210 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254144; -- 254144 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254805; -- 254805 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253527; -- 253527 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255026; -- 255026 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253203; -- 253203 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254843; -- 254843 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253733; -- 253733 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253732; -- 253732 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252922; -- 252922 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252871; -- 252871 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255047; -- 255047 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255046; -- 255046 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252447; -- 252447 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252446; -- 252446 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252207; -- 252207 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=251941; -- 251941 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258951; -- 258951 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287482; -- 287482 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285783; -- 285783 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287484; -- 287484 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285755; -- 285755 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282472; -- 282472 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284473; -- 284473 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287486 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287484 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287482 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287409 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288969 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287408 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288967 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287400 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288963 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285783 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285783 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285755 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285755 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285584 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285583 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285041 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=284924 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282435 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=281824 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=277363 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=277362 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=277359 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270484 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270486 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270485 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270483 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287482 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285783 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285783 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287484 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285755 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285755 AND `Index`=0); |