summaryrefslogtreecommitdiff
path: root/docs/quest_template.md
diff options
context:
space:
mode:
authorWalter Pagani <paganiwalter@gmail.com>2021-01-12 07:02:37 -0300
committerGitHub <noreply@github.com>2021-01-12 11:02:37 +0100
commit58854d415c5ab6b19fcd530edd7726f35cc143f4 (patch)
treefa3eb7023ccce1b5abf473dd74a6069e0e0d8a4d /docs/quest_template.md
parent0e7b3b282b7e2712b0fcc9babd11e8a0dfc9351f (diff)
downloadwiki-58854d415c5ab6b19fcd530edd7726f35cc143f4.tar.gz
wiki-58854d415c5ab6b19fcd530edd7726f35cc143f4.tar.bz2
wiki-58854d415c5ab6b19fcd530edd7726f35cc143f4.zip
refact(tables): converting from HTML to Markdown part #7 (#337)
* Holidays.md * item_loot_items.md * game_weather.md * creature_classlevelstats.md * game_event_condition.md * game_event.md * item_instance.md * pet_aura.md * character_queststatus.md * gossip_menu_option_locale.md * arena_team.md * access_requirement.md * character_aura.md * guild_member.md * character_equipmentsets.md * character_pet.md * Spell.md * SkillLine.md * creature_addon.md * gm_ticket.md * character_stats.md * spell_area.md * gossip_menu_option.md * creature_text.md * quest_template_addon.md * Achievement_Criteria.md * fix powerType Spell.md * loot_template.md * Emotes.md * quest_template.md * npc_text.md * gameobject_template.md * spell_dbc.md * worldstates.md * FactionTemplate.md * Achievement.md * AreaTable.md * DBC-AreaTrigger.md
Diffstat (limited to 'docs/quest_template.md')
-rw-r--r--docs/quest_template.md1122
1 files changed, 121 insertions, 1001 deletions
diff --git a/docs/quest_template.md b/docs/quest_template.md
index 4a1084b..c60d80e 100644
--- a/docs/quest_template.md
+++ b/docs/quest_template.md
@@ -8,800 +8,73 @@ 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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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>
+| Field | Type | Null | Key | Default | Extra | Comment |
+|------------------------------------|----------------------|------|-----|---------|-------|---------|
+| ID | int(10) unsigned | NO | PRI | 0 | | |
+| QuestType | tinyint(3) unsigned | NO | | 2 | | |
+| QuestLevel | int(11) | NO | | -1 | | |
+| QuestPackageID | int(10) unsigned | NO | | 0 | | |
+| MinLevel | int(11) | NO | | 0 | | |
+| QuestSortID | smallint(6) | NO | | 0 | | |
+| QuestInfoID | smallint(5) unsigned | NO | | 0 | | |
+| SuggestedGroupNum | tinyint(3) unsigned | NO | | 0 | | |
+| RewardNextQuest | int(10) unsigned | NO | | 0 | | |
+| RewardXPDifficulty | int(10) unsigned | NO | | 0 | | |
+| RewardXPMultiplier | float | NO | | 1 | | |
+| RewardMoney | int(11) | NO | | 0 | | |
+| RewardMoneyDifficulty | int(10) unsigned | NO | | 0 | | |
+| RewardMoneyMultiplier | float | NO | | 1 | | |
+| RewardBonusMoney | int(10) unsigned | NO | | 0 | | |
+| RewardDisplaySpell(X=1...3) | int(10) unsigned | NO | | 0 | | |
+| RewardSpell | int(10) unsigned | NO | | 0 | | |
+| RewardHonor | int(10) unsigned | NO | | 0 | | |
+| RewardKillHonor | int(10) unsigned | NO | | 0 | | |
+| StartItem | int(10) unsigned | NO | | 0 | | |
+| RewardArtifactXPDifficulty | int(10) unsigned | NO | | 0 | | |
+| RewardArtifactXPMultiplier | float | NO | | 1 | | |
+| RewardArtifactCategoryID | int(10) unsigned | NO | | 0 | | |
+| Flags | int(10) unsigned | NO | | 0 | | |
+| FlagsEx | int(10) unsigned | NO | | 0 | | |
+| RewardItem(X=1...4) | int(10) unsigned | NO | | 0 | | |
+| RewardAmount(X=1...4) | int(10) unsigned | NO | | 0 | | |
+| ItemDrop(X=1...4) | int(10) unsigned | NO | | 0 | | |
+| ItemDropQuantity(X=1...4) | int(10) unsigned | NO | | 0 | | |
+| RewardChoiceItemID(X=1...6) | int(10) unsigned | NO | | 0 | | |
+| RewardChoiceItemQuantity(X=1...6) | int(10) unsigned | NO | | 0 | | |
+| RewardChoiceItemDisplayID(X=1...6) | int(10) unsigned | NO | | 0 | | |
+| POIContinent | int(10) unsigned | NO | | 0 | | |
+| POIx | float | NO | | 0 | | |
+| POIy | float | NO | | 0 | | |
+| POIPriority | int(11) | NO | | 0 | | |
+| RewardTitle | int(10) unsigned | NO | | 0 | | |
+| RewardArenaPoints | int(10) unsigned | NO | | 0 | | |
+| RewardSkillLineID | int(10) unsigned | NO | | 0 | | |
+| RewardNumSkillUps | int(10) unsigned | NO | | 0 | | |
+| PortraitGiver | int(10) unsigned | NO | | 0 | | |
+| PortraitTurnIn | int(10) unsigned | NO | | 0 | | |
+| RewardFactionID(X=1...5) | int(10) unsigned | NO | | 0 | | |
+| RewardFactionValue(X=1...5) | int(11) | NO | | 0 | | |
+| RewardFactionOverride(X=1...5) | int(11) | NO | | 0 | | |
+| RewardFactionCapIn(X=1...5) | int(10) unsigned | NO | | 0 | | |
+| RewardFactionFlags | int(10) unsigned | NO | | 0 | | |
+| RewardCurrencyID(X=1...4) | int(10) unsigned | NO | | 0 | | |
+| RewardCurrencyQty(X=1...4) | int(10) unsigned | NO | | 0 | | |
+| AcceptedSoundKitID | int(10) unsigned | NO | | 0 | | |
+| CompleteSoundKitID | int(10) unsigned | NO | | 0 | | |
+| AreaGroupID | int(10) unsigned | NO | | 0 | | |
+| TimeAllowed | int(10) unsigned | NO | | 0 | | |
+| AllowableRaces | int(11) | NO | | -1 | | |
+| QuestRewardID | int(10) unsigned | NO | | 0 | | |
+| LogTitle | text | YES | | (NULL) | | |
+| LogDescription | text | YES | | (NULL) | | |
+| QuestDescription | text | YES | | (NULL) | | |
+| AreaDescription | text | YES | | (NULL) | | |
+| PortraitGiverText | text | YES | | (NULL) | | |
+| PortraitGiverName | text | YES | | (NULL) | | |
+| PortraitTurnInText | text | YES | | (NULL) | | |
+| PortraitTurnInName | text | YES | | (NULL) | | |
+| QuestCompletionLog | text | YES | | (NULL) | | |
+| VerifiedBuild | smallint(5) | YES | | 0 | | |
**Description of the fields**
@@ -938,192 +211,41 @@ Items given by the quest giver at beginning of the quest. Items will be deleted
This flag field defines more specifically the type of quest it is. Aside from the daily flag and sharable flag, this field is used just for grouping purposes and NOT for any other quest requirements. The quest requirements are calculated from non-zero values in other quest template fields. Also, while some of these flags are known, others have yet an unknown purpose and the comments below is simply guesswork on them.
-<table>
-<thead>
-<tr class="header">
-<th><p>Flag</p></th>
-<th><p>Name</p></th>
-<th><p>Comments</p></th>
-</tr>
-</thead>
-<tbody>
-<tr class="odd">
-<td><p>0</p></td>
-<td><p>QUEST_FLAGS_NONE</p></td>
-<td><p>No flags, so no groups assigned to this quest.</p></td>
-</tr>
-<tr class="even">
-<td><p>1</p></td>
-<td>