blob: 7be13924086a719a238ae1b57195ed3fa55aba90 (
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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
# character\_equipmentsets
[<-Back-to:Characters](database-characters.md)
**The \`character\_equipmentsets\` table**
This table holds info about player's equipment manager settings.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|------------------|--------------|------------|-----|------|---------|----------------|---------|
| [guid][1] | int(10) | signed | | NO | | | |
| [setguid][2] | bigint(20) | signed | PRI | NO | | Auto Increment | |
| [setindex][3] | tinyint(3) | signed | | NO | | | |
| [name][4] | varchar(31) | | | NO | | | |
| [iconname][5] | varchar(100) | | | NO | | | |
| [ignore_mask][6] | int(11) | unsigned | | NO | | | |
| [item0][7] | int(11) | unsigned | | NO | | | |
| [item1][8] | int(11) | unsigned | | NO | | | |
| [item2][9] | int(11) | unsigned | | NO | | | |
| [item3][10] | int(11) | unsigned | | NO | | | |
| [item4][11] | int(11) | unsigned | | NO | | | |
| [item5][12] | int(11) | unsigned | | NO | | | |
| [item6][13] | int(11) | unsigned | | NO | | | |
| [item7][14] | int(11) | unsigned | | NO | | | |
| [item8][15] | int(11) | unsigned | | NO | | | |
| [item9][16] | int(11) | unsigned | | NO | | | |
| [item10][17] | int(11) | unsigned | | NO | | | |
| [item11][18] | int(11) | unsigned | | NO | | | |
| [item12][19] | int(11) | unsigned | | NO | | | |
| [item13][20] | int(11) | unsigned | | NO | | | |
| [item14][21] | int(11) | unsigned | | NO | | | |
| [item15][22] | int(11) | unsigned | | NO | | | |
| [item16][23] | int(11) | unsigned | | NO | | | |
| [item17][24] | int(11) | unsigned | | NO | | | |
| [item18][25] | int(11) | unsigned | | NO | | | |
[1]: #guid
[2]: #setguid
[3]: #setindex
[4]: #name
[5]: #iconname
[6]: #ignore_mask
[7]: #item0
[8]: #item1
[9]: #item2
[10]: #item3
[11]: #item4
[12]: #item5
[13]: #item6
[14]: #item7
[15]: #item8
[16]: #item9
[17]: #item10
[18]: #item11
[19]: #item12
[20]: #item13
[21]: #item14
[22]: #item15
[23]: #item16
[24]: #item17
[25]: #item18
**Description of the fields**
### guid
Player's GUID. See characters.guid
### setguid
First free guid.
### setindex
Set index, values from 0 to 9 are used.
### name
Individual. Name is set by player.
### iconname
Name taken from ItemDisplayInfo.dbc, column 6
### ignore\_mask
`field-no-description|6`
### item0-18
Values taken from item\_instance.guid
| ID | Name |
|----|-----------|
| 0 | Head |
| 1 | Neck |
| 2 | Shoulder |
| 3 | Shirt |
| 4 | Chest |
| 5 | Waist |
| 6 | Legs |
| 7 | Feet |
| 8 | Wrist |
| 9 | Hands |
| 10 | Ring 1 |
| 11 | Ring 2 |
| 12 | Trinket 1 |
| 13 | Trinket 2 |
| 14 | Back |
| 15 | Main Hand |
| 16 | Off Hand |
| 17 | Relic |
| 18 | Tabard |
|
