diff options
| -rw-r--r-- | sql/updates/world/master/2017_04_21_00_world.sql | 455 |
1 files changed, 455 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_04_21_00_world.sql b/sql/updates/world/master/2017_04_21_00_world.sql new file mode 100644 index 00000000000..6e22e89e4f2 --- /dev/null +++ b/sql/updates/world/master/2017_04_21_00_world.sql @@ -0,0 +1,455 @@ +DELETE FROM `quest_template` WHERE `ID` IN (47017, 46997, 46865, 46833, 46822, 46169, 46167, 46163, 46017, 46012, 46006, 45930, 45929, 45926, 45923, 45837, 45531, 45061); +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 +(47017, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 241421, 0, 0, 0, 0, 1, 0, 35651584, 0, 0, 0, 0, 0, 147432, 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, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 6, 'Only The Best', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46997, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 240986, 0, 0, 240685, 0, 0, 0, 0, 1, 0, 39845888, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 6, 'Boon of the Command Center', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46865, 3, 110, 0, 110, 8527, 145, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193088, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2045, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5206, 0, -1, 358, 6, 'Cathedral of Eternal Night: Mother of Flame', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46833, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239862, 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, 5202, 0, -1, 340, 6, 'Nature Unshackled', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46822, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239858, 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, 5202, 0, -1, 356, 6, 'Natural Selection', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46169, 3, -1, 0, 98, 7334, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242354, 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, 1900, 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, 'Dro''zek', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46167, 3, -1, 0, 98, 7334, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242354, 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, 1900, 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, 'Kozrum', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46163, 3, -1, 0, 98, 7334, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242349, 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, 1900, 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, 'Thaz''gul', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46017, 3, -1, 0, 98, 7541, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242339, 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, 1948, 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, 'Shel''drozul', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46012, 3, -1, 0, 98, 7541, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242338, 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, 1948, 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, 'Fel Commander Urgoz', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46006, 3, -1, 0, 98, 7541, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242338, 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, 1948, 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, 'Arkuthaz', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45930, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234964, 0, 0, 0, 0, 0, 0, 37290240, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5112, 0, -1, 340, 6, 'We Didn''t Start the Fire', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45929, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234962, 0, 0, 0, 0, 0, 0, 37290240, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5112, 0, -1, 356, 6, 'Purging the Flames', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45926, 3, -1, 0, 98, 7558, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242337, 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, 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, 'Zar''teth', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45923, 3, -1, 0, 98, 7558, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242336, 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, 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, 'Gloth', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45837, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 239867, 0, 0, 0, 0, 0, 0, 37290240, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5104, 0, -1, 340, 6, 'Creeping Fel', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45531, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 239867, 0, 0, 0, 0, 0, 0, 37290240, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5104, 0, -1, 356, 6, 'Creeping Fel', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45061, 2, 110, 0, 110, -406, 107, 0, 44782, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 144457, 0, 1, 0, 38273024, 8448, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 144457, 142397, 0, 0, 1, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 6, 'Scrolls of the Faldrottin', 'Take the scrolls to the Council of the Six in Dalaran.', 'While it is definitely odd that a demon would carry a scroll of vrykul writings, what is even more interesting are the contents. \n\nThe writings appear to reference a vrykul prophesy of one who would unite the Tideskorn against the Burning Legion. This information should be brought to the Council of Six immediately.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); + +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=47202; +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=47112; +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=47097; +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=46282; +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=46275; +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=46274; +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=46272; +UPDATE `quest_template` SET `QuestSortID`=-434 WHERE `ID`=46268; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44189; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44027; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44022; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44016; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43627; +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42926; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42784; +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42757; +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42744; +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionID2`=1948, `RewardFactionValue1`=3, `RewardFactionValue2`=7, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42242; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41824; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `RewardSkillLineID`=165, `RewardNumSkillUps`=1, `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41639; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41597; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41582; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41568; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41552; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41519; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41507; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41488; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41432; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41316; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41244; +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=40279; +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=35989; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32446; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=15000, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32238; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=32223; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32221; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32197; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32158; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32157; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32156; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32154; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32139; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32138; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32007; +UPDATE `quest_template` SET `RewardBonusMoney`=3400, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=31526; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=31142; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30067; +UPDATE `quest_template` SET `Expansion`=3, `VerifiedBuild`=23911 WHERE `ID`=29118; +UPDATE `quest_template` SET `Expansion`=3, `VerifiedBuild`=23911 WHERE `ID`=27092; +UPDATE `quest_template` SET `Expansion`=3, `VerifiedBuild`=23911 WHERE `ID`=27060; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=26918; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26916; +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=24969; +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=24799; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=14011; +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13380; +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13249; +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13247; +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13241; +UPDATE `quest_template` SET `RewardFactionValue1`=2, `RewardFactionOverride1`=0, `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13004; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=12753; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10762; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10164; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10094; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9719; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9717; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9715; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9692; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9673; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9612; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9489; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9474; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9278; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=9196; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9189; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=9026; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8983; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8912; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8424; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8409; +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionValue1`=2, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8322; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8276; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7861; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7844; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7840; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7830; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7828; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7816; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7815; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7492; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7402; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7321; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7164; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7029; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6564; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6141; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6023; +UPDATE `quest_template` SET `RewardBonusMoney`=18350, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=5924; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5848; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5781; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5582; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5538; +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionValue2`=6, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=5441; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5307; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5306; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5305; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5263; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=5261; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5181; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5168; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5166; +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5121; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4866; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4862; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4729; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4681; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4241; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4024; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3824; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3639; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3563; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3513; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3117; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2995; +UPDATE `quest_template` SET `RewardBonusMoney`=91500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=2985; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2284; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1938; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1819; +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1657; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1650; +UPDATE `quest_template` SET `RewardBonusMoney`=228550, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1527; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1503; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1452; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1435; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1395; +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1387; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1369; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1282; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1218; +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1151; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1143; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1064; +UPDATE `quest_template` SET `RewardFactionValue1`=1, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=860; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=813; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=809; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=717; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=671; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=562; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=519; +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=455; +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=453; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=424; +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=419; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=381; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=364; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=299; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=294; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=293; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=262; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=240; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=157; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=155; +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=74; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=39; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42784; +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42744; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41519; +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionID2`=1948, `RewardFactionValue1`=3, `RewardFactionValue2`=7, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42242; +UPDATE `quest_template` SET `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42926; + +DELETE FROM `quest_objectives` WHERE `ID` IN (289787 /*289787*/, 289786 /*289786*/, 289748 /*289748*/, 289747 /*289747*/, 289746 /*289746*/, 289745 /*289745*/, 289744 /*289744*/, 289716 /*289716*/, 289016 /*289016*/, 289014 /*289014*/, 289010 /*289010*/, 288803 /*288803*/, 288798 /*288798*/, 288794 /*288794*/, 288759 /*288759*/, 288742 /*288742*/, 288753 /*288753*/, 288741 /*288741*/, 288738 /*288738*/, 288735 /*288735*/, 288640 /*288640*/, 288639 /*288639*/, 288637 /*288637*/, 288092 /*288092*/, 287456 /*287456*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289787, 46865, 0, 1, 116944, 1, 0, 0, 0, 'Mephistroth Slain', 23911), -- 289787 +(289786, 46865, 0, 0, 120715, 1, 0, 0, 0, 'Raga''yut Slain', 23911), -- 289786 +(289748, 46833, 0, 3, 120739, 50, 92, 0, 2, '', 23911), -- 289748 +(289747, 46833, 0, 2, 120735, 13, 92, 0, 8, 'Captured Druid freed', 23911), -- 289747 +(289746, 46833, 0, 1, 117091, 5, 92, 0, 20, '', 23911), -- 289746 +(289745, 46833, 0, 0, 120709, 20, 92, 0, 5, 'Demons slain', 23911), -- 289745 +(289744, 46833, 15, -1, 0, 1, 0, 0, 0, 'Plans disrupted', 23911), -- 289744 +(289716, 46822, 0, 0, 120546, 3, 0, 0, 0, 'Legion Portal destroyed', 23911), -- 289716 +(289016, 46169, 0, 0, 117067, 1, 1, 0, 0, '', 23911), -- 289016 +(289014, 46167, 0, 0, 117061, 1, 1, 0, 0, '', 23911), -- 289014 +(289010, 46163, 0, 0, 117068, 1, 1, 0, 0, '', 23911), -- 289010 +(288803, 46017, 0, 0, 118013, 1, 1, 0, 0, '', 23911), -- 288803 +(288798, 46012, 0, 0, 118006, 1, 1, 0, 0, '', 23911), -- 288798 +(288794, 46006, 0, 0, 117065, 1, 1, 0, 0, '', 23911), -- 288794 +(288759, 45930, 0, 1, 118323, 1, 1, 0, 0, '', 23911), -- 288759 +(288742, 45930, 0, 0, 118281, 10, 0, 0, 0, '', 23911), -- 288742 +(288753, 45929, 0, 1, 118323, 1, 1, 0, 0, '', 23911), -- 288753 +(288741, 45929, 0, 0, 118281, 10, 0, 0, 0, '', 23911), -- 288741 +(288738, 45926, 0, 0, 118017, 1, 1, 0, 0, '', 23911), -- 288738 +(288735, 45923, 0, 0, 117049, 1, 1, 0, 0, '', 23911), -- 288735 +(288640, 45837, 0, 0, 118134, 1, 3, 0, 0, '', 23911), -- 288640 +(288639, 45837, 0, 1, 118142, 15, 0, 0, 0, '', 23911), -- 288639 +(288637, 45531, 0, 0, 118134, 1, 3, 0, 0, '', 23911), -- 288637 +(288092, 45531, 0, 1, 117424, 10, 0, 0, 0, 'Legion Creep purged', 23911), -- 288092 +(287456, 45061, 0, 0, 115900, 1, 0, 0, 0, 'Go to Dalaran', 23911); -- 287456 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286370; -- 286370 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286128; -- 286128 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286122; -- 286122 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286114; -- 286114 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285564; -- 285564 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284906; -- 284906 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284905; -- 284905 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284743; -- 284743 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284742; -- 284742 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284711; -- 284711 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284710; -- 284710 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286780; -- 286780 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284675; -- 284675 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283962; -- 283962 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283961; -- 283961 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282889; -- 282889 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282604; -- 282604 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282552; -- 282552 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282537; -- 282537 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282525; -- 282525 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282506; -- 282506 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282475; -- 282475 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282457; -- 282457 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282438; -- 282438 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282371; -- 282371 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282208; -- 282208 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282103; -- 282103 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=280584; -- 280584 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=274273; -- 274273 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269823; -- 269823 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269567; -- 269567 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269619; -- 269619 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269611; -- 269611 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269541; -- 269541 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269647; -- 269647 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269646; -- 269646 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269645; -- 269645 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269832; -- 269832 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269831; -- 269831 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269644; -- 269644 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269536; -- 269536 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=269354; -- 269354 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268672; -- 268672 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268170; -- 268170 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268169; -- 268169 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251808; -- 251808 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254322; -- 254322 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265680; -- 265680 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253403; -- 253403 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253402; -- 253402 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265769; -- 265769 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265768; -- 265768 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258980; -- 258980 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258979; -- 258979 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255980; -- 255980 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255979; -- 255979 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265339; -- 265339 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265029; -- 265029 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265028; -- 265028 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264298; -- 264298 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264297; -- 264297 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264296; -- 264296 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263892; -- 263892 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264285; -- 264285 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263703; -- 263703 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263315; -- 263315 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263314; -- 263314 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263313; -- 263313 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260118; -- 260118 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255474; -- 255474 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260507; -- 260507 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257751; -- 257751 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260900; -- 260900 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257773; -- 257773 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257772; -- 257772 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257771; -- 257771 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257770; -- 257770 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260145; -- 260145 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261541; -- 261541 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262158; -- 262158 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261100; -- 261100 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261099; -- 261099 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260009; -- 260009 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260664; -- 260664 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260663; -- 260663 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260662; -- 260662 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259985; -- 259985 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259984; -- 259984 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259983; -- 259983 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=255930; -- 255930 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258860; -- 258860 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258859; -- 258859 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259673; -- 259673 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259672; -- 259672 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259301; -- 259301 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260175; -- 260175 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259277; -- 259277 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259276; -- 259276 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259367; -- 259367 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259354; -- 259354 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259030; -- 259030 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259201; -- 259201 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259325; -- 259325 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258552; -- 258552 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258551; -- 258551 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257229; -- 257229 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256130; -- 256130 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256129; -- 256129 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258782; -- 258782 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258743; -- 258743 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258291; -- 258291 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257922; -- 257922 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257921; -- 257921 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258434; -- 258434 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258433; -- 258433 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256268; -- 256268 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256634; -- 256634 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256721; -- 256721 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258672; -- 258672 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257580; -- 257580 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257579; -- 257579 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257656; -- 257656 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257655; -- 257655 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257257; -- 257257 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257256; -- 257256 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257255; -- 257255 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257254; -- 257254 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257585; -- 257585 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258701; -- 258701 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257894; -- 257894 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258166; -- 258166 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256796; -- 256796 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256019; -- 256019 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257307; -- 257307 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257306; -- 257306 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257305; -- 257305 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257012; -- 257012 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255998; -- 255998 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257051; -- 257051 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256877; -- 256877 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256876; -- 256876 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256875; -- 256875 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256066; -- 256066 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252631; -- 252631 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254255; -- 254255 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=256040; -- 256040 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255685; -- 255685 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256050; -- 256050 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256049; -- 256049 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256048; -- 256048 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255194; -- 255194 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255193; -- 255193 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255506; -- 255506 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255401; -- 255401 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255760; -- 255760 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255759; -- 255759 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255130; -- 255130 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254647; -- 254647 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255228; -- 255228 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254701; -- 254701 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254247; -- 254247 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254246; -- 254246 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254245; -- 254245 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253486; -- 253486 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253706; -- 253706 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253705; -- 253705 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253498; -- 253498 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253497; -- 253497 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253496; -- 253496 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253363; -- 253363 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253362; -- 253362 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253361; -- 253361 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253560; -- 253560 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253256; -- 253256 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253171; -- 253171 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253148; -- 253148 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253147; -- 253147 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252801; -- 252801 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252800; -- 252800 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252799; -- 252799 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252798; -- 252798 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253365; -- 253365 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253364; -- 253364 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252621; -- 252621 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252600; -- 252600 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252567; -- 252567 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251977; -- 251977 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251925; -- 251925 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284743; -- 284743 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284742; -- 284742 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286780; -- 286780 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284675; -- 284675 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282475; -- 282475 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283962; -- 283962 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=283961; -- 283961 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284906; -- 284906 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284905; -- 284905 + + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286370 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284906 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284905 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284743 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284742 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284711 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284710 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286780 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284675 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=283962 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282438 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=280584 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=274273 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269567 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269645 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269645 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269832 AND `Index`=3); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269832 AND `Index`=2); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269832 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269832 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269831 AND `Index`=3); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269831 AND `Index`=2); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269831 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269831 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269644 AND `Index`=3); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269644 AND `Index`=2); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269644 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269644 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=269536 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284743 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284742 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286780 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284675 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=283962 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284906 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284905 AND `Index`=0); |