diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_02_00_world.sql | 93 |
1 files changed, 93 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_02_00_world.sql b/sql/updates/world/master/2017_05_02_00_world.sql new file mode 100644 index 00000000000..42f67eed907 --- /dev/null +++ b/sql/updates/world/master/2017_05_02_00_world.sql @@ -0,0 +1,93 @@ +DELETE FROM `quest_template` WHERE `ID` IN (46752 /*-Unknown-*/, 46750 /*-Unknown-*/, 46248 /*-Unknown-*/, 46192 /*-Unknown-*/, 39189 /*-Unknown-*/); +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 +(46752, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239840, 0, 0, 0, 0, 0, 0, 37421312, 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, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4816, 0, -1, 340, 6, 'On Borrowed Wings', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46750, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239802, 0, 0, 0, 0, 0, 0, 37421312, 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, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4816, 0, -1, 356, 6, 'Battery Backup', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46248, 2, 110, 0, 110, -428, 0, 0, 0, 0, 1, 388000, 6, 1, 0, 0, 0, 0, 239972, 0, 0, 0, 0, 1, 0, 35651592, 0, 0, 0, 0, 0, 147842, 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, 2045, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 150000, 0, 0, 0, 0, 0, 0, 0, -1, 0, 6, 'Self-Fulfilling Prophecy', 'Complete 12 World Quests on the Broken Shore.', 'In my life, I have witnessed many visions. Some filled me with hope... others, with despair.\n\nVictory over Kil''jaeden lies within our grasp. I have foreseen it. But visions only show us where our path might lead. They require effort to become reality.\n\nThat effort falls upon your shoulders, $n. You have done much, but more is needed. Fight on the battlefields of the Broken Shore and forge a destiny free from the Legion''s grasp!', '', '', 1342, 0, 0, 0, 50, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46192, 3, -1, 0, 98, 7503, 142, 0, 0, 5, 4, 0, 0, 1, 0, 0, 0, 0, 242342, 0, 0, 0, 0, 0, 0, 37290240, 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, 1828, 1894, 0, 0, 0, 4, 4, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 335, 6, 'Zar''vok', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(39189, 1, 65, 0, 64, 3518, 0, 0, 0, 1, 1, 3400, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 33555378, 0, 1, 'Warchief''s Command: Nagrand', 'Speak with one of the druids at the Cenarion Thicket in Terokkar Forest.', 'We have lost contact with the druids of the Cenarion Thicket$B$BThe Warchief has commanded any able bodies of the Horde to venture into Terokkar Forest and discover what has happened.$b$bThe thicket can be found by heading northwest through Terokkar Forest from Zangarmarsh.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown- + +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=44025; -- WANTED: Oreth the Vile +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43072; -- DANGER: The Whisperer +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41539; -- Sparkling Starlight Roses +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41459; -- Dense Leystone Outcropping +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41294; -- Flourishing Dreamleaf +UPDATE `quest_template` SET `RewardBonusMoney`=3400, `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=31528; -- A Worthy Challenge: Darkmaster Gandling +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30818; -- A New Fate +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=30817; -- The Healing of Shen-zin Su +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=29405; -- The Lesson of the Iron Staff +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=28879; -- Back To The Orphanage +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26673; -- REUSE - BREADCRUMB +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=24874; -- Blood Quickening +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=24798; -- A Victory For The Sunreavers +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=24596; -- The Purification of Quel'Delar +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13383; -- Killohertz +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13371; -- The Killing Time +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13369; -- Fate, Up Against Your Will +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=11022; -- Speak with Mog'dorg +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9222; -- Epic Armaments of Battle - Friend of the Dawn +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=9221; -- Superior Armaments of Battle - Friend of the Dawn +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9121; -- The Dread Citadel - Naxxramas +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=7863; -- Sentinel Basic Care Package +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5518; -- The Gordok Ogre Suit +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5149; -- Pamela's Doll +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5086; -- [DEPRECATED]Toxic Horrors +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4972; -- Counting Out Time +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4969; -- Knowledge of the Orb of Orahil +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4341; -- Kharan Mighthammer +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4181; -- Goblin Engineering +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3912; -- Meet at the Grave +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3627; -- Uniting the Shattered Amulet +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3502; -- One Draenei's Junk... +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2993; -- Return to the Hinterlands +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=2522; -- Kum'isha's Endeavors +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41539; -- Sparkling Starlight Roses + +DELETE FROM `quest_objectives` WHERE `ID` IN (289558 /*289558*/, 289557 /*289557*/, 289556 /*289556*/, 289549 /*289549*/, 289548 /*289548*/, 289547 /*289547*/, 289258 /*289258*/, 289063 /*289063*/, 254524 /*254524*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289558, 46752, 0, 1, 117952, 10, 92, 0, 10, '', 23911), -- 289558 +(289557, 46752, 15, -1, 0, 1, 2, 0, 0, 'Power Core replenished', 23911), -- 289557 +(289556, 46752, 1, 0, 146892, 3, 0, 1, 0, '', 23911), -- 289556 +(289549, 46750, 0, 1, 117952, 10, 92, 0, 10, '', 23911), -- 289549 +(289548, 46750, 15, -1, 0, 1, 2, 0, 0, 'Power Core replenished', 23911), -- 289548 +(289547, 46750, 1, 0, 146892, 3, 0, 1, 0, '', 23911), -- 289547 +(289258, 46248, 14, 0, 58069, 1, 0, 0, 0, 'World quests completed on Broken Shore', 23911), -- 289258 +(289063, 46192, 0, 0, 117993, 1, 1, 0, 0, '', 23911), -- 289063 +(254524, 2522, 1, 0, 8244, 1, 0, 0, 0, '', 23911); -- 254524 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286126; -- 286126 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285034; -- 285034 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282496; -- 282496 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282407; -- 282407 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282172; -- 282172 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=268674; -- 268674 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264103; -- 264103 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252338; -- 252338 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253878; -- 253878 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261700; -- 261700 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265544; -- 265544 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264686; -- 264686 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259145; -- 259145 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259144; -- 259144 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259056; -- 259056 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259055; -- 259055 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257047; -- 257047 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257046; -- 257046 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257045; -- 257045 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257044; -- 257044 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257043; -- 257043 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256087; -- 256087 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256086; -- 256086 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256085; -- 256085 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256084; -- 256084 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256787; -- 256787 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257929; -- 257929 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256871; -- 256871 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258075; -- 258075 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=257285; -- 257285 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=257284; -- 257284 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=257283; -- 257283 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257109; -- 257109 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282496; -- 282496 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285034 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282407 AND `Index`=0); |