summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorBogir[rus] <m-1@bk.ru>2019-11-25 01:13:06 +0300
committerFrancesco Borzì <borzifrancesco@gmail.com>2019-11-24 23:13:06 +0100
commit139a646e7751ec06ad5496a182cbaa0c72f5d0f0 (patch)
treef255210e879c124c314b8ba650b6a01eb602407d /docs
parent83e85c15b8f5e649620fa7ad93d840636cbdbcc0 (diff)
downloadwiki-139a646e7751ec06ad5496a182cbaa0c72f5d0f0.tar.gz
wiki-139a646e7751ec06ad5496a182cbaa0c72f5d0f0.tar.bz2
wiki-139a646e7751ec06ad5496a182cbaa0c72f5d0f0.zip
Update gm_ticket.md (#150)
Added missed 2 fields and description for them.
Diffstat (limited to 'docs')
-rw-r--r--docs/gm_ticket.md65
1 files 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=