character_equipmentsets

Owned by King Pin

Last updated: ago 02, 2014 by Aokromes

1 min read

Back-to:Characters

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(10)	signed		NO	0
setguid	bigint(20)	signed	PRI	NO		Auto Increment
setindex	tinyint(3)	signed		NO	0
name	varchar(31)	signed		NO	"
iconname	varchar(100)	signed		NO	"
ignore_mask	int(11)	unsigned		NO	0
item0	int(11)	unsigned		NO	0
item1	int(11)	unsigned		NO	0
item2	int(11)	unsigned		NO	0
item3	int(11)	unsigned		NO	0
item4	int(11)	unsigned		NO	0
item5	int(11)	unsigned		NO	0
item6	int(11)	unsigned		NO	0
item7	int(11)	unsigned		NO	0
item8	int(11)	unsigned		NO	0
item9	int(11)	unsigned		NO	0
item10	int(11)	unsigned		NO	0
item11	int(11)	unsigned		NO	0
item12	int(11)	unsigned		NO	0
item13	int(11)	unsigned		NO	0
item14	int(11)	unsigned		NO	0
item15	int(11)	unsigned		NO	0
item16	int(11)	unsigned		NO	0
item17	int(11)	unsigned		NO	0
item18	int(11)	unsigned		NO	0

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

 0. Head

Neck
Shoulder
Shirt
Chest
Waist
Legs
Feet
Wrist
Hands
Ring 1
Ring 2
Trinket 1
Trinket 2
Back
Main Hand
Off Hand
Relic
Tabard

/p