creature_properties
This table contains the properties and configuration data used by creatures.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| entry | int(30) | 0 | key |
| build | smallint(6) | 12340 | key |
| killcredit1 | int(10) | 0 | |
| killcredit2 | int(10) | 0 | |
| male_displayid | int(10) | 0 | |
| female_displayid | int(10) | 0 | |
| male_displayid2 | int(10) | 0 | |
| female_displayid2 | int(10) | 0 | |
| name | varchar(100) | ||
| subname | varchar(100) | ||
| icon_name | varchar(100) | ||
| type_flags | int(10) | 0 | |
| type | int(10) | 0 | |
| family | int(10) | 0 | |
| rank | int(10) | 0 | |
| encounter | int(10) | 0 | |
| base_attack_mod | float(0) | 1 | |
| range_attack_mod | float(0) | 1 | |
| leader | tinyint(3) | 0 | |
| minlevel | int(30) | ||
| maxlevel | int(30) | ||
| faction | int(30) | 0 | |
| minhealth | int(30) | ||
| maxhealth | int(30) | 0 | |
| mana | int(30) | 0 | |
| scale | float(0) | 0 | |
| npcflags | int(30) | 0 | |
| attacktime | int(30) | 0 | |
| attack_school | tinyint(1) | 0 | |
| mindamage | float(0) | 0 | |
| maxdamage | float(0) | 0 | |
| can_ranged | int(11) | 0 | |
| rangedattacktime | int(30) | 0 | |
| rangedmindamage | float(0) | 0 | |
| rangedmaxdamage | float(0) | 0 | |
| respawntime | int(30) | 0 | |
| armor | mediumint(10) | 0 | |
| resistance1 | smallint(5) | 0 | Holy resistance. |
| resistance2 | smallint(5) | 0 | Fire resistance. |
| resistance3 | smallint(5) | 0 | Nature resistance. |
| resistance4 | smallint(5) | 0 | Frost resistance. |
| resistance5 | smallint(5) | 0 | Shadow resistance. |
| resistance6 | smallint(5) | 0 | Arcane resistance. |
| combat_reach | float(0) | 1 | |
| bounding_radius | float(0) | 1 | |
| auras | longtext(0) | ||
| boss | int(11) | 0 | |
| money | int(30) | 0 | |
| isTriggerNpc | smallint(5) | 0 | |
| walk_speed | float(0) | 2.5 | |
| run_speed | float(0) | 8 | |
| fly_speed | float(0) | 14 | |
| extra_a9_flags | int(30) | 0 | |
| spell1 | int(10) | 0 | |
| spell2 | int(10) | 0 | |
| spell3 | int(10) | 0 | |
| spell4 | int(10) | 0 | |
| spell5 | int(10) | 0 | |
| spell6 | int(10) | 0 | |
| spell7 | int(10) | 0 | |
| spell8 | int(10) | 0 | |
| spell_flags | int(30) | 0 | |
| modImmunities | int(30) | 0 | |
| isTrainingDummy | int(10) | 0 | |
| guardtype | int(10) | 0 | |
| summonguard | int(10) | 0 | |
| spelldataid | int(10) | 0 | |
| vehicleid | int(10) | 0 | |
| rooted | int(10) | 0 | |
| questitem1 | int(11) | 0 | |
| questitem2 | int(11) | 0 | |
| questitem3 | int(11) | 0 | |
| questitem4 | int(11) | 0 | |
| questitem5 | int(11) | 0 | |
| questitem6 | int(11) | 0 | |
| waypointid | int(10) | 0 |
entry
The unique entry ID of the creature.
build
Client build number used to determine whether the creature data matches the current client version.
killcredit_1
Creature entry ID that receives kill credit when this creature is killed.
killcredit_2
Creature entry ID that receives additional kill credit when this creature is killed.
displayids_male_female
Display/model IDs used by the creature.
The available display IDs are:
male_displayid— primary male display ID.female_displayid— primary female display ID.male_displayid2— secondary male display ID.female_displayid2— secondary female display ID.
If multiple display IDs are configured, one of the available IDs can be selected when the creature is spawned.
name
The name of the creature displayed in-game.
subname
The subname or title displayed below the creature’s name.
icon_name
Defines the interaction icon displayed when the player hovers over the creature.
Common values include:
Repair - Anvil icon used by repair NPCs. Speak - Chat bubble icon used by NPCs with quest or gossip interactions. Taxi - Flight master icon. Trainer - Book icon used by trainers. vehichleCursor - Indicator for a player-controlled vehicle. Gunner - Indicator for a turret NPC or player-controlled turret. Directions - Direction indicator used by guards and teleporters. Buy - Brown bag icon used by NPCs that sell items. Attack - Sword icon indicating an attackable target. Point - Point indicator used by guards and teleporters. Pickup - Hand icon used for creatures that can be picked up. LootAll - Multiple-bag icon used for looting. PVP - Unused or unknown. Quest - Unused or unknown.
For client versions above 4.x.x:
Transmogrify - added in patch 4.3.0 SkinAlliance - added in patch 4.0.3 Reforge - added in patch 4.0.1 Voidstorage - added in patch 4.0.1 openhand openhandglow Interact Inspect GatherHerbs EngineerSkin Driver Cast
type_flags
Flags that define additional properties of the creature.
1 = Makes the creature tamable. The creature must have type "Beast" and a family set. 2 = Creature can be seen while the player is dead. 4 = Creature is a world boss. 128 = Player can interact with the creature while it is dead. 256 = Makes the creature herb-lootable. 512 = Makes the creature mine-lootable. 1024 = Death event is not shown in the combat log. 2048 = Creature can fight while mounted if it has a mount. 4096 = Creature can heal players. 32768 = Engineer can loot this creature. 65536 = Creature is an exotic pet. 524288 = Creature reacts to projectiles. 67108864 = Counts for party members.
type
The creature type.
0 = None 1 = Beast 2 = Dragonkin 3 = Demon 4 = Elemental 5 = Giant 6 = Undead 7 = Humanoid 8 = Critter 9 = Mechanical 10 = Not specified 11 = Totem 12 = Non-combat Pet 13 = Gas Cloud
family
The creature family.
0 = No family 1 = Wolf 2 = Cat 3 = Spider 4 = Bear 5 = Boar 6 = Crocolisk 7 = Carrion Bird 8 = Crab 9 = Gorilla 10 = UNUSED 11 = Raptor 12 = Tallstrider 13 = UNUSED 14 = UNUSED 15 = Felhunter 16 = Voidwalker 17 = Succubus 18 = UNUSED 19 = Doomguard 20 = Scorpid 21 = Turtle 22 = UNUSED 23 = Imp 24 = Bat 25 = Hyena 26 = Bird of Prey 27 = Wind Serpent 28 = Remote Control 29 = Felguard 30 = Dragonhawk 31 = Ravager 32 = Warp Stalker 33 = Sporebat 34 = Nether Ray 35 = Serpent 36 = UNUSED 37 = Moth 38 = Chimaera 39 = Devilsaur 40 = Ghoul 41 = Silithid 42 = Worm 43 = Rhino 44 = Wasp 45 = Core Hound 46 = Spirit Beast
rank
The rank of the creature.
0 = Normal 1 = Elite 2 = Rare-Elite 3 = Boss 4 = Rare
encounter
Indicates whether the creature is an encounter.
0 = false 1 = true
base_attack_mod
Modifier applied to the creature’s base attack values.
range_attack_mod
Modifier applied to the creature’s ranged attack values.
leader
Indicates whether the creature is a leader.
0 = Non-Leader 1 = Leader
minlevel
The minimum level at which the creature can spawn.
maxlevel
The maximum level at which the creature can spawn.
faction
Faction ID of the creature, based on FactionTemplate.dbc.
Common faction IDs:
7 = Neutral 14 = Hostile 35 = Friendly 1802 = Alliance 1801 = Horde
minhealth
The minimum health value of the creature.
maxhealth
The maximum health value of the creature.
mana
The maximum mana value of the creature.
scale
The creature’s model scale.
A value of 1 represents the normal scale.
npcflags
Flags defining the NPC’s available interactions.
Most interaction flags require the UNIT_NPC_FLAG_GOSSIP flag to be present.
For example, a creature that is a quest giver, vendor, and repair NPC can use:
1 + 2 + 128 + 4096 = 4227
Pure flags:
| Pure Flags | Decimal | Binary (32 Bit) | Remarks |
|---|---|---|---|
| UNIT_NPC_FLAG_NONE | 0 | 0000 0000 0000 0000 0000 0000 0000 0000 | No NPC flags. |
| UNIT_NPC_FLAG_GOSSIP | 1 | 0000 0000 0000 0000 0000 0000 0000 0001 | Opens gossip options. |
| UNIT_NPC_FLAG_QUESTGIVER | 2 | 0000 0000 0000 0000 0000 0000 0000 0010 | Allows the NPC to give or take quests. |
| UNIT_NPC_FLAG_UNK1 | 4 | 0000 0000 0000 0000 0000 0000 0000 0100 | Unknown. |
| UNIT_NPC_FLAG_UNK2 | 8 | 0000 0000 0000 0000 0000 0000 0000 1000 | Unknown. |
| UNIT_NPC_FLAG_TRAINER | 16 | 0000 0000 0000 0000 0000 0000 0001 0000 | Allows the NPC to use a trainer list. |
| UNIT_NPC_FLAG_TRAINER_CLASS | 32 | 0000 0000 0000 0000 0000 0000 0010 0000 | Class trainer. |
| UNIT_NPC_FLAG_TRAINER_PROF | 64 | 0000 0000 0000 0000 0000 0000 0100 0000 | Profession trainer. |
| UNIT_NPC_FLAG_VENDOR | 128 | 0000 0000 0000 0000 0000 0000 1000 0000 | Allows the NPC to sell items. |
| UNIT_NPC_FLAG_VENDOR_AMMO | 256 | 0000 0000 0000 0000 0000 0001 0000 0000 | Ammunition vendor. |
| UNIT_NPC_FLAG_VENDOR_FOOD | 512 | 0000 0000 0000 0000 0000 0010 0000 0000 | Food vendor. |
| UNIT_NPC_FLAG_VENDOR_POISON | 1024 | 0000 0000 0000 0000 0000 0100 0000 0000 | Poison vendor. |
| UNIT_NPC_FLAG_VENDOR_REAGENT | 2048 | 0000 0000 0000 0000 0000 1000 0000 0000 | Reagent vendor. |
| UNIT_NPC_FLAG_ARMORER | 4096 | 0000 0000 0000 0000 0001 0000 0000 0000 | Allows the NPC to repair items. |
| UNIT_NPC_FLAG_TAXIVENDOR | 8192 | 0000 0000 0000 0000 0010 0000 0000 0000 | Flight master. |
| UNIT_NPC_FLAG_SPIRITHEALER | 16384 | 0000 0000 0000 0000 0100 0000 0000 0000 | Spirit healer. |
| UNIT_NPC_FLAG_SPIRITGUIDE | 32768 | 0000 0000 0000 1000 0000 0000 0000 0000 | Spirit guide. |
| UNIT_NPC_FLAG_INNKEEPER | 65536 | 0000 0000 0001 0000 0000 0000 0000 0000 | Allows the NPC to set a hearthstone location. |
| UNIT_NPC_FLAG_BANKER | 131072 | 0000 0000 0010 0000 0000 0000 0000 0000 | Opens the bank. |
| UNIT_NPC_FLAG_ARENACHARTER | 262144 | 0000 0000 0100 0000 0000 0000 0000 0000 | Arena or guild charter vendor. |
| UNIT_NPC_FLAG_TABARDVENDOR | 524288 | 0000 0000 1000 0000 0000 0000 0000 0000 | Allows guild tabard design. |
| UNIT_NPC_FLAG_BATTLEFIELDPERSON | 1048576 | 0000 0001 0000 0000 0000 0000 0000 0000 | Battleground or arena organizer. |
| UNIT_NPC_FLAG_AUCTIONEER | 2097152 | 0000 0010 0000 0000 0000 0000 0000 0000 | Opens the auction house. |
| UNIT_NPC_FLAG_STABLE | 4194304 | 0000 0100 0000 0000 0000 0000 0000 0000 | Allows hunters to stable pets. |
| UNIT_NPC_FLAG_GUILD_BANKER | 8388608 | 0000 1000 0000 0000 0000 0000 0000 0000 | Opens the guild bank. |
| UNIT_NPC_FLAG_SPELLCLICK | 16777216 | 0001 0000 0000 0000 0000 0000 0000 0000 | Enables spell-click interactions. |
| UNIT_NPC_FLAG_MAILBOX | 67108864 | 0000 0100 0000 0000 0000 0000 0000 0000 | Allows the NPC to act as a mailbox. |
| Guard | 268435456 | 0001 0000 0000 0000 0000 0000 0000 0000 | City guards, which must be scripted. |
attacktime
Delay between the creature’s melee attacks, in milliseconds.
attack_school
Damage school used by the creature.
0 = SCHOOL_NORMAL 1 = SCHOOL_HOLY 2 = SCHOOL_FIRE 3 = SCHOOL_NATURE 4 = SCHOOL_FROST 5 = SCHOOL_SHADOW 6 = SCHOOL_ARCANE
mindamage
Minimum melee damage dealt by the creature.
maxdamage
Maximum melee damage dealt by the creature.
can_ranged
Indicates whether the creature can perform ranged attacks.
rangedattacktime
Delay between ranged attacks, in milliseconds.
rangedmindamage
Minimum ranged damage dealt by the creature.
rangedmaxdamage
Maximum ranged damage dealt by the creature.
respawntime
Time before the creature respawns after being removed, in milliseconds.
armor
Total armor value of the creature.
resistance1
Holy resistance.
resistance2
Fire resistance.
resistance3
Nature resistance.
resistance4
Frost resistance.
resistance5
Shadow resistance.
resistance6
Arcane resistance.
combat_reach
The distance from which the creature can reach and attack its target.
bounding_radius
The creature’s bounding radius used for distance and collision calculations.
auras
Spell IDs of auras applied to the creature.
Multiple spell IDs are separated by commas.
Example:
1234,5678,9012
boss
Indicates whether the creature is a boss.
0 = Normal 1 = Boss
money
Amount of money dropped by the creature, specified in copper.
Examples:
1000 = 10s 100000 = 1g 111111 = 11g 11s 11c
isTriggerNpc
Defines the creature’s invisibility/trigger NPC type.
0 = INVIS_FLAG_NORMAL - Used by players. 1 = INVIS_FLAG_ELEMENTAL_SPIRIT - Used by Shaman totem quests. 2 = INVIS_FLAG_UNKNOWN_2 - Used by spell ID 24306. 3 = INVIS_FLAG_TRAP - Used by gameobjects only. 4 = INVIS_FLAG_QUEST_4 - Used by many quest creatures. 5 = INVIS_FLAG_DUNGEON_SET_NPC - Used by dungeon set 2 NPCs. 6 = INVIS_FLAG_DRUNK - Visible only while drunk. 7 = INVIS_FLAG_QUEST_7 - Used by many quest creatures. 8 = INVIS_FLAG_QUEST_8 - Used by many quest creatures. 9 = INVIS_FLAG_QUEST_9 - Used by many quest creatures. 10 = INVIS_FLAG_QUEST_10 - Used by many quest creatures. 11 = INVIS_FLAG_UNKNOWN_11 - Used by spell ID 49962. 12 = INVIS_FLAG_UNUSED_12 - Unused. 13 = INVIS_FLAG_UNUSED_13 - Unused. 14 = INVIS_FLAG_UNUSED_14 - Unused. 15 = INVIS_FLAG_NEVER_VISIBLE - Used by triggers or placeholder NPCs.
walk_speed
The movement speed of the creature while walking.
run_speed
The movement speed of the creature while running.
fly_speed
The movement speed of the creature while flying.
extra_a9_flags
Additional flags.
NOTE: Currently unused.
spells_1_8
Spell IDs available to the creature.
These spells can be used by creatures acting as totems, pets, vehicles, or while possessed through mind control.
spell_flags
Flags controlling creature spell behavior.
1 = RANDOM_CAST 2 = OUT_OF_COMBAT
The following value combines both flags:
3 = RANDOM_CAST | OUT_OF_COMBAT
modImmunities
Flags defining immunities to various crowd-control effects and spell mechanics.
1 = Charm (Mind Control, enslave demon) 2 = Confuse (Blind, etc.) 4 = Fear 8 = Root 16 = Silence 32 = Stun 64 = Sheep 128 = Banish 256 = Sap 512 = Frozen 1024 = Ensnared 2048 = Sleep 4096 = Taunt (aura) 8192 = Decrease Speed (Hamstring) (aura) 16384 = Spell Haste (Curse of Tongues) (aura) 32768 = Interrupt Cast 65536 = Mod Healing % (Mortal Strike) (aura) 131072 = Total Stats % (Vindication) (aura)
isTrainingDummy
Indicates whether the creature is a training dummy.
Training dummies cannot be killed and cannot move.
guardtype
Defines the type of guard represented by the creature.
Most city guards, bruisers, and peacekeepers use 2.
summonguard
Creature entry ID of the guard summoned by this creature.
The exact usage is unknown.
spelldataid
Spell data ID associated with the creature.
vehicleid
Vehicle data ID associated with the creature.
This corresponds to the vehicle data entry.
rooted
Indicates whether the creature is rooted.
0 = Unrooted 1 = Rooted
questitems_1_6
Quest item IDs that can be looted from the creature.
Up to six quest items can be configured.
waypointid
Waypoint path ID used by the creature.
The path is defined in creature_waypoints.