diff options
Diffstat (limited to 'docs/guild_eventlog.md')
| -rw-r--r-- | docs/guild_eventlog.md | 130 |
1 files changed, 25 insertions, 105 deletions
diff --git a/docs/guild_eventlog.md b/docs/guild_eventlog.md index 35abaf9..5b89c89 100644 --- a/docs/guild_eventlog.md +++ b/docs/guild_eventlog.md @@ -8,100 +8,23 @@ **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="#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="#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="#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="#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="#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="#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="#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> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|------------|------------|-----|------|---------|-------|---------------------------------------------| +| [guildid][1] | int(11) | signed | PRI | NO | NULL | | Guild Identificator | +| [LogGuid][2] | int(11) | signed | PRI | NO | NULL | | Log record identificator - auxiliary column | +| [EventType][3] | tinyint(1) | signed | | NO | NULL | | Event type | +| [PlayerGuid1][4] | int(11) | signed | | NO | NULL | | Player 1 | +| [PlayerGuid2][5] | int(11) | signed | | NO | NULL | | Player 2 | +| [NewRank][6] | tinyint(2) | signed | | NO | NULL | | New rank(in case promotion/demotion) | +| [TimeStamp][7] | bigint(20) | signed | | NO | NULL | | Event UNIX time | + +[1]: #guildid +[2]: #logguid +[3]: #eventtype +[4]: #playerguid1 +[5]: #playerguid2 +[6]: #newrank +[7]: #timestamp **Description of the fields** @@ -115,17 +38,14 @@ ### 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 +| Value | Description | +|-------|-------------------------------------| +| 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 |