blob: f4c6d2c8dcf3475b9599679db825064e31d6a1f5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
# guild\_eventlog
[<-Volver a:Characters](database-characters.md)
**Tabla \`guild\_eventlog\`**
**Estructura**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ---------------- | ------- | ---------- | --- | ---- | ------- | ----- | ------------------------------------------- |
| [guildid][1] | INT | UNSIGNED | PRI | NO | | | Guild Identificator |
| [LogGuid][2] | INT | UNSIGNED | PRI | NO | | | Log record identificator - auxiliary column |
| [EventType][3] | TINYINT | UNSIGNED | | NO | | | Event type |
| [PlayerGuid1][4] | INT | UNSIGNED | | NO | | | Player 1 |
| [PlayerGuid2][5] | INT | UNSIGNED | | NO | | | Player 2 |
| [NewRank][6] | TINYINT | UNSIGNED | | NO | | | New rank(in case promotion/demotion) |
| [timestamp][7] | BIGINT | UNSIGNED | | NO | | | Event UNIX time |
[1]: #guildid
[2]: #logguid
[3]: #eventtype
[4]: #playerguid1
[5]: #playerguid2
[6]: #newrank
[7]: #timestamp
**Descripción de los Campos**
### guildid
ID de la hermandad correspondiente.
### LogGuid
GUID del registro - columna auxiliar.
### EventType
| Valor | Descripción | Comentarios |
| ----- | ----------------------------------- | ------------------------ |
| 1 | GUILD\_EVENT\_LOG\_INVITE\_PLAYER | Invitación al jugador |
| 2 | GUILD\_EVENT\_LOG\_JOIN\_GUILD | Ingreso a la hermandad |
| 3 | GUILD\_EVENT\_LOG\_PROMOTE\_PLAYER | Ascenso de jugador |
| 4 | GUILD\_EVENT\_LOG\_DEMOTE\_PLAYER | Degradación de jugador |
| 5 | GUILD\_EVENT\_LOG\_UNINVITE\_PLAYER | Reachaza invitación |
| 6 | GUILD\_EVENT\_LOG\_LEAVE\_GUILD | Abandona la hermandad |
### PlayerGuid1
GUID o Identificador Global Único del jugador número 1.
### PlayerGuid2
GUID o Identificador Global Único del jugador número 2.
### NewRank
Nuevo rango (en caso de ascenso/degradación).
### timestamp
Evento medido en tiempo UNIX.
|
