diff options
| author | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
|---|---|---|
| committer | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
| commit | a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch) | |
| tree | 91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/quest_template.md | |
| parent | d8d1823802ded97300fa57405d80b16736603489 (diff) | |
| download | wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2 wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip | |
Import DB wiki from TC 335
Diffstat (limited to 'docs/quest_template.md')
| -rw-r--r-- | docs/quest_template.md | 1723 |
1 files changed, 1594 insertions, 129 deletions
diff --git a/docs/quest_template.md b/docs/quest_template.md index db3cbb5..b8c59c8 100644 --- a/docs/quest_template.md +++ b/docs/quest_template.md @@ -1,129 +1,1594 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [quest_template](quest_template) - -Column | Type | Description ---- | --- | --- -ID | mediumint(8) unsigned | -QuestType | tinyint(3) unsigned | -QuestLevel | smallint(3) | -MinLevel | tinyint(3) unsigned | -QuestSortID | smallint(6) | -QuestInfoID | smallint(5) unsigned | -SuggestedGroupNum | tinyint(3) unsigned | -RequiredFactionId1 | smallint(5) unsigned | -RequiredFactionId2 | smallint(5) unsigned | -RequiredFactionValue1 | mediumint(8) | -RequiredFactionValue2 | mediumint(8) | -RewardNextQuest | mediumint(8) unsigned | -RewardXPDifficulty | tinyint(3) unsigned | -RewardMoney | int(11) | -RewardBonusMoney | int(10) unsigned | -RewardDisplaySpell | mediumint(8) unsigned | -RewardSpell | int(11) | -RewardHonor | int(11) | -RewardKillHonor | float | -StartItem | mediumint(8) unsigned | -Flags | int(10) unsigned | -RequiredPlayerKills | tinyint(3) unsigned | -RewardItem1 | mediumint(8) unsigned | -RewardItem2 | mediumint(8) unsigned | -RewardItem3 | mediumint(8) unsigned | -RewardItem4 | mediumint(8) unsigned | -RewardAmount1 | smallint(5) unsigned | -RewardAmount2 | smallint(5) unsigned | -RewardAmount3 | smallint(5) unsigned | -RewardAmount4 | smallint(5) unsigned | -ItemDrop1 | mediumint(8) unsigned | -ItemDropQuantity1 | smallint(5) unsigned | -ItemDrop2 | mediumint(8) unsigned | -ItemDropQuantity2 | smallint(5) unsigned | -ItemDrop3 | mediumint(8) unsigned | -ItemDropQuantity3 | smallint(5) unsigned | -ItemDrop4 | mediumint(8) unsigned | -ItemDropQuantity4 | smallint(5) unsigned | -RewardChoiceItemID1 | mediumint(8) unsigned | -RewardChoiceItemID2 | mediumint(8) unsigned | -RewardChoiceItemID3 | mediumint(8) unsigned | -RewardChoiceItemID4 | mediumint(8) unsigned | -RewardChoiceItemID5 | mediumint(8) unsigned | -RewardChoiceItemID6 | mediumint(8) unsigned | -RewardChoiceItemQuantity1 | smallint(5) unsigned | -RewardChoiceItemQuantity2 | smallint(5) unsigned | -RewardChoiceItemQuantity3 | smallint(5) unsigned | -RewardChoiceItemQuantity4 | smallint(5) unsigned | -RewardChoiceItemQuantity5 | smallint(5) unsigned | -RewardChoiceItemQuantity6 | smallint(5) unsigned | -POIContinent | smallint(5) unsigned | -POIx | float | -POIy | float | -POIPriority | mediumint(8) unsigned | -RewardTitle | tinyint(3) unsigned | -RewardTalents | tinyint(3) unsigned | -RewardArenaPoints | smallint(5) unsigned | -RewardFactionID1 | smallint(5) unsigned | -RewardFactionID2 | smallint(5) unsigned | -RewardFactionID3 | smallint(5) unsigned | -RewardFactionID4 | smallint(5) unsigned | -RewardFactionID5 | smallint(5) unsigned | -RewardFactionValue1 | mediumint(8) | -RewardFactionValue2 | mediumint(8) | -RewardFactionValue3 | mediumint(8) | -RewardFactionValue4 | mediumint(8) | -RewardFactionValue5 | mediumint(8) | -RewardFactionOverride1 | mediumint(8) | -RewardFactionOverride2 | mediumint(8) | -RewardFactionOverride3 | mediumint(8) | -RewardFactionOverride4 | mediumint(8) | -RewardFactionOverride5 | mediumint(8) | -TimeAllowed | int(10) unsigned | -AllowableRaces | smallint(5) unsigned | -LogTitle | text | -LogDescription | text | -QuestDescription | text | -AreaDescription | text | -OfferRewardText | text | -RequestItemsText | text | -QuestCompletionLog | text | -RequiredNpcOrGo1 | mediumint(8) | -RequiredNpcOrGo2 | mediumint(8) | -RequiredNpcOrGo3 | mediumint(8) | -RequiredNpcOrGo4 | mediumint(8) | -RequiredNpcOrGoCount1 | smallint(5) unsigned | -RequiredNpcOrGoCount2 | smallint(5) unsigned | -RequiredNpcOrGoCount3 | smallint(5) unsigned | -RequiredNpcOrGoCount4 | smallint(5) unsigned | -RequiredItemId1 | mediumint(8) unsigned | -RequiredItemId2 | mediumint(8) unsigned | -RequiredItemId3 | mediumint(8) unsigned | -RequiredItemId4 | mediumint(8) unsigned | -RequiredItemId5 | mediumint(8) unsigned | -RequiredItemId6 | mediumint(8) unsigned | -RequiredItemCount1 | smallint(5) unsigned | -RequiredItemCount2 | smallint(5) unsigned | -RequiredItemCount3 | smallint(5) unsigned | -RequiredItemCount4 | smallint(5) unsigned | -RequiredItemCount5 | smallint(5) unsigned | -RequiredItemCount6 | smallint(5) unsigned | -Unknown0 | tinyint(3) unsigned | -ObjectiveText1 | text | -ObjectiveText2 | text | -ObjectiveText3 | text | -ObjectiveText4 | text | -DetailsEmote1 | smallint(5) unsigned | -DetailsEmote2 | smallint(5) unsigned | -DetailsEmote3 | smallint(5) unsigned | -DetailsEmote4 | smallint(5) unsigned | -DetailsEmoteDelay1 | int(10) unsigned | -DetailsEmoteDelay2 | int(10) unsigned | -DetailsEmoteDelay3 | int(10) unsigned | -DetailsEmoteDelay4 | int(10) unsigned | -EmoteOnIncomplete | smallint(5) unsigned | -EmoteOnComplete | smallint(5) unsigned | -OfferRewardEmote1 | smallint(5) unsigned | -OfferRewardEmote2 | smallint(5) unsigned | -OfferRewardEmote3 | smallint(5) unsigned | -OfferRewardEmote4 | smallint(5) unsigned | -OfferRewardEmoteDelay1 | int(10) unsigned | -OfferRewardEmoteDelay2 | int(10) unsigned | -OfferRewardEmoteDelay3 | int(10) unsigned | -OfferRewardEmoteDelay4 | int(10) unsigned | -VerifiedBuild | smallint(6) | +# quest\_template + +**Table: quest\_template** + +Contains all basic definitions of available quests. + +## **Structure** + +<table> +<thead> +<tr class="header"> +<th>Field</th> +<th>Type</th> +<th>Null</th> +<th>Key</th> +<th>Default</th> +<th>Extra</th> +<th>Comment</th> +</tr> +</thead> +<tbody> +<tr class="odd"> +<td><p><a href="#quest_template-ID">ID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p>PRI</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-QuestType">QuestType</a></p></td> +<td><p>tinyint(3) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>2</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-QuestLevel">QuestLevel</a></p></td> +<td><p>int(11)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>-1</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-QuestPackageID">QuestPackageID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-MinLevel">MinLevel</a></p></td> +<td><p>int(11)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-QuestSortID">QuestSortID</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-QuestInfoID">QuestInfoID</a></p></td> +<td><p>smallint(5) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-SuggestedGroupNum">SuggestedGroupNum</a></p></td> +<td><p>tinyint(3) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardNextQuest">RewardNextQuest</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardXPDifficulty">RewardXPDifficulty</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardXPMultiplier">RewardXPMultiplier</a></p></td> +<td><p>float</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>1</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardMoney">RewardMoney</a></p></td> +<td><p>int(11)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardMoneyDifficulty">RewardMoneyDifficulty</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardMoneyMultiplier">RewardMoneyMultiplier</a></p></td> +<td><p>float</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>1</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardBonusMoney">RewardBonusMoney</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardDisplaySpell">RewardDisplaySpell(X=1...3)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardSpell">RewardSpell</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardHonor">RewardHonor</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardKillH">RewardKillHonor</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-StartItem">StartItem</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">RewardArtifactXPDifficulty</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="quest_template">RewardArtifactXPMultiplier</a></p></td> +<td><p>float</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>1</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">RewardArtifactCategoryID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-Flags">Flags</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-FlagsEx">FlagsEx</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardItem(X=1...4)">RewardItem(X=1...4)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardAmount">RewardAmount(X=1...4)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-ItemDrop">ItemDrop(X=1...4)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-ItemDropQuantity(X=1...4)">ItemDropQuantity(X=1...4)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardChoiceItemID">RewardChoiceItemID(X=1...6)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardChoiceItemQuantity(">RewardChoiceItemQuantity(X=1...6)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardChoiceItemDisplayID(X">RewardChoiceItemDisplayID(X=1...6)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-POIContinent">POIContinent</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="quest_template">POIx</a></p></td> +<td><p>float</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">POIy</a></p></td> +<td><p>float</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-POIPriority">POIPriority</a></p></td> +<td><p>int(11)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardTitle">RewardTitle</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="quest_template">RewardArenaPoints</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">RewardSkillLineID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardNumSkillUps">RewardNumSkillUps</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">PortraitGiver</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-PortraitTurnIn">PortraitTurnIn</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardFactionID">RewardFactionID(X=1...5)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardFactionValue">RewardFactionValue(X=1...5)</a></p></td> +<td><p>int(11)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardFactionOverride(X=1...5)">RewardFactionOverride(X=1...5)</a></p></td> +<td><p>int(11)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardFactionCapIn(X=1...5)">RewardFactionCapIn(X=1...5)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardFactionFlags">RewardFactionFlags</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-RewardCurrencyID(">RewardCurrencyID(X=1...4)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-RewardCurrencyQty">RewardCurrencyQty(X=1...4)</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-AcceptedSoundKitID">AcceptedSoundKitID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-CompleteSoundKitID">CompleteSoundKitID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-AreaGroupID">AreaGroupID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-TimeAllowed">TimeAllowed</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-AllowableRaces">AllowableRaces</a></p></td> +<td><p>int(11)</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>-1</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-QuestRewardID">QuestRewardID</a></p></td> +<td><p>int(10) unsigned</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-LogTitle">LogTitle</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">LogDescription</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-QuestDescription">QuestDescription</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">AreaDescription</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="quest_template">PortraitGiverText</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">PortraitGiverName</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_template-PortraitTurnInText">PortraitTurnInText</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="quest_template">PortraitTurnInName</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="quest_template">QuestCompletionLog</a></p></td> +<td><p>text</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>(NULL)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#quest_template-VerifiedBuild">VerifiedBuild</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>YES</p></td> +<td><p><br /> +</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +</tbody> +</table> + +** +** + +**Description of the fields** + +### ID + +The quest ID. This column is the Primary Key for the Table. Each quest ID must be unique! + +### QuestType + +Accepted values: 0, 1, 2 or 3. Their meaning is described in table below. + +| Value | Result | +|-------|----------------------------------------------------------------------------------------------------------| +| 0 | Quest is enabled, but it is auto-completed when accepted; this skips quest objectives and quest details. | +| 1 | Quest is disabled (not yet implemented in the core). | +| 2 | Quest is enabled (does not auto-complete). | +| 3 | Quest is a World Quest. | + +### QuestLevel + +Level of quest. Player receives full experience amount only if their level is less than or equal to Level+5. If Level is set to -1, the player's level wil |
