diff options
Diffstat (limited to 'docs/guild_eventlog.md')
| -rw-r--r-- | docs/guild_eventlog.md | 155 |
1 files changed, 144 insertions, 11 deletions
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** + +<table> +<colgroup> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#guild_eventlog-guildid">guildid</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +<td><p>Guild Identificator</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#guild_eventlog-LogGuid">LogGuid</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +<td><p>Log record identificator - auxiliary column</p></td> +</tr> +<tr class="even"> +<td><p><a href="#guild_eventlog-EventType">EventType</a></p></td> +<td><p>tinyint(1)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +<td><p>Event type</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#guild_eventlog-PlayerGuid1">PlayerGuid1</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +<td><p>Player 1</p></td> +</tr> +<tr class="even"> +<td><p><a href="#guild_eventlog-PlayerGuid2">PlayerGuid2</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +<td><p>Player 2</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#guild_eventlog-NewRank">NewRank</a></p></td> +<td><p>tinyint(2)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +<td><p>New rank(in case promotion/demotion)</p></td> +</tr> +<tr class="even"> +<td><p><a href="#guild_eventlog-TimeStamp">TimeStamp</a></p></td> +<td><p>bigint(20)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +<td><p>Event UNIX time</p></td> +</tr> +</tbody> +</table> + +**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` |
