AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
guild_eventlog
The `guild_eventlog` table
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | INT | UNSIGNED | PRI | NO | Guild Identificator | ||
| LogGuid | INT | UNSIGNED | PRI | NO | Log record identificator - auxiliary column | ||
| EventType | TINYINT | UNSIGNED | NO | Event type | |||
| PlayerGuid1 | INT | UNSIGNED | NO | Player 1 | |||
| PlayerGuid2 | INT | UNSIGNED | NO | Player 2 | |||
| NewRank | TINYINT | UNSIGNED | NO | New rank(in case promotion/demotion) | |||
| timestamp | BIGINT | UNSIGNED | NO | Event UNIX time |
Description of the fields
guildid
Guild Identificator.
LogGuid
Log record identificator - auxiliary column.
EventType
| Value | Description |
|---|---|
| 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
GUID of Player1.
PlayerGuid2
GUID of Player2.
NewRank
New rank (in case of promotion/demotion).
timestamp
Event UNIX time.