Guild eventlog
Материал из YTDB DataBase
Версия от 16:24, 7 марта 2010; Neggod (Обсуждение | вклад)
|
Back to characters database list of tables.
The `guild_eventlog` table
This table holds information about changes in guilds membership.
Structure
Field | Type | Null | Key | Default | Extra |
guildid | int(11) unsigned | NO | PRI | 0 | |
LogGuid | int(11) unsigned | NO | PRI | 0 | |
EventType | tinyint(1) unsigned | NO | 0 | ||
PlayerGuid1 | int(11) unsigned | NO | 0 | ||
PlayerGuid2 | int(11) unsigned | NO | 0 | ||
NewRank | tinyint(2) unsigned | NO | 0 | ||
TimeStamp | bigint(20) unsigned | NO | 0 |
Description of the fields
guildid
Id of related guild. See guild.guildid
LogGuid
A unique identifier given to each log entry to distinguish one entry from another. Two guild event logs can NOT have same GUID.
EventType
GUILD_EVENT_LOG_INVITE_PLAYER = 1 GUILD_EVENT_LOG_JOIN_GUILD = 2 GUILD_EVENT_LOG_PROMOTE_PLAYER = 3 GUILD_EVENT_LOG_DEMOTE_PLAYER = 4 GUILD_EVENT_LOG_UNINVITE_PLAYER = 5 GUILD_EVENT_LOG_LEAVE_GUILD = 6
PlayerGuid1
Guid of character who made the change. See character.guid
PlayerGuid2
Guid of character who was "changed". See character.guid
NewRank
Id of new rank of PlayerGuid2. See guild_rank.rid
TimeStamp
Unix timestamp when event happens.
(c)udbwiki