From 6e12d64f0728ddcec447ee65d7a4ac81e9d3cba7 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Wed, 6 Jan 2021 14:35:07 -0300 Subject: docs: Converting from HTML to Markdown part #3 (#331) --- docs/mail.md | 254 ++++++++++------------------------------------------------- 1 file changed, 41 insertions(+), 213 deletions(-) (limited to 'docs/mail.md') 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** -  - -  - - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO

0

 

Identifier

messageType

tinyint(3)

unsigned

 

NO

0

 

 

stationery

tinyint(3)

signed

 

NO

41

 

 

mailTemplateId

mediumint(5)

unsigned

 

NO

0

 

 

sender

int(10)

unsigned

 

NO

0

 

Character Global Unique Identifier

receiver

int(10)

unsigned

 

NO

0

 

Character Global Unique Identifier

subject

longtext

signed

 

YES

NULL

 

 

body

longtext

signed

 

YES

   

has_items

tinyint(3)

unsigned

 

NO

0

  

expire_time

int(10)

unsigned

 

NO

0

  

deliver_time

int(10)

unsigned

 

NO

0

  

money

int(10)

unsigned

 

NO

0

  

cod

int(10)

unsigned

 

NO

0

  

checked

tinyint(3)

unsigned

 

NO

0

  
+| 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 - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

- -/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 | -- cgit