guild_eventlog
Logs guild events to be displayed in the guild event log in-game.
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 | MUL | NO | Player 1 | ||
| PlayerGuid2 | int | unsigned | MUL | NO | Player 2 | ||
| NewRank | tinyint | unsigned | NO | New rank(in case promotion/demotion) | |||
| TimeStamp | int | unsigned | NO | Event UNIX time | |||
Description of fields
guildid
references guild.guildid.
LogGuid
Log record enumerator, unique per guild.
EventType
| Name | EventType | PlayerGuid1 | PlayerGuid2 | NewRank | Comment |
|---|---|---|---|---|---|
| GUILD_EVENT_LOG_INVITE_PLAYER | 1 | OfficerGUID | InviteeGUID | 0 | player received invite |
| GUILD_EVENT_LOG_JOIN_GUILD | 2 | InviteeGUID | 0 | 0 | player accepted invite |
| GUILD_EVENT_LOG_PROMOTE_PLAYER | 3 | OfficerGUID | MemberGUID | 1 – 8 | guild rank++ |
| GUILD_EVENT_LOG_DEMOTE_PLAYER | 4 | OfficerGUID | MemberGUID | 2 – 9 | guild rank-- |
| GUILD_EVENT_LOG_UNINVITE_PLAYER | 5 | OfficerGUID | MemberGUID | 0 | player was kicked from guild |
| GUILD_EVENT_LOG_LEAVE_GUILD | 6 | MemberGUID | 0 | 0 | player left guild on own volition |
TimeStamp
Unix timestamp when the event occured.