diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_01_00_world.sql | 94 |
1 files changed, 94 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_01_00_world.sql b/sql/updates/world/master/2017_05_01_00_world.sql new file mode 100644 index 00000000000..2d71fae6a58 --- /dev/null +++ b/sql/updates/world/master/2017_05_01_00_world.sql @@ -0,0 +1,94 @@ +DELETE FROM `quest_template` WHERE `ID` IN (46998, 46868, 46814, 46811); +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 +(46998, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 239966, 0, 0, 240685, 0, 0, 0, 0, 1, 0, 39845888, 8192, 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, -1, 0, 6, 'Boon of the Command Center', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46868, 3, 110, 0, 110, 8527, 145, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193088, 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, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5206, 0, -1, 358, 6, 'Cathedral of Eternal Night: Infernal Dead', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46814, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239870, 0, 0, 0, 0, 0, 0, 41484544, 8192, 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, 5181, 0, -1, 340, 6, 'Call of the Frostwyrm', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46811, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239865, 0, 0, 0, 0, 0, 0, 41484544, 8192, 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, 5181, 0, -1, 356, 6, 'The Broodmother''s Wrath', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); + +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionValue1`=1, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43477; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41596; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41563; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41551; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41514; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41458; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Flags`=524608, `RewardSkillLineID`=356, `RewardNumSkillUps`=1, `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41267; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41232; +UPDATE `quest_template` SET `Expansion`=4, `VerifiedBuild`=23911 WHERE `ID`=32809; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=26969; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13242; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=11139; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10899; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10366; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=8379; +UPDATE `quest_template` SET `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=8046; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7634; +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7503; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6822; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6569; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5902; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5673; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5203; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5167; +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4810; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3541; +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2863; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2298; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=901; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=355; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=336; +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionValue1`=1, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43477; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41514; + +DELETE FROM `quest_objectives` WHERE `ID` IN (289793 /*289793*/, 289792 /*289792*/, 289683 /*289683*/, 289655 /*289655*/, 289654 /*289654*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289793, 46868, 0, 1, 116944, 1, 0, 0, 0, 'Mephistroth Slain', 23911), -- 289793 +(289792, 46868, 0, 0, 120716, 1, 0, 0, 0, 'Serilis Slain', 23911), -- 289792 +(289683, 46814, 0, 0, 116313, 25, 0, 0, 0, 'Demons slain', 23911), -- 289683 +(289655, 46811, 0, 1, 116313, 100, 2, 0, 0, 'Demons killed', 23911), -- 289655 +(289654, 46811, 0, 0, 120492, 1, 0, 0, 0, 'Daumyr mounted', 23911); -- 289654 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282551; -- 282551 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282520; -- 282520 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282505; -- 282505 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282470; -- 282470 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282406; -- 282406 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282147; -- 282147 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282085; -- 282085 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270571; -- 270571 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270460; -- 270460 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270459; -- 270459 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=270458; -- 270458 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267984; -- 267984 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256534; -- 256534 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263569; -- 263569 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255841; -- 255841 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255840; -- 255840 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=260456; -- 260456 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257794; -- 257794 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259607; -- 259607 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258753; -- 258753 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255577; -- 255577 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255576; -- 255576 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255575; -- 255575 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255574; -- 255574 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256937; -- 256937 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257290; -- 257290 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257289; -- 257289 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257288; -- 257288 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257287; -- 257287 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258773; -- 258773 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257142; -- 257142 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256502; -- 256502 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253973; -- 253973 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255378; -- 255378 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282470; -- 282470 + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270571 AND `Index`=2); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270571 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270571 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270460 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270460 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270459 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270459 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270458 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=270458 AND `Index`=0); |