mirror of
https://github.com/araxiaonline/ScourgeInvasion.git
synced 2026-06-13 03:02:21 -04:00
24 lines
4.6 KiB
SQL
24 lines
4.6 KiB
SQL
DELETE FROM `quest_template` WHERE (`ID` = 12616);
|
|
INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardDisplaySpell`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `Flags`, `RequiredPlayerKills`, `RewardItem1`, `RewardAmount1`, `RewardItem2`, `RewardAmount2`, `RewardItem3`, `RewardAmount3`, `RewardItem4`, `RewardAmount4`, `ItemDrop1`, `ItemDropQuantity1`, `ItemDrop2`, `ItemDropQuantity2`, `ItemDrop3`, `ItemDropQuantity3`, `ItemDrop4`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemQuantity1`, `RewardChoiceItemID2`, `RewardChoiceItemQuantity2`, `RewardChoiceItemID3`, `RewardChoiceItemQuantity3`, `RewardChoiceItemID4`, `RewardChoiceItemQuantity4`, `RewardChoiceItemID5`, `RewardChoiceItemQuantity5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardTalents`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionValue1`, `RewardFactionOverride1`, `RewardFactionID2`, `RewardFactionValue2`, `RewardFactionOverride2`, `RewardFactionID3`, `RewardFactionValue3`, `RewardFactionOverride3`, `RewardFactionID4`, `RewardFactionValue4`, `RewardFactionOverride4`, `RewardFactionID5`, `RewardFactionValue5`, `RewardFactionOverride5`, `TimeAllowed`, `AllowableRaces`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `VerifiedBuild`) VALUES
|
|
(12616, 2, 70, 70, 2562, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 74, 0, 40354, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38629, 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, 'Chamber of Secrets', 'The Argent Dawn Emissary wants you to search the chamber of Tenris Mirkblood within the Servant\'s Quarters of Karazhan.', 'Excellent, an experienced adventurer. Precisely what we need.$b$bThere has been talk from the Kirin Tor guarding Medivh\'s tower that something is amiss with Karazhan. There is a new power lurking within, one that answers neither to the Guardian\'s magic nor the Legion. From what they\'ve scouted, it appears it is an elven prince called Tenris Mirkblood, and there is reason to believe he serves the Scourge.$b$bGo, my friend, investigate Mirkblood\'s chamber, and return with any information you might find.', '', 'Return to Argent Emissary.', 28194, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Kill Prince Tenris Mirkblood', '', '', '', 12340);
|
|
|
|
DELETE FROM `quest_template_addon` WHERE (`ID` = 12616);
|
|
INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES
|
|
(12616, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
|
|
|
|
DELETE FROM `quest_offer_reward` WHERE (`ID` = 12616);
|
|
INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
|
|
(12616, 0, 0, 0, 0, 0, 0, 0, 0, 'The information you report is dire indeed if the orders you saw are legitimate. We can only hope that his mission was stopped early enough to prevent the enemy from knowing too much about our strengths.$b$bThank you, $N. May you remain safe in these dark times.', 12340);
|
|
|
|
DELETE FROM `quest_request_items` WHERE (`ID` = 12616);
|
|
INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `CompletionText`, `VerifiedBuild`) VALUES
|
|
(12616, 0, 0, 'What have you discovered?', 12340);
|
|
|
|
DELETE FROM `creature_queststarter` WHERE (`quest` = 12616);
|
|
INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
|
|
(16285, 12616);
|
|
|
|
DELETE FROM `creature_questender` WHERE (`quest` = 12616);
|
|
INSERT INTO `creature_questender` (`id`, `quest`) VALUES
|
|
(16285, 12616);
|