summaryrefslogtreecommitdiff
path: root/docs/quest_template.md
diff options
context:
space:
mode:
authorFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
committerFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
commita35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch)
tree91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/quest_template.md
parentd8d1823802ded97300fa57405d80b16736603489 (diff)
downloadwiki-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.md1723
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