From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/guild_eventlog.md | 155 +++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 144 insertions(+), 11 deletions(-) (limited to 'docs/guild_eventlog.md') diff --git a/docs/guild_eventlog.md b/docs/guild_eventlog.md index 8b3f2af..1cb6620 100644 --- a/docs/guild_eventlog.md +++ b/docs/guild_eventlog.md @@ -1,11 +1,144 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [guild_eventlog](guild_eventlog) - -Column | Type | Description ---- | --- | --- -Guildid | int(10) unsigned | -LogGuid | int(10) unsigned | -EventType | tinyint(3) unsigned | -PlayerGuid1 | int(10) unsigned | -PlayerGuid2 | int(10) unsigned | -NewRank | tinyint(3) unsigned | -TimeStamp | int(10) unsigned | +# 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** + +### guildid + +`Guild Identificator` + +### LogGuid + +`Log record identificator - auxiliary column` + +### EventType + +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 + +### PlayerGuid1 + +`GUID of Player1` + +### PlayerGuid2 + +`GUID of Player2` + +### NewRank + +`New rank (in case of promotion/demotion)` + +### TimeStamp + +`Event UNIX time` -- cgit