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);
- 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);