summaryrefslogtreecommitdiff
path: root/docs/gm_ticket.md
diff options
context:
space:
mode:
authorJulio A. Leyva Osorio <tony931023@gmail.com>2021-07-16 16:23:43 -0400
committerGitHub <noreply@github.com>2021-07-16 22:23:43 +0200
commit9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd (patch)
treecc7fe36188f6d9144baaddecdc35ed77a2eb1a36 /docs/gm_ticket.md
parent535ad2787b77d2ffd79b6788e38156ec5144ca7f (diff)
downloadwiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.gz
wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.bz2
wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.zip
chore: characters (#584)
* Update account_data.md * Update account_instance_times.md * Update account_tutorial.md * Update addons.md * Update arena_team.md * Fix arena_team.md * Update arena_team_member.md * Update auctionhouse.md * Update banned_addons.md * Update battleground_deserters.md * Update bugreport.md * Update calendar_events.md * fix calendar_events.md * fix * fix * fix3 * update calendar_invites.md * update channels.md * fix channels.md * fix channels.md * update channels_bans.md * update channels_bans.md * update petition.md * fix 4 * Update characters.md * Update worlstates.md * Update gm_ticket.md * + Update * + update 2.md * + update 3 * update + characters.md * + update 4.md * + update 5.md * update characters, thanks @r-o-b-o-t-o * fix + * + Update 6 * + Update 7 * + Update 8 * + Update 9 * Fix + @Kitzunu
Diffstat (limited to 'docs/gm_ticket.md')
-rw-r--r--docs/gm_ticket.md64
1 files changed, 32 insertions, 32 deletions
diff --git a/docs/gm_ticket.md b/docs/gm_ticket.md
index acd1a2e..fbabb9e 100644
--- a/docs/gm_ticket.md
+++ b/docs/gm_ticket.md
@@ -1,37 +1,37 @@
-# gm_ticket
+# gm\_ticket
[<-Back-to:Characters](database-characters.md)
-## The `gm_tickets` table
+## The \`gm\_tickets\` table
This table stores all tickets.
Note: do not insert directly into most of these columns, else the client won't update the ticket status until table reload and a logout.
-## Structure
+**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
-|------------------------|-------------|------------|-----|------|---------|----------------|--------------------------------------------|
-| [Id][1] | INT | SIGNED | PRI | NO | | Auto increment | |
-| [type][2] | TINYINT | UNSIGNED | | NO | | | 0 open, 1 closed, 2 character deleted |
-| [playerGuid][3] | INT | UNSIGNED | | NO | | | Global Unique Identifier of ticket creator |
-| [name][4] | VARCHAR(12) | | | NO | | | Name of ticket creator |
-| [description][5] | text | | | NO | | | |
-| [createtime][6] | INT | UNSIGNED | | NO | | | |
-| [mapId][7] | SMALLINT | UNSIGNED | | NO | | | |
-| [posX][8] | FLOAT | SIGNED | | NO | | | |
-| [posY][9] | FLOAT | SIGNED | | NO | | | |
-| [posZ][10] | FLOAT | SIGNED | | NO | | | |
-| [lastModifiedTime][11] | INT | SIGNED | | NO | | | |
-| [closedBy][12] | INT | SIGNED | | NO | | | |
-| [assignedTo][13] | INT | UNSIGNED | | NO | | | GUID of admin to whom ticket is assigned |
-| [comment][14] | text | | | NO | | | |
-| [response][15] | text | | | NO | | | |
-| [completed][16] | TINYINT | UNSIGNED | | NO | | | |
-| [escalated][17] | TINYINT | UNSIGNED | | NO | | | |
-| [viewed][18] | TINYINT | UNSIGNED | | NO | | | |
-| [needMoreHelp][19] | TINYINT | UNSIGNED | | NO | | | |
-| [resolvedBy][20] | INT | UNSIGNED | | NO | | | GUID of GM who resolved the ticket |
+| ---------------------- | ----------- | ---------- | --- | ---- | ------- | -------------- | ------------------------------------------ |
+| [Id][1] | INT | UNSIGNED | PRI | NO | | Auto increment | |
+| [type][2] | TINYINT | UNSIGNED | | NO | 0 | | 0 open, 1 closed, 2 character deleted |
+| [playerGuid][3] | INT | UNSIGNED | | NO | 0 | | Global Unique Identifier of ticket creator |
+| [name][4] | VARCHAR(12) | SIGNED | | NO | | | Name of ticket creator |
+| [description][5] | text | SIGNED | | NO | | | |
+| [createTime][6] | INT | UNSIGNED | | NO | 0 | | |
+| [mapId][7] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [posX][8] | FLOAT | SIGNED | | NO | 0 | | |
+| [posY][9] | FLOAT | SIGNED | | NO | 0 | | |
+| [posZ][10] | FLOAT | SIGNED | | NO | 0 | | |
+| [lastModifiedTime][11] | INT | UNSIGNED | | NO | 0 | | |
+| [closedBy][12] | INT | SIGNED | | NO | 0 | | -1 Closed by Console, >0 GUID of GM |
+| [assignedTo][13] | INT | UNSIGNED | | NO | 0 | | GUID of admin to whom ticket is assigned |
+| [comment][14] | text | SIGNED | | NO | | | |
+| [response][15] | text | SIGNED | | NO | | | |
+| [completed][16] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [escalated][17] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [viewed][18] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [needMoreHelp][19] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [resolvedBy][20] | INT | SIGNED | | NO | 0 | | -1 Resolved by Console, >0 GUID of GM |
[1]: #id
[2]: #type
@@ -65,27 +65,27 @@ The ticket global unique identifier. This number must be unique and is the best
Type of ticket. Variables:
- 0 = open
- 1 = closed
-- 2 = character deleted.
+- 2 = character deleted
### playerGuid
-Player's GUID. See characters.guid
+Player's GUID. See [characters.guid](characters#guid).
### name
-The name of the character who created that ticket
+The name of the character who created that ticket.
### description
-The content of the ticket
+The content of the ticket.
### createTime
-The creation time of the ticket as linux timestamp
+The creation time of the ticket as linux timestamp.
### mapId
-Map where ticket has ben created. See Map.dbc
+Map where ticket has ben created. See [Map.dbc](map).
### posX
@@ -101,7 +101,7 @@ Position Z Where ticket has ben created.
### lastModifiedTime
-The time when the ticket was closed or deleted by the issuer as linux timestamp
+The time when the ticket was closed or deleted by the issuer as linux timestamp.
### closedBy
@@ -140,7 +140,7 @@ The string the GM inserted with `.ticket response` commands to answer the ticket
### needMoreHelp
-Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"
+Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket".
### resolvedBy