Skip to content

character_equipmentsets

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

Structure ​

FieldTypeAttributesKeyNullDefaultExtraComment
guidintunsignedMULNO0
setguidbigintunsignedPRINOauto_increment
setindextinyintunsignedMULNO0
namevarchar(31)NO
iconnamevarchar(100)NO
ignore_maskintunsignedNO0
item0intunsignedNO0
item1intunsignedNO0
item2intunsignedNO0
item3intunsignedNO0
item4intunsignedNO0
item5intunsignedNO0
item6intunsignedNO0
item7intunsignedNO0
item8intunsignedNO0
item9intunsignedNO0
item10intunsignedNO0
item11intunsignedNO0
item12intunsignedNO0
item13intunsignedNO0
item14intunsignedNO0
item15intunsignedNO0
item16intunsignedNO0
item17intunsignedNO0
item18intunsignedNO0

 

Description of fields ​

guid ​

The guid of the character.
 

setguid ​

First free guid.
 

setindex ​

Set index, values from 0 to 9 are used.
 

name ​

Individual. Name is set by player.
 

iconname ​

ItemDisplayInfo InventoryIcon_0
 

ignore_mask ​

Bitmask of EQUIPMENT_SLOT_* IDs not used by the equipment set.
 

item[0-18] ​

An item guid to equip or 0 for an empty slot.

The fields index is an equipment slot id:
enum EquipmentSlots

IDNameComment
0EQUIPMENT_SLOT_HEAD
1EQUIPMENT_SLOT_NECK
2EQUIPMENT_SLOT_SHOULDERS
3EQUIPMENT_SLOT_BODYshirt
4EQUIPMENT_SLOT_CHEST
5EQUIPMENT_SLOT_WAIST
6EQUIPMENT_SLOT_LEGS
7EQUIPMENT_SLOT_FEET
8EQUIPMENT_SLOT_WRISTS
9EQUIPMENT_SLOT_HANDS
10EQUIPMENT_SLOT_FINGER1
11EQUIPMENT_SLOT_FINGER2
12EQUIPMENT_SLOT_TRINKET1
13EQUIPMENT_SLOT_TRINKET2
14EQUIPMENT_SLOT_BACK
15EQUIPMENT_SLOT_MAINHAND
16EQUIPMENT_SLOT_OFFHAND
17EQUIPMENT_SLOT_RANGEDranged or relic
18EQUIPMENT_SLOT_TABARD