diff options
author | Vincent-Michael <vincent_michael@gmx.de> | 2016-10-02 01:01:23 +0200 |
---|---|---|
committer | Vincent-Michael <vincent_michael@gmx.de> | 2016-10-02 01:01:23 +0200 |
commit | 07e0d43ac3eb6812d746931190b8afe76f13fb12 (patch) | |
tree | d0be3e4025ebd9e45baf9019dd2f0626655bdc89 | |
parent | 51ff98ce18366e0e7f44520bb41696ba0c0beb46 (diff) |
DB/Quests: Updated quest_template to 7.0.3.22624 part 17
-rw-r--r-- | sql/updates/world/6.x/2016_10_02_00_world.sql | 150 |
1 files changed, 150 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_10_02_00_world.sql b/sql/updates/world/6.x/2016_10_02_00_world.sql new file mode 100644 index 00000000000..dd3aa2f68ca --- /dev/null +++ b/sql/updates/world/6.x/2016_10_02_00_world.sql @@ -0,0 +1,150 @@ +DELETE FROM `quest_template` WHERE `ID` IN (44896 /*-Unknown-*/, 44290 /*-Unknown-*/, 44172 /*-Unknown-*/, 43687 /*-Unknown-*/, 43560 /*-Unknown-*/, 43438 /*-Unknown-*/, 43192 /*-Unknown-*/, 43063 /*-Unknown-*/, 42927 /*-Unknown-*/, 42922 /*-Unknown-*/, 42870 /*-Unknown-*/, 42796 /*-Unknown-*/, 42769 /*-Unknown-*/, 42764 /*-Unknown-*/, 42757 /*-Unknown-*/, 42745 /*-Unknown-*/, 42712 /*-Unknown-*/, 42636 /*-Unknown-*/, 42240 /*-Unknown-*/, 42176 /*-Unknown-*/, 41948 /*-Unknown-*/, 41816 /*-Unknown-*/, 41675 /*-Unknown-*/, 41538 /*-Unknown-*/, 41519 /*-Unknown-*/, 41507 /*-Unknown-*/, 41353 /*-Unknown-*/, 41347 /*-Unknown-*/, 41338 /*-Unknown-*/, 41291 /*-Unknown-*/, 41290 /*-Unknown-*/, 41278 /*-Unknown-*/, 41259 /*-Unknown-*/, 41252 /*-Unknown-*/, 41196 /*-Unknown-*/, 41188 /*-Unknown-*/, 41187 /*-Unknown-*/, 41186 /*-Unknown-*/, 41077 /*-Unknown-*/, 41014 /*-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 +(44896, 2, 0, 0, 0, 16, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33588224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Tracking Quest', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44290, 3, 110, 0, 110, 7503, 135, 0, 0, 1, 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, 4, 4, 0, 0, 0, 0, 0, 0, -1, 48, 'WANTED: Bristlemaul', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44172, 2, 110, 0, 110, -409, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 193104, 0, 0, 0, 0, 1, 0, 35684424, 8388608, 0, 0, 0, 0, 141889, 141071, 0, 0, 1, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 188, 'The Arena Calls', 'Win 10 Arena Skirmish battles.', 'This alignment of the stars is a dire sign, stirring bloodlust and calling warriors to battle to the death in close quarters. Arena masters turn a tidy profit during these days, likely not understanding why their stands are overflowing. Amidst the excitement, great rewards do await those brave, or foolhardy, enough to venture into the arena....', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43687, 2, -1, 0, 98, -406, 107, 0, 0, 7, 1, 582000, 7, 1, 274350, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748736, 33562880, 0, 0, 0, 0, 139566, 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, 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, 'Walking in Shadows', 'Seek the aid of the Knights of the Ebon Blade in Acherus above the Broken Isles.', 'If we are to infuse the shard''s power into the Ashbringer we will need help. We cannot wield such dark magic; however, I know who can...$B$BThe Knights of the Ebon Blade.$B$BI will commission a flight for you to Acherus at once and meet you there - find Aludane Whitecloud in Dalaran when you are ready.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43560, 2, 100, 0, 110, -406, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 220909, 0, 0, 0, 0, 1, 0, 36700168, 33554432, 0, 0, 0, 0, 139536, 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, 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, 'Audience with the Windlord', 'Witness Thunderaan.', 'I have kept my promise. Thunderaan the Windlord awaits.\n\nKnow that if betrayal is in your heart, the Windlord will not be deceived. Be silent, and perhaps your audience shall be a fortunate one.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43438, 3, 110, 0, 110, 7541, 109, 0, 0, 1, 1, 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: Nameless King', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43192, 3, 110, 0, 110, 7334, 112, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 226986, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 0, 0, -1, 16, 'Terror of the Deep', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43063, 3, 110, 0, 110, 8000, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 0, 0, -1, 52, 'DANGER: Stormfeather', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42927, 3, 110, 0, 110, 7558, 136, 0, 0, 1, 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, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 0, 0, -1, 55, 'DANGER: Malisandra', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42922, 3, 110, 0, 110, 7787, 137, 0, 0, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4803, 0, -1, 186, 'Vault of the Wardens: Startup Sequence', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42870, 3, 110, 0, 110, 7558, 136, 0, 0, 1, 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, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 0, 0, -1, 55, 'DANGER: Kathaw the Savage', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42796, 3, 110, 0, 110, 7637, 109, 0, 0, 1, 1, 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, 4742, 0, -1, 29, 'WANTED: Broodmother Shu''malis', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42769, 3, 110, 0, 110, 8079, 137, 0, 0, 0, 0, 0, 0, 0, 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, 1859, 0, 0, 0, 0, 30000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4761, 0, -1, 181, 'Court of Stars: Bring Me the Eyes', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42764, 3, 110, 0, 110, 8079, 137, 0, 0, 0, 0, 0, 0, 0, 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, 1859, 0, 0, 0, 0, 30000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4761, 0, -1, 181, 'Court of Stars: Wraith in the Machine', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42757, 3, 110, 0, 110, 7812, 137, 0, 0, 0, 0, 0, 0, 0, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4519, 0, -1, 183, 'Maw of Souls: Menace of the Seas', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42745, 3, 110, 0, 110, 7673, 137, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 215617, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4751, 0, -1, 179, 'Darkheart Thicket: A Burden to Bear', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42712, 3, 110, 0, 110, 8040, 137, 0, 0, 0, 0, 0, 0, 0, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4699, 0, -1, 182, 'Eye of Azshara: Termination Claws', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42636, 3, 110, 0, 110, 7334, 109, 0, 0, 1, 1, 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, 3, 3, 0, 0, 0, 0, 0, 0, -1, 21, 'WANTED: Arcanist Shal''iman', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42240, 3, 110, 0, 110, 7672, 137, 0, 0, 0, 0, 0, 0, 0, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4503, 0, -1, 178, 'Halls of Valor: Ponderous Poaching', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42176, 3, 110, 0, 110, 7541, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 221576, 0, 0, 0, 0, 0, 0, 40435968, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4689, 0, -1, 25, 'Rise of Skovald', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41948, 3, 110, 0, 110, 7541, 115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 209144, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 5, 'All Pets Go to Heaven', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41816, 3, 110, 0, 110, 7503, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 226059, 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, 5, 5, 0, 0, 0, 0, 0, 0, -1, 53, 'DANGER: Oubdob da Smasher', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41675, 3, 110, 0, 110, 7334, 122, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 524544, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5, 0, 0, 0, 0, 0, 4221, 0, -1, 78, 'Work Order: Blink-Trigger Headgun', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41538, 3, 110, 0, 110, 7637, 119, 0, 0, 1, 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, 147, 'Iridescent Starlight Roses', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41519, 3, 110, 0, 110, 7541, 119, 0, 0, 1, 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- +(41507, 3, 110, 0, 110, 7541, 120, 0, 0, 1, 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, 4471, 0, -1, 148, 'Leystone Basilisks', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41353, 3, 110, 0, 110, 7637, 120, 0, 0, 1, 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, 149, 'Odious Felslate Outcropping', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41347, 3, 110, 0, 110, 7637, 124, 0, 0, 1, 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, 4339, 0, -1, 141, 'Extra-Rancid Felhound Hide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41338, 3, 110, 0, 110, 7558, 124, 0, 0, 1, 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, 5, 0, 0, 0, 0, 0, 4274, 0, -1, 134, 'Work Order: Stonehide Leather', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41291, 3, 110, 0, 110, 7558, 119, 0, 0, 1, 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 Cluster', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41290, 3, 110, 0, 110, 7334, 119, 0, 0, 1, 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, 'Aqueous Aethril', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41278, 3, 110, 0, 110, 7541, 130, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1769792, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4471, 0, -1, 138, 'Slippery Stormrays', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41259, 3, 110, 0, 110, 7334, 131, 0, 0, 1, 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, 44, 'Slab of Bacon', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41252, 3, 110, 0, 110, 7503, 130, 0, 0, 1, 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, 140, 'Wild Northern Barracuda', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41196, 3, 110, 0, 110, 7503, 120, 0, 0, 1, 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, 4590, 0, -1, 148, 'Leystone Basilisks', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41188, 2, 110, 0, 110, -377, 81, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 223893, 0, 0, 0, 0, 1, 0, 35651592, 8192, 0, 0, 0, 0, 131733, 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, 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, 'Misdirected', 'Go to Neltharion''s Lair and recover the Ancient Highmountain Artifact.', 'I''ve been looking into the history of Huln Highmountain, a legendary warrior from the War of the Ancients whom this very land is named after.$b$bAllegedly some of his personal effects were carried here after his death and have been lost in time.$b$bAfter some digging around I believe I have discovered the location of one of his artifacts to be in a place called Neltharion''s Lair.$b$bI''m no fighter, $n, but you are. Will you go and recover this artifact for me?', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41187, 2, 110, 0, 110, -377, 0, 0, 41188, 0, 1, 0, 0, 1, 0, 0, 0, 0, 205382, 0, 0, 136372, 0, 1, 0, 39845896, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136372, 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, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Surveying Student', 'Complete 20 successful surveys with Luron present.', 'The reason I sent for someone was that I''ve been having trouble keeping up with my research and training my assistant.$b$bI was hoping you might be able to show him the ropes again. Get him reacquainted with surveying.$b$bJust speak with him when you''re ready to go.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41186, 2, 110, 0, 110, -377, 0, 0, 41187, 1, 1, 19400, 1, 1, 18350, 0, 0, 0, 207606, 0, 0, 0, 0, 1, 0, 35651592, 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, 'History of Highmountain', 'Meet with Lessah in Highmountain.', 'Let''s see, one... two... three... oh, hello $n. Sorry I didn''t see you come in.$b$bThings have been hectic around here. I could really use an assistant.$b$bI do have something for you though, a fellow archaeologist named Lessah has been asking for someone to help her in Highmountain.$b$bI thought you''d be the perfect person for the job.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41077, 3, 110, 0, 110, 7503, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 206438, 0, 0, 0, 0, 0, 0, 36241664, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4842, 0, -1, 23, 'Munitions Testing', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41014, 3, 110, 0, 110, 7503, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 206523, 0, 0, 0, 0, 0, 0, 41615616, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 133944, 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, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4539, 0, -1, 23, 'Fury Road', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624); -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (286514 /*286514*/, 286328 /*286328*/, 286250 /*286250*/, 286222 /*286222*/, 286221 /*286221*/, 286219 /*286219*/, 285527 /*285527*/, 285276 /*285276*/, 285089 /*285089*/, 285028 /*285028*/, 284907 /*284907*/, 284898 /*284898*/, 284897 /*284897*/, 284851 /*284851*/, 284767 /*284767*/, 284725 /*284725*/, 284724 /*284724*/, 284723 /*284723*/, 284722 /*284722*/, 284711 /*284711*/, 284710 /*284710*/, 286781 /*286781*/, 284676 /*284676*/, 284627 /*284627*/, 284626 /*284626*/, 284511 /*284511*/, 283954 /*283954*/, 283953 /*283953*/, 283857 /*283857*/, 285624 /*285624*/, 283175 /*283175*/, 282878 /*282878*/, 282640 /*282640*/, 282495 /*282495*/, 282475 /*282475*/, 282457 /*282457*/, 282244 /*282244*/, 282238 /*282238*/, 282229 /*282229*/, 282169 /*282169*/, 282168 /*282168*/, 282158 /*282158*/, 282349 /*282349*/, 282138 /*282138*/, 282120 /*282120*/, 281999 /*281999*/, 284239 /*284239*/, 282023 /*282023*/, 282831 /*282831*/, 282830 /*282830*/, 282829 /*282829*/, 282821 /*282821*/, 282016 /*282016*/, 282123 /*282123*/, 281803 /*281803*/, 281858 /*281858*/, 281801 /*281801*/, 281653 /*281653*/, 281652 /*281652*/, 260961 /*260961*/, 260960 /*260960*/, 260959 /*260959*/, 260203 /*260203*/, 260057 /*260057*/, 255669 /*255669*/, 258249 /*258249*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(286514, 44290, 0, 0, 97449, 1, 1, 0, '', 22624), -- 286514 +(286328, 44172, 14, 0, 53033, 1, 0, 0, 'Arena Skirmishes won', 22624), -- 286328 +(286250, 43687, 0, 3, 112579, 1, 4, 0, '(Optional) Leave Acherus', 22624), -- 286250 +(286222, 43687, 0, 2, 112509, 1, 2, 0, 'Four Horsemen''s aid received', 22624), -- 286222 +(286221, 43687, 0, 1, 112508, 1, 2, 0, 'Speak to Tyrosus', 22624), -- 286221 +(286219, 43687, 0, 0, 112490, 1, 0, 0, 'Fly to Acherus', 22624), -- 286219 +(285527, 43560, 0, 0, 110990, 1, 0, 0, 'Audience with Thunderaan', 22624), -- 285527 +(285276, 43438, 0, 0, 92763, 1, 1, 0, 'Nameless King slain.', 22624), -- 285276 +(285089, 43192, 0, 0, 108829, 1, 0, 0, '', 22624), -- 285089 +(285028, 43063, 0, 0, 109594, 1, 0, 0, 'Stormfeather slain', 22624), -- 285028 +(284907, 42927, 0, 0, 109281, 1, 1, 0, '', 22624), -- 284907 +(284898, 42922, 0, 1, 95888, 1, 0, 0, 'Cordana defeated', 22624), -- 284898 +(284897, 42922, 0, 0, 109284, 1, 0, 0, 'Complete the startup sequence', 22624), -- 284897 +(284851, 42870, 0, 0, 109125, 1, 1, 0, '', 22624), -- 284851 +(284767, 42796, 0, 0, 105632, 1, 1, 0, '', 22624), -- 284767 +(284725, 42769, 0, 1, 104218, 1, 0, 0, 'Advisor Melandrus slain', 22624), -- 284725 +(284724, 42769, 0, 0, 108740, 1, 0, 0, 'Velimar slain', 22624), -- 284724 +(284723, 42764, 0, 1, 104218, 1, 0, 0, 'Advisor Melandrus slain', 22624), -- 284723 +(284722, 42764, 0, 0, 108701, 1, 0, 0, 'Ataxius slain', 22624), -- 284722 +(284711, 42757, 0, 1, 96759, 1, 0, 0, 'Helya defeated.', 22624), -- 284711 +(284710, 42757, 0, 0, 108494, 1, 0, 0, 'Soulfiend Tagerma slain', 22624), -- 284710 +(286781, 42745, 0, 1, 99192, 1, 0, 0, 'Shade of Xavius defeated', 22624), -- 286781 +(284676, 42745, 0, 0, 95779, 9, 0, 0, 'Defeat Bears', 22624), -- 284676 +(284627, 42712, 0, 1, 96028, 1, 0, 0, 'Wrath of Azshara slain', 22624), -- 284627 +(284626, 42712, 0, 0, 101411, 1, 0, 0, 'Gom Crabbar slain', 22624), -- 284626 +(284511, 42636, 0, 0, 107657, 1, 1, 0, 'Arcanist Shal''iman slain.', 22624), -- 284511 +(283954, 42240, 0, 1, 95676, 1, 0, 0, 'Odyn defeated', 22624), -- 283954 +(283953, 42240, 0, 0, 96647, 1, 0, 0, 'Earlnoc the Beastbreaker slain', 22624), -- 283953 +(283857, 42176, 0, 1, 106587, 1, 1, 0, '', 22624), -- 283857 +(285624, 42176, 0, 0, 106568, 10, 0, 0, '', 22624), -- 285624 +(283175, 41948, 11, 0, 105512, 1, 0, 0, 'Defeat Envoy of the Hunt', 22624), -- 283175 +(282878, 41816, 0, 0, 95204, 1, 1, 0, 'Oubdob da Smasher slain.', 22624), -- 282878 +(282640, 41675, 1, 0, 132500, 1, 0, 0, '', 22624), -- 282640 +(282495, 41538, 1, 0, 140991, 10, 0, 0, '', 22624), -- 282495 +(282475, 41519, 0, 0, 103647, 1, 0, 0, 'Felwort gathered', 22624), -- 282475 +(282457, 41507, 1, 0, 134104, 40, 0, 0, '', 22624), -- 282457 +(282244, 41353, 1, 0, 141246, 1, 0, 0, '', 22624), -- 282244 +(282238, 41347, 1, 0, 134819, 8, 0, 0, '', 22624), -- 282238 +(282229, 41338, 1, 0, 124113, 40, 0, 0, '', 22624), -- 282229 +(282169, 41291, 0, 0, 103845, 1, 0, 0, 'Dreamleaf Cluster gathered', 22624), -- 282169 +(282168, 41290, 1, 0, 135480, 12, 0, 0, '', 22624), -- 282168 +(282158, 41278, 1, 0, 135489, 24, 2, 0, '', 22624), -- 282158 +(282349, 41278, 1, 1, 135496, 1, 0, 0, '', 22624), -- 282349 +(282138, 41259, 1, 0, 135511, 1, 0, 0, '', 22624), -- 282138 +(282120, 41252, 1, 0, 134547, 10, 0, 0, '', 22624), -- 282120 +(281999, 41196, 1, 0, 134104, 40, 0, 0, '', 22624), -- 281999 +(284239, 41188, 0, 1, 91007, 1, 0, 0, '', 22624), -- 284239 +(282023, 41188, 1, 0, 134093, 1, 0, 0, '', 22624), -- 282023 +(282831, 41187, 14, 5, 47152, 1, 28, 0, 'Secret Credit 15', 22624), -- 282831 +(282830, 41187, 14, 4, 47150, 1, 28, 0, 'Secret Credit 9', 22624), -- 282830 +(282829, 41187, 14, 0, 47148, 1, 28, 0, 'Secret Credit 4', 22624), -- 282829 +(282821, 41187, 14, 2, 47146, 1, 28, 0, 'Secret Credit 1', 22624), -- 282821 +(282016, 41187, 14, 0, 46934, 1, 2, 0, '', 22624), -- 282016 +(282123, 41187, 0, 1, 103735, 1, 0, 0, 'Speak with Luron', 22624), -- 282123 +(281803, 41077, 0, 0, 103103, 15, 2, 0, 'Hunt animals using Razik''s prototype', 22624), -- 281803 +(281858, 41077, 2, 2, 246975, 1, 2, 0, 'Grab a prototype from Razik''s weapon rack', 22624), -- 281858 +(281801, 41077, 3, 1, 99468, 1, 0, 0, 'Speak to Gertie', 22624), -- 281801 +(281653, 41014, 1, 1, 133947, 100, 2, 0, 'Unrefined Gems', 22624), -- 281653 +(281652, 41014, 0, 0, 102689, 1, 1, 0, 'Obtain a crystal from Shardmaster Ufrogg', 22624), -- 281652 +(260961, 8911, 8, -1, 0, 200000, 0, 0, '', 22624), -- 260961 +(260960, 8911, 1, 1, 16703, 1, 0, 0, '', 22624), -- 260960 +(260959, 8911, 1, 0, 21928, 15, 0, 0, '', 22624), -- 260959 +(260203, 8161, 4, -1, 392, 297, 0, 0, '', 22624), -- 260203 +(260057, 8160, 4, -1, 392, 297, 0, 0, '', 22624), -- 260057 +(255669, 5466, 1, 0, 13626, 1, 0, 0, '', 22624), -- 255669 +(258249, 3842, 1, 0, 3825, 2, 0, 0, '', 22624); -- 258249 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=286250 AND `Index`=0) OR (`ID`=286222 AND `Index`=0) OR (`ID`=286221 AND `Index`=0) OR (`ID`=286219 AND `Index`=0) OR (`ID`=285089 AND `Index`=0) OR (`ID`=285028 AND `Index`=0) OR (`ID`=284907 AND `Index`=0) OR (`ID`=284898 AND `Index`=0) OR (`ID`=284897 AND `Index`=1) OR (`ID`=284897 AND `Index`=0) OR (`ID`=284851 AND `Index`=0) OR (`ID`=284725 AND `Index`=0) OR (`ID`=284724 AND `Index`=0) OR (`ID`=284723 AND `Index`=0) OR (`ID`=284722 AND `Index`=0) OR (`ID`=284711 AND `Index`=0) OR (`ID`=284710 AND `Index`=0) OR (`ID`=286781 AND `Index`=0) OR (`ID`=284627 AND `Index`=0) OR (`ID`=284626 AND `Index`=0) OR (`ID`=283954 AND `Index`=0) OR (`ID`=283953 AND `Index`=0) OR (`ID`=283175 AND `Index`=0) OR (`ID`=282169 AND `Index`=0) OR (`ID`=282158 AND `Index`=0) OR (`ID`=282138 AND `Index`=0) OR (`ID`=282120 AND `Index`=0) OR (`ID`=282023 AND `Index`=0) OR (`ID`=282123 AND `Index`=0) OR (`ID`=281803 AND `Index`=3) OR (`ID`=281803 AND `Index`=2) OR (`ID`=281803 AND `Index`=1) OR (`ID`=281803 AND `Index`=0) OR (`ID`=281858 AND `Index`=0) OR (`ID`=281801 AND `Index`=0) OR (`ID`=281652 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(286250, 0, 5816, 22624), -- 286250 +(286222, 0, 5815, 22624), -- 286222 +(286221, 0, 2099, 22624), -- 286221 +(286219, 0, 5287, 22624), -- 286219 +(285089, 0, 2101, 22624), -- 285089 +(285028, 0, 2101, 22624), -- 285028 +(284907, 0, 2101, 22624), -- 284907 +(284898, 0, 2101, 22624), -- 284898 +(284897, 1, 6480, 22624), -- 284897 +(284897, 0, 2101, 22624), -- 284897 +(284851, 0, 2101, 22624), -- 284851 +(284725, 0, 2101, 22624), -- 284725 +(284724, 0, 2101, 22624), -- 284724 +(284723, 0, 2101, 22624), -- 284723 +(284722, 0, 2101, 22624), -- 284722 +(284711, 0, 2101, 22624), -- 284711 +(284710, 0, 2101, 22624), -- 284710 +(286781, 0, 2101, 22624), -- 286781 +(284627, 0, 2101, 22624), -- 284627 +(284626, 0, 2101, 22624), -- 284626 +(283954, 0, 2101, 22624), -- 283954 +(283953, 0, 2101, 22624), -- 283953 +(283175, 0, 4796, 22624), -- 283175 +(282169, 0, 6057, 22624), -- 282169 +(282158, 0, 5830, 22624), -- 282158 +(282138, 0, 5669, 22624), -- 282138 +(282120, 0, 6219, 22624), -- 282120 +(282023, 0, 4580, 22624), -- 282023 +(282123, 0, 4579, 22624), -- 282123 +(281803, 3, 4549, 22624), -- 281803 +(281803, 2, 4548, 22624), -- 281803 +(281803, 1, 4547, 22624), -- 281803 +(281803, 0, 4546, 22624), -- 281803 +(281858, 0, 2100, 22624), -- 281858 +(281801, 0, 2099, 22624), -- 281801 +(281652, 0, 2099, 22624); -- 281652 |