DB/Quests: Updated quest_template data for 7.1.5 part 3

1 files changed, 116 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_02_07_00_world.sql b/sql/updates/world/master/2017_02_07_00_world.sql
new file mode 100644
index 00000000000..7fd7d137f60
--- /dev/null
+++ b/sql/updates/world/master/2017_02_07_00_world.sql
@@ -0,0 +1,116 @@
+DELETE FROM `quest_template` WHERE `ID` IN (44560 /*-Unknown-*/, 44559 /*-Unknown-*/, 44558 /*-Unknown-*/, 44546 /*-Unknown-*/, 41008 /*-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`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES
+(44560, 2, -1, 0, 20, -376, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33558536, 0, 0, 0, 0, 0, 49927, 143542, 0, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 18875469, 0, 'Follow the Recipe', 'Collect the other parts of the Crown Chemical Company''s recipe, then return to Inspector Snip Snagglebolt in Stormwind.', 'This seems to be part of a recipe for whatever concoction the Crown Chemical Company is cooking up. The other parts must be nearby.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420), -- -Unknown-
+(44559, 2, -1, 0, 20, -376, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33558536, 0, 0, 0, 0, 0, 49927, 143542, 0, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 33555378, 0, 'Follow the Recipe', 'Collect the other parts of the Crown Chemical Company''s recipe, then return to Detective Snap Snagglebolt in Orgrimmar.', 'This seems to be part of a recipe for whatever concoction the Crown Chemical Company is cooking up. The other parts must be nearby.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420), -- -Unknown-
+(44558, 2, -1, 0, 20, -376, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 50130, 0, 1, 0, 4096, 0, 0, 0, 0, 0, 49927, 0, 0, 0, 5, 0, 0, 0, 50130, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18875469, 0, 'Crushing the Crown', 'Kill 12 Crown Chemical Co. Employees and use Snagglebolt''s Khorium Bomb to destroy a chemical wagon south of Shadowfang Keep in Silverpine Forest, then return to Inspector Snip Snagglebolt in Stormwind.', 'This ledger is full of locations, and I need you to investigate and take action, pal. This has gone on long enough.$b$bHere''s an entry I want you to check out: it''s just south of Shadowfang Keep in Silverpine Forest. That can''t be good. Get out there and rough ''em up.$b$bOh, and if you see something big and dangerous enough that it needs destroying, toss this bomb at it.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420), -- -Unknown-
+(44546, 2, -1, 0, 20, -376, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 50130, 0, 1, 0, 4096, 0, 0, 0, 0, 0, 49927, 0, 0, 0, 5, 0, 0, 0, 50130, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 33555378, 0, 'Crushing the Crown', 'Kill 12 Crown Chemical Co. Employees and use Snagglebolt''s Khorium Bomb to destroy a chemical wagon south of Shadowfang Keep in Silverpine Forest, then return to Detective Snap Snagglebolt in Orgrimmar.', 'This ledger is full of locations, and I need you to investigate and take action, pal. This has gone on long enough.$b$bHere''s an entry I want you to check out: it''s just south of Shadowfang Keep in Silverpine Forest. That can''t be good. Get out there and rough ''em up.$b$bOh, and if you see something big and dangerous enough that it needs destroying, toss this bomb at it.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420), -- -Unknown-
+(41008, 2, -1, 0, 98, -261, 107, 0, 40953, 1, 1, 0, 0, 1, 18350, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748736, 33554688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Hunter to Hunter', 'Returno the Hunter''s Reach shop in Dalaran and speak to Emmarel Shadewarden.', 'I sense the threads of fate entwined about you. Your destiny is tied to that of the ancient night elf who started you on this journey.$b$bI can send you back to the city in the sky. From there, you must begin the task of gathering allies against the ravenous darkness.$b$bFight well, $n. May Talonclaw serve you well.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23420); -- -Unknown-
+
+UPDATE `quest_template` SET `RewardBonusMoney`=11150, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=37278; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=2100, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=32583; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=3400, `VerifiedBuild`=23420 WHERE `ID`=31524; -- -Unknown-
+UPDATE `quest_template` SET `Flags`=16384, `FlagsEx`=64, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=26904; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=59000, `RewardBonusMoney`=30, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=25572; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=60, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=13377; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=11200; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=33555378, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=10493; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=18350, `VerifiedBuild`=23420 WHERE `ID`=9677; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=9471; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=137150, `VerifiedBuild`=23420 WHERE `ID`=9449; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8414; -- -Unknown-
+UPDATE `quest_template` SET `RewardMoney`=48500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=8194; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=7487; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=5127; -- -Unknown-
+UPDATE `quest_template` SET `RewardNextQuest`=0, `Flags`=540672, `FlagsEx`=64, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23420 WHERE `ID`=3099; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestDescription`='Hello, $n. I know you''re busy helping out the people of Azeroth, but when you have the time, you should return to Ironforge and speak to one of the most respected paladins of your home: Tiza Battleforge. She''s the one the younger dwarven paladins go to when it is time they learn more about the Light and what''s expected of all of us.$B$BYou can find her upstairs in the Hall of Mysteries which is located in the Mystic Ward.', `VerifiedBuild`=23420 WHERE `ID`=3000; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `VerifiedBuild`=23420 WHERE `ID`=2860; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2852; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2851; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `VerifiedBuild`=23420 WHERE `ID`=2379; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `VerifiedBuild`=23420 WHERE `ID`=2300; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=2203; -- -Unknown-
+UPDATE `quest_template` SET `RewardBonusMoney`=137150, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=1787; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=1045; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=1031; -- -Unknown-
+UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23420 WHERE `ID`=183; -- -Unknown-
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (286718 /*286718*/, 286717 /*286717*/, 286716 /*286716*/, 286715 /*286715*/, 286714 /*286714*/, 286713 /*286713*/, 286711 /*286711*/, 286710 /*286710*/, 286699 /*286699*/, 286698 /*286698*/, 261959 /*261959*/, 261958 /*261958*/, 261957 /*261957*/, 257022 /*257022*/, 257021 /*257021*/, 256380 /*256380*/, 256795 /*256795*/, 256794 /*256794*/, 256793 /*256793*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(286718, 44560, 2, 2, 259805, 1, 0, 0, 0, 'Collected 3rd Fragment', 23420), -- 286718
+(286717, 44560, 2, 1, 259804, 1, 0, 0, 0, 'Collected 2nd Fragment', 23420), -- 286717
+(286716, 44560, 2, 0, 259803, 1, 0, 0, 0, 'Collected 1st Fragment', 23420), -- 286716
+(286715, 44559, 2, 2, 259805, 1, 0, 0, 0, 'Collected 3rd Fragment', 23420), -- 286715
+(286714, 44559, 2, 1, 259804, 1, 0, 0, 0, 'Collected 2nd Fragment', 23420), -- 286714
+(286713, 44559, 2, 0, 259803, 1, 0, 0, 0, 'Collected 1st Fragment', 23420), -- 286713
+(286711, 44558, 0, 1, 114275, 12, 0, 0, 0, 'Crown Chemical Co. Employees Slain', 23420), -- 286711
+(286710, 44558, 0, 0, 38035, 1, 0, 0, 0, 'Chemical Wagon Destroyed', 23420), -- 286710
+(286699, 44546, 0, 1, 114275, 12, 0, 0, 0, 'Crown Chemical Co. Employees Slain', 23420), -- 286699
+(286698, 44546, 0, 0, 38035, 1, 0, 0, 0, 'Chemical Wagon Destroyed', 23420), -- 286698
+(261959, 10493, 8, -1, 0, 200000, 0, 0, 0, '', 23420), -- 261959
+(261958, 10493, 1, 1, 16722, 1, 0, 0, 0, '', 23420), -- 261958
+(261957, 10493, 1, 0, 22381, 15, 0, 1, 0, '', 23420), -- 261957
+(257022, 5127, 1, 1, 12806, 1, 0, 0, 0, '', 23420), -- 257022
+(257021, 5127, 1, 0, 12847, 1, 0, 1, 0, '', 23420), -- 257021
+(256380, 2860, 1, 0, 9236, 1, 0, 1, 0, '', 23420), -- 256380
+(256795, 2851, 1, 2, 8153, 2, 0, 0, 0, '', 23420), -- 256795
+(256794, 2851, 1, 1, 8197, 2, 0, 0, 0, '', 23420), -- 256794
+(256793, 2851, 1, 0, 8193, 2, 0, 0, 0, '', 23420); -- 256793
+
+UPDATE `quest_objectives` SET `Type`=14, `ObjectID`=57382, `VerifiedBuild`=23420 WHERE `ID`=284743; -- 284743
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=268195; -- 268195
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254648; -- 254648
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259869; -- 259869
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=260383; -- 260383
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=262099; -- 262099
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259931; -- 259931
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259818; -- 259818
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=260583; -- 260583
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259888; -- 259888
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259887; -- 259887
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259886; -- 259886
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=260407; -- 260407
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=258892; -- 258892
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256872; -- 256872
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256538; -- 256538
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252977; -- 252977
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252976; -- 252976
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252975; -- 252975
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252974; -- 252974
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=259159; -- 259159
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255873; -- 255873
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256634; -- 256634
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257356; -- 257356
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257355; -- 257355
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257226; -- 257226
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256778; -- 256778
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256635; -- 256635
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256824; -- 256824
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256632; -- 256632
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256293; -- 256293
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=256303; -- 256303
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=257396; -- 257396
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255714; -- 255714
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255504; -- 255504
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=255521; -- 255521
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254970; -- 254970
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254969; -- 254969
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254746; -- 254746
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254934; -- 254934
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=254034; -- 254034
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=253019; -- 253019
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=251953; -- 251953
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252408; -- 252408
+UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23420 WHERE `ID`=252275; -- 252275
+
+DELETE FROM `quest_visual_effect` WHERE (`ID`=286718 AND `Index`=0) OR (`ID`=286717 AND `Index`=0) OR (`ID`=286716 AND `Index`=0) OR (`ID`=286715 AND `Index`=0) OR (`ID`=286714 AND `Index`=0) OR (`ID`=286713 AND `Index`=0) OR (`ID`=286711 AND `Index`=1) OR (`ID`=286711 AND `Index`=0) OR (`ID`=286699 AND `Index`=1) OR (`ID`=286699 AND `Index`=0);
+INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES
+(286718, 0, 2099, 23420),
+(286717, 0, 2099, 23420),
+(286716, 0, 2099, 23420),
+(286715, 0, 2099, 23420),
+(286714, 0, 2099, 23420),
+(286713, 0, 2099, 23420),
+(286711, 1, 6126, 23420),
+(286711, 0, 6125, 23420),
+(286699, 1, 6126, 23420),
+(286699, 0, 6125, 23420);