diff options
| author | Walter Pagani <paganiwalter@gmail.com> | 2021-01-06 14:35:07 -0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-01-06 18:35:07 +0100 |
| commit | 6e12d64f0728ddcec447ee65d7a4ac81e9d3cba7 (patch) | |
| tree | 7ce958ac43e28184ccdb8d662e826a6871898411 /docs/mail.md | |
| parent | 9075de0ff5cf803b10a1c461d97ec2ef61e9ec61 (diff) | |
| download | wiki-6e12d64f0728ddcec447ee65d7a4ac81e9d3cba7.tar.gz wiki-6e12d64f0728ddcec447ee65d7a4ac81e9d3cba7.tar.bz2 wiki-6e12d64f0728ddcec447ee65d7a4ac81e9d3cba7.zip | |
docs: Converting from HTML to Markdown part #3 (#331)
Diffstat (limited to 'docs/mail.md')
| -rw-r--r-- | docs/mail.md | 254 |
1 files changed, 41 insertions, 213 deletions
diff --git a/docs/mail.md b/docs/mail.md index 3e79337..22ab2b2 100644 --- a/docs/mail.md +++ b/docs/mail.md @@ -8,174 +8,37 @@ This table contains main data about all mails in the game. **Structure** - - - - -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>Field</strong></p></td> -<td><p><strong>Type</strong></p></td> -<td><p><strong>Attributes</strong></p></td> -<td><p><strong>Key</strong></p></td> -<td><p><strong>Null</strong></p></td> -<td><p><strong>Default</strong></p></td> -<td><p><strong>Extra</strong></p></td> -<td><p><strong>Comment</strong></p></td> -</tr> -<tr class="even"> -<td><p><a href="#id">id</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p>Identifier</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#messagetype">messageType</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#stationery">stationery</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>41</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#mailtemplateid_x">mailTemplateId</a></p></td> -<td><p>mediumint(5)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#sender">sender</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p>Character Global Unique Identifier</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#receiver">receiver</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p>Character Global Unique Identifier</p></td> -</tr> -<tr class="even"> -<td><p><a href="#subject">subject</a></p></td> -<td><p>longtext</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>YES</p></td> -<td><p>NULL</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#body">body</a></p></td> -<td><p>longtext</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>YES</p></td> -<td> </td> -<td> </td> -<td> </td> -</tr> -<tr class="even"> -<td><p><a href="#has_items">has_items</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td> </td> -<td> </td> -</tr> -<tr class="odd"> -<td><p><a href="#expire_time">expire_time</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td> </td> -<td> </td> -</tr> -<tr class="even"> -<td><p><a href="#deliver_time">deliver_time</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td> </td> -<td> </td> -</tr> -<tr class="odd"> -<td><p><a href="#money">money</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td> </td> -<td> </td> -</tr> -<tr class="even"> -<td><p><a href="#cod">cod</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td> </td> -<td> </td> -</tr> -<tr class="odd"> -<td><p><a href="#checked">checked</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>unsigned</p></td> -<td> </td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td> </td> -<td> </td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|--------------|------------|-----|------|---------|-------|------------------------------------| +| [id][1] | int(10) | unsigned | PRI | NO | 0 | | Identifier | +| [messageType][2] | tinyint(3) | unsigned | | NO | 0 | | | +| [stationery][3] | tinyint(3) | signed | | NO | 41 | | | +| [mailTemplateId][4] | mediumint(5) | unsigned | | NO | 0 | | | +| [sender][5] | int(10) | unsigned | | NO | 0 | | Character Global Unique Identifier | +| [receiver][6] | int(10) | unsigned | | NO | 0 | | Character Global Unique Identifier | +| [subject][7] | longtext | signed | | YES | NULL | | | +| [body][8] | longtext | signed | | YES | | | | +| [has_items][9] | tinyint(3) | unsigned | | NO | 0 | | | +| [expire_time][10] | int(10) | unsigned | | NO | 0 | | | +| [deliver_time][11] | int(10) | unsigned | | NO | 0 | | | +| [money][12] | int(10) | unsigned | | NO | 0 | | | +| [cod][13] | int(10) | unsigned | | NO | 0 | | | +| [checked][14] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #id +[2]: #messagetype +[3]: #stationery +[4]: #mailtemplateid +[5]: #sender +[6]: #receiver +[7]: #subject +[8]: #body +[9]: #has_items +[10]: #expire_time +[11]: #deliver_time +[12]: #money +[13]: #cod +[14]: #checked **Description of the fields** @@ -188,7 +51,7 @@ Don't have autoincrement !!! ### messageType - 0 = Normal -- 1 doesn't exist +- 1 = doesn't exist - 2 = Auction - 3 = Creature - 4 = Gameobject @@ -199,10 +62,7 @@ Don't have autoincrement !!! This field can contain these values: - 1 = Test -- 41 = Normal mail layout, - -<!-- --> - +- 41 = Normal mail layout - 61 = GM (Blizzard) - 62 = Auction - 64 = VAL (???) @@ -256,43 +116,11 @@ when is set to 1, that field \`money\` stores gold for COD. ### checked -<table> -<colgroup> -<col width="50%" /> -<col width="50%" /> -</colgroup> -<thead> -<tr class="header"> -<th><p>Flag</p></th> -<th><p>Comment</p></th> -</tr> -</thead> -<tbody> -<tr class="odd"> -<td><p>0</p></td> -<td><p>MAIL_CHECK_MASK_NONE</p></td> -</tr> -<tr class="even"> -<td><p>1</p></td> -<td><p>MAIL_CHECK_MASK_READ</p></td> -</tr> -<tr class="odd"> -<td><p>2</p></td> -<td><p>MAIL_CHECK_MASK_RETURNED</p></td> -</tr> -<tr class="even"> -<td><p>4</p></td> -<td><p>MAIL_CHECK_MASK_COPIED</p></td> -</tr> -<tr class="odd"> -<td><p>8</p></td> -<td><p>MAIL_CHECK_MASK_COD_PAYMENT</p></td> -</tr> -<tr class="even"> -<td><p>16</p></td> -<td><p>MAIL_CHECK_MASK_HAS_BODY</p></td> -</tr> -</tbody> -</table> - -/td +| Flag | Comment | +|------|-----------------------------| +| 0 | MAIL_CHECK_MASK_NONE | +| 1 | MAIL_CHECK_MASK_READ | +| 2 | MAIL_CHECK_MASK_RETURNED | +| 4 | MAIL_CHECK_MASK_COPIED | +| 8 | MAIL_CHECK_MASK_COD_PAYMENT | +| 16 | MAIL_CHECK_MASK_HAS_BODY | |
