From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/gm_ticket.md | 363 ++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 339 insertions(+), 24 deletions(-) (limited to 'docs/gm_ticket.md') diff --git a/docs/gm_ticket.md b/docs/gm_ticket.md index 8f284b0..33a2154 100644 --- a/docs/gm_ticket.md +++ b/docs/gm_ticket.md @@ -1,24 +1,339 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [gm_ticket](gm_ticket) - -Column | Type | Description ---- | --- | --- -Id | int(10) unsigned | -Type | tinyint(3) unsigned | -PlayerGuid | int(10) unsigned | -Name | varchar(12) | -Description | text | -CreateTime | int(10) unsigned | -MapId | smallint(5) unsigned | -PosX | float | -PosY | float | -PosZ | float | -LastModifiedTime | int(10) unsigned | -ClosedBy | int(10) unsigned | -AssignedTo | int(10) unsigned | -Comment | text | -Response | text | -Completed | tinyint(3) unsigned | -Escalated | tinyint(3) unsigned | -Viewed | tinyint(3) unsigned | -NeedMoreHelp | tinyint(3) unsigned | -ResolvedBy | int(10) unsigned | +# gm\_ticket + +`Back-to:Characters` + +**The \`gm\_tickets\` table** + +This table stores all tickets + +**Structure** + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

Id

int(10)

signed

PRI

NO


+

Auto increment


+

playerGuid

int(10)

unsigned


+

NO

0


+

Global Unique Identifier of ticket creator

name

varchar(12)

signed


+

NO

NULL


+

Name of ticket creator

description

text

signed


+

NO


+


+


+

createtime

int(10)

unsigned


+

NO

0
+
+

mapId

smallint(5)

unsigned


+

NO

0
+
+

posX

float

signed


+

NO

0


+
+

posY

float

signed


+

NO

0


+
+

posZ

float

signed


+

NO

0


+
+

lastModifiedTime

int(10)

signed


+

NO

0


+
+

closedBy

int(10)

signed


+

NO

0


+
+

assignedTo

int(10)

unsigned


+

NO

0


+

GUID of admin to whom ticket is assigned

comment

text

signed


+

NO


+
+
+

response

text

signed


+

NO


+
+
+

completed

tinyint(3)

unsigned


+

NO

0


+
+

escalated

tinyint(3)

unsigned


+

NO

0


+
+

viewed

tinyint(3)

unsigned


+

NO

0


+
+

needMoreHelp

tinyint(3)

unsigned


+

NO

0


+
+
+ +'Description of the fields''' + +### Id + +The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets. + +### playerGuid + +Player's GUID. See characters.guid + +### name + +The name of the character who created that ticket + +### description + +The content of the ticket + +### createTime + +The creation time of the ticket as linux timestamp + +### mapId + +Map where ticket has ben created. See Map.dbc + +### posX + +Position X Where ticket has ben created. + +### posY + +Position Y Where ticket has ben created. + +### posZ + +Position Z Where ticket has ben created. + +### lastModifiedTime + +The time when the ticket was closed or deleted by the issuer as linux timestamp + +### closedBy + +0 : Open + +-1 : Closed by Console + +>0 : player who abandoned ticket or GM who closed ticket + +### assignedTo + +Specify account number of GameMaster that have this ticket assigned. + +### comment + +The comment to the ticket, only visible to game masters + +### response + +Requires GM response. 17 = true, 1 = false (17 is default) + +### completed + +`field-no-description|14` + +### escalated + +`field-no-description|15` + +### viewed + +0 : no one has viewed the ticket. + +>0 : How many times the ticket has been viewed. + +### needMoreHelp + +Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket" + +td class= -- cgit