Back-to:Hotfixes

The `item_appearance` table

This table contains some of the appearance data regarding item hotfixes. Together with item, item_modified_appearance and item_sparse they present the means to hotfix an item.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int(10)	unsigned	PRI	NO	0
DisplayID	int(10)	unsigned		NO	0
IconFileDataID	int(10)	unsigned		NO	0
VerifiedBuild	smallint(6)	signed		NO	0

Description of the fields

ID

This is the unique ID for the item_appearance table and has no relation whatsoever to the item id that is being hotfixed.
This value links to hotfix_data.RecordID with the proper TableHash accompanied and item_modified_appearance.AppearanceId.

DisplayID

The model ID of the item. This value can be found as the ID in itemdisplayinfo.dbc.

IconFileDataID

The ID of the item's icon that will show up in bags and such, found in FileData.db2.

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

Navegador incompatible