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.
info_str
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. Transmogrify - added in patch 4.3.0 Reforge - added in patch 4.0.1 currently in use, it's worth standardizing. (don't use these values). Voidstorage SkinAlliance PickLock openhandglow openhand 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 | |
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 | |
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_BANK | 8388608 | 0000 0000 1000 0000 0000 0000 0000 0000 | |
UNIT_NPC_FLAG_SPELLCLICK | 16777216 | 0000 0001 0000 0000 0000 0000 0000 0000 | (Needs data on npc_spellclick_spells table) |
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