diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_23_00_world.sql | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_23_00_world.sql b/sql/updates/world/6.x/2016_09_23_00_world.sql new file mode 100644 index 00000000000..7f076eabac5 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_23_00_world.sql @@ -0,0 +1,67 @@ +DELETE FROM `quest_template` WHERE `ID` IN (44301 /*-Unknown-*/, 44054 /*-Unknown-*/, 43752 /*-Unknown-*/, 43751 /*-Unknown-*/, 43566 /*-Unknown-*/, 42806 /*-Unknown-*/, 41774 /*-Unknown-*/, 41599 /*-Unknown-*/, 41582 /*-Unknown-*/, 41566 /*-Unknown-*/, 41513 /*-Unknown-*/, 41457 /*-Unknown-*/, 41337 /*-Unknown-*/, 41296 /*-Unknown-*/, 41293 /*-Unknown-*/, 41223 /*-Unknown-*/, 41209 /*-Unknown-*/, 32314 /*-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 +(44301, 3, 110, 0, 110, 7558, 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, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 27, 'WANTED: Bahagar', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44054, 3, 110, 0, 110, 8000, 136, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 1, 0, 37289984, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4893, 0, -1, 52, 'Demonicide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43752, 3, 110, 0, 110, 7541, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 222232, 0, 0, 0, 0, 0, 0, 41484544, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, 33555378, 25, 'Oh, Ship!', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43751, 3, 110, 0, 110, 7541, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 222232, 0, 0, 0, 0, 0, 0, 41484544, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, 18875469, 25, 'Oh, Ship!', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43566, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554432, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Withered Progress', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42806, 3, 110, 0, 110, 7541, 136, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 226059, 0, 0, 0, 0, 0, 0, 37290304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5, 5, 0, 0, 0, 0, 0, 0, -1, 54, 'DANGER: Fjorlag, the Grave''s Chill', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41774, 2, -1, 0, 110, -423, 0, 0, 41934, 6, 1, 388000, 6, 1, 228550, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 39845888, 33562624, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'The Rival Lords of Fire', 'Return to Lord Smolderon with Garixxia''s Smoldering Heart and the Core of Molten Rage.', 'You stand before the true Lord of the Firelands, mortal. This land is mine by right, claimed from the ashes of Ragnaros himself.$b$bHowever, there are still some who foolishly oppose my reign. I would take great pleasure in destroying their worthless souls, but I will not honor them with death by my hands.$b$bThey must be humiliated for their insolence, and there is nothing more humiliating than being slain by a mere mortal.$b$bAmuse me shaman. Prove your worth and destroy my rivals!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41599, 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- +(41582, 3, 110, 0, 110, 7334, 124, 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, 4168, 0, -1, 141, 'Smooth Sunrunner Hide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41566, 3, 110, 0, 110, 7558, 124, 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, 152, 'Felhide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41513, 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, 151, 'Felwort', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41457, 3, 110, 0, 110, 7558, 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, 148, 'Radiant Leystone Outcropping', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41337, 3, 110, 0, 110, 7558, 124, 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, 4273, 0, -1, 141, 'Pristine Stag Hide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41296, 3, 110, 0, 110, 7541, 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, 146, 'Fjarnskaggl Cluster', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41293, 3, 110, 0, 110, 7558, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 524608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4274, 0, -1, 130, 'Supplies Needed: Dreamleaf', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41223, 3, 110, 0, 110, 7503, 119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 524608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5, 0, 0, 0, 0, 0, 4350, 0, -1, 132, 'Work Order: Foxflower', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41209, 3, 110, 0, 110, 7503, 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- +(32314, 2, 90, 0, 90, -61, 21, 0, 32317, 5, 1, 114000, 5, 1, 575, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Slaughter Selenora', 'Obtain the second chapter of Legacy of the Masters from Shadowmancer Selenora in Domination Point.', '$n... You''ve heard correctly. King Varian tasked me with tracking down this Council of the Black Harvest.$B$BUnfortunately, the Horde is seeking them out as well. One of my spies recently sent word that Shadowmancer Selenora has the second piece of their journal.$B$BHead to Domination Point, slaughter Selenora and bring back whatever you find on her rotting cadaver.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624); -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (286550 /*286550*/, 286193 /*286193*/, 286204 /*286204*/, 286192 /*286192*/, 286195 /*286195*/, 286203 /*286203*/, 286191 /*286191*/, 285752 /*285752*/, 285795 /*285795*/, 285801 /*285801*/, 285751 /*285751*/, 285914 /*285914*/, 285913 /*285913*/, 284781 /*284781*/, 282993 /*282993*/, 282992 /*282992*/, 282554 /*282554*/, 282537 /*282537*/, 282523 /*282523*/, 282469 /*282469*/, 282405 /*282405*/, 282228 /*282228*/, 282175 /*282175*/, 282171 /*282171*/, 282066 /*282066*/, 282025 /*282025*/, 269609 /*269609*/, 269597 /*269597*/, 254089 /*254089*/, 252774 /*252774*/, 252773 /*252773*/, 252772 /*252772*/, 257716 /*257716*/, 257419 /*257419*/, 254839 /*254839*/, 254838 /*254838*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(286550, 44301, 0, 0, 110562, 1, 1, 0, '', 22624), -- 286550 +(286193, 44054, 0, 1, 112450, 10, 92, 10, '', 22624), -- 286193 +(286204, 44054, 0, 3, 112449, 100, 92, 1, '8', 22624), -- 286204 +(286192, 44054, 0, 0, 112448, 20, 92, 5, '', 22624), -- 286192 +(286195, 44054, 0, 6, 112447, 34, 92, 3, '', 22624), -- 286195 +(286203, 44054, 0, 2, 112446, 100, 92, 1, '', 22624), -- 286203 +(286191, 44054, 15, -1, 0, 1, 0, 0, 'Purge demons.', 22624), -- 286191 +(285752, 43752, 0, 0, 111449, 1, 3, 0, 'Ignite the Powder Kegs', 22624), -- 285752 +(285795, 43752, 0, 1, 111455, 1, 3, 0, '', 22624), -- 285795 +(285801, 43752, 0, 2, 111603, 1, 0, 0, 'Grapple aboard the King''s Fang', 22624), -- 285801 +(285751, 43751, 0, 0, 111448, 1, 2, 0, 'Sabotage the Plague Cistern', 22624), -- 285751 +(285914, 43751, 0, 2, 111760, 1, 3, 0, '', 22624), -- 285914 +(285913, 43751, 0, 1, 111603, 1, 0, 0, 'Grapple aboard the Deathbringer', 22624), -- 285913 +(284781, 42806, 0, 0, 108827, 1, 1, 0, '', 22624), -- 284781 +(282993, 41774, 1, 1, 136536, 1, 0, 0, '', 22624), -- 282993 +(282992, 41774, 1, 0, 136535, 1, 0, 0, '', 22624), -- 282992 +(282554, 41599, 1, 0, 134564, 10, 0, 0, '', 22624), -- 282554 +(282537, 41582, 1, 0, 137628, 8, 0, 0, '', 22624), -- 282537 +(282523, 41566, 0, 0, 103686, 1, 0, 0, 'Skin the Felhide Gargantuan', 22624), -- 282523 +(282469, 41513, 0, 0, 103647, 1, 0, 0, 'Felwort gathered', 22624), -- 282469 +(282405, 41457, 1, 0, 141230, 1, 0, 0, '', 22624), -- 282405 +(282228, 41337, 1, 0, 134813, 8, 0, 0, '', 22624), -- 282228 +(282175, 41296, 0, 0, 103847, 1, 0, 0, 'Fjarnskaggl Cluster gathered', 22624), -- 282175 +(282171, 41293, 1, 0, 124102, 40, 0, 0, '', 22624), -- 282171 +(282066, 41223, 1, 0, 124103, 40, 0, 0, '', 22624), -- 282066 +(282025, 41209, 0, 0, 103594, 1, 0, 0, 'Brimstone Destroyer Core mined', 22624), -- 282025 +(269609, 32314, 1, 0, 92484, 1, 0, 0, 'Obtain the Sealed Missive', 22624), -- 269609 +(269597, 32314, 0, 1, 68009, 1, 0, 0, 'Kill Shadowmancer Selenora', 22624), -- 269597 +(254089, 8965, 1, 0, 22229, 1, 0, 0, '', 22624), -- 254089 +(252774, 8906, 8, -1, 0, 200000, 0, 0, '', 22624), -- 252774 +(252773, 8906, 1, 1, 16681, 1, 0, 0, '', 22624), -- 252773 +(252772, 8906, 1, 0, 21928, 15, 0, 0, '', 22624), -- 252772 +(257716, 8044, 1, 0, 19576, 1, 0, 0, '', 22624), -- 257716 +(257419, 8043, 1, 0, 19575, 1, 0, 0, '', 22624), -- 257419 +(254839, 2604, 1, 1, 8391, 2, 0, 0, '', 22624), -- 254839 +(254838, 2604, 1, 0, 8396, 10, 0, 0, '', 22624); -- 254838 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=284781 AND `Index`=0) OR (`ID`=282405 AND `Index`=0) OR (`ID`=282175 AND `Index`=0) OR (`ID`=282025 AND `Index`=0) OR (`ID`=269597 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(284781, 0, 2101, 22624), -- 284781 +(282405, 0, 5548, 22624), -- 282405 +(282175, 0, 6049, 22624), -- 282175 +(282025, 0, 6044, 22624), -- 282025 +(269597, 0, 658, 22624); -- 269597 |