AzerothCore
Pages :

character_equipmentsets

<-Back-to:Characters

The `character_equipmentsets` table

This table holds info about player's equipment manager settings.

Table 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