equipmentsets

This table contains the item sets for the characters… unfortunately it is not used or it can’t verify. If you have information about the function of this table, port it to our forums.

Structure

Field Type Default Comment
ownerguid int(10) 1  
setGUID int(10) 1  
setid int(10) 1  
setname varchar(16) Empty String  
iconname varchar(100) Empty String  
head int(10) 0  
neck int(10) 0  
shoulders int(10) 0  
body int(10) 0  
chest int(10) 0  
waist int(10) 0  
legs int(10) 0  
feet int(10) 0  
wrists int(10) 0  
hands int(10) 0  
finger1 int(10) 0  
finger2 int(10) 0  
trinket1 int(10) 0  
trinket2 int(10) 0  
back int(10) 0  
mainhand int(10) 0  
offhand int(10) 0  
ranged int(10) 0  
tabard int(10) 0  

ownerguid

Owner ID from characters table.

setGUID

The ID of the set…

setid

Another ID to identify the set…

setname

The name of the set.

iconname

The Icon name…

The Id from items table.

neck

The Id from items table.

shoulders

The Id from items table.

body

The Id from items table.

chest

The Id from items table.

waist

The Id from items table.

legs

The Id from items table.

feet

The Id from items table.

wrists

The Id from items table.

hands

The Id from items table.

finger1

The Id from items table.

finger2

The Id from items table.

trinket1

The Id from items table.

trinket2

The Id from items table.

back

The Id from items table.

mainhand

The Id from items table.

offhand

The Id from items table.

ranged

The Id from items table.

tabard

The Id from items table.