From 139a646e7751ec06ad5496a182cbaa0c72f5d0f0 Mon Sep 17 00:00:00 2001
From: "Bogir[rus]" <m-1@bk.ru>
Date: Mon, 25 Nov 2019 01:13:06 +0300
Subject: Update gm_ticket.md (#150)

Added missed 2 fields and description for them.
---
 docs/gm_ticket.md | 65 +++++++++++++++++++++++++++++++++++++++++--------------
 1 file changed, 49 insertions(+), 16 deletions(-)

diff --git a/docs/gm_ticket.md b/docs/gm_ticket.md
index 3ee55c7..7fb6b79 100644
--- a/docs/gm_ticket.md
+++ b/docs/gm_ticket.md
@@ -33,6 +33,18 @@ This table stores all tickets
 </p></td>
 </tr>
 <tr class="odd">
+<td><p><a href="#type">type</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>0 open, 1 closed, 2 character deleted</p></td>
+</tr>
+<tr class="even">
 <td><p><a href="#playerguid">playerGuid</a></p></td>
 <td><p>int(10)</p></td>
 <td><p>unsigned</p></td>
@@ -44,7 +56,7 @@ This table stores all tickets
 </p></td>
 <td><p>Global Unique Identifier of ticket creator</p></td>
 </tr>
-<tr class="even">
+<tr class="odd">
 <td><p><a href="#name">name</a></p></td>
 <td><p>varchar(12)</p></td>
 <td><p>signed</p></td>
@@ -56,7 +68,7 @@ This table stores all tickets
 </p></td>
 <td><p>Name of ticket creator</p></td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#description">description</a></p></td>
 <td><p>text</p></td>
 <td><p>signed</p></td>
@@ -70,7 +82,7 @@ This table stores all tickets
 <td><p><br />
 </p></td>
 </tr>
-<tr class="even">
+<tr class="odd">
 <td><p><a href="#createtime">createtime</a></p></td>
 <td><p>int(10)</p></td>
 <td><p>unsigned</p></td>
@@ -83,7 +95,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#mapid">mapId</a></p></td>
 <td><p>smallint(5)</p></td>
 <td><p>unsigned</p></td>
@@ -96,7 +108,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="even">
+<tr class="dd">
 <td><p><a href="#posx">posX</a></p></td>
 <td><p>float</p></td>
 <td><p>signed</p></td>
@@ -109,7 +121,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#posy">posY</a></p></td>
 <td><p>float</p></td>
 <td><p>signed</p></td>
@@ -122,7 +134,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="even">
+<tr class="odd">
 <td><p><a href="#posz">posZ</a></p></td>
 <td><p>float</p></td>
 <td><p>signed</p></td>
@@ -135,7 +147,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#lastmodifiedtime">lastModifiedTime</a></p></td>
 <td><p>int(10)</p></td>
 <td><p>signed</p></td>
@@ -148,7 +160,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="even">
+<tr class="odd">
 <td><p><a href="#closedby">closedBy</a></p></td>
 <td><p>int(10)</p></td>
 <td><p>signed</p></td>
@@ -161,7 +173,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#assignedto">assignedTo</a></p></td>
 <td><p>int(10)</p></td>
 <td><p>unsigned</p></td>
@@ -173,7 +185,7 @@ This table stores all tickets
 </td>
 <td><p>GUID of admin to whom ticket is assigned</p></td>
 </tr>
-<tr class="even">
+<tr class="odd">
 <td><p><a href="#comment">comment</a></p></td>
 <td><p>text</p></td>
 <td><p>signed</p></td>
@@ -187,7 +199,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#response">response</a></p></td>
 <td><p>text</p></td>
 <td><p>signed</p></td>
@@ -201,7 +213,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="even">
+<tr class="odd">
 <td><p><a href="#completed">completed</a></p></td>
 <td><p>tinyint(3)</p></td>
 <td><p>unsigned</p></td>
@@ -214,7 +226,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#escalated">escalated</a></p></td>
 <td><p>tinyint(3)</p></td>
 <td><p>unsigned</p></td>
@@ -227,7 +239,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="even">
+<tr class="odd">
 <td><p><a href="#viewed">viewed</a></p></td>
 <td><p>tinyint(3)</p></td>
 <td><p>unsigned</p></td>
@@ -240,7 +252,7 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
-<tr class="odd">
+<tr class="even">
 <td><p><a href="#needmorehelp">needMoreHelp</a></p></td>
 <td><p>tinyint(3)</p></td>
 <td><p>unsigned</p></td>
@@ -253,6 +265,19 @@ This table stores all tickets
 <td><br />
 </td>
 </tr>
+<tr class="odd">
+<td><p><a href="#resolvedBy">resolvedBy</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td>GUID of GM who resolved the ticket</td>
+</tr>
+
 </tbody>
 </table>
 
@@ -262,6 +287,10 @@ This table stores all tickets
 
 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
@@ -336,4 +365,8 @@ Requires GM response. 17 = true, 1 = false (17 is default)
 
 Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"
 
+### resolvedBy
+
+GUID of GM who resolved the ticket.
+
 td class=
-- 
cgit