diff options
Diffstat (limited to 'docs/character_queststatus.md')
| -rw-r--r-- | docs/character_queststatus.md | 291 |
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 |
