diff options
| -rw-r--r-- | sql/updates/world/master/2017_07_03_01_world.sql | 222 |
1 files changed, 222 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_07_03_01_world.sql b/sql/updates/world/master/2017_07_03_01_world.sql new file mode 100644 index 00000000000..7b0574f52ed --- /dev/null +++ b/sql/updates/world/master/2017_07_03_01_world.sql @@ -0,0 +1,222 @@ +DELETE FROM `quest_template` WHERE `ID`=45405; +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 +(45405, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 142118, 0, 1, 0, 37748744, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 142118, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 6, 'Breaching the Sanctum', 'Speak with Oculeth to start the assault.', 'It is time. Valtrois is ready to destroy the barrier guarding the breach in the Sanctum. I will teleport you to the breach, then it falls on you to secure the area.$b$bTake these telemancy orbs. If you find you need support, use them to summon Withered.$b$bWe must strike before the enemy can ready new defenses. Let me know when you are ready and we will begin.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330); -- -Unknown- + +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45742; -- The Colossus of Zora +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43436; -- WANTED: Glimar Ironfist +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41444; -- Dark Leystone Deposits +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41295; -- Dreamleaf-Covered Ancient +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=40920; -- Stonebinder Bounty +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=40278; -- My Beasts's Bidding +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37974; -- Pet Battles Not Active +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37754; -- Dungeon Active +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=36017; -- Prisoner of the Mind +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=36005; -- The Scrying Game +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=36004; -- Power Unleashed +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32562; -- Imposing Threat +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32153; -- Hero Killer +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32151; -- Tower Defense +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32150; -- Supply Block +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32149; -- Resource Gathering +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32148; -- Attack! Move! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32135; -- Hero Killer +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32134; -- Hard Counter +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32132; -- Worker Harassment +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32130; -- Good Luck, Have Fun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31762; -- Crumbling Behemoth +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31758; -- Laosy Scouting +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31171; -- Tiger Palm +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=24330 WHERE `ID`=30308; -- Stone Hard Quilen +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27846; -- The Grateful Dead +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26916; -- Mastering the Arcane +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26274; -- The Arts of a Warlock +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=25295; -- Press Fire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24840; -- A Change of Heart +UPDATE `quest_template` SET `RewardBonusMoney`=30, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=2, `VerifiedBuild`=24330 WHERE `ID`=13257; -- Herald of War +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10283; -- Taretha's Diversion +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10071; -- Evisceration +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9433; -- A Dip in the Moonwell +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8980; -- Zinge's Assessment +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8564; -- Priest Training +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8461; -- [DEPRECATED]Deadwood of the North +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8421; -- The Wrong Stuff +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8401; -- Fight for Warsong Gulch +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8344; -- Windows to the Source +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7602; -- Flawless Fel Essence +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7482; -- Elven Legends +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6284; -- Arachnophobia +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6161; -- Claim Rackmore's Treasure! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5626; -- In Favor of the Light +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5203; -- [DEPRECATED]Rescue From Jaedenar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5156; -- [DEPRECATED]Verifying the Corruption +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5155; -- [DEPRECATED]Forces of Jaedenar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5082; -- [DEPRECATED]Threat of the Winterfall +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5063; -- Cap of the Scarlet Savant +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4906; -- [DEPRECATED]Further Corruption +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=4901; -- Guardians of the Altar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4881; -- Assassination Plot +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4809; -- Chillwind Horns +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4135; -- The Writhing Deep +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4101; -- [DEPRECATED]Cleansing Felwood +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3102; -- Encrypted Letter +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2756; -- The Old Ways +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2458; -- Deep Cover +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2160; -- Supplies to Tannok +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1651; -- The Tome of Valor +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1482; -- The Corrupter +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1243; -- The Missing Diplomat +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1218; -- Marsh Frog Legs +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1180; -- Goblin Sponsorship +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1124; -- Wasteland +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=1101; -- The Crone of the Kraul +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1010; -- Bathran's Hair +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=971; -- Knowledge in the Deeps +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=925; -- Cairne's Hoofprint +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=735; -- The Star, the Hand and the Heart +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=733; -- Scrounging +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=710; -- Study of the Elements: Rock +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=692; -- The Lost Fragments +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=589; -- The Singing Crystals +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=563; -- [DEPRECATED] Reassignment +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=514; -- [DEPRECATED] Letter to Stormpike +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=420; -- Senir's Observations +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=346; -- Return to Kristoff +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=328; -- The Hidden Key +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=324; -- The Lost Ingots +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=281; -- Reclaiming Goods +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=271; -- Vyrin's Revenge +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=226; -- Wolves at Our Heels +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=210; -- Krazek's Cookery +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=154; -- Return the Comb + +DELETE FROM `quest_objectives` WHERE `ID` IN (287943 /*287943*/, 287942 /*287942*/, 287941 /*287941*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(287943, 45405, 0, 2, 115112, 1, 2, 0, 0, 'Secure the breach', 24330), -- 287943 +(287942, 45405, 0, 1, 115111, 1, 2, 0, 0, 'Enter the portal', 24330), -- 287942 +(287941, 45405, 0, 0, 115110, 1, 0, 0, 0, 'Speak with Oculeth', 24330); -- 287941 + +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288404; -- 288404 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285273; -- 285273 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282384; -- 282384 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282173; -- 282173 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281751; -- 281751 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281962; -- 281962 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281376; -- 281376 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=280583; -- 280583 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=274784; -- 274784 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=274593; -- 274593 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=274516; -- 274516 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=274515; -- 274515 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270080; -- 270080 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269557; -- 269557 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269578; -- 269578 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269576; -- 269576 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269575; -- 269575 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269533; -- 269533 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269558; -- 269558 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269556; -- 269556 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269555; -- 269555 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269525; -- 269525 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269524; -- 269524 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268988; -- 268988 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268999; -- 268999 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268204; -- 268204 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268203; -- 268203 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263770; -- 263770 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264254; -- 264254 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258980; -- 258980 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258979; -- 258979 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255456; -- 255456 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255455; -- 255455 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265406; -- 265406 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255386; -- 255386 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255385; -- 255385 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259001; -- 259001 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261654; -- 261654 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=261653; -- 261653 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260016; -- 260016 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260015; -- 260015 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259754; -- 259754 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259753; -- 259753 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259752; -- 259752 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260091; -- 260091 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260090; -- 260090 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259791; -- 259791 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257768; -- 257768 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257767; -- 257767 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258601; -- 258601 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258600; -- 258600 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258599; -- 258599 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258802; -- 258802 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256206; -- 256206 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256205; -- 256205 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257269; -- 257269 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257268; -- 257268 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257267; -- 257267 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257277; -- 257277 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257276; -- 257276 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257275; -- 257275 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257274; -- 257274 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257701; -- 257701 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257700; -- 257700 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257699; -- 257699 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257462; -- 257462 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257461; -- 257461 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257460; -- 257460 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257459; -- 257459 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257458; -- 257458 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258322; -- 258322 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258321; -- 258321 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258320; -- 258320 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258319; -- 258319 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257711; -- 257711 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254463; -- 254463 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257029; -- 257029 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255476; -- 255476 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255475; -- 255475 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256012; -- 256012 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255546; -- 255546 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255428; -- 255428 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255130; -- 255130 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254781; -- 254781 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=24330 WHERE `ID`=255648; -- 255648 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254697; -- 254697 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254880; -- 254880 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254512; -- 254512 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254044; -- 254044 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254043; -- 254043 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254042; -- 254042 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255105; -- 255105 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254866; -- 254866 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254041; -- 254041 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254040; -- 254040 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254039; -- 254039 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254109; -- 254109 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253254; -- 253254 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254034; -- 254034 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253186; -- 253186 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253019; -- 253019 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253383; -- 253383 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253400; -- 253400 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252995; -- 252995 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252845; -- 252845 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252844; -- 252844 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255177; -- 255177 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=251953; -- 251953 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=287942 AND `Index`=0) OR (`ID`=287941 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(287942, 0, 6304, 24330), +(287941, 0, 6303, 24330); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288404 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=281962 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=281376 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=280583 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=274784 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=274593 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=274516 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270080 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=269578 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=269575 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=268999 AND `Index`=0); |