character_equipmentsets
The `character_equipmentsets` table
This table holds info about player's equipment manager settings.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
guid | INT | SIGNED | NO | UNIQUE | |||
setguid | BIGINT | SIGNED | PRI | NO | UNIQUE | ||
setindex | TINYINT | UNSIGNED | NO | UNIQUE | |||
name | VARCHAR(31) | SIGNED | NO | ||||
iconname | VARCHAR(100) | SIGNED | NO | ||||
ignore_mask | INT | UNSIGNED | NO | ||||
item0 | INT | UNSIGNED | NO | ||||
item1 | INT | UNSIGNED | NO | ||||
item2 | INT | UNSIGNED | NO | ||||
item3 | INT | UNSIGNED | NO | ||||
item4 | INT | UNSIGNED | NO | ||||
item5 | INT | UNSIGNED | NO | ||||
item6 | INT | UNSIGNED | NO | ||||
item7 | INT | UNSIGNED | NO | ||||
item8 | INT | UNSIGNED | NO | ||||
item9 | INT | UNSIGNED | NO | ||||
item10 | INT | UNSIGNED | NO | ||||
item11 | INT | UNSIGNED | NO | ||||
item12 | INT | UNSIGNED | NO | ||||
item13 | INT | UNSIGNED | NO | ||||
item14 | INT | UNSIGNED | NO | ||||
item15 | INT | UNSIGNED | NO | ||||
item16 | INT | UNSIGNED | NO | ||||
item17 | INT | UNSIGNED | NO | ||||
item18 | INT | UNSIGNED | NO |
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
item
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 |