数据库:characters数据库:mail
差别
这里会显示出您选择的修订版和当前版本之间的差别。
两侧同时换到之前的修订记录前一修订版后一修订版 | 前一修订版 | ||
数据库:characters数据库:mail [2023/09/24 12:58] – [subject] 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 |
- | + | | |
- | 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 | + | |
- | lotId: id field from auctionhouse table | + | |
- | + | ||
- | itemCount: amount of item at this Lot | + | |
==== body ==== | ==== body ==== | ||
行 95: | 行 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. | ||
行 141: | 行 133: | ||
==== 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 ==== | ||
数据库/characters数据库/mail.1695531513.txt.gz · 最后更改: 2023/09/24 12:58 由 admin