diff options
| -rw-r--r-- | sql/updates/world/master/2017_04_24_00_world.sql | 246 |
1 files changed, 246 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_04_24_00_world.sql b/sql/updates/world/master/2017_04_24_00_world.sql new file mode 100644 index 00000000000..8d7ade3cd0c --- /dev/null +++ b/sql/updates/world/master/2017_04_24_00_world.sql @@ -0,0 +1,246 @@ +DELETE FROM `quest_template` WHERE `ID` IN (47008 /*-Unknown-*/, 46288 /*-Unknown-*/, 46072 /*-Unknown-*/, 45744 /*-Unknown-*/, 45743 /*-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 +(47008, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 240980, 0, 0, 237135, 0, 0, 0, 0, 1, 0, 39846144, 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 Mage Tower', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46288, 3, 110, 0, 110, 8553, 136, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 237225, 0, 0, 0, 0, 0, 0, 37290240, 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, 5139, 0, -1, 340, 6, 'Everyone to the Front', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(46072, 3, 110, 0, 110, 7543, 136, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 236581, 0, 0, 0, 0, 0, 0, 37290240, 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, 5139, 0, -1, 356, 6, 'Full Fel', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45744, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234120, 0, 0, 0, 0, 0, 0, 37290240, 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, 5093, 0, -1, 340, 6, 'Fall of the Felskorn', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), -- -Unknown- +(45743, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234117, 0, 0, 0, 0, 0, 0, 37290240, 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, 5093, 0, -1, 356, 6, 'Judgement of Odyn', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); -- -Unknown- + +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43428; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43426; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionID1`=1090, `RewardFactionID2`=1828, `RewardFactionValue1`=3, `RewardFactionValue2`=7, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41857; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `RewardSkillLineID`=197, `RewardNumSkillUps`=1, `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41647; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41558; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41493; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41444; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41323; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `RewardSkillLineID`=182, `RewardNumSkillUps`=1, `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41223; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=40985; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=40278; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=38240; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37264; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37261; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=3, `VerifiedBuild`=23911 WHERE `ID`=26977; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=26966; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=26121; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=194000, `RewardBonusMoney`=182850, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=25348; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=24967; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=13915; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=2, `VerifiedBuild`=23911 WHERE `ID`=13245; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=11539; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=194000, `RewardBonusMoney`=182850, `VerifiedBuild`=23911 WHERE `ID`=11487; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=11392; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10900; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9532; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=9518; -- -Unknown- +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=9447; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=8762; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8402; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=8395; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=7670; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=7201; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6186; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=6129; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=6123; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=45700, `RewardFactionValue1`=2, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5922; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5802; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43426; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5283; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=1, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5250; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=5234; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=5154; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=5092; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=5051; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4984; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=4770; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=4769; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4768; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4735; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4721; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4505; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4294; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4183; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4182; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4141; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=4133; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=4061; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3907; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=3903; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3882; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=3821; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3568; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=3562; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3385; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3105; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2984; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2870; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `QuestCompletionLog`='', `VerifiedBuild`=23911 WHERE `ID`=2758; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=2383; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1951; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1798; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1738; -- -Unknown- +UPDATE `quest_template` SET `RewardBonusMoney`=91500, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1715; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1681; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1666; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1599; -- -Unknown- +UPDATE `quest_template` SET `RewardMoney`=48500, `RewardBonusMoney`=45700, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=1478; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1370; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1273; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1196; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1071; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1017; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=1, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1004; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1003; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=964; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=942; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=902; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=804; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=2, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=767; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=760; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=703; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=690; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=626; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=625; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=7, `RewardFactionValue2`=-7, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=618; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionValue2`=-5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=610; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=594; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=478; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=439; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=345; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=296; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=281; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=250; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=160; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionValue2`=6, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `VerifiedBuild`=23911 WHERE `ID`=105; -- -Unknown- +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=98; -- -Unknown- +UPDATE `quest_template` SET `RewardFactionValue1`=4, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=70; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=40985; -- -Unknown- +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43428; -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (289183 /*289183*/, 289094 /*289094*/, 288849 /*288849*/, 288424 /*288424*/, 288422 /*288422*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(289183, 46288, 0, 0, 118776, 20, 0, 0, 0, 'Demons slain', 23911), -- 289183 +(289094, 46072, 0, 1, 119100, 1, 3, 0, 0, '', 23911), -- 289094 +(288849, 46072, 0, 0, 119099, 10, 0, 0, 0, 'Demon Essence drained', 23911), -- 288849 +(288424, 45744, 0, 0, 117732, 15, 0, 0, 0, 'Felskorn slain', 23911), -- 288424 +(288422, 45743, 0, 0, 117732, 20, 0, 0, 0, 'Felskorn slain', 23911); -- 288422 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285256; -- 285256 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285254; -- 285254 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282965; -- 282965 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282964; -- 282964 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282612; -- 282612 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282512; -- 282512 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282443; -- 282443 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282384; -- 282384 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282216; -- 282216 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282066; -- 282066 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281964; -- 281964 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281562; -- 281562 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281561; -- 281561 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281560; -- 281560 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281559; -- 281559 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=280583; -- 280583 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=276038; -- 276038 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=276032; -- 276032 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267197; -- 267197 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267196; -- 267196 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=267061; -- 267061 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253086; -- 253086 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256065; -- 256065 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256064; -- 256064 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264117; -- 264117 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=264674; -- 264674 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262840; -- 262840 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262839; -- 262839 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=262838; -- 262838 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=262654; -- 262654 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256510; -- 256510 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263346; -- 263346 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=263345; -- 263345 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259626; -- 259626 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259625; -- 259625 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=261201; -- 261201 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259808; -- 259808 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259559; -- 259559 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259298; -- 259298 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258804; -- 258804 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258784; -- 258784 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258783; -- 258783 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=259159; -- 259159 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285254; -- 285254 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256490; -- 256490 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256489; -- 256489 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256488; -- 256488 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=257560; -- 257560 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256110; -- 256110 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257598; -- 257598 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257597; -- 257597 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257643; -- 257643 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256987; -- 256987 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258503; -- 258503 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258120; -- 258120 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258119; -- 258119 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257980; -- 257980 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257928; -- 257928 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258240; -- 258240 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258308; -- 258308 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258403; -- 258403 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258402; -- 258402 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258401; -- 258401 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258400; -- 258400 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258428; -- 258428 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258355; -- 258355 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258023; -- 258023 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258022; -- 258022 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=258117; -- 258117 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257153; -- 257153 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257152; -- 257152 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257151; -- 257151 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257150; -- 257150 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257194; -- 257194 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=252816; -- 252816 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252815; -- 252815 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252814; -- 252814 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256253; -- 256253 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256383; -- 256383 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255373; -- 255373 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256324; -- 256324 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256198; -- 256198 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256257; -- 256257 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255922; -- 255922 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253084; -- 253084 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255787; -- 255787 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255786; -- 255786 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254736; -- 254736 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255354; -- 255354 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255353; -- 255353 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255472; -- 255472 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254916; -- 254916 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254664; -- 254664 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254636; -- 254636 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254556; -- 254556 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253960; -- 253960 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=253814; -- 253814 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253613; -- 253613 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253298; -- 253298 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=255043; -- 255043 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252966; -- 252966 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=252711; -- 252711 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252207; -- 252207 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251817; -- 251817 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=251964; -- 251964 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281964; -- 281964 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281562; -- 281562 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281561; -- 281561 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281560; -- 281560 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=281559; -- 281559 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285256; -- 285256 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=288849 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(288849, 0, 6940, 23911); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282512 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282443 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=280583 AND `Index`=0); |