guild_eventlog - cmangos/issues GitHub Wiki

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.