creature_equip_template
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| CreatureID | int | unsigned | PRI | NO | 0 | ||
| ID | tinyint | unsigned | PRI | NO | 1 | ||
| ItemID1 | int | unsigned | NO | 0 | |||
| AppearanceModID1 | smallint | unsigned | NO | 0 | |||
| ItemVisual1 | smallint | unsigned | NO | 0 | |||
| ItemID2 | int | unsigned | NO | 0 | |||
| AppearanceModID2 | smallint | unsigned | NO | 0 | |||
| ItemVisual2 | smallint | unsigned | NO | 0 | |||
| ItemID3 | int | unsigned | NO | 0 | |||
| AppearanceModID3 | smallint | unsigned | NO | 0 | |||
| ItemVisual3 | smallint | unsigned | NO | 0 | |||
| VerifiedBuild | int | signed | NO | 0 | |||
Description of fields
CreatureID
The direct corresponding id in creature table or entry in creature_template table.
ID
An additional identifier for each individual entry, enabling multiple equipment for one creature entry. Counter must start with 1 and grow accordingly.
ItemID1
This is the item number of the equipment used in the right hand from ItemSparse.db2 or Item.db2.
AppearanceModID1
ItemID + AppearanceModID together form a key to get DisplayID. Check: ItemModifiedAppearance.db2
ItemVisual1
ItemVisual is ID for ItemVisuals.db2, for e.g. enchant visuals.
ItemID2
This is the item number of the equipment used in the left hand from ItemSparse.db2 or Item.db2.
AppearanceModID2
ItemID + AppearanceModID together form a key to get DisplayID. Check: ItemModifiedAppearance.db2
ItemVisual2
ItemVisual is ID for ItemVisuals.db2, for e.g. enchant visuals.
ItemID3
This is the item number of the equipment used in the ranged slot from ItemSparse.db2 or Item.db2.
AppearanceModID3
ItemID + AppearanceModID together form a key to get DisplayID. Check: ItemModifiedAppearance.db2
ItemVisual3
ItemVisual is ID for ItemVisuals.db2, for e.g. enchant visuals.
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.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.