summaryrefslogtreecommitdiff
path: root/docs/character_queststatus.md
diff options
context:
space:
mode:
Diffstat (limited to 'docs/character_queststatus.md')
-rw-r--r--docs/character_queststatus.md291
1 files changed, 273 insertions, 18 deletions
diff --git a/docs/character_queststatus.md b/docs/character_queststatus.md
index 0552a91..a04cd6e 100644
--- a/docs/character_queststatus.md
+++ b/docs/character_queststatus.md
@@ -1,18 +1,273 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_queststatus](character_queststatus)
-
-Column | Type | Description
---- | --- | ---
-Guid | int(10) unsigned |
-Quest | int(10) unsigned |
-Status | tinyint(3) unsigned |
-Explored | tinyint(3) unsigned |
-Timer | int(10) unsigned |
-Mobcount1 | smallint(5) unsigned |
-Mobcount2 | smallint(5) unsigned |
-Mobcount3 | smallint(5) unsigned |
-Mobcount4 | smallint(5) unsigned |
-Itemcount1 | smallint(5) unsigned |
-Itemcount2 | smallint(5) unsigned |
-Itemcount3 | smallint(5) unsigned |
-Itemcount4 | smallint(5) unsigned |
-Playercount | smallint(5) unsigned |
+# character\_queststatus
+
+`Back-to:Characters`
+
+**The \`character\_queststatus\` table**
+
+Holds information on the quest status of each character.
+
+**Structure**
+
+<table>
+<tbody>
+<tr class="odd">
+<td><p><strong>Field</strong></p></td>
+<td><p><strong>Type</strong></p></td>
+<td><p><strong>Attributes</strong></p></td>
+<td><p><strong>Key</strong></p></td>
+<td><p><strong>Null</strong></p></td>
+<td><p><strong>Default</strong></p></td>
+<td><p><strong>Extra</strong></p></td>
+<td><p><strong>Comment</strong></p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_queststatus-guid">guid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p>Global Unique Identifier</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_queststatus-quest">quest</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p>Quest Identifier</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_queststatus-status">status</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-explored">explored</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-timer">timer</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-mobcount">mobcount1</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-mobcount">mobcount2</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-mobcount">mobcount3</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-mobcount">mobcount4</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-itemcount">itemcount1</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-itemcount">itemcount2</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-itemcount">itemcount3</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</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="#character_queststatus-itemcount">itemcount4</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td>itemcount5</td>
+<td>smallint(5)</td>
+<td>unsigned</td>
+<td><br />
+</td>
+<td>NO</td>
+<td>0</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="even">
+<td>itemcount6</td>
+<td>smallint(5)</td>
+<td>unsigned</td>
+<td><br />
+</td>
+<td>NO</td>
+<td>0</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_queststatus-playercount">playercount</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### guid
+
+The GUID of the character. See characters.guid
+
+### quest
+
+The quest ID. See quest\_template.entry
+
+### status
+
+The current quest status.
+
+**Possible values**
+
+| Value | Status | Comments |
+|-------|----------------------------|---------------------------------------------|
+| 0 | QUEST\_STATUS\_NONE | Quest isn't shown in quest list; default |
+| 1 | QUEST\_STATUS\_COMPLETE | Quest has been completed |
+| 2 | QUEST\_STATUS\_UNAVAILABLE | NOT USED |
+| 3 | QUEST\_STATUS\_INCOMPLETE | Quest is active in quest log but incomplete |
+| 4 | QUEST\_STATUS\_AVAILABLE | NOT USED |
+| 5 | QUEST\_STATUS\_FAILED | Player failed to complete the quest |
+
+### explored
+
+Boolean 1 or 0 representing if the character has explored what was needed to explore for the quest.
+
+### timer
+
+`field-no-description|5`
+
+### mobcount1-4
+
+Current count of the number of kills or casts on the first creature or gameobject, if any. Corresponds with quest\_template.ReqCreatureOrGOCount
+
+### itemcount1-6
+
+Current item count for the first item in a delivery quest, if any. Corresponds with quest\_template.ReqItemCount
+
+### playercount
+
+Current player slay count. Required in quest\_template.PlayersSlain