summaryrefslogtreecommitdiff
path: root/docs/mail.md
diff options
context:
space:
mode:
Diffstat (limited to 'docs/mail.md')
-rw-r--r--docs/mail.md254
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 |
generated by cgit (git 2.34.1) at 2026-05-16 01:07:48 +0000