Item_enchantment_template - cmangos/issues GitHub Wiki

Back to world database list of tables.

The `item_enchantment_template` table

This table holds enchantment chance information for items that should have either a random property or a random suffix attached to them.

Structure

Field	Type	Null	Key	Default	Extra
entry	int(10) unsigned	NO	PRI	0
ench	int(10) unsigned	NO	PRI	0
chance	float unsigned	NO		0

Description of the fields

entry

This field ties in with EITHER RandomProperty OR RandomSuffix fields in the item_template table. An item cannot have both of those fields set at non-zero values.

NOTE: For 4.3.4 Core Use Negative Values To Specify a Random Suffix Entry and a Positive Value for a Random Properties Value

This is to prevent overlapping values since in 4.3.4 Official Data we do have about 12 overlapping Random Property and Random Suffix entries.

ench

The enchantment to apply on the item. If the entry for the current row is used in RandomProperty, then this field points to the ID in ItemRandomProperties.dbc. If the entry is used in RandomSuffix, then this field points to the ID in ItemRandomSuffix.dbc.

chance

The chance for a random property or suffix to be applied to the item. For each entry in this table, the combined chances of all properties/suffixes need to equal 100 otherwise the item may not get a random enchantment on it.