Dataquest Submission

Discussion for various features for Dawn of Light: Storm

Moderators: Project Admin, Support Team, Storm Team

Dataquest Submission

Postby mattress » Sun Nov 20, 2011 4:40 pm

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);
Last edited by mattress on Sun Nov 20, 2011 8:24 pm, edited 1 time in total.
Matt450/Variations of "Matt"
User avatar
mattress
Server Team
 
Posts: 277
Joined: Mon Jul 05, 2010 3:30 am
Location: Oceanside, California

Big Cat Hunting

Postby mattress » Sun Nov 20, 2011 8:23 pm

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);
Matt450/Variations of "Matt"
User avatar
mattress
Server Team
 
Posts: 277
Joined: Mon Jul 05, 2010 3:30 am
Location: Oceanside, California

Re: Dataquest Submission

Postby Graveen » Sun Nov 20, 2011 9:00 pm

TY Mattress, 'll incolude them on Storm !
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 11968
Joined: Fri Oct 19, 2007 9:22 pm
Location: France

Way of the Cat

Postby mattress » Mon Nov 21, 2011 5:15 am

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);
Matt450/Variations of "Matt"
User avatar
mattress
Server Team
 
Posts: 277
Joined: Mon Jul 05, 2010 3:30 am
Location: Oceanside, California


Return to Feature Discussion

Who is online

Users browsing this forum: No registered users and 0 guests