diff options
| author | vincent-michael <vincent_michael@gmx.de> | 2016-11-14 18:32:47 +0100 |
|---|---|---|
| committer | vincent-michael <vincent_michael@gmx.de> | 2016-11-14 18:33:02 +0100 |
| commit | dc11efd9b4232a5fd815c7680b64be579a2b3de4 (patch) | |
| tree | b94350b39523a666e748f944d32161fec4466355 | |
| parent | 0f7b9c67f35f2d61446aebbcef48497afb321651 (diff) | |
DB/Quests: Updated quest_template data for 7.1.0 part 4
| -rw-r--r-- | sql/updates/world/master/2016_11_14_01_world.sql | 161 |
1 files changed, 161 insertions, 0 deletions
diff --git a/sql/updates/world/master/2016_11_14_01_world.sql b/sql/updates/world/master/2016_11_14_01_world.sql new file mode 100644 index 00000000000..bd23a3176bd --- /dev/null +++ b/sql/updates/world/master/2016_11_14_01_world.sql @@ -0,0 +1,161 @@ +DELETE FROM `quest_template` WHERE `ID`=42441; +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 +(42441, 2, -1, 0, 98, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'zzzREUSEMEzzz', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22995); -- -Unknown- + +UPDATE `quest_template` SET `QuestSortID`=7541 WHERE `ID`=44943; -- -Unknown- +UPDATE `quest_template` SET `StartItem`=142210 WHERE `ID`=44767; -- -Unknown- +UPDATE `quest_template` SET `Flags`=33554440, `FlagsEx`=0 WHERE `ID`=44734; -- -Unknown- +UPDATE `quest_template` SET `AreaGroupID`=5054 WHERE `ID`=43807; -- -Unknown- +UPDATE `quest_template` SET `Flags`=33554432 WHERE `ID`=43750; -- -Unknown- +UPDATE `quest_template` SET `RewardXPMultiplier`=2.5 WHERE `ID`=42903; -- -Unknown- +UPDATE `quest_template` SET `RewardXPMultiplier`=2.5 WHERE `ID`=42901; -- -Unknown- +UPDATE `quest_template` SET `Flags`=33554432 WHERE `ID`=42193; -- -Unknown- +UPDATE `quest_template` SET `Flags`=33554432 WHERE `ID`=40883; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1400, `VerifiedBuild`=22995 WHERE `ID`=39523; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1400, `VerifiedBuild`=22995 WHERE `ID`=39520; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=11150, `VerifiedBuild`=22995 WHERE `ID`=37279; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=11150, `VerifiedBuild`=22995 WHERE `ID`=37275; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=11150, `VerifiedBuild`=22995 WHERE `ID`=37263; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=32446; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=32236; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=32154; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=32141; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=170, `VerifiedBuild`=22995 WHERE `ID`=32140; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=30342; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=30341; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=30339; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=1700, `VerifiedBuild`=22995 WHERE `ID`=30265; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=94000, `RewardBonusMoney`=525, `Flags`=65672, `VerifiedBuild`=22995 WHERE `ID`=27588; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=59000, `RewardBonusMoney`=30, `VerifiedBuild`=22995 WHERE `ID`=25787; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=97000, `RewardBonusMoney`=91500, `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=25295; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `VerifiedBuild`=22995 WHERE `ID`=24874; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `VerifiedBuild`=22995 WHERE `ID`=24873; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=120, `VerifiedBuild`=22995 WHERE `ID`=24798; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=30, `VerifiedBuild`=22995 WHERE `ID`=13347; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `VerifiedBuild`=22995 WHERE `ID`=13255; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=180, `VerifiedBuild`=22995 WHERE `ID`=13254; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=11207; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=11174; -- -Unknown- +UPDATE `quest_template` SET `AllowableRaces`=33555378, `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=8916; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `VerifiedBuild`=22995 WHERE `ID`=8373; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=8235; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=182850, `VerifiedBuild`=22995 WHERE `ID`=7582; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=274350, `VerifiedBuild`=22995 WHERE `ID`=7581; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=7509; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `VerifiedBuild`=22995 WHERE `ID`=7507; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `VerifiedBuild`=22995 WHERE `ID`=6601; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=5648; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=5621; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `QuestDescription`='There is but one task remaining, $n. Confront the lich, Ras Frostwhisper, in his lair.$B$BUse the power of the keepsake against the beast - be unrelenting in your actions! Weather the blows that the flailing beast will surely bring down upon you. Do not give in to the pain!$B$BWhen the ritual is complete, Ras will be mortal once more. It is at that point that he must be slain. Strike him down and take his human head.', `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=5466; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=5051; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=7500, `RewardMoneyDifficulty`=5, `RewardBonusMoney`=0, `VerifiedBuild`=22995 WHERE `ID`=3402; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=3372; -- -Unknown- +UPDATE `quest_template` SET `RewardNextQuest`=0, `Flags`=540672, `FlagsEx`=64, `VerifiedBuild`=22995 WHERE `ID`=3096; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `AllowableRaces`=-1, `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=1710; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=0, `AllowableRaces`=-1, `QuestDescription`='I want to try Furen Longbeard''s new techniques on my own piece of armor. And because you helped Furen and he helped me, you''re welcome to the armor after I make it!$B$BTo finish the piece, I need a special coral, searing coral. It grows in only one place--along the coast south of Menethil Harbor in the Wetlands.$B$BBring me enough searing coral and I''ll get right to work on the armor. And hurry, $n. I''m so eager to get started it''s making my toes twist!', `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=1708; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=18350, `VerifiedBuild`=22995 WHERE `ID`=1687; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=194000, `RewardBonusMoney`=182850, `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=1658; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=18350, `VerifiedBuild`=22995 WHERE `ID`=1558; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `VerifiedBuild`=22995 WHERE `ID`=1508; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=137150, `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=1473; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=1396; -- -Unknown- +UPDATE `quest_template` SET `QuestCompletionLog`='', `VerifiedBuild`=22995 WHERE `ID`=717; -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID`=256030; +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(256030, 1708, 1, 0, 6848, 20, 0, 1, 0, '', 22995); -- 256030 + +UPDATE `quest_objectives` SET `Type`=14, `ObjectID`=56942 WHERE `ID`=287285; -- 287285 +UPDATE `quest_objectives` SET `Type`=14, `ObjectID`=56940 WHERE `ID`=286901; -- 286901 +UPDATE `quest_objectives` SET `Amount`=50 WHERE `ID`=283186; -- 283186 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=269823; -- 269823 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=269540; -- 269540 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=268096; -- 268096 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=268108; -- 268108 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=265544; -- 265544 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=263659; -- 263659 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=264217; -- 264217 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=263953; -- 263953 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=263032; -- 263032 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=260644; -- 260644 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257896; -- 257896 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=253034; -- 253034 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=252595; -- 252595 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=260093; -- 260093 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=260567; -- 260567 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=259041; -- 259041 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=259149; -- 259149 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257292; -- 257292 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=260322; -- 260322 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=259367; -- 259367 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=259538; -- 259538 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=259102; -- 259102 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=259248; -- 259248 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=259183; -- 259183 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257442; -- 257442 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257586; -- 257586 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257228; -- 257228 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256897; -- 256897 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=258530; -- 258530 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=258823; -- 258823 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=258743; -- 258743 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255669; -- 255669 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257643; -- 257643 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=258277; -- 258277 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=258487; -- 258487 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257781; -- 257781 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257166; -- 257166 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256942; -- 256942 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257308; -- 257308 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256880; -- 256880 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256569; -- 256569 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256470; -- 256470 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256315; -- 256315 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=257011; -- 257011 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256348; -- 256348 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256347; -- 256347 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255993; -- 255993 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255992; -- 255992 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255991; -- 255991 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256220; -- 256220 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256219; -- 256219 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256218; -- 256218 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256217; -- 256217 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256198; -- 256198 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255916; -- 255916 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254145; -- 254145 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256015; -- 256015 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255259; -- 255259 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256022; -- 256022 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256112; -- 256112 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256111; -- 256111 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256050; -- 256050 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256049; -- 256049 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=256048; -- 256048 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255625; -- 255625 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255424; -- 255424 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255827; -- 255827 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254971; -- 254971 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254512; -- 254512 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254653; -- 254653 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=266968; -- 266968 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254198; -- 254198 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255075; -- 255075 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254360; -- 254360 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254359; -- 254359 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254358; -- 254358 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254247; -- 254247 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254246; -- 254246 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=254245; -- 254245 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=253531; -- 253531 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=253263; -- 253263 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=253273; -- 253273 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=255378; -- 255378 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=252817; -- 252817 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=251778; -- 251778 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=252600; -- 252600 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=252633; -- 252633 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=252570; -- 252570 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=252862; -- 252862 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=251847; -- 251847 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=22995 WHERE `ID`=251941; -- 251941 |