guild_eventlog Table¶
Recent guild events (member join/leave, leadership changes) shown in-game.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
guild_id |
int(11) | PRI | NO | ||
log_guid |
int(11) | PRI | NO | ||
event_type |
tinyint(1) | NO | |||
player_guid1 |
int(11) | MUL | NO | ||
player_guid2 |
int(11) | MUL | NO | ||
new_rank |
tinyint(2) | NO | |||
timestamp |
bigint(20) | NO |
Field Breakdown¶
guild_id- Primary Key. Guild the event belongs to.log_guid- Primary Key. Log entry counter.event_type- Event code (GuildEventLogEntryTypes): 1 invite, 2 join, 3 promotion, 4 demotion, 5 uninvite, 6 leave.player_guid1- Actors involved (e.g. leaver + issuer).player_guid2- Actors involved (e.g. leaver + issuer).new_rank- Rank after promotion events.timestamp- When it happened. Table keeps a rolling recent window only.