数据库:characters数据库:mail
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 后一修订版 | 前一修订版 | ||
| 数据库:characters数据库:mail [2023/09/24 12:56] – 创建 admin | 数据库:characters数据库:mail [2023/09/24 13:01] (当前版本) – [checked] admin | ||
|---|---|---|---|
| 行 7: | 行 7: | ||
| **表结构** | **表结构** | ||
| ^Field^Type^Attributes^Key^Null^Default^Extra^Comment^ | ^Field^Type^Attributes^Key^Null^Default^Extra^Comment^ | ||
| - | |[[# | + | |[[# |
| - | |[[#gmlevel|gmlevel]]|TINYINT|UNSIGNED| |NO| | | | | + | |[[#messageType|messageType]]|TINYINT|UNSIGNED| |NO|0| | | |
| - | |[[#RealmID|RealmID]]|INT|SIGNED|PRI|NO|-1| | | | + | |[[#stationery|stationery]]|TINYINT|UNSIGNED| |NO|41| | | |
| - | |[[#comment|comment]]|VARCHAR(255)|SIGNED| |YES|' '| | | | + | |[[# |
| + | |[[# | ||
| + | |[[#receiver|receiver]]|INT|UNSIGNED| |NO|0| |Character Global Unique Identifier| | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| 行 21: | 行 33: | ||
| Don't have autoincrement !!! | Don't have autoincrement !!! | ||
| - | === messageType === | + | ==== messageType |
| - | 0 = Normal | + | * 0 = Normal |
| - | 1 = doesn' | + | |
| - | 2 = Auction | + | |
| - | 3 = Creature | + | |
| - | 4 = Gameobject | + | |
| - | 5 = Item | + | |
| - | == stationery == | + | ==== stationery |
| This field can contain these values: | This field can contain these values: | ||
| - | 1 = Test | + | * 1 = Test |
| - | 41 = Normal mail layout | + | |
| - | 61 = GM (Blizzard) | + | |
| - | 62 = Auction | + | |
| - | 64 = VAL (???) | + | |
| - | 65 = CHR (???) | + | |
| - | == mailTemplateId == | + | ==== mailTemplateId |
| Id from MailTemplate.dbc | Id from MailTemplate.dbc | ||
| - | == sender == | + | ==== sender |
| In this field is entered sender character.guid. | In this field is entered sender character.guid. | ||
| - | == receiver == | + | ==== receiver |
| Here is receiver' | Here is receiver' | ||
| - | == subject == | + | ==== subject |
| Here is stored mail subject. | Here is stored mail subject. | ||
| 行 59: | 行 71: | ||
| itemEntry: | itemEntry: | ||
| - | itemEntry: entry field from item_template table | + | * itemEntry: entry field from item_template table |
| + | * 0: allways 0 | ||
| + | * response: Flag from 0 to 6 | ||
| - | 0: allways 0 | + | ^Flag^Comment^ |
| + | |0|AUCTION_OUTBIDDED| | ||
| + | |1|AUCTION_WON| | ||
| + | |2|AUCTION_SUCCESSFUL| | ||
| + | |3|AUCTION_EXPIRED| | ||
| + | |4|AUCTION_CANCELLED_TO_BIDDER| | ||
| + | |5|AUCTION_CANCELED| | ||
| + | |6|AUCTION_SALE_PENDING| | ||
| - | response: Flag from 0 to 6 | + | * lotId: id field from auctionhouse table |
| + | * itemCount: amount of item at this Lot | ||
| - | Flag Comment | + | ==== body ==== |
| - | 0 AUCTION_OUTBIDDED | + | |
| - | 1 AUCTION_WON | + | |
| - | 2 AUCTION_SUCCESSFUL | + | |
| - | 3 AUCTION_EXPIRED | + | |
| - | 4 AUCTION_CANCELLED_TO_BIDDER | + | |
| - | 5 AUCTION_CANCELED | + | |
| - | 6 AUCTION_SALE_PENDING | + | |
| - | lotId: id field from auctionhouse table | + | |
| - | + | ||
| - | itemCount: amount of item at this Lot | + | |
| - | + | ||
| - | == body == | + | |
| The text contained in the mail. Max length is 8000 characters. | The text contained in the mail. Max length is 8000 characters. | ||
| 行 83: | 行 93: | ||
| If stationery is 62, body has formatted data: | If stationery is 62, body has formatted data: | ||
| - | hexID: | + | <color #ed1c24>hexID: |
| - | hexID: hex value of itemowner' | + | * **hexID**: hex value of itemowner' |
| - | + | * **bid**: ending bid for this lot\\ \\ | |
| - | bid: ending bid for this lot | + | * **buyout**: buyout price of lot\\ \\ |
| - | + | * **deposit**: amount of money which will be taken by auctionhouse and returned then auction ends\\ \\ | |
| - | buyout: buyout price of lot | + | * **cut**: Commission fee. Will be taken by auctionhouse then auction ends\\ \\ |
| - | + | * **delay**: time in seconds to delay mail with money for successfully solded lot\\ \\ | |
| - | deposit: amount of money which will be taken by auctionhouse and returned then auction ends | + | * **eta**: packed time to next mail whth money which appears in mail heder and body of notification mail |
| - | + | ||
| - | cut: Commission fee. Will be taken by auctionhouse then auction ends | + | |
| - | + | ||
| - | delay: time in seconds to delay mail with money for successfully solded lot | + | |
| - | + | ||
| - | eta: packed time to next mail whth money which appears in mail heder and body of notification mail | + | |
| This formatted data seen only in mail with notification about successful auction or about pending mail with money. | This formatted data seen only in mail with notification about successful auction or about pending mail with money. | ||
| - | == has_items == | + | ==== has_items |
| Default: 0, | Default: 0, | ||
| 行 109: | 行 113: | ||
| For items look at mail_items table. | For items look at mail_items table. | ||
| - | == expire_time == | + | ==== expire_time |
| Here is timestamp which stores date for auto-return mail to sender or delete if stationery is 62 (AuctionHouse). | Here is timestamp which stores date for auto-return mail to sender or delete if stationery is 62 (AuctionHouse). | ||
| - | == deliver_time == | + | ==== deliver_time |
| Here is timestamp which stores date when mail must be delivered to receiver. Can be delayed mails from AuctionHouse. | Here is timestamp which stores date when mail must be delivered to receiver. Can be delayed mails from AuctionHouse. | ||
| - | == money == | + | ==== money ==== |
| The ammout of money in mail, or money to pay when is COD. | The ammout of money in mail, or money to pay when is COD. | ||
| - | == cod == | + | ==== cod ==== |
| Default: 0 - No COD, | Default: 0 - No COD, | ||
| 行 127: | 行 131: | ||
| when is set to 1, that field `money` stores gold for COD. | when is set to 1, that field `money` stores gold for COD. | ||
| - | == checked == | + | ==== checked |
| - | Flag Comment | + | ^Flag^Comment^ |
| - | 0 MAIL_CHECK_MASK_NONE | + | |0|MAIL_CHECK_MASK_NONE| |
| - | 1 MAIL_CHECK_MASK_READ | + | |1|MAIL_CHECK_MASK_READ| |
| - | 2 MAIL_CHECK_MASK_RETURNED | + | |2|MAIL_CHECK_MASK_RETURNED| |
| - | 4 MAIL_CHECK_MASK_COPIED | + | |4|MAIL_CHECK_MASK_COPIED| |
| - | 8 MAIL_CHECK_MASK_COD_PAYMENT | + | |8|MAIL_CHECK_MASK_COD_PAYMENT| |
| - | 16 MAIL_CHECK_MASK_HAS_BODY | + | |16|MAIL_CHECK_MASK_HAS_BODY| |
| - | == auctionId == | + | |
| + | ==== auctionId | ||
| Only if stationery is 62. | Only if stationery is 62. | ||
| 行 145: | 行 150: | ||
| auctionId = -777 : mail contains info that Lot id 777 is sold. Money will be delivered in next mail, time of deliver is set in deliver_time field. | auctionId = -777 : mail contains info that Lot id 777 is sold. Money will be delivered in next mail, time of deliver is set in deliver_time field. | ||
| - | |||
数据库/characters数据库/mail.1695531372.txt.gz · 最后更改: 2023/09/24 12:56 由 admin