guild_eventlog

Back-to:Characters

The `guild_eventlog` table

table-no-description

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guildid	int(11)	signed	PRI	NO	NULL		Guild Identificator
LogGuid	int(11)	signed	PRI	NO	NULL		Log record identificator - auxiliary column
EventType	tinyint(1)	signed		NO	NULL		Event type
PlayerGuid1	int(11)	signed		NO	NULL		Player 1
PlayerGuid2	int(11)	signed		NO	NULL		Player 2
NewRank	tinyint(2)	signed		NO	NULL		New rank(in case promotion/demotion)
TimeStamp	bigint(20)	signed		NO	NULL		Event UNIX time

Description of the fields

Guild Identificator

Log record identificator - auxiliary column

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

GUID of Player1

GUID of Player2

New rank (in case of promotion/demotion)

Event UNIX time