AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
creature_equip_template
Table: creature_equip_template
This table contains all the equipment combinations that can be sent for each creature.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| CreatureID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | Unique entry | |
| ID | TINYINT | UNSIGNED | PRI | NO | 1 | Unique entry | |
| ItemID1 | MEDIUMINT | UNSIGNED | NO | 0 | |||
| ItemID2 | MEDIUMINT | UNSIGNED | NO | 0 | |||
| ItemID3 | MEDIUMINT | UNSIGNED | NO | 0 |
Description of the 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 Item.dbc.
ItemID2
This is the item number of the equipment used in the left hand from聽Item.dbc.
ItemID3
This is the item number of the equipment used in the ranged slot from聽Item.dbc.