Back-to:Characters
The `guild_eventlog` table
table-no-description
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(11) | signed | PRI | NO | NULL |
| Guild Identificator | |
int(11) | signed | PRI | NO | NULL |
| Log record identificator - auxiliary column | |
tinyint(1) | signed |
| NO | NULL |
| Event type | |
int(11) | signed |
| NO | NULL |
| Player 1 | |
int(11) | signed |
| NO | NULL |
| Player 2 | |
tinyint(2) | signed |
| NO | NULL |
| New rank(in case promotion/demotion) | |
bigint(20) | signed |
| NO | NULL |
| Event UNIX time |
Description of the fields
guildid
field-no-description|1
LogGuid
field-no-description|2
EventType
1 = GUILD_EVENT_LOG_INVITE_PLAYER
2 = GUILD_EVENT_LOG_JOIN_GUILD
3 = GUILD_EVENT_LOG_PROMOTE_PLAYER
4 = GUILD_EVENT_LOG_DEMOTE_PLAYER
5 = GUILD_EVENT_LOG_UNINVITE_PLAYER
6 = GUILD_EVENT_LOG_LEAVE_GUILD
PlayerGuid1
field-no-description|4
PlayerGuid2
field-no-description|5
NewRank
field-no-description|6
TimeStamp
field-no-description|7