diff options
| author | Bogir[rus] <m-1@bk.ru> | 2019-11-25 01:13:06 +0300 |
|---|---|---|
| committer | Francesco Borzì <borzifrancesco@gmail.com> | 2019-11-24 23:13:06 +0100 |
| commit | 139a646e7751ec06ad5496a182cbaa0c72f5d0f0 (patch) | |
| tree | f255210e879c124c314b8ba650b6a01eb602407d /docs | |
| parent | 83e85c15b8f5e649620fa7ad93d840636cbdbcc0 (diff) | |
| download | wiki-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.md | 65 |
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= |
