character_equipmentsets

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
  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

/p