用户工具

站点工具


数据库: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't exist +  1 = doesn't exist 
-2 = Auction +  2 = Auction 
-3 = Creature +  3 = Creature 
-4 = Gameobject +  4 = Gameobject 
-5 = Item+  5 = Item
 ==== stationery ==== ==== stationery ====
  
 This field can contain these values: This field can contain these values:
  
-1 = Test +  * 1 = Test 
-41 = Normal mail layout +  41 = Normal mail layout 
-61 = GM (Blizzard) +  61 = GM (Blizzard) 
-62 = Auction +  62 = Auction 
-64 = VAL (???) +  64 = VAL (???) 
-65 = CHR (???)+  65 = CHR (???)
 ==== mailTemplateId ==== ==== mailTemplateId ====
  
行 71: 行 71:
 itemEntry:0:response:lotId:itemCount itemEntry:0:response:lotId:itemCount
  
-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 +
-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:bid:buyout:deposit:cut:delay:eta+<color #ed1c24>hexID:bid:buyout:deposit:cut:delay:eta</color>
  
-hexID: hex value of itemowner's GUID (guid field from characters table) +  * **hexID**: hex value of itemowner's GUID (guid field from characters table)\\ \\  
- +  * **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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki