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
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.