The `creature_addon` table
The creature_addon and creature_template_addon tables define different things that are applied on creatures when they are loaded. These "different things" can be for example to have the creature be mounted, to have it emote something, to have it display an aura effect, etc. Through the use of the fields in this table, many things can be changed about the outward visual appearance of the creature. The creature_template_addon table affects all creatures with that creature template ID while the creature_addon table affects individually spawned creatures (so that two creatures using the same template can look different).
NOTE: A creature_addon record will override a creature_template_addon record should they overlap on the same creature.
NOTICE: The data for this table is largely incomplete and is mostly just a regurgitation of what the client receives from the server. This article is a WIP as to what all the possible values are.
Description of the fields
For creature_addon, this field signifies a unique creature guid. It will affect just that creature whose GUID matches the one specified here. For creature_template_addon, this field signifies the creature_template.entry. It will affect all spawned creatures using that template entry.
If a creature has waypoint pathed movement, this field hold the waypoint_data.id for the path the creature is to follow.
The model ID of the mount to be used to make the creature appear mounted. The value here overrides the value for the creature's unit field UNIT_FIELD_MOUNTDISPLAYID.
The value here overrides the value for the creature's unit field UNIT_FIELD_BYTES_1.
List of known values and what their visual effects on the creature
The value here overrides the value for the creature's unit field UNIT_FIELD_BYTES_2.
NOTE: //creatures always have melee weapon ready if any unless specified otherwise
List of few known values and what their visual effects on the creature
Emote ID that the creature should continually perform.
List of often used emote IDs and what they do can be found here.
AnimKit ID from AnimKit.db2 that is applied on creature when spawned.
This field controls the visibility distance for creatures:
0 = Normal, standard visible distance from worldserver.conf (default 90 yards)
1 = Large, maximum visibility distance (250 yards)
This field controls any auras to be applied on the creature (both in effect and visually). To apply multiple auras, you can add more aura entries, separating each entry by a space. Remember that if a spell applies multiple auras.
List of useful aura entries (examples):