diff options
| -rw-r--r-- | sql/updates/world/master/2017_07_15_00_world.sql | 256 |
1 files changed, 256 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_07_15_00_world.sql b/sql/updates/world/master/2017_07_15_00_world.sql new file mode 100644 index 00000000000..438fc607020 --- /dev/null +++ b/sql/updates/world/master/2017_07_15_00_world.sql @@ -0,0 +1,256 @@ +DELETE FROM `quest_template` WHERE `ID`=46502; +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 +(46502, 3, 110, 0, 110, 8524, 141, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193152, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5218, 0, -1, 16, 6, 'Tomb of Sargeras: Hand of the Legion', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 24330); -- -Unknown- + +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=47007; -- -Unknown- +UPDATE `quest_template` SET `Flags`=37290304, `VerifiedBuild`=24330 WHERE `ID`=46021; -- -Unknown- +UPDATE `quest_template` SET `Flags`=37290304, `VerifiedBuild`=24330 WHERE `ID`=45926; -- Zar'teth +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45776; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45049; -- Like the Wind +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43751; -- Oh, Ship! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43641; -- The Arcway: Wandering Plague +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43478; -- Experimental Potion: Test Subjects Needed +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43101; -- DANGER: Witchdoctor Grgl-Brgl +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42146; -- Dazed and Confused and Adorable +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41855; -- Stand Up to Bullies +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41614; -- Huge Stormrays +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41569; -- Felhide +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41555; -- Slab of Bacon +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41537; -- Lively Starlight Roses +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41523; -- Felwort +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41504; -- Leystone Basilisks +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41492; -- Brimstone Destroyer +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41446; -- Darkened Felslate Deposits +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41443; -- Ancient Leystone Deposits +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41357; -- Primordial Felslate Deposits +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41334; -- Musky Bear Hide +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41276; -- Rocket Boot Fishing +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41253; -- Migrating Highmountain Salmon +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41210; -- Brimstone Destroyer +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41185; -- The Keys to Success +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=40951; -- Bitestone Bazaar +UPDATE `quest_template` SET `Flags`=33653832 WHERE `ID`=38482; -- Platinum Tracker +UPDATE `quest_template` SET `Flags`=33653832 WHERE `ID`=37640; -- Gold Tracker +UPDATE `quest_template` SET `Flags`=33653832 WHERE `ID`=37639; -- Silver Tracker +UPDATE `quest_template` SET `Flags`=33653832 WHERE `ID`=37638; -- Bronze Tracker +UPDATE `quest_template` SET `Flags`=2182086728 WHERE `ID`=37289; -- Shadowmoon Invasion! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37278; -- A Worthy Challenge: Yalnu +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36831; -- Shadow Council Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36830; -- Shadow Council Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36653; -- Botani Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36650; -- Ogre Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36623; -- Ogre Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36414; -- Shadowmoon Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36412; -- Shadowmoon Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36376; -- Goren Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=36171; -- Botani Invasion! +UPDATE `quest_template` SET `Flags`=2182152256 WHERE `ID`=35142; -- Goren Invasion! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32565; -- Encroaching Force +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32136; -- Work Order: Fuel +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32131; -- We Require More Minerals! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31166; -- Tiger Palm +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31142; -- Palm of the Tiger +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27038; -- Missing Parts +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26947; -- A Woodsman's Training +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26207; -- The Arts of a Rogue +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24964; -- The Thrill of the Hunt +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=24330 WHERE `ID`=14448; -- Takes One to Know One +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=24330 WHERE `ID`=14447; -- Takes One to Know One +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=12918; -- Gem Perfection +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11539; -- Taking the Harbor +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9525; -- Imprisoned in the Citadel +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9441; -- Envoy to the Mag'har +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9440; -- [DEPRECATED]Little Morsels +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8740; -- Twilight Marauders +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8573; -- Champion's Battlegear +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8572; -- Veteran's Battlegear +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8548; -- Volunteer's Battlegear +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8425; -- Voodoo Feathers +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8348; -- Signet of the Dukes +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=7866; -- Outrider Basic Care Package +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7487; -- Attunement to the Core +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6605; -- A Strange One +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6567; -- The Champion of the Horde +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5727; -- Hidden Enemies +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5538; -- Mold Rhymes With... +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5527; -- A Reliquary of Purity +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5242; -- [DEPRECATED]A Final Blow +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5241; -- Uncle Carlin +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5234; -- Return to the Bulwark +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5098; -- All Along the Watchtowers +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5089; -- General Drakkisath's Command +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4982; -- Bijou's Belongings +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4761; -- Thundris Windweaver +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4061; -- The Rise of the Machines +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3905; -- Grape Manifest +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3903; -- Milly Osworth +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3884; -- Williden's Journal +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3108; -- Etched Rune +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2931; -- Castpipe's Task +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2773; -- The Mithril Kid +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2772; -- The World At Your Feet +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2771; -- A Good Head On Your Shoulders +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1920; -- Investigate the Blue Recluse +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1430; -- [DEPRECATED]Fresh Meat +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1418; -- Neeka Bloodscar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1196; -- The Sacred Flame +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1151; -- Test of Strength +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=1149; -- Test of Faith +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1123; -- Rabine Saturna +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1059; -- Reclaiming the Charred Vale +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=898; -- Free From the Hold +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=698; -- [DEPRECATED]Lack of Surplus +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=650; -- Ripple Recovery +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=444; -- Rot Hide Origins +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=439; -- Rot Hide Clues +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=243; -- Into the Field +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=225; -- The Weathered Grave +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=158; -- Zombie Juice +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=148; -- Supplies from Darkshire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43641; -- The Arcway: Wandering Plague + +DELETE FROM `quest_objectives` WHERE `ID`=289319; +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289319, 46502, 0, 0, 120012, 1, 0, 0, 0, 'Dresanoth slain', 24330); -- 289319 + +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288806; -- 288806 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288738; -- 288738 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288485; -- 288485 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=287411; -- 287411 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288972; -- 288972 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285751; -- 285751 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285914; -- 285914 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285913; -- 285913 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285586; -- 285586 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285585; -- 285585 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285053; -- 285053 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=283763; -- 283763 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282957; -- 282957 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282569; -- 282569 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282526; -- 282526 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282509; -- 282509 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282494; -- 282494 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282479; -- 282479 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282454; -- 282454 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282442; -- 282442 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282386; -- 282386 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282383; -- 282383 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282247; -- 282247 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282224; -- 282224 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282156; -- 282156 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285805; -- 285805 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282125; -- 282125 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282026; -- 282026 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282222; -- 282222 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282906; -- 282906 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282053; -- 282053 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282050; -- 282050 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281748; -- 281748 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281747; -- 281747 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281736; -- 281736 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281445; -- 281445 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281729; -- 281729 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=276065; -- 276065 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270147; -- 270147 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=269517; -- 269517 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268197; -- 268197 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268196; -- 268196 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268170; -- 268170 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268169; -- 268169 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266730; -- 266730 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266534; -- 266534 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266533; -- 266533 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265944; -- 265944 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265943; -- 265943 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265651; -- 265651 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265650; -- 265650 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264611; -- 264611 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264610; -- 264610 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264609; -- 264609 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=262840; -- 262840 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=262839; -- 262839 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=262838; -- 262838 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257173; -- 257173 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255813; -- 255813 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255812; -- 255812 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255811; -- 255811 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255810; -- 255810 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260978; -- 260978 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260977; -- 260977 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260976; -- 260976 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259359; -- 259359 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259358; -- 259358 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259357; -- 259357 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259356; -- 259356 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259355; -- 259355 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258827; -- 258827 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258826; -- 258826 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258825; -- 258825 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258824; -- 258824 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257239; -- 257239 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257238; -- 257238 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257237; -- 257237 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257236; -- 257236 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259888; -- 259888 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259887; -- 259887 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259886; -- 259886 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257571; -- 257571 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256872; -- 256872 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257922; -- 257922 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257921; -- 257921 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258226; -- 258226 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258327; -- 258327 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258326; -- 258326 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258325; -- 258325 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257560; -- 257560 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257366; -- 257366 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257365; -- 257365 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257364; -- 257364 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257363; -- 257363 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257485; -- 257485 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256838; -- 256838 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258355; -- 258355 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258335; -- 258335 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258217; -- 258217 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256542; -- 256542 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252322; -- 252322 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252321; -- 252321 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256214; -- 256214 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256213; -- 256213 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256083; -- 256083 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256082; -- 256082 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256100; -- 256100 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256099; -- 256099 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256098; -- 256098 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255538; -- 255538 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254736; -- 254736 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254647; -- 254647 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254264; -- 254264 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255679; -- 255679 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255616; -- 255616 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255043; -- 255043 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285586; -- 285586 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285585; -- 285585 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=289319 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(289319, 0, 2101, 24330); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288485 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288485 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=287411 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288972 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285586 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285585 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285053 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282569 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282442 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282026 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282222 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282053 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282050 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282050 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=270147 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=269517 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285586 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285585 AND `Index`=0); |