Dawn of Light

Mid Tutorial zone quest, "Hunting Season," tested and working.
The quest:

Code: Select all

INSERT INTO `dataquest` (`ID`, `Name`, `StartType`, `StartName`, `StartRegionID`, `AcceptText`, `Description`, `SourceName`, `SourceText`, `StepType`, `StepText`, `StepItemTemplates`, `AdvanceText`, `TargetName`, `TargetText`, `CollectItemTemplate`, `MaxCount`, `MinLevel`, `MaxLevel`, `RewardMoney`, `RewardXP`, `RewardCLXP`, `RewardRP`, `RewardBP`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (3654, 'Hunting Season', 0, 'Boeth', 27, 'assistance', 'Hello, road weary traveler. Welcome to the Hammer and Axe. I am Boeth, barkeep and chef extrordinaire. This tavern is a place of respite for travelers such as yourself, as well as locals who need to escape from the pressures of day to day life. Especially with all these vendo raids. \n\nI\'ve heard that you have been quite helpful to the locals as of late, I wonder id you would be of some [assistance] to me. My task is nothing too difficult. I don\'t need you to hunt down some vendo thug or guard my supply lines or anything like that. I just need you to hunt some deer and return to me with the venison. It makes a wonderful stew. \n\nThey can be found in the woods to the north. Happy hunting.', NULL, '|||Hand me the Venison.|Hand me the next piece of Venison.|Hand me the final piece of Venison.', '0|0|0|2|2|3', 'Boeth needs venison for his stew. He has asked you to kill three deer and return to him with the meat.|Boeth needs venison for his stew. Kill two more deer and return to him with the meat.|Boeth needs venison for his stew. Kill one more deer and return to him with the meat.|Deliver the Venison to Boeth.|Hand Boeth the second piece of Venison.|Give the final piece of Venison to Boeth.', 'Venison|Venison|Venison|||', NULL, 'deer;27|deer;27|deer;27|Boeth;27|Boeth;27|Boeth;27', NULL, '|||Venison|Venison|Venison', 1, 9, 10, '0|0|0|0|0|1136', '0|0|0|0|0|11000', NULL, NULL, NULL, NULL, NULL, 'This will make a wonderful stew, thank you! Please take this small amount of money as a token of my appreciation.', NULL, NULL, NULL);

The itemtemplate needed for the collectitem(if you don't already have "Venison" in the Storm table):

Code: Select all

INSERT INTO `itemtemplate` (`Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `IsNotLosingDur`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `ExtraBonusType`, `CanUseEvery`, `SpellID`, `Charges`, `MaxCharges`, `SpellID1`, `Charges1`, `MaxCharges1`, `ProcChance`, `ProcSpellID`, `ProcSpellID1`, `PoisonSpellID`, `PoisonCharges`, `PoisonMaxCharges`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `Price`, `MaxCount`, `IsIndestructible`, `PackSize`, `Realm`, `AllowedClasses`, `Flags`, `BonusLevel`, `LevelRequirement`, `PackageID`, `Description`, `ClassType`, `SalvageYieldID`, `ItemTemplate_ID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('Venison', 'Venison', 1, 50000, 50000, NULL, 50000, 50000, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 102, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 1, NULL, 1, 0, NULL, NULL, NULL, NULL, 'dolpubdb', NULL, NULL, NULL, 'Venison', NULL, NULL, NULL);

This will add another quest to the Midgard Commander in Jordheim, he does not currently have this quest. The other quests he has are probably scripted, so I'm not sure how this one will work out with him. I'm assuming this will add another set of dialog under what is already there??

Code: Select all

INSERT INTO `dataquest` (`ID`, `Name`, `StartType`, `StartName`, `StartRegionID`, `AcceptText`, `Description`, `SourceName`, `SourceText`, `StepType`, `StepText`, `StepItemTemplates`, `AdvanceText`, `TargetName`, `TargetText`, `CollectItemTemplate`, `MaxCount`, `MinLevel`, `MaxLevel`, `RewardMoney`, `RewardXP`, `RewardCLXP`, `RewardRP`, `RewardBP`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (13675, 'Big Cat Hunting', 0, 'Midgard Commander', 101, 'Shrouded Isles', 'Midgard Commander says, "I have a task that involves [Shrouded Isles]."', NULL, 'We\'ve been having some problems with our mining expeditions in and around the Delling Crater. It seems the Sabre-Toothed Cats are becoming much more aggressive than normal, and have been raiding our camps. I need you to go there and reduce the numbers.||', '0|0|1', 'Kill 3 Saber-Toothed Cats in Delling Crater.|Kill 2 Saber-Toothed Cats in Delling Crater.|Kill 1 Saber-Toothed Cat in Delling Crater.', NULL, NULL, 'saber-toothed cat;151|saber-toothed cat;151|saber-toothed cat;151', NULL, NULL, 1, 47, 50, '0|0|10000', '0|0|1300000000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

TY Mattress, 'll incolude them on Storm !

Very welcome...
Midgard Tutorial quest "Way of the Cat." Tested and working.
Quest:

Code: Select all

INSERT INTO `dataquest` (`ID`, `Name`, `StartType`, `StartName`, `StartRegionID`, `AcceptText`, `Description`, `SourceName`, `SourceText`, `StepType`, `StepText`, `StepItemTemplates`, `AdvanceText`, `TargetName`, `TargetText`, `CollectItemTemplate`, `MaxCount`, `MinLevel`, `MaxLevel`, `RewardMoney`, `RewardXP`, `RewardCLXP`, `RewardRP`, `RewardBP`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (8663, 'Way of the Cat', 0, 'Tyla', 27, 'lynx hide', 'Hello, word has spread throughout the Sound about your heroic deeds. I wonder, do you have the time to aid in the concern of mine. I do hate to beg, or give you a poor example of our citizenry. \n\nAs you may or may not know, I am a cloth merchant. My wares have seen use in warfare and tableware. Do you like that? I think I may use it to boost business. Anyway, my usual supplier has had trouble getting through because of the Albion siege. \n\nIf you could hunt a few lynx by the cliffs not far from here, that should supplement my supply rather well. The [lynx hide] is softer and more flexible then that of the bear. It is excellent for light armor.', NULL, 'Thank you, please return when you have the pelts.|||||||||', '0|0|0|0|0|2|2|2|2|3', 'The Albion siege has kept Tyla\'s leather suppler from making her delivery. She has asked you to collect pelts from the lynx that reside by the cliffs to the south.|Collect pelts from lynx near the cliffs (4)|Collect pelts from lynx near the cliffs (3)|Collect pelts from lynx near the cliffs (2)|Collect pelts from lynx near the cliffs (1)|Return with the pelts and give them to Tyla.|Finish giving the pelts to Tyla.|Finish giving the pelts to Tyla.|Finish giving the pelts to Tyla.|Finish giving the pelts to Tyla.', 'lynx_pelt|lynx_pelt|lynx_pelt|lynx_pelt|lynx_pelt|||||', NULL, 'lynx;27|lynx;27|lynx;27|lynx;27|lynx;27|Tyla;27|Tyla;27|Tyla;27|Tyla;27|Tyla;27', '|||||||||', '|||||lynx_pelt|lynx_pelt|lynx_pelt|lynx_pelt|lynx_pelt', 1, 10, 15, '0|0|0|0|0|0|0|0|0|1469', '0|0|0|0|0|0|0|0|0|25000', NULL, NULL, NULL, NULL, NULL, 'Thank you, my friend, these pelts will do nicely, please accept this reward as a token of my thanks.', NULL, NULL, NULL);

Required step/collect item, Lynx Pelt:

Code: Select all

INSERT INTO `itemtemplate` (`Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `IsNotLosingDur`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `ExtraBonusType`, `CanUseEvery`, `SpellID`, `Charges`, `MaxCharges`, `SpellID1`, `Charges1`, `MaxCharges1`, `ProcChance`, `ProcSpellID`, `ProcSpellID1`, `PoisonSpellID`, `PoisonCharges`, `PoisonMaxCharges`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `Price`, `MaxCount`, `IsIndestructible`, `PackSize`, `Realm`, `AllowedClasses`, `Flags`, `BonusLevel`, `LevelRequirement`, `PackageID`, `Description`, `ClassType`, `SalvageYieldID`, `ItemTemplate_ID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('lynx_pelt', 'Lynx Pelt', 5, 50000, 50000, NULL, 50000, 50000, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 5, NULL, NULL, 0, '', NULL, NULL, NULL, 'dolpubdb', '', NULL, NULL, 'lynx_pelt', NULL, NULL, NULL);