Back-to:Characters
The `guild_bank_eventlog` table
table-no-description
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(11) | unsigned | PRI | NO | 0 |
| Guild Identificator | |
int(11) | unsigned | PRI | NO | 0 |
| Log record identificator - auxiliary column | |
tinyint(3) | unsigned | PRI | NO | 0 |
| Guild bank TabId | |
tinyint(3) | unsigned |
| NO | 0 |
| Event type | |
int(11) | unsigned |
| NO | 0 |
|
| |
int(11) | unsigned |
| NO | 0 |
|
| |
tinyint(3) | unsigned |
| NO | 0 |
|
| |
tinyint(1) | unsigned |
| NO | 0 |
| Destination Tab Id | |
bigint(20) | unsigned |
| NO | 0 |
| Event UNIX time |
Description of the fields
guildid
field-no-description|1
LogGuid
field-no-description|2
TabId
field-no-description|3
EventType
1 = GUILD_BANK_LOG_DEPOSIT_ITEM
2 = GUILD_BANK_LOG_WITHDRAW_ITEM
3 = GUILD_BANK_LOG_MOVE_ITEM
4 = GUILD_BANK_LOG_DEPOSIT_MONEY
5 = GUILD_BANK_LOG_WITHDRAW_MONEY
6 = GUILD_BANK_LOG_REPAIR_MONEY
7 = GUILD_BANK_LOG_MOVE_ITEM2
8 = GUILD_BANK_LOG_UNK1
9 = GUILD_BANK_LOG_BUY_SLOT
PlayerGuid
field-no-description|5
ItemOrMoney
field-no-description|6
ItemStackCount
field-no-description|7
DestTabId
field-no-description|8
TimeStamp
field-no-description|9