diff options
author | vincent-michael <vincent_michael@gmx.de> | 2017-04-17 17:07:36 +0200 |
---|---|---|
committer | vincent-michael <vincent_michael@gmx.de> | 2017-04-17 17:07:36 +0200 |
commit | a39cec29a375906ed46b75cdbff14f67876b105a (patch) | |
tree | bd1c2c85050da5a14b307da800032531fc34e4d7 /sql | |
parent | 6d85dab6f524c1e15afaaa1b9f71f41f298cc42c (diff) |
DB/Quests: Updated quest_template data for 7.2.0 part 2
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2017_04_17_00_world.sql | 598 |
1 files changed, 598 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_04_17_00_world.sql b/sql/updates/world/master/2017_04_17_00_world.sql new file mode 100644 index 00000000000..b0eb670375e --- /dev/null +++ b/sql/updates/world/master/2017_04_17_00_world.sql @@ -0,0 +1,598 @@ +DELETE FROM `quest_template` WHERE `ID` IN (46829 /*-Unknown-*/, 46817 /*-Unknown-*/, 46190 /*-Unknown-*/, 46188 /*-Unknown-*/, 45804 /*-Unknown-*/, 45358 /*-Unknown-*/, 45178 /*-Unknown-*/, 29878 /*-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 +(46829, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 240491, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5204, 0, -1, 340, 6, 'Elemental Abuse', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46817, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 240283, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5204, 0, -1, 356, 6, 'Infernal Downfall', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46190, 3, -1, 0, 98, 7503, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242342, 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, 'Ulgrom', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46188, 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, 'Orgrokk', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45804, 3, -1, 0, 98, 7558, 139, 0, 0, 5, 4, 0, 0, 0, 0, 0, 0, 0, 234448, 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, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 334, 6, 'Impvasion!', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45358, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 239035, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5125, 0, -1, 356, 6, 'Contagion Containment', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45178, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 239035, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5125, 0, -1, 340, 6, 'Contagion Containment', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(29878, 2, 86, 0, 85, 5785, 0, 0, 29880, 5, 1, 0, 0, 1, 525, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 65544, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 52430847, 0, 4, 'Building a Better Hozen Trap', 'Collect 8 Slickies and 8 Intact Pottery Jars from Lake Kittitata.', 'One thing is now painfully clear. The Hozen love their ''slickies''.$b$bWhile deep in your meditative trance, scattered images and impressions came to your mind. Now fully awake, you struggle to make sense of the experience.$b$bThe beginnings of an absurd plan begin to take shape in your head. It might just be crazy enough to work...', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown- + +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=45675; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=45047; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44305; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44187; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44013; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43804; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43628; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43619; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardArtifactXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43346; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43101; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42806; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42796; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=20000, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42106; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41948; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41866; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `RewardSkillLineID`=333, `RewardNumSkillUps`=1, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41669; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41572; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41556; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41525; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41252; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41185; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41090; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41024; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37792; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37752; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37750; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37278; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37263; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=36017; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=40000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32676; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32585; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32152; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=3400, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32002; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=31151; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=30989; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=3, `VerifiedBuild`=23911 WHERE `ID`=28807; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=27307; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=3, `VerifiedBuild`=23911 WHERE `ID`=27072; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=3, `VerifiedBuild`=23911 WHERE `ID`=27038; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=27027; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26985; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26974; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=26970; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=26945; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=26915; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=25572; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=25249; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=24840; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=24533; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=24531; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=24494; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13252; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13246; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13240; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13099; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13097; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13002; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=11492; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10169; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9723; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9678; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9664; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9639; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9633; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=17500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=9446; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9443; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9439; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9063; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8746; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8462; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8366; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8365; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8229; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8228; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7862; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7850; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7849; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7845; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=7796; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7729; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7728; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7727; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7724; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7723; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7722; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7701; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=7504; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7498; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7489; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7481; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7441; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7067; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6963; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6395; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=6127; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=6029; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5727; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5721; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=55, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=5650; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5646; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5527; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5282; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5242; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=5219; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5214; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5212; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5165; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5128; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5065; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5056; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5050; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4987; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4976; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=4968; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4865; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4812; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4811; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4781; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4763; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4762; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4741; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4738; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4521; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4495; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionValue2`=7, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=4402; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4300; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4101; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3902; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3790; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3564; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3501; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3104; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3095; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2975; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2966; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2946; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2927; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2862; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2761; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2681; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2521; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2258; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2241; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2098; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1963; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1956; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1920; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1883; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1825; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1824; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1802; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1702; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1701; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=2, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1656; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1502; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1498; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1488; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1467; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1444; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1430; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1426; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1423; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1419; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1238; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1179; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1147; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1135; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1126; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1077; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1033; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1025; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1024; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1007; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=993; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=984; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=982; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=977; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=966; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=957; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=956; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=950; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=948; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=916; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=1, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=892; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=853; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=816; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=812; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=789; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=776; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=763; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=759; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=756; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=750; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=721; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=719; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=718; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=716; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=711; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=701; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=697; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=661; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=650; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionValue2`=-3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=603; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=581; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=542; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=525; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=524; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=523; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=513; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=467; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=464; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=461; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=459; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=457; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=454; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=437; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=430; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=422; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=421; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=418; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=360; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=324; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=307; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=284; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=277; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=276; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=222; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=211; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=159; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=152; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=136; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=119; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=104; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=90; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=57; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=14; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41525; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43619; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43628; -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (289715 /*289715*/, 289709 /*289709*/, 289708 /*289708*/, 289707 /*289707*/, 289689 /*289689*/, 289688 /*289688*/, 289687 /*289687*/, 289061 /*289061*/, 289059 /*289059*/, 289392 /*289392*/, 288597 /*288597*/, 288601 /*288601*/, 288596 /*288596*/, 288595 /*288595*/, 289345 /*289345*/, 289344 /*289344*/, 289343 /*289343*/, 289342 /*289342*/, 289341 /*289341*/, 289340 /*289340*/, 289338 /*289338*/, 289347 /*289347*/, 289346 /*289346*/, 252746 /*252746*/, 252745 /*252745*/, 257009 /*257009*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289715, 46829, 1, 3, 147283, 3, 0, 1, 0, '', 23911), -- 289715 +(289709, 46829, 1, 2, 147284, 3, 0, 1, 0, '', 23911), -- 289709 +(289708, 46829, 1, 1, 147285, 3, 0, 1, 0, '', 23911), -- 289708 +(289707, 46829, 1, 0, 147286, 3, 0, 1, 0, '', 23911), -- 289707 +(289689, 46817, 0, 2, 120399, 1, 0, 0, 0, 'Third Infernal ritual stopped', 23911), -- 289689 +(289688, 46817, 0, 1, 120398, 1, 0, 0, 0, 'Second Infernal ritual stopped', 23911), -- 289688 +(289687, 46817, 0, 0, 120283, 1, 0, 0, 0, 'First Infernal ritual stopped', 23911), -- 289687 +(289061, 46190, 0, 0, 117967, 1, 1, 0, 0, '', 23911), -- 289061 +(289059, 46188, 0, 0, 117053, 1, 1, 0, 0, '', 23911), -- 289059 +(289392, 45804, 0, 3, 120116, 1, 28, 0, 0, '', 23911), -- 289392 +(288597, 45804, 0, 1, 118066, 1, 0, 0, 0, '', 23911), -- 288597 +(288601, 45804, 0, 2, 118078, 20, 92, 0, 5, '', 23911), -- 288601 +(288596, 45804, 0, 0, 118077, 25, 92, 0, 4, '', 23911), -- 288596 +(288595, 45804, 15, -1, 0, 1, 0, 0, 0, 'Imps slain', 23911), -- 288595 +(289345, 45358, 0, 6, 120059, 1, 28, 0, 0, '', 23911), -- 289345 +(289344, 45358, 0, 5, 120058, 1, 28, 0, 0, '', 23911), -- 289344 +(289343, 45358, 0, 4, 120057, 1, 28, 0, 0, '', 23911), -- 289343 +(289342, 45358, 0, 3, 120056, 1, 28, 0, 0, '', 23911), -- 289342 +(289341, 45358, 0, 2, 120055, 1, 28, 0, 0, '', 23911), -- 289341 +(289340, 45358, 2, 1, 268517, 5, 0, 0, 0, 'Fel Spreaders destroyed', 23911), -- 289340 +(289338, 45358, 0, 0, 120051, 8, 0, 0, 0, 'Legionfall Fighters cured', 23911), -- 289338 +(289347, 45178, 0, 1, 120068, 1, 1, 0, 0, '', 23911), -- 289347 +(289346, 45178, 2, 0, 267224, 12, 0, 0, 0, 'Fel-Corrupted Eggs destroyed', 23911), -- 289346 +(252746, 29878, 1, 1, 75212, 8, 0, 1, 0, '', 23911), -- 252746 +(252745, 29878, 1, 0, 75202, 8, 0, 1, 0, '', 23911), -- 252745 +(257009, 7796, 1, 0, 14047, 20, 0, 0, 0, '', 23911); -- 257009 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288329; -- 288329 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=287409; -- 287409 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288969; -- 288969 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286554; -- 286554 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286369; -- 286369 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286112; -- 286112 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285824; -- 285824 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285565; -- 285565 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285556; -- 285556 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285222; -- 285222 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285053; -- 285053 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284781; -- 284781 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284767; -- 284767 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286134; -- 286134 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286146; -- 286146 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283175; -- 283175 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282984; -- 282984 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282983; -- 282983 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282634; -- 282634 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282529; -- 282529 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282510; -- 282510 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282482; -- 282482 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282120; -- 282120 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282222; -- 282222 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282906; -- 282906 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282053; -- 282053 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282050; -- 282050 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281824; -- 281824 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281823; -- 281823 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281667; -- 281667 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281723; -- 281723 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281722; -- 281722 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281721; -- 281721 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281666; -- 281666 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281665; -- 281665 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=276875; -- 276875 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=276065; -- 276065 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=276037; -- 276037 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=274784; -- 274784 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270253; -- 270253 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270252; -- 270252 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270112; -- 270112 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269618; -- 269618 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269574; -- 269574 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269349; -- 269349 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268178; -- 268178 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268177; -- 268177 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267905; -- 267905 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264859; -- 264859 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266432; -- 266432 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266730; -- 266730 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255940; -- 255940 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255939; -- 255939 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257430; -- 257430 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259998; -- 259998 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259997; -- 259997 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253521; -- 253521 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253520; -- 253520 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266222; -- 266222 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266221; -- 266221 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265105; -- 265105 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265104; -- 265104 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255386; -- 255386 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255385; -- 255385 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266386; -- 266386 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266385; -- 266385 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266580; -- 266580 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266579; -- 266579 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267636; -- 267636 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264731; -- 264731 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263994; -- 263994 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263615; -- 263615 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263308; -- 263308 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263307; -- 263307 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263306; -- 263306 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262631; -- 262631 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252509; -- 252509 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262287; -- 262287 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262286; -- 262286 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262285; -- 262285 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262284; -- 262284 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262283; -- 262283 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261989; -- 261989 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261052; -- 261052 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261051; -- 261051 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261050; -- 261050 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261049; -- 261049 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262536; -- 262536 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259666; -- 259666 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259649; -- 259649 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259648; -- 259648 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258549; -- 258549 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255806; -- 255806 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255805; -- 255805 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255804; -- 255804 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255803; -- 255803 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255649; -- 255649 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259020; -- 259020 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259019; -- 259019 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259018; -- 259018 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259017; -- 259017 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258984; -- 258984 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258609; -- 258609 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258608; -- 258608 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259259; -- 259259 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259258; -- 259258 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259161; -- 259161 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259160; -- 259160 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259576; -- 259576 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258988; -- 258988 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258747; -- 258747 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259134; -- 259134 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258954; -- 258954 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258465; -- 258465 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258950; -- 258950 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258776; -- 258776 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258816; -- 258816 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259110; -- 259110 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257590; -- 257590 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253985; -- 253985 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258935; -- 258935 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258757; -- 258757 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257863; -- 257863 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258226; -- 258226 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256595; -- 256595 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258327; -- 258327 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258326; -- 258326 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258325; -- 258325 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257296; -- 257296 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257295; -- 257295 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257323; -- 257323 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257400; -- 257400 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257879; -- 257879 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257878; -- 257878 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257877; -- 257877 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257876; -- 257876 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256910; -- 256910 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257645; -- 257645 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257644; -- 257644 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257653; -- 257653 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257797; -- 257797 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=257227; -- 257227 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257033; -- 257033 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257100; -- 257100 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256168; -- 256168 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258870; -- 258870 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253445; -- 253445 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253288; -- 253288 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258731; -- 258731 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258597; -- 258597 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258596; -- 258596 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258496; -- 258496 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258277; -- 258277 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254463; -- 254463 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258189; -- 258189 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257030; -- 257030 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257127; -- 257127 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256568; -- 256568 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256752; -- 256752 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256527; -- 256527 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256526; -- 256526 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256525; -- 256525 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=256768; -- 256768 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256745; -- 256745 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256422; -- 256422 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256230; -- 256230 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256229; -- 256229 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255927; -- 255927 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255926; -- 255926 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255925; -- 255925 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255924; -- 255924 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256477; -- 256477 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256119; -- 256119 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256118; -- 256118 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256117; -- 256117 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256053; -- 256053 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256395; -- 256395 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256394; -- 256394 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256393; -- 256393 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256296; -- 256296 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256090; -- 256090 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256100; -- 256100 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256099; -- 256099 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256098; -- 256098 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=256346; -- 256346 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255881; -- 255881 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255880; -- 255880 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255714; -- 255714 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255591; -- 255591 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255590; -- 255590 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255589; -- 255589 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255588; -- 255588 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254145; -- 254145 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255711; -- 255711 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255859; -- 255859 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255858; -- 255858 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=255433; -- 255433 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255538; -- 255538 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257961; -- 257961 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257960; -- 257960 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257959; -- 257959 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255700; -- 255700 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255715; -- 255715 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255233; -- 255233 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254826; -- 254826 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254553; -- 254553 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254552; -- 254552 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254551; -- 254551 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254882; -- 254882 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254829; -- 254829 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=254486; -- 254486 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254971; -- 254971 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255384; -- 255384 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255383; -- 255383 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255382; -- 255382 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255381; -- 255381 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254696; -- 254696 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254825; -- 254825 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254625; -- 254625 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254909; -- 254909 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254668; -- 254668 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254667; -- 254667 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254598; -- 254598 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254817; -- 254817 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254610; -- 254610 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254320; -- 254320 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=254361; -- 254361 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254408; -- 254408 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254653; -- 254653 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254752; -- 254752 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254587; -- 254587 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254703; -- 254703 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254534; -- 254534 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255076; -- 255076 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254367; -- 254367 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254482; -- 254482 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254307; -- 254307 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254306; -- 254306 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254734; -- 254734 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254210; -- 254210 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254256; -- 254256 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255197; -- 255197 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253531; -- 253531 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253889; -- 253889 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=254124; -- 254124 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254023; -- 254023 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253295; -- 253295 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253816; -- 253816 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253502; -- 253502 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253229; -- 253229 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253924; -- 253924 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255008; -- 255008 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254973; -- 254973 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253272; -- 253272 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253271; -- 253271 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253270; -- 253270 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255202; -- 255202 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255201; -- 255201 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255155; -- 255155 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255154; -- 255154 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254888; -- 254888 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253319; -- 253319 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253098; -- 253098 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253745; -- 253745 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253400; -- 253400 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252875; -- 252875 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252871; -- 252871 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255047; -- 255047 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255046; -- 255046 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252641; -- 252641 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252640; -- 252640 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252467; -- 252467 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252496; -- 252496 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252565; -- 252565 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252564; -- 252564 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252563; -- 252563 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252562; -- 252562 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255369; -- 255369 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254996; -- 254996 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251670; -- 251670 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251669; -- 251669 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252255; -- 252255 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252254; -- 252254 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251612; -- 251612 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251611; -- 251611 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251610; -- 251610 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282482; -- 282482 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285556; -- 285556 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285565; -- 285565 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=288597 AND `Index`=0) OR (`ID`=289340 AND `Index`=0) OR (`ID`=289338 AND `Index`=1) OR (`ID`=289338 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(288597, 0, 6761, 23911), +(289340, 0, 7086, 23911), +(289338, 1, 7085, 23911), +(289338, 0, 7084, 23911); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=288329 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=287409 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=288969 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286369 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285222 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285053 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284781 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286134 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286146 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=283175 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282120 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282222 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282053 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282050 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282050 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=281824 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=274784 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270253 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270252 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270252 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270112 AND `Index`=0); |