summaryrefslogtreecommitdiff
path: root/docs/es/guild_bank_eventlog.md
blob: ade53843d1b1a3186555e5977c9dfa03367e3216 (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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
# guild\_bank\_eventlog

[<-Volver a:Characters](database-characters.md)

Leer en: [English :gb:](../guild_bank_eventlog) [Spanish :es:](guild_bank_eventlog)

**Tabla \`guild\_bank\_eventlog\`**

**Estructura**

| Field               | Type     | Attributes | Key | Null | Default | Extra | Comment                                     |
| ------------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------------------------------------------- |
| [guildid][1]        | INT      | UNSIGNED   | PRI | NO   | 0       |       | Guild Identificator                         |
| [LogGuid][2]        | INT      | UNSIGNED   | PRI | NO   | 0       |       | Log record identificator - auxiliary column |
| [TabId][3]          | TINYINT  | UNSIGNED   | PRI | NO   | 0       |       | Guild bank TabId                            |
| [EventType][4]      | TINYINT  | UNSIGNED   |     | NO   | 0       |       | Event type                                  |
| [PlayerGuid][5]     | INT      | UNSIGNED   |     | NO   | 0       |       |                                             |
| [ItemOrMoney][6]    | INT      | UNSIGNED   |     | NO   | 0       |       |                                             |
| [ItemStackCount][7] | SMALLINT | UNSIGNED   |     | NO   | 0       |       |                                             |
| [DestTabId][8]      | TINYINT  | UNSIGNED   |     | NO   | 0       |       | Destination Tab Id                          |
| [TimeStamp][9]      | INT      | UNSIGNED   |     | NO   | 0       |       | Event UNIX time                             |

[1]: #guildid
[2]: #logguid
[3]: #tabid
[4]: #eventtype
[5]: #playerguid
[6]: #itemormoney
[7]: #itemstackcount
[8]: #desttabid
[9]: #timestamp

**Descripción de los campos**

### guildid

Identificador de la hermandad.

### LogGuid

Identificación del registro de Log - columna auxiliar.

### TabId

TabId del banco de la hermandad.

### EventType

| Value | Description                       |
| ----- | --------------------------------- |
| 1     | GUILD\_BANK\_LOG\_DEPOSIT\_ITEM   |
| 2     | GUILD\_BANK\_LOG\_WITHDRAW\_ITEM  |
| 3     | GUILD\_BANK\_LOG\_MOVE\_ITEM      |
| 4     | GUILD\_BANK\_LOG\_DEPOSIT\_MONEY  |
| 5     | GUILD\_BANK\_LOG\_WITHDRAW\_MONEY |
| 6     | GUILD\_BANK\_LOG\_REPAIR\_MONEY   |
| 7     | GUILD\_BANK\_LOG\_MOVE\_ITEM2     |
| 8     | GUILD\_BANK\_LOG\_UNK1            |
| 9     | GUILD\_BANK\_LOG\_BUY\_SLOT       |

### PlayerGuid

GUID del personaje.

### ItemOrMoney

`campo-sin-descripción|6`

### ItemStackCount

`campo-sin-descripción|7`

### DestTabId

ID de la pestaña de destino.

### TimeStamp

Hora del envento en UNIX.