Page 1 of 2

[added to Storm] Dataquest Submissions

PostPosted: Fri Sep 02, 2011 7:42 am
by mattress
Gonna post quests I create here, this one is Quell the Invasion in Grenlock's Sound, the quest and items below, I tested it and it works. For your review: ......just fixed the AF on the studded boots, hadn't noticed I made it 19 instead of 10!
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`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (16454, 'Quell the Invasion', 200, 'Captain Hreldan', 27, NULL, 'Captain Hreldan wants you to kill 3 Albion Invaders.', NULL, 'We used to hold a tower on that island out there, but those bloodthirsty Albion scoundrels attacked us and drove our forces back. I need you to reinforce our soldiers who are still there. Talk to the dockmaster and get a ticket from him to take a boat to the island. Kill any invaders you can. They have encroached upon us for long enough.|||', '0|0|0|5', 'Captain Hreldan wants you to kill some of the invaders on the southern island. Talk to the dockmaster and get a ticket from him. Hand him the ticket to get to the island. Return to him when you are done.|Kill 2 more Albion Invaders.|Kill 1 more Albion Invader.|Return to Captain Hreldan', NULL, NULL, 'Albion Invader;27|Albion Invader;27|Albion Invader;27|Captain Hreldan;27', NULL, NULL, 1, 4, 10, '0|0|0|248', '0|0|0|965', '2sounds_cloth_boot_mid|sounds_studded_boot_mid|sounds_leather_boot_mid', NULL, 'Thank you for the assistance, please take one of these items to assist you in your future service to the realm.', NULL, NULL, NULL);

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 ('sounds_studded_boot_mid', 'Sound\'s Studded Boots', 10, 50000, 50000, 0, 50000, 50000, 100, 10, 19, 0, 0, 34, 23, 0, 0, 0, 40, 84, 0, 5, 3, 3, 1, 2, 0, 0, 0, 0, 0, 0, 0, 2, 1, 16, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1000, 1, 0, 1, 2, '0', 0, 4, 4, 'GrenlockSoundQuestItem', '', '', NULL, '14860df8-0b1f-4fba-837f-98c17a75f06d', NULL, NULL, NULL);

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 ('sounds_leather_boot_mid', 'Sound\'s Leather Boots', 10, 50000, 50000, 0, 50000, 50000, 100, 10, 10, 0, 0, 33, 23, 0, 0, 0, 40, 244, 0, 5, 3, 3, 1, 2, 0, 0, 0, 0, 0, 0, 0, 2, 1, 15, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1000, 1, 0, 1, 2, '0', 0, 4, 4, 'GrenlockSoundQuestItem', '', '', NULL, '14261df8-0b1f-4fba-837f-98c17a75f06d', NULL, NULL, NULL);

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 ('sounds_cloth_boot_mid', 'Sound\'s Cloth Boots', 10, 50000, 50000, 0, 50000, 50000, 100, 5, 0, 0, 0, 32, 23, 6, 0, 0, 40, 382, 0, 5, 3, 1, 2, 3, 0, 0, 0, 0, 0, 0, 0, 2, 16, 19, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1000, 1, 0, 1, 2, '0', 0, 4, 4, 'GrenlockSoundQuestItem', '', '', NULL, '3764f6c8-f6ef-4e12-9a65-98180eca2686', NULL, NULL, NULL);

Re: Dataquest Submissions

PostPosted: Fri Sep 02, 2011 8:15 am
by Graveen
Thank you, excellent !

Quest: The benefits of Potions

PostPosted: Fri Sep 02, 2011 8:17 am
by mattress
Tested and functioning properly....pasted it right this time!
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`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (12956, 'The Benefits of Potions', 200, 'Captain Hreldan', 27, NULL, 'Speak with Captain Hreldan about potions.', NULL, 'Hail to you. If you are looking for something to assist you in the fight for the realm, I would recommend the potions made by Alchemists. They come in many varieties with several different benefits to the imbiber. Some potions Provide you with great strength, while others help you swing your weapon faster. There are potions that will benefit those from all schools of the realm. (To drink a potion, right-click it to bring up the small information window and then type /use, or place the spell icon attached to it on your hotbar and click it.)', '5', 'Continue speaking to Captain Hreldan.', NULL, NULL, 'Captain Hreldan;27', NULL, NULL, 1, 1, 10, '5', '2', '', 'Elixir_of_Might2', 'Use this knowledge for the glory of the realm!', NULL, NULL, NULL);

