数据库:characters数据库:mail
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录前一修订版后一修订版 | 前一修订版 | ||
| 数据库:characters数据库:mail [2023/09/24 12:58] – [id] admin | 数据库:characters数据库:mail [2023/09/24 13:01] (当前版本) – [checked] admin | ||
|---|---|---|---|
| 行 35: | 行 35: | ||
| ==== 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 ==== | ||
| 行 71: | 行 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. | ||
| 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, | ||
| 行 119: | 行 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, | ||
| 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 | + | |
| - | 0 MAIL_CHECK_MASK_NONE | + | ^Flag^Comment^ |
| - | 1 MAIL_CHECK_MASK_READ | + | |0|MAIL_CHECK_MASK_NONE| |
| - | 2 MAIL_CHECK_MASK_RETURNED | + | |1|MAIL_CHECK_MASK_READ| |
| - | 4 MAIL_CHECK_MASK_COPIED | + | |2|MAIL_CHECK_MASK_RETURNED| |
| - | 8 MAIL_CHECK_MASK_COD_PAYMENT | + | |4|MAIL_CHECK_MASK_COPIED| |
| - | 16 MAIL_CHECK_MASK_HAS_BODY | + | |8|MAIL_CHECK_MASK_COD_PAYMENT| |
| - | auctionId | + | |16|MAIL_CHECK_MASK_HAS_BODY| |
| + | |||
| + | ==== auctionId | ||
| Only if stationery is 62. | Only if stationery is 62. | ||
数据库/characters数据库/mail.1695531485.txt.gz · 最后更改: 2023/09/24 12:58 由 admin