Character equipmentsets tc2

Back to characters database list of tables.

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	"
item0	int(10)	unsigned		NO	0
item1	int(10)	unsigned		NO	0
item2	int(10)	unsigned		NO	0
item3	int(10)	unsigned		NO	0
item4	int(10)	unsigned		NO	0
item5	int(10)	unsigned		NO	0
item6	int(10)	unsigned		NO	0
item7	int(10)	unsigned		NO	0
item8	int(10)	unsigned		NO	0
item9	int(10)	unsigned		NO	0
item10	int(10)	unsigned		NO	0
item11	int(10)	unsigned		NO	0
item12	int(10)	unsigned		NO	0
item13	int(10)	unsigned		NO	0
item14	int(10)	unsigned		NO	0
item15	int(10)	unsigned		NO	0
item16	int(10)	unsigned		NO	0
item17	int(10)	unsigned		NO	0
item18	int(10)	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

item0-18

Values taken from item_instance.guid

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