AzerothCore
Pages :
guild_eventlog
Tabla `guild_eventlog`
Estructura
| 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 |
Descripción de los Campos
guildid
ID de la hermandad correspondiente.
LogGuid
GUID del registro - columna auxiliar.
EventType
| Valor | Descripción | Comentarios |
|---|---|---|
| 1 | GUILD_EVENT_LOG_INVITE_PLAYER | Invitación al jugador |
| 2 | GUILD_EVENT_LOG_JOIN_GUILD | Ingreso a la hermandad |
| 3 | GUILD_EVENT_LOG_PROMOTE_PLAYER | Ascenso de jugador |
| 4 | GUILD_EVENT_LOG_DEMOTE_PLAYER | Degradación de jugador |
| 5 | GUILD_EVENT_LOG_UNINVITE_PLAYER | Reachaza invitación |
| 6 | GUILD_EVENT_LOG_LEAVE_GUILD | Abandona la hermandad |
PlayerGuid1
GUID o Identificador Global Único del jugador número 1.
PlayerGuid2
GUID o Identificador Global Único del jugador número 2.
NewRank
Nuevo rango (en caso de ascenso/degradación).
timestamp
Evento medido en tiempo UNIX.