diff options
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 will be used as (Quest)Level for the experience calculation. + +### MinLevel + +Minimum level at which a player can get the quest. + +### MaxLevel + +Maximum level at which a player can get the quest. + +### QuestSortID + +This field defines under what category the quest falls in the quest log. + +If **value > 0** then value is Zone IDs taken from AreaTable.dbc. + +if **value < 0** then (**-value**) is quest sort id: (in general profession or class quests. Also see [RequiredSkillPoints](#quest_template-RequiredSkillPoints) ) Value is ID from QuestSort.dbc + +### QuestInfoID + +These values are ID taken from QuestInfo.dbc + +### SuggestedGroupNum + +Recommended number of players to do the quest together. + +### LimitTime + +Time in seconds that the player has to complete this quest. + +### ~~RequiredClasses~~ + +~~Classes required to get the quest. 0 means the quest is available for all classes.~~ +~~This field is a bitmask, you can combine class values. See [ChrClasses.dbc](https://trinitycore.atlassian.net/wiki/display/tc/ChrRaces)~~ + +### AllowableRaces + +Races allowed to get the quest. 0 means the quest is accessible for all races. Field value is a decimal value which must transform to an 8 bits binary in order to be understandable. In binary form, each different bit represents a different race. They're assigned as follows : + +**Race** + |