AzerothCore
Pages :

log_money

<-Back-to:Characters

The `log_money` table

Table Structure

Field Type Attributes Key Null Default Extra Comment
sender_acc INT UNSIGNED NO
sender_guid INT UNSIGNED NO
sender_name CHAR(32) SIGNED NO
sender_ip CHAR(32) SIGNED NO
receiver_acc INT UNSIGNED NO
receiver_name CHAR(32) SIGNED NO
money BIGINT UNSIGNED NO
topic CHAR(255) SIGNED NO
date DATETIME SIGNED NO
[type][10] TINYINT SIGNED NO 1=COD,2=AH,3=GB DEPOSIT,4=GB WITHDRAW,5=MAIL,6=TRADE

Description of the fields

sender_acc

Account of the player who gave the money. See account.id.

sender_guid

GUID of the character who gave the money. See characters.guid.

sender_name

Name of the character who gave the money.

sender_ip

IP of the player who gave the money.

receiver_acc

Account of the player who got the money. See account.id.

receiver_name

Name of the character who got the money.

money

The amount of money in copper.

topic

Details of the transfer, for example the mail subject, the auction or the guild bank.

date

The date and time of the transfer.

type

Name Value
1 COD
2 AH
3 GB DEPOSIT
4 GB WITHDRAW
5 MAIL
6 TRADE