diff options
| -rw-r--r-- | sql/updates/world/master/2017_07_10_01_world.sql | 251 |
1 files changed, 251 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_07_10_01_world.sql b/sql/updates/world/master/2017_07_10_01_world.sql new file mode 100644 index 00000000000..1d93d8fb20a --- /dev/null +++ b/sql/updates/world/master/2017_07_10_01_world.sql @@ -0,0 +1,251 @@ +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=46077; -- Felbound Spirits +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45674; -- The Colossus of Regal +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44301; -- WANTED: Bahagar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44193; -- DANGER: Sea King Tidross +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44186; -- WANTED: Broodmother Shu'malis +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44025; -- WANTED: Oreth the Vile +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43459; -- WANTED: Thondrax +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=42743; -- Darkheart Thicket: Kudzilla +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41534; -- Brambly Fjarnskaggl +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41529; -- Bushy Aethril +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41291; -- Dreamleaf Cluster +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41283; -- The Angler Mangler +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=24330 WHERE `ID`=40501; -- REUSEME_40501 +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=39003; -- Cooking the Books +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=38008; -- The Road of Glory +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=24330 WHERE `ID`=37836; -- Breaking Badness +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=32722; -- Forge Ahead! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31527; -- A Worthy Challenge: Flameweaver Koegler +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30907; -- Round 4: The P.U.G. +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30883; -- Round 3: The Wrestler +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30881; -- Round 2: Clever Ashyo & Ken-Ken +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=30879; -- Round 1: Brewmaster Chani +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26977; -- Twilight Investigation +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24966; -- Of Light and Shadows +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24760; -- The Arts of a Shaman +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=24494; -- Empowered Rune +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=13253; -- Proof of Demise: Loken +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=13250; -- Proof of Demise: Gal'darah +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11201; -- [DEPRECATED]The Grimtotem Plot +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11200; -- [DEPRECATED]More than Coincidence +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=10169; -- Losing Gracefully +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9673; -- Beast Training +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9533; -- A Helping Hand +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9449; -- Call of Earth +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9248; -- A Humble Offering +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9226; -- Superior Armaments of Battle - Revered Amongst the Dawn +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9225; -- Epic Armaments of Battle - Revered Amongst the Dawn +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=9211; -- The Ice Guard +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=8947; -- Anthion's Strange Request +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8332; -- Dukes of the Council +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7873; -- Vanquish the Invaders! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7667; -- Material Assistance +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7502; -- Harnessing Shadows +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7165; -- Earned Reverence +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5635; -- Desperate Prayer +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5544; -- Carrion Grubbage +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5543; -- Blood Tinged Skies +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5542; -- Demon Dogs +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5513; -- Mantles of the Dawn +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5149; -- Pamela's Doll +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=5146; -- Elemental Leatherworking +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5087; -- [DEPRECATED]Winterfall Runners +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5086; -- [DEPRECATED]Toxic Horrors +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5056; -- Shy-Rotam +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4987; -- Glyphed Oaken Branch +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4981; -- Operative Bijou +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4784; -- Components for the Enchanted Gold Bloodrobe +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4741; -- Wild Guardians +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4143; -- Haze of Evil +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3564; -- Andron's Payment to Jediga +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3528; -- The God Hakkar +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=3448; -- Passing the Burden +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3096; -- Encrypted Scroll +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2763; -- The Art of the Imbue +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2762; -- The Great Silver Deceiver +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2761; -- Smelt On, Smelt Off +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2759; -- In Search of Galvan +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2204; -- Restoring the Necklace +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2138; -- Cleansing of the Infected +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1580; -- Electropellers +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1529; -- Call of Water +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1448; -- In Search of The Temple +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1395; -- Supplies for Nethergarde +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1394; -- Final Passage +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=1301; -- [DEPRECATED]James Hyal +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=1240; -- The Troll Witchdoctor +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1184; -- Parts of the Swarm +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1183; -- Goblin Sponsorship +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1169; -- [DEPRECATED]Identifying the Brood +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1089; -- The Den +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1073; -- Ineptitude + Chemicals = Fun +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1027; -- Playing Possum +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1024; -- Dryad Delivery +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1009; -- Ruuzel +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=980; -- The New Springs +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=977; -- [DEPRECATED]Are We There, Yeti? +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=973; -- The Tower of Althalaxx +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=690; -- Malin's Request +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=424; -- Arugal's Folly +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=299; -- Uncovering the Past +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=293; -- Cleansing the Eye +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=284; -- The Search Continues +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=278; -- A Dark Threat Looms +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=248; -- Looking Further +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=177; -- [DEPRECATED]Look To The Stars +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=155; -- The Defias Brotherhood +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=48; -- Sweet Amber +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7502; -- Harnessing Shadows +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44301; -- WANTED: Bahagar + +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288874; -- 288874 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288327; -- 288327 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286550; -- 286550 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286374; -- 286374 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286348; -- 286348 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286126; -- 286126 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285291; -- 285291 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286779; -- 286779 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=284674; -- 284674 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282491; -- 282491 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282486; -- 282486 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282169; -- 282169 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282163; -- 282163 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=280832; -- 280832 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=280831; -- 280831 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=280830; -- 280830 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=278782; -- 278782 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=278781; -- 278781 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=278780; -- 278780 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277304; -- 277304 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=277212; -- 277212 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270292; -- 270292 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=270291; -- 270291 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268673; -- 268673 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267715; -- 267715 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267714; -- 267714 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267713; -- 267713 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254108; -- 254108 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253399; -- 253399 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253398; -- 253398 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252488; -- 252488 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266820; -- 266820 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=266819; -- 266819 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267985; -- 267985 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=265483; -- 265483 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267636; -- 267636 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=264481; -- 264481 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263997; -- 263997 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259869; -- 259869 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260383; -- 260383 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252509; -- 252509 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260391; -- 260391 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260390; -- 260390 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260317; -- 260317 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260316; -- 260316 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260655; -- 260655 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260654; -- 260654 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259411; -- 259411 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259410; -- 259410 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260882; -- 260882 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260881; -- 260881 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260880; -- 260880 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260879; -- 260879 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256210; -- 256210 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256209; -- 256209 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259412; -- 259412 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260268; -- 260268 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260267; -- 260267 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259013; -- 259013 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259251; -- 259251 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257981; -- 257981 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258035; -- 258035 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257839; -- 257839 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257838; -- 257838 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257837; -- 257837 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257713; -- 257713 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257712; -- 257712 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256787; -- 256787 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256175; -- 256175 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256174; -- 256174 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256173; -- 256173 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256172; -- 256172 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257887; -- 257887 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257929; -- 257929 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257653; -- 257653 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257227; -- 257227 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258112; -- 258112 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258111; -- 258111 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258110; -- 258110 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258731; -- 258731 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258248; -- 258248 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257030; -- 257030 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257166; -- 257166 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256569; -- 256569 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256252; -- 256252 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256251; -- 256251 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256196; -- 256196 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256195; -- 256195 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256230; -- 256230 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256229; -- 256229 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253602; -- 253602 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256021; -- 256021 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256272; -- 256272 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256077; -- 256077 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255959; -- 255959 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255506; -- 255506 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255141; -- 255141 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254715; -- 254715 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254468; -- 254468 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254467; -- 254467 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254504; -- 254504 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254503; -- 254503 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254502; -- 254502 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254624; -- 254624 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254623; -- 254623 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254835; -- 254835 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254696; -- 254696 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255457; -- 255457 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254598; -- 254598 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254704; -- 254704 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253256; -- 253256 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252801; -- 252801 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252800; -- 252800 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252799; -- 252799 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252798; -- 252798 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252621; -- 252621 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252868; -- 252868 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252867; -- 252867 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252866; -- 252866 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252996; -- 252996 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252695; -- 252695 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252003; -- 252003 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259013; -- 259013 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286550; -- 286550 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=7); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=6); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=5); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=4); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=3); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=2); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288874 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288327 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=286374 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=286779 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=284674 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282169 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=282163 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=280832 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=280831 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=278782 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=278781 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=277212 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=267715 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=267714 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=267713 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=254108 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=253399 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=253398 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=252488 AND `Index`=0); |