diff options
author | Vincent-Michael <vincent_michael@gmx.de> | 2016-09-25 22:19:08 +0200 |
---|---|---|
committer | Vincent-Michael <vincent_michael@gmx.de> | 2016-09-25 22:19:08 +0200 |
commit | e22c800edd1100582238b4c505c0d2a262c0b8c7 (patch) | |
tree | 66af449b11eaad0b18fb68c87da93d1dcde58a1a | |
parent | 49d5bc049181f628beb97c6ff124845dbba79b2d (diff) |
DB/Quests: Updated quest_template to 7.0.3.22624 part 16
-rw-r--r-- | sql/updates/world/6.x/2016_09_25_01_world.sql | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_25_01_world.sql b/sql/updates/world/6.x/2016_09_25_01_world.sql new file mode 100644 index 00000000000..20222feb8f3 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_25_01_world.sql @@ -0,0 +1,59 @@ +DELETE FROM `quest_template` WHERE `ID` IN (42274 /*-Unknown-*/, 41268 /*-Unknown-*/, 41295 /*-Unknown-*/, 43801 /*-Unknown-*/, 44304 /*-Unknown-*/, 41821 /*-Unknown-*/, 41489 /*-Unknown-*/, 41518 /*-Unknown-*/, 42148 /*-Unknown-*/, 44028 /*-Unknown-*/, 43612 /*-Unknown-*/, 44018 /*-Unknown-*/, 41699 /*-Unknown-*/, 43451 /*-Unknown-*/, 44013 /*-Unknown-*/, 41598 /*-Unknown-*/, 44024 /*-Unknown-*/, 41442 /*-Unknown-*/, 41219 /*-Unknown-*/, 43615 /*-Unknown-*/, 44027 /*-Unknown-*/, 41289 /*-Unknown-*/, 44302 /*-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`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(42274, 3, 110, 0, 110, 7334, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 213068, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4709, 0, -1, 21, 'Won''t Anyone Think of the Whelps?', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41268, 3, 110, 0, 110, 7334, 130, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4683, 0, -1, 135, 'Queen Queenfish', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41295, 3, 110, 0, 110, 7558, 119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 144, 'Dreamleaf-Covered Ancient', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43801, 3, 110, 0, 110, 7334, 136, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 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, 1894, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 4872, 0, -1, 52, 'Shell Out Some Pain', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44304, 3, 110, 0, 110, 7558, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 50, 'WANTED: Darkshade', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41821, 3, 110, 0, 110, 7503, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 23, 'WANTED: Shara Felbreath', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41489, 3, 110, 0, 110, 7541, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 150, 'Brimstone Destroyer', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41518, 3, 110, 0, 110, 7558, 119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 151, 'Felwort', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42148, 3, 110, 0, 110, 7334, 115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3735808, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 5, 'The Wine''s Gone Bad', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44028, 3, 110, 0, 110, 7637, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 51, 'WANTED: Lieutenant Strathmar', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43612, 3, 110, 0, 110, 7334, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 47, 'WANTED: Normantis the Deposed', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44018, 3, 110, 0, 110, 7637, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 29, 'WANTED: Magister Phaedris', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41699, 3, 110, 0, 110, 7503, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 207023, 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, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4615, 0, -1, 23, 'Crabby Crunchies', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43451, 3, 110, 0, 110, 7541, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 25, 'WANTED: Urgev the Flayer', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44013, 3, 110, 0, 110, 7637, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 29, 'WANTED: Guardian Thor''el', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41598, 3, 110, 0, 110, 7334, 130, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 135, 'Lively Cursed Queenfish', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44024, 3, 110, 0, 110, 7637, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 51, 'WANTED: Shal''an', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41442, 3, 110, 0, 110, 7541, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4259, 0, -1, 148, 'Striking Leystone Deposits', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41219, 3, 110, 0, 110, 7503, 119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 145, 'Flourishing Foxflower', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43615, 3, 110, 0, 110, 7334, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 47, 'WANTED: Warbringer Mox''na', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44027, 3, 110, 0, 110, 7637, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 51, 'WANTED: Magister Phaedris', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41289, 3, 110, 0, 110, 7334, 119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 143, 'Flourishing Aethril', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44302, 3, 110, 0, 110, 7558, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 50, 'WANTED: Seersei', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624); -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (284117 /*284117*/, 284116 /*284116*/, 282148 /*282148*/, 282173 /*282173*/, 285819 /*285819*/, 285818 /*285818*/, 286553 /*286553*/, 282885 /*282885*/, 282439 /*282439*/, 282474 /*282474*/, 283771 /*283771*/, 286129 /*286129*/, 285549 /*285549*/, 286116 /*286116*/, 282692 /*282692*/, 285283 /*285283*/, 286112 /*286112*/, 282553 /*282553*/, 286125 /*286125*/, 282382 /*282382*/, 282059 /*282059*/, 285552 /*285552*/, 286128 /*286128*/, 282167 /*282167*/, 286551 /*286551*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(284117, 42274, 0, 1, 107216, 1, 0, 0, 'Legion Jailer Slain', 22624), -- 284117 +(284116, 42274, 0, 0, 107171, 10, 0, 0, 'Azure Whelplings Freed', 22624), -- 284116 +(282148, 41268, 0, 0, 104258, 1, 0, 0, '', 22624), -- 282148 +(282173, 41295, 0, 0, 104259, 8, 0, 0, 'Dreamleaf Bloom gathered', 22624), -- 282173 +(285819, 43801, 0, 1, 111647, 15, 0, 0, 'Saltspray Crab slain', 22624), -- 285819 +(285818, 43801, 0, 0, 111648, 5, 0, 0, 'Mak''rana Siltwalker slain', 22624), -- 285818 +(286553, 44304, 0, 0, 92965, 1, 1, 0, '', 22624), -- 286553 +(282885, 41821, 0, 0, 97093, 1, 1, 0, 'Shara Felbreath slain.', 22624), -- 282885 +(282439, 41489, 0, 0, 103594, 1, 0, 0, 'Brimstone Destroyer Core mined', 22624), -- 282439 +(282474, 41518, 0, 0, 103647, 1, 0, 0, 'Felwort gathered', 22624), -- 282474 +(283771, 42148, 12, 0, 1891, 1, 0, 0, 'Defeat Vinu', 22624), -- 283771 +(286129, 44028, 0, 0, 102303, 1, 1, 0, '', 22624), -- 286129 +(285549, 43612, 0, 0, 90217, 1, 1, 0, 'Normantis the Deposed slain.', 22624), -- 285549 +(286116, 44018, 0, 0, 109954, 1, 1, 0, '', 22624), -- 286116 +(282692, 41699, 1, 3, 135583, 100, 0, 0, '', 22624), -- 282692 +(285283, 43451, 0, 0, 93401, 1, 1, 0, 'Urgev the Flayer slain.', 22624), -- 285283 +(286112, 44013, 0, 0, 110944, 1, 1, 0, '', 22624), -- 286112 +(282553, 41598, 1, 0, 134564, 10, 0, 0, '', 22624), -- 282553 +(286125, 44024, 0, 0, 109054, 1, 1, 0, '', 22624), -- 286125 +(282382, 41442, 1, 0, 141235, 10, 0, 0, '', 22624), -- 282382 +(282059, 41219, 1, 0, 140986, 10, 0, 0, '', 22624), -- 282059 +(285552, 43615, 0, 0, 90164, 1, 1, 0, 'Warbringer Mox''na slain.', 22624), -- 285552 +(286128, 44027, 0, 0, 109954, 1, 1, 0, '', 22624), -- 286128 +(282167, 41289, 1, 0, 140947, 10, 0, 0, '', 22624), -- 282167 +(286551, 44302, 0, 0, 92180, 1, 1, 0, '', 22624); -- 286551 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=284116 AND `Index`=1) OR (`ID`=284116 AND `Index`=0) OR (`ID`=282439 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(284116, 1, 6037, 22624), -- 284116 +(284116, 0, 6036, 22624), -- 284116 +(282439, 0, 6044, 22624); -- 282439 |