diff options
| -rw-r--r-- | sql/updates/world/master/2017_07_06_00_world.sql | 237 |
1 files changed, 237 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_07_06_00_world.sql b/sql/updates/world/master/2017_07_06_00_world.sql new file mode 100644 index 00000000000..d716d7be2f2 --- /dev/null +++ b/sql/updates/world/master/2017_07_06_00_world.sql @@ -0,0 +1,237 @@ +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=46829; -- Elemental Abuse +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=46001; -- Rules of the Hunt +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43628; -- WANTED: Urgev the Flayer +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43458; -- WANTED: Perrexx +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41844; -- WANTED: Sekhan +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41819; -- WANTED: Gurbog da Basher +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41596; -- Lively Highmountain Salmon +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41280; -- Huge Runescale Koi +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37837; -- An Inside Job +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37752; -- Pet Battles Active +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37750; -- Professions Active +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31524; -- A Worthy Challenge: Raigonn +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30042; -- Much to Learn +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=4, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=29407; -- The First Sign of Winter +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=29405; -- The Lesson of the Iron Staff +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27020; -- The First Lesson +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24968; -- Dark Deeds +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24845; -- A Change of Heart +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24839; -- A Change of Heart +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24831; -- Path of Wisdom +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24830; -- Path of Wisdom +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24829; -- Path of Destruction +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24799; -- A Victory For The Sunreavers +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24598; -- The Purification of Quel'Delar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=14176; -- The Grateful Dead +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=14169; -- The Grateful Dead +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=14011; -- Primal Strike +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11487; -- The Best of Brews +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11192; -- [DEPRECATED]Thresher Oil +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=1, `QuestDescription`='$n, once again Farseer Nobundo has been asking for you. It must be time for you to learn the secrets of air, the last of the elements!$B$BI want you to know that I''m very proud of all that you have accomplished thus far. I know that you have great things ahead of you.$B$BTake the boat from Auberdine in Darkshore on Kalimdor. Cross the Veiled Sea and seek out the farseer inside the Crystal Hall of the Exodar on Azuremyst Isle.', `VerifiedBuild`=24330 WHERE `ID`=10491; -- Call of Air +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9639; -- Kamsis +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9587; -- Dark Tidings +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9526; -- Reclaiming Felfire Hill +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9516; -- Destroy the Legion +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9492; -- Turning the Tide +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9428; -- Report to Splintertree Post +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7865; -- Sentinel Advanced Care Package +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7789; -- Quell the Silverwing Usurpers +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7734; -- Improved Quality +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6603; -- Trouble in Winterspring! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6461; -- Blood Feeders +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6162; -- [DEPRECATED]A Husband's Last Battle +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6122; -- The Principal Source +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6029; -- The Everlook Report +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5660; -- Touch of Weakness +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4521; -- Wild Guardians +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4505; -- [DEPRECATED]Well of Corruption +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4294; -- ... and a Batch of Ooze +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4293; -- A Sample of Slime... +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4181; -- Goblin Engineering +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3924; -- [DEPRICATED] Samophlange Manual +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3921; -- Wenikee Boltbucket +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3901; -- Rattling the Rattlecages +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3786; -- Morrowgrain Research +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3783; -- [DEPRECATED]Are We There, Yeti? +UPDATE `quest_template` SET `RewardBonusMoney`=18350, `Flags`=16384, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=3632; -- Gnome Engineering +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3519; -- A Friend in Need +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3512; -- In Eranikus' Own Words +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3088; -- Encrypted Parchment +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3063; -- Vengeance on the Northspring +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3062; -- Dark Heart +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2880; -- Troll Necklace Bounty +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2870; -- Against Lord Shalzaru +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2821; -- The Mark of Quality +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2769; -- The Brassbolts Brothers +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2478; -- Mission: Possible But Not Probable +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2201; -- Find the Gems +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1999; -- Tools of the Trade +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1881; -- Speak with Anastasia +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1819; -- Ulag the Cleaver +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1802; -- Tome of the Cabal +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1796; -- Components for the Enchanted Gold Bloodrobe +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1716; -- Devourer of Souls +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1527; -- Call of Fire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1435; -- The Burning of Spirits +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1359; -- Zinge's Delivery +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1197; -- The Sacred Flame +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1143; -- The Tower of Althalaxx +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1071; -- A Gnome's Respite +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1035; -- Fallen Sky Lake +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1031; -- The Branch of Cenarius +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1026; -- Search the Bole +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1025; -- An Aggressive Defense +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1022; -- The Howling Vale +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1012; -- Insane Druids +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=944; -- The Master's Glaive +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=917; -- Webwood Egg +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=907; -- Enraged Thunder Lizards +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=666; -- Sunken Treasure +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionValue2`=-5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=24330 WHERE `ID`=664; -- Drowned Sorrows +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=662; -- Deep Sea Salvage +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=564; -- [DEPRECATED] Costly Menace +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=461; -- The Hidden Niche +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=446; -- Thule Ravenclaw +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=441; -- Raleigh and the Undercity +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=430; -- Return to Quinn +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=376; -- The Damned +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=366; -- Return the Book +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=363; -- Rude Awakening +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=295; -- Ormer's Revenge +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=275; -- Blisters on The Land +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=274; -- A Dark Threat Looms +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=249; -- Morganth +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=230; -- Sven's Camp +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=139; -- Captain Sanders' Hidden Treasure +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5; -- Jitters' Growling Gut + +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289715; -- 289715 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289709; -- 289709 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289708; -- 289708 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289707; -- 289707 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288792; -- 288792 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288793; -- 288793 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285565; -- 285565 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285290; -- 285290 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282916; -- 282916 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282881; -- 282881 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282551; -- 282551 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282160; -- 282160 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277072; -- 277072 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277071; -- 277071 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277070; -- 277070 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268670; -- 268670 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=24330 WHERE `ID`=252343; -- 252343 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252338; -- 252338 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266148; -- 266148 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266147; -- 266147 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255951; -- 255951 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255950; -- 255950 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265295; -- 265295 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265294; -- 265294 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253355; -- 253355 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253354; -- 253354 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264812; -- 264812 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265344; -- 265344 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265531; -- 265531 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265339; -- 265339 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264925; -- 264925 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263521; -- 263521 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263601; -- 263601 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265029; -- 265029 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265028; -- 265028 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=262654; -- 262654 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259068; -- 259068 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259604; -- 259604 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264088; -- 264088 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263273; -- 263273 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259569; -- 259569 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259376; -- 259376 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259496; -- 259496 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257171; -- 257171 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257170; -- 257170 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258582; -- 258582 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258502; -- 258502 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258935; -- 258935 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258597; -- 258597 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258596; -- 258596 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257928; -- 257928 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258240; -- 258240 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258239; -- 258239 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258075; -- 258075 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258259; -- 258259 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257975; -- 257975 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255850; -- 255850 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255847; -- 255847 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253139; -- 253139 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=24330 WHERE `ID`=257423; -- 257423 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256392; -- 256392 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256095; -- 256095 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256094; -- 256094 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256093; -- 256093 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256092; -- 256092 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256810; -- 256810 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256495; -- 256495 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256383; -- 256383 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256697; -- 256697 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256185; -- 256185 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256184; -- 256184 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256183; -- 256183 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256242; -- 256242 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256241; -- 256241 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256240; -- 256240 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256063; -- 256063 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252631; -- 252631 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255881; -- 255881 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255880; -- 255880 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256162; -- 256162 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256040; -- 256040 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255194; -- 255194 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255193; -- 255193 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255782; -- 255782 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254794; -- 254794 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255228; -- 255228 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255354; -- 255354 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255353; -- 255353 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254818; -- 254818 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254746; -- 254746 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254797; -- 254797 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255384; -- 255384 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255383; -- 255383 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255382; -- 255382 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255381; -- 255381 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254833; -- 254833 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254780; -- 254780 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254779; -- 254779 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254778; -- 254778 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254103; -- 254103 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255655; -- 255655 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254957; -- 254957 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253716; -- 253716 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253715; -- 253715 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253492; -- 253492 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253491; -- 253491 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253519; -- 253519 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253518; -- 253518 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253517; -- 253517 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253516; -- 253516 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255397; -- 255397 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255396; -- 255396 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254973; -- 254973 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253247; -- 253247 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253308; -- 253308 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254888; -- 254888 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253243; -- 253243 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253242; -- 253242 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253273; -- 253273 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253232; -- 253232 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253231; -- 253231 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255377; -- 255377 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=251778; -- 251778 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255032; -- 255032 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252633; -- 252633 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288792 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282160 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=277072 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=277071 AND `Index`=0); |