creature_properties

This table contains creature properties information.

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)
info_str	varchar(500)
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
resistance2	smallint(5)	0	Fire
resistance3	smallint(5)	0	Nature
resistance4	smallint(5)	0	Frost
resistance5	smallint(5)	0	Shadow
resistance6	smallint(5)	0	Arcane
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 entry ID of the creature.

build

Build number to determine if the data is for our current compiled version.

killcredit_1

…

killcredit_2

…

displayids_male_female

The Display/Model ID of the creature. If more than 1 filled, randomly picks between them on creature spawn.

name

The name of the creature.

subname

The subname/title of the creature. Displayed in-game below the name, in <>’s.

icon_name

Used to tell the player what kind of NPC this creature is (when you hover over the npc).

Repair - shows a Anvil icon identifying this npc as a Repair NPC.
Speak - shows a Chat Bubble icon if this NPC has Quest/Gossip options.
Taxi - shows a Boot wings icon identifying this NPC as a "Taxi".
Trainer - shows a Book icon, identifying this NPC as a "Trainer".
vehichleCursor - indicator that this is a Player Controlled Vehicle.
Gunner - indicator of a Turret NPC/Player Controlled.
Directions - used for Guards and Teleporter NPC's.
Buy - shows a Brown Bag icon usually if the NPC only sells things.
Attack - shows a Sword icon indicating you can attack this target.
Point - used for Guards and Teleporter NPC's.
Pickup - shows a Hand Grasping icon of if this NPC can be picked up for quest/items.
LootAll - shows a Multiple Brown Bag icon (Same as holding Shift before looting a creature).
PVP - unused or Unknown.
Quest - unused or Unknown.

version 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

1        = Makes the mob tamable. Must be type "Beast" [1] and "family" set.
2        = This creature can be seen also when player is dead.
4        = Creature is a world boss
128      = Player can interact with creature while it is dead.
256      = Makes mob herb-able.
512      = Makes mob mine-able.
1024     = Death event will not show up in combat log.
2048     = Creature will fight mounted if has mount.
4096     = Creature can heal players?
32768    = Engineer can loot this npc.
65536    = Exotic pet
524288   = Reacts on projectile?
67108864 = Counts for party members?

type

The type of creature.

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 family of the creature.

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

This row shows if a creature is an encounter. Currently it is used as boolean.

0 = false
1 = true

base_attack_mod

range_attack_mod

leader

0 = Non-Leader
1 = Leader

minlevel

The minimum level of the creature when it is spawned in-game.

maxlevel

The maximum level of the creature when it is spawned in-game. Must be higher than minlevel!

faction

The faction ID of the creature, from FactionTemplate.DBC.

7    = Neutral
14   = Hostile
35   = Friendly
1802 = Alliance
1801 = Horde

minhealth

The minimum health of the creature.

maxhealth

The maximum health of the creature.

mana

The maximum mana of the creature.

scale

The scale/size of the creature.

1 = Normal
2 = 1 x 2

npcflags

The flags of the creature.

Note that most of these also require the “Gossip” [1] flag to work.

So if you want a NPC that is a quest giver, a vendor and can repair you just add the specific flags together: 1 + 2 + 128 + 4096 = 4227.

Pure Flags	Decimal	Binary (32 Bit)	Remarks
UNIT_NPC_FLAG_NONE	0	0000 0000 0000 0000 0000 0000 0000 0000
UNIT_NPC_FLAG_GOSSIP	1	0000 0000 0000 0000 0000 0000 0000 0001	If NPC has more gossip options, add this flag to bring up a menu.
UNIT_NPC_FLAG_QUESTGIVER	2	0000 0000 0000 0000 0000 0000 0000 0010	Any NPC giving or taking quests needs to have this flag.
UNIT_NPC_FLAG_UNK1	4	0000 0000 0000 0000 0000 0000 0000 0100
UNIT_NPC_FLAG_UNK2	8	0000 0000 0000 0000 0000 0000 0000 1000
UNIT_NPC_FLAG_TRAINER	16	0000 0000 0000 0000 0000 0000 0001 0000	Allows the NPC to have a trainer list to teach spells, all trainers must have this flag.
UNIT_NPC_FLAG_TRAINER_CLASS	32	0000 0000 0000 0000 0000 0000 0010 0000
UNIT_NPC_FLAG_TRAINER_PROF	64	0000 0000 0000 0000 0000 0000 0100 0000
UNIT_NPC_FLAG_VENDOR	128	0000 0000 0000 0000 0000 0000 1000 0000	Any NPC selling items needs to have this flag.
UNIT_NPC_FLAG_VENDOR_AMMO	256	0000 0000 0000 0000 0000 0001 0000 0000
UNIT_NPC_FLAG_VENDOR_FOOD	512	0000 0000 0000 0000 0000 0010 0000 0000
UNIT_NPC_FLAG_VENDOR_POISON	1024	0000 0000 0000 0000 0000 0100 0000 0000
UNIT_NPC_FLAG_VENDOR_REAGENT	2048	0000 0000 0000 0000 0000 1000 0000 0000
UNIT_NPC_FLAG_ARMORER	4096	0000 0000 0000 0000 0001 0000 0000 0000	NPC with this flag can repair items.
UNIT_NPC_FLAG_TAXIVENDOR	8192	0000 0000 0000 0000 0010 0000 0000 0000	Any NPC serving as fly master has this.
UNIT_NPC_FLAG_SPIRITHEALER	16384	0000 0000 0000 0000 0100 0000 0000 0000	Makes the NPC invisible to alive characters and has the resurrect function.
UNIT_NPC_FLAG_SPIRITGUIDE	32768	0000 0000 0000 0000 1000 0000 0000 0000	NPC Spirit healer.
UNIT_NPC_FLAG_INNKEEPER	65536	0000 0000 0000 0001 0000 0000 0000 0000	NPC with this flag can set hearthstone locations.
UNIT_NPC_FLAG_BANKER	131072	0000 0000 0000 0010 0000 0000 0000 0000	NPC with this flag can show the bank.
UNIT_NPC_FLAG_ARENACHARTER	262144	0000 0000 0000 0100 0000 0000 0000 0000	NPC supplier of the arena charter, the same supplier of the guild charter.
UNIT_NPC_FLAG_TABARDVENDOR	524288	0000 0000 0000 1000 0000 0000 0000 0000	Allows the designing of guild tabards.
UNIT_NPC_FLAG_BATTLEFIELDPERSON	1048576	0000 0000 0001 0000 0000 0000 0000 0000	NPC with this flag port players to battlegrounds. Like battlemasters, arena organzier etc.
UNIT_NPC_FLAG_AUCTIONEER	2097152	0000 0000 0010 0000 0000 0000 0000 0000	Allows NPC to display auction list.
UNIT_NPC_FLAG_STABLE	4194304	0000 0000 0100 0000 0000 0000 0000 0000	Has the option to stable pets for hunters.
UNIT_NPC_FLAG_GUILD_BANKER	8388608	0000 0000 1000 0000 0000 0000 0000 0000	Cause client to send 997 opcode.
UNIT_NPC_FLAG_SPELLCLICK	16777216	0000 0001 0000 0000 0000 0000 0000 0000	Cause client to send 1015 opcode. Needs data on npc_spellclick_spells table.
UNIT_NPC_FLAG_MAILBOX	67108864	0000 0100 0000 0000 0000 0000 0000 0000	NPC will act like a mailbox, opens mailbox with right-click.
Guard	268435456	0001 0000 0000 0000 0000 0000 0000 0000	Cityguards, must be scripted.

attacktime

The delay between attacks, in milliseconds.

attack_school

The type of damage that is dealt by the creature. Determines damage reduction via armor or resistances.

0 = SCHOOL_NORMAL
1 = SCHOOL_HOLY
2 = SCHOOL_FIRE
3 = SCHOOL_NATURE
4 = SCHOOL_FROST
5 = SCHOOL_SHADOW
6 = SCHOOL_ARCANE

mindamage

The minimum damage dealt by the creature.

maxdamage

The maximum damage dealt by the creature.

can_ranged

…

rangedattacktime

The delay between ranged attacks, in milliseconds.

rangedmindamage

The minimum ranged damage dealt by the creature.

rangedmaxdamage

The maximum damage dealt by the creature.

respawntime

The time before the creature respawns, in milliseconds.

armor

The total armor of the creature.

restistance1

The Holy resistance of the creature.

restistance2

The Fire resistance of the creature.

restistance3

The Nature resistance of the creature.

restistance4

The Frost resistance of the creature.

restistance5

The Shadow resistance of the creature.

restistance6

The Arcane resistance of the creature.

combat_reach

The distance of where the creature can hit it’s target.

bounding_radius

The amount of yards before the creature will reset.

auras

The Spell IDs of auras that are present on the creature. IDs separated with a comma (,).

boss

0 = Normal
1 = Boss

money

The money dropped by the creature in copper (1000 = 10s, 100000 = 1g, 111111 = 11g 11s 11c)

isTriggerNpc

0  = INVIS_FLAG_NORMAL              - Used by players
1  = INVIS_FLAG_ELEMENTAL_SPIRIT    - 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               - These can only be seen when 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
13 = INVIS_FLAG_UNUSED_13
14 = INVIS_FLAG_UNUSED_14
15 = INVIS_FLAG_NEVER_VISIBLE       - Used by trigger or placeholder npcs
INVIS_FLAG_TOTAL

walk_speed

The speed of the creature when it is walking.

run_speed

The speed of the creature when it is running.

fly_speed

The speed of the creature when it is flying.

extra_a9_flags

NOTE currently not used!

spells_1_8

The spells that are available to the creature. These are the spells that used when the creature is a Totem, or Pet, Vehicle or when possessed (mind control) too.

spell_flags

The flags for the spells in Spell1-4

1 = RANDOM_CAST
2 = OUT_OF_COMBAT
3 = COOLDOWN_HALF (Sets cooldown to 1.5)

modImmunities

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

Whether or not the creature is a “Training Dummy”. Training dummy’s are not killable and cannot move.

guardtype

The type of guard the creature is. Most city guards, bruisers and peace keepers has ‘2’ here.

summonguard

The guard that is summoned. Unknown (?)

spelldataid

…

vehicleid

Vehicle data for this creature. Index of Vehicle.dbc

rooted

1 = rooted
0 = unrooted

questitems_1_6

ID of the Questitem which can be looted from npc. (untested)

waypointid

The waypoint ID from creature_waypoints