diff options
| -rw-r--r-- | sql/updates/world/master/2017_07_09_03_world.sql | 141 |
1 files changed, 141 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_07_09_03_world.sql b/sql/updates/world/master/2017_07_09_03_world.sql new file mode 100644 index 00000000000..66ed7b6b9b7 --- /dev/null +++ b/sql/updates/world/master/2017_07_09_03_world.sql @@ -0,0 +1,141 @@ +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=46999; -- Boon of the Command Center +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=46844; -- -Unknown- +UPDATE `quest_template` SET `Flags`=37290304, `VerifiedBuild`=24330 WHERE `ID`=46184; -- Gelgothar +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=45651; -- The Ruins of Ahn'Qiraj: Ossirian +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=44192; -- DANGER: Lysanis Shadesoul +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43431; -- WANTED: Warbringer Mox'na +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=43346; -- DANGER: Ealdis +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41857; -- Neltharion's Lair: Stonedark Slaves +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=24330 WHERE `ID`=41349; -- Rock-Hard Crab Chitin +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=41294; -- Flourishing Dreamleaf +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=40966; -- Ritualists in Our Midsts +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=37753; -- Relic Hunter Active +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31522; -- A Worthy Challenge: Sha of Hatred +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=31173; -- The Tiger Palm +UPDATE `quest_template` SET `RewardMoney`=2, `Flags`=524288, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=24330 WHERE `ID`=30043; -- Much to Learn +UPDATE `quest_template` SET `RewardBonusMoney`=182850, `Flags`=3166216, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=0, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=29039; -- Hunting Practice +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=27014; -- Hallowed Note +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26970; -- Learning the Word +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=26966; -- The Light's Power +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=25414; -- The Missing +UPDATE `quest_template` SET `RewardBonusMoney`=91500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=24330 WHERE `ID`=25290; -- Infiltrating the Cult +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=13249; -- Proof of Demise: The Prophet Tharon'ja +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11413; -- Did Someone Say "Souvenir?" +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=11180; -- What's Haunting Witch Hill? +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9690; -- The Second Trial +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9619; -- The Rune of Summoning +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=9475; -- Reclaiming the Eggs +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=9464; -- Call of Fire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8983; -- Tracing the Source +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=8154; -- Arathi Basin Resources! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=7733; -- Improved Quality +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6523; -- Protect Kaya +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=6148; -- The Scarlet Oracle, Demetria +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5730; -- Hidden Enemies +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=5342; -- The Last Barov +UPDATE `quest_template` SET `RewardFactionValue1`=1, `RewardFactionOverride1`=0, `VerifiedBuild`=24330 WHERE `ID`=5095; -- A Call to Arms: The Plaguelands! +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=4768; -- The Darkstone Tablet +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3639; -- Show Your Work +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3092; -- Etched Note +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=3089; -- Rune-Inscribed Parchment +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2984; -- Call of Fire +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2975; -- The Ogres of Feralas +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2863; -- Alpha Strike +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2359; -- Klaven's Tower +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=2281; -- Redridge Rendezvous +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1945; -- Laughing Sisters +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1791; -- The Windwatcher +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1458; -- Reagents for Reclaimers Inc. +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1387; -- Centaur Bounty +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1206; -- Jarl Needs Eyes +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1199; -- Twilight Falls +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1094; -- Further Instructions +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1057; -- Reclaiming the Charred Vale +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1040; -- Passage to Booty Bay +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=1023; -- The Lost Gem +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=857; -- The Tear of the Moons +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=643; -- Sigil of Arathor +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=539; -- [DEPRECATED] Battle of Hillsbrad +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=520; -- [DEPRECATED] The Crown of Will +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=440; -- The Engraved Ring +UPDATE `quest_template` SET `VerifiedBuild`=24330 WHERE `ID`=263; -- In Defense of the King's Lands + +DELETE FROM `quest_objectives` WHERE `ID`=256426; +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(256426, 29039, 0, 0, 51711, 5, 0, 0, 0, 'Hunting Practice', 24330); -- 256426 + +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289750; -- 289750 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289749; -- 289749 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=289055; -- 289055 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=288293; -- 288293 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=286373; -- 286373 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285259; -- 285259 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=285222; -- 285222 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282965; -- 282965 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282964; -- 282964 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282240; -- 282240 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=282172; -- 282172 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281690; -- 281690 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281705; -- 281705 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=281458; -- 281458 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268668; -- 268668 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268206; -- 268206 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=268205; -- 268205 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=251822; -- 251822 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259998; -- 259998 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259997; -- 259997 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267197; -- 267197 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=267196; -- 267196 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252171; -- 252171 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252170; -- 252170 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252169; -- 252169 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252168; -- 252168 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252352; -- 252352 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=263892; -- 263892 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253830; -- 253830 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257710; -- 257710 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260974; -- 260974 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=260973; -- 260973 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259931; -- 259931 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259212; -- 259212 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=259048; -- 259048 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258772; -- 258772 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255961; -- 255961 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=258503; -- 258503 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257307; -- 257307 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257306; -- 257306 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=257305; -- 257305 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256641; -- 256641 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256315; -- 256315 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256527; -- 256527 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256526; -- 256526 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256525; -- 256525 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256502; -- 256502 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256328; -- 256328 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256327; -- 256327 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256189; -- 256189 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256284; -- 256284 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=256283; -- 256283 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255401; -- 255401 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255550; -- 255550 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254984; -- 254984 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254523; -- 254523 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255061; -- 255061 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255060; -- 255060 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255059; -- 255059 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255058; -- 255058 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255240; -- 255240 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254378; -- 254378 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254224; -- 254224 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255096; -- 255096 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=255095; -- 255095 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254915; -- 254915 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=254914; -- 254914 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=253207; -- 253207 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252874; -- 252874 +UPDATE `quest_objectives` SET `VerifiedBuild`=24330 WHERE `ID`=252873; -- 252873 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=288293 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=286373 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=285222 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=24330 WHERE (`ID`=281458 AND `Index`=0); |