数据库:characters数据库:guild_eventlog
guild_eventlog 表
表结构
| 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 |
字段说明
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.
数据库/characters数据库/guild_eventlog.txt · 最后更改: 2023/09/24 12:18 由 admin