logs_trade Table¶
Money flow log entries above the configured threshold (loot, quest rewards, trades, mail, GM changes).
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
time |
timestamp | NO | current_timestamp() | ||
type |
enum('AuctionBid','AuctionBuyout','BuyItem','SellItem','GM','Mail','QuestMaxLevel','Quest','Loot','Trade','') | NO | '' | ||
sender |
int(11) unsigned | MUL | NO | 0 | |
senderType |
int(11) unsigned | NO | 0 | ||
senderEntry |
int(11) unsigned | NO | 0 | ||
receiver |
int(11) unsigned | MUL | NO | 0 | |
amount |
int(11) | NO | 0 | ||
data |
int(11) | NO | 0 |
Field Breakdown¶
time- Trade timestamp.type- Trade event kind (item/money flow direction codes).sender- Sender GUID low counter (player guid low, or vendor/auction owner guid).senderType- Sender GUID high part: the object type (player, creature, item…).senderEntry- Sender template entry (creature/vendor/item);0for players.receiver- Receiving player/object.amount- Money amount traded.data- Single related id depending ontype: item template id for auction/vendor lines, quest id for quest rewards; otherwise0.