blob: 9c027181df7b8cc929521c82d49ab1522390f444 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
# gm\_ticket
[<-Back-to:Characters](database-characters.md)
**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**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ---------------------- | ----------- | ---------- | --- | ---- | ------- | -------------- | ------------------------------------------ |
| [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
[3]: #playerguid
[4]: #name
[5]: #description
[6]: #createtime
[7]: #mapid
[8]: #posx
[9]: #posy
[10]: #posz
[11]: #lastmodifiedtime
[12]: #closedby
[13]: #assignedto
[14]: #comment
[15]: #response
[16]: #completed
[17]: #escalated
[18]: #viewed
[19]: #needmorehelp
[20]: #resolvedby
**Description of the fields**
### Id
The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.
### type
Type of ticket. Variables:
- 0 = open
- 1 = closed
- 2 = character deleted
### playerGuid
Player's GUID. See [characters.guid](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](map).
### 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~ (not implemented on azerothcore yet)
- > 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 added with `.ticket comment`, only visible to game masters. If the command is used twice, it overwrites the previous comment.
### response
The string the GM inserted with `.ticket response` commands to answer the ticket before completing it. If the command is used twice, it appends the new answer at the end of the previous one.
### completed
- 0 = not completed
- 1 = completed (will inform the user and show what is in `response`)
### escalated
- 0 = ticket is not currently assigned to a gm
- 1 = ticket is assigned to a normal gm
- 2 = ticket has been escalated after completion (a GM is supposed to contact the player back)
### viewed
- 0 = no one has viewed the ticket.
- > 0 = How many times the ticket has been viewed by GMs
### needMoreHelp
Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket".
### resolvedBy
- 0 = Open
- ~-1 = Resolved by Console~ (not supported on azerothcore yet cause of datatype in DB)
- > 0 = Character guid of the GM who resolved it (by closing the ticket or by completing the ticket)
|