Re: Dataquest Submissions

PostPosted: Fri Sep 02, 2011 9:20 am
by Graveen
Can you give the export version of your above CSV export, and tell what it refers ? ty ;)

Quest: Reporting for Duty

PostPosted: Fri Sep 02, 2011 11:12 am
by mattress
Tested and functioning. This one inserts an item into the itemtemplate table for the quest item.
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`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (23645, 'Reporting for Duty', 0, 'Captain Hreldan', 27, 'favor', 'Thanks for all your help here. Can you do me a [favor]? I hate to take any more of your time, but it\'s important that the Gythja Brodira have this progress report. It speaks quite highly of you as well. You can find her up the road. She is usually outside of her home.', NULL, 'Talk to Captain Hreldan again to receive the report.|Please deliver the report the Gythja Brodira in Hafheim.', '4|3', 'Talk to Captain Hreldan again to receive the report.|Deliver the report to Gythja Brodira in Hafheim.', 'grenlock_report|', NULL, 'Captain Hreldan;27|Brodira;27', '', '|grenlock_report', 1, 5, 10, '0|248', '0|965', '', NULL, 'You have completed the Reporting for Duty quest!', NULL, NULL, NULL);

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 ('grenlock_report', 'Report from Captain Hreldan', 0, 50000, 50000, NULL, 50000, 50000, 100, 0, 0, 0, 0, 0, 40, 0, 0, 0, 1, 499, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 0, 0, 0, 0, 1, NULL, 1, NULL, '', NULL, NULL, NULL, 'grenlocksoundquestitem', 'Non Public', NULL, NULL, 'grenlock_report', NULL, NULL, NULL);

Quest: A Distant Shore

PostPosted: Fri Sep 02, 2011 11:14 am
by mattress
Tested and working, this will apply to all 3 realms due to the duplicates of "Dockmaster" and "Dockmistress" in region 27.
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`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (2665, 'A Distant Shore', 0, 'Dockmaster', 27, 'ticket', 'Aye, I\'ve seen some fine ships in my day. This one here is one of the finest. Sadly, it\'s doom to the life of a cargo and ferry boat. I can give you a [ticket] to the island out there if you need it. Just let me know, friend.', NULL, 'Purchase a ticket and hand it to the dockmaster.|Speak with the dockmistress on the isle.', '4|5', 'Purchase a ticket and hand it to the dockmaster.|Speak with the dockmistress on the isle.', NULL, NULL, 'Dockmaster;27|Dockmistress;27', NULL, '', 1, 4, 10, '0|153', '0|405', NULL, NULL, 'You have completed A Distant Shore quest!', NULL, NULL, NULL);

Quest: The Matriarch

PostPosted: Fri Sep 02, 2011 2:04 pm
by mattress
Tested and working. Quest and 3 reward items, all the quests I've submitted are for Mid Tutorial zone btw.
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`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (3452, 'The Matriarch', 200, 'Commander Culino', 27, NULL, 'Every year I\'d swear the rat problem around here gets worse. It\'s time someone showed these vermin who\'s boss! I\'ve seen one recently, looked about twice the size of a normal rat. That rat must be the nest mother. Find her and end her disgusting existence. ', NULL, 'Kill the Rat Matriarch.|Return to Commander Culino', '0|5', 'Kill the Rat Matriarch.|Return to Commander Culino.', NULL, NULL, 'Rat Matriarch;27|Commander Culino;27', NULL, NULL, 1, 3, 10, '0|81', '0|145', '2sounds_cloth_leggings_of_grace_mid|sounds_leather_leggings_of_skill_mid|sounds_studded_leggings_of_power_mid', NULL, 'Please take one of these items as a token of my appreciation!', NULL, NULL, NULL);

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 ('sounds_cloth_leggings_of_grace_mid', 'Sound\'s Cloth Leggings of Grace', 5, 50000, 50000, 0, 50000, 50000, 100, 5, 0, 0, 0, 32, 27, 0, 0, 0, 40, 246, 0, 5, 3, 2, 3, 2, 0, 0, 0, 0, 0, 0, 0, 3, 18, 10, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1000, 1, 0, 1, 2, '0', 0, 0, 4, 'GrenlockSoundQuestItem', '', '', NULL, 'c3f8a820-91aa-4929-bcf8-488b9c7a282c', NULL, NULL, NULL);

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 ('sounds_leather_leggings_of_skill_mid', 'Sound\'s Leather Leggings of Skill', 5, 50000, 50000, 0, 50000, 50000, 100, 10, 10, 0, 0, 33, 27, 0, 0, 0, 40, 37, 0, 5, 3, 2, 2, 3, 0, 0, 0, 0, 0, 0, 0, 3, 19, 18, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1000, 1, 0, 1, 2, '0', 0, 0, 4, 'GrenlockSoundQuestItem', '', '', NULL, 'e1cecb70-0991-4b7c-ae8b-d3a9f2714e6b', NULL, NULL, NULL);

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 ('sounds_studded_leggings_of_power_mid', 'Sound\'s Studded Leggings of Power', 5, 50000, 50000, 0, 50000, 50000, 100, 10, 19, 0, 0, 34, 27, 0, 0, 0, 40, 271, 0, 5, 3, 3, 2, 2, 0, 0, 0, 0, 0, 0, 0, 3, 10, 12, 19, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1000, 1, 0, 1, 2, '0', 0, 0, 4, 'GrenlockSoundQuestItem', '', '', NULL, 'fbc2d5b6-6df8-4e48-9585-1a2c9eef5e7d', NULL, NULL, NULL);

Quest: The Specialists

PostPosted: Fri Sep 02, 2011 2:28 pm
by mattress
Tested and working.
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`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (4328, 'The Specialists', 0, 'Miraveth', 27, 'walk', 'Did you know that there are specialized merchants that can perform specific services for you? You\'d better believe it! If you go [walk] around Hafheim some of the people here can explain their specialties to you.', NULL, 'Speak with Alarma the Recharger, Marirun the Enchanter, and Yulinte the Vault Keeper.|||', '4|4|4|5', 'Speak with Alarma the Recharger.|Speak with Marirun the Enchanter.|Speak with Yulinte the Vault Keeper.|Return to Miraveth for your reward.', NULL, NULL, 'Alarma;27|Marirun;27|Yulinte;27|Miraveth;27', NULL, NULL, 1, 2, 10, '0|0|0|81', '0|0|0|145', NULL, NULL, 'You have completed The Specialists quest!', NULL, NULL, NULL);

Quest: Orders for the Dockmaster

PostPosted: Sat Sep 03, 2011 7:52 am
by mattress
Tested and working.
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`, `OptionalRewardItemTemplates`, `FinalRewardItemTemplates`, `FinishText`, `QuestDependency`, `AllowedClasses`, `ClassType`) VALUES (5487, 'Orders for the Dockmaster', 0, 'Commander Culino', 27, 'orders', 'Hail, it\'s good to see you! Seems that since you\'ve come to our little town things have been getting done. Not that we\'ve ever had a problem in that area, but everyone around here\'s been whispering good things about you. Might I then encroach upon your kindness a bit more? I need these [orders] delivered to the dockmaster. It\'s quite important and I can\'t leave my post.', NULL, 'Deliver the orders to the dockmaster. (Right-click him to hand them to him.)', '5', 'Give the orders to the dockmaster.', NULL, NULL, 'Dockmaster;27', NULL, NULL, 1, 3, 10, '153', '405', NULL, NULL, NULL, NULL, NULL, NULL);

Re: Dataquest Submissions

PostPosted: Fri Oct 21, 2011 1:34 pm
by Dinberg
Nice work :D

Re: Dataquest Submissions

PostPosted: Fri Oct 21, 2011 2:00 pm
by Tolakram
Has anyone added these onto Storm? Nice stuff, glad to see my dataquests can be understood by someone besides me. :)

Re: Dataquest Submissions

PostPosted: Fri Oct 21, 2011 2:52 pm
by Graveen
I'll add them to Storm, ty Mattress

Re: Dataquest Submissions

PostPosted: Fri Oct 21, 2011 3:14 pm
by Argo
i hope they do not interfere with the dataquests which i have submitted recently for constantines sound

Re: [added to Storm] Dataquest Submissions

PostPosted: Tue Nov 01, 2011 8:50 am
by Graveen
Committed on Storm, let's test :)

TY Mattress !

Re: Dataquest Submissions

PostPosted: Tue Nov 01, 2011 8:54 am
by Graveen
i hope they do not interfere with the dataquests which i have submitted recently for constantines sound
Did you committed identical quests ? If yes tell me, thank you.
/worship !