Tabelle: 'guild_eventlog'
The `guild_eventlog` tabletable-no-description
StructureField | Type | Attributes | Key | Null | Default | Extra | Comment |
---|
guildid | int(11) | vorzeichenbehaftet | PRI | nein | NULL | | Guild Identificator | LogGuid | int(11) | vorzeichenbehaftet | PRI | nein | NULL | | Log record identificator - auxiliary column | EventType | tinyint(1) | vorzeichenbehaftet | | nein | NULL | | Event type | PlayerGuid1 | int(11) | vorzeichenbehaftet | | nein | NULL | | Player 1 | PlayerGuid2 | int(11) | vorzeichenbehaftet | | nein | NULL | | Player 2 | NewRank | tinyint(2) | vorzeichenbehaftet | | nein | NULL | | New rank(in case promotion/demotion) | TimeStamp | bigint(20) | vorzeichenbehaftet | | nein | NULL | | Event UNIX time |
Description of the fieldsguildidGuild Identificator
LogGuidLog record identificator - auxiliary column
EventType1 = 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 PlayerGuid1GUID of Player1
PlayerGuid2GUID of Player2
NewRankNew rank (in case of promotion/demotion)
TimeStampEvent UNIX time
|