diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_04_23_00_world.sql | 262 |
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); |