The `guild_bank_eventlog` table
Table Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
guildid | INT | UNSIGNED | PRI | NO | 0 | Guild Identificator | |
LogGuid | INT | UNSIGNED | PRI | NO | 0 | Log record identificator - auxiliary column | |
TabId | TINYINT | UNSIGNED | PRI | NO | 0 | Guild bank TabId | |
EventType | TINYINT | UNSIGNED | NO | 0 | Event type | ||
PlayerGuid | INT | UNSIGNED | NO | 0 | |||
ItemOrMoney | INT | UNSIGNED | NO | 0 | |||
ItemStackCount | SMALLINT | UNSIGNED | NO | 0 | |||
DestTabId | TINYINT | UNSIGNED | NO | 0 | Destination Tab Id | ||
TimeStamp | INT | UNSIGNED | NO | 0 | Event UNIX time |
Description of the fields
Guild Identificator.
Log record identification - auxiliary column.
Guild bank TabId.
Value | Description |
---|---|
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 |
GUID of the Player.
field-no-description|6
field-no-description|7
Destination Tab Id.
Event UNIX time.