DB/Quests: Updated quest_template data for 7.2.0 part 6

1 files changed, 262 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_04_23_00_world.sql b/sql/updates/world/master/2017_04_23_00_world.sql
new file mode 100644
index 00000000000..6927e50fce2
--- /dev/null
+++ b/sql/updates/world/master/2017_04_23_00_world.sql
@@ -0,0 +1,262 @@
+DELETE FROM `quest_template` WHERE `ID`=45694;
+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
+(45694, 3, 110, 0, 110, 7796, 109, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239067, 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, 5084, 0, -1, 339, 6, 'Arachnicide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911);
+
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=45741;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=45737;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44292;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43624;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43623;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43429;
+UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42939;
+UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41931;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41534;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41532;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41461;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41291;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41093;
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32236;
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32199;
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32141;
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32140;
+UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=31306;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26947;
+UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=25561;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=24843;
+UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=24784;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=14355;
+UPDATE `quest_template` SET `RewardSpell`=0, `Flags`=2637824, `FlagsEx`=64, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=14013;
+UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13158;
+UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=11164;
+UPDATE `quest_template` SET `QuestPackageID`=1486, `RewardBonusMoney`=0, `RewardChoiceItemID1`=0, `RewardChoiceItemID2`=0, `RewardChoiceItemQuantity1`=0, `RewardChoiceItemQuantity2`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=512, `Expansion`=1, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=10549;
+UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9434;
+UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9429;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8921;
+UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8437;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8427;
+UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=8344;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8332;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8297;
+UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8286;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8151;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7789;
+UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7642;
+UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7637;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7582;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7581;
+UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7499;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7461;
+UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionValue2`=7, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=7363;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7165;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6548;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6481;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5660;
+UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=5633;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5625;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5624;
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=5466;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5342;
+UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5321;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5102;
+UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4771;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4284;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4146;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3786;
+UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=3641;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3561;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3542;
+UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=3524;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3113;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2998;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2941;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2359;
+UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2339;
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=2238;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2138;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2038;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1960;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1959;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1885;
+UPDATE `quest_template` SET `RewardBonusMoney`=18350, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1818;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1716;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1653;
+UPDATE `quest_template` SET `RewardBonusMoney`=182850, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=1644;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1510;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1509;
+UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1394;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1362;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1322;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1242;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1160;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1138;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1108;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1016;
+UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=944;
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=920;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=736;
+UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=731;
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=728;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=692;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=630;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=528;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=502;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=456;
+UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=440;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=425;
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=219;
+UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=148;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41093;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41532;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41291;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43623;
+UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43624;
+UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7637;
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (288353 /*288353*/, 288347 /*288347*/, 288346 /*288346*/, 288345 /*288345*/, 261953 /*261953*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(288353, 45694, 1, 3, 143856, 30, 0, 1, 0, '', 23911), -- 288353
+(288347, 45694, 0, 2, 117352, 1, 1, 0, 0, '', 23911), -- 288347
+(288346, 45694, 0, 1, 117351, 1, 1, 0, 0, '', 23911), -- 288346
+(288345, 45694, 0, 0, 117350, 1, 1, 0, 0, '', 23911), -- 288345
+(261953, 10549, 1, 0, 30503, 1, 0, 1, 0, '', 23911); -- 261953
+
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288403; -- 288403
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288399; -- 288399
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286528; -- 286528
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285561; -- 285561
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285560; -- 285560
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285257; -- 285257
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283115; -- 283115
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282491; -- 282491
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282489; -- 282489
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282409; -- 282409
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282169; -- 282169
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281827; -- 281827
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269769; -- 269769
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269565; -- 269565
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269543; -- 269543
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269540; -- 269540
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268495; -- 268495
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268494; -- 268494
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268493; -- 268493
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266534; -- 266534
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=266533; -- 266533
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265665; -- 265665
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264916; -- 264916
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264915; -- 264915
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265509; -- 265509
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265508; -- 265508
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257281; -- 257281
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257280; -- 257280
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257279; -- 257279
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257278; -- 257278
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264654; -- 264654
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264653; -- 264653
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256886; -- 256886
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260017; -- 260017
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260874; -- 260874
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=260873; -- 260873
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260872; -- 260872
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260871; -- 260871
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260870; -- 260870
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259946; -- 259946
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260452; -- 260452
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257768; -- 257768
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257767; -- 257767
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256210; -- 256210
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256209; -- 256209
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256839; -- 256839
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258340; -- 258340
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259376; -- 259376
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259230; -- 259230
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259229; -- 259229
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259228; -- 259228
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259227; -- 259227
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259226; -- 259226
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258951; -- 258951
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259102; -- 259102
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259248; -- 259248
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258611; -- 258611
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255713; -- 255713
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255712; -- 255712
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257802; -- 257802
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259251; -- 259251
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259206; -- 259206
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259205; -- 259205
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258530; -- 258530
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258529; -- 258529
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257548; -- 257548
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257315; -- 257315
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255669; -- 255669
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255961; -- 255961
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258094; -- 258094
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257632; -- 257632
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258504; -- 258504
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258639; -- 258639
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258638; -- 258638
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258637; -- 258637
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258636; -- 258636
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258258; -- 258258
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258257; -- 258257
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255847; -- 255847
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257515; -- 257515
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257514; -- 257514
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257513; -- 257513
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257604; -- 257604
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257332; -- 257332
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257506; -- 257506
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256341; -- 256341
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256873; -- 256873
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256328; -- 256328
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256327; -- 256327
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256220; -- 256220
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256219; -- 256219
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256218; -- 256218
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256217; -- 256217
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256272; -- 256272
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256580; -- 256580
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256579; -- 256579
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256578; -- 256578
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256577; -- 256577
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256059; -- 256059
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256058; -- 256058
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256057; -- 256057
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253628; -- 253628
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255676; -- 255676
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=255370; -- 255370
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255407; -- 255407
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254820; -- 254820
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254787; -- 254787
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254765; -- 254765
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254764; -- 254764
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254103; -- 254103
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254360; -- 254360
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254359; -- 254359
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254358; -- 254358
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=254545; -- 254545
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254041; -- 254041
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254040; -- 254040
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254039; -- 254039
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253562; -- 253562
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253835; -- 253835
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255026; -- 255026
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253703; -- 253703
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253702; -- 253702
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253207; -- 253207
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253420; -- 253420
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281827; -- 281827
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282489; -- 282489
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282169; -- 282169
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285560; -- 285560
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285561; -- 285561
+UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258951; -- 258951
+
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=288403 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=288399 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282169 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269565 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269540 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268495 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268494 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=268493 AND `Index`=0);
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282169 AND `Index`=0);