Creature template 548
Back to world database list of tables.
The `creature_template` table
This table holds the information of any creatures in the world.
Structure
DB Structure
Structure | ||||||
---|---|---|---|---|---|---|
Field | Type | Attribute | Key | Null | Default | Comment |
entry | mediumint(8) | unsigned | PRI | NO | 0 | |
difficulty_entry_1 | mediumint(8) | unsigned | NO | NO | 0 | |
difficulty_entry_2 | mediumint(8) | unsigned | NO | NO | 0 | |
difficulty_entry_3 | mediumint(8) | unsigned | NO | NO | 0 | |
KillCredit1 | int(11) | unsigned | NO | NO | 0 | |
KillCredit2 | int(11) | unsigned | NO | NO | 0 | |
modelid1 | mediumint(8) | unsigned | NO | NO | 0 | |
modelid2 | mediumint(8) | unsigned | NO | NO | 0 | |
modelid3 | mediumint(8) | unsigned | NO | NO | 0 | |
modelid4 | mediumint(8) | unsigned | NO | NO | 0 | |
name | char(100) | NO | NO | 0 | ||
subname | char(100) | NO | YES | |||
IconName | char(100) | NO | YES | |||
gossip_menu_id | mediumint(8) | unsigned | NO | NO | 0 | |
minlevel | smallint(5) | NO | NO | 1 | ||
maxlevel | smallint(5) | NO | NO | 1 | ||
exp | smallint(5) | NO | NO | 0 | ||
exp_unk | smallint(5) | NO | NO | 0 | ||
faction_A | smallint(5) | unsigned | NO | NO | 0 | |
faction_H | smallint(5) | unsigned | NO | NO | 0 | |
npcflag | int(10) | NO | NO | 0 | ||
speed_walk | float | NO | NO | 1 | Result of 2.5/2.5, most common value | |
speed_run | float | NO | NO | 1.14286 | Result of 8.0/7.0, most common value | |
scale | float | NO | NO | 1 | ||
npc_rank | tinyint(3) | unsigned | NO | NO | 0 | |
mindmg | float | NO | NO | 0 | ||
maxdmg | float | NO | NO | 0 | ||
dmgschool | tinyint(3) | NO | NO | 0 | ||
attackpower | int(10) | unsigned | NO | NO | 0 | |
dmg_multiplier | float | NO | NO | 1 | ||
baseattacktime | int(10) | unsigned | NO | NO | 0 | |
rangeattacktime | int(10) | unsigned | NO | NO | 0 | |
unit_class | tinyint(3) | unsigned | NO | NO | 0 | |
unit_flags | int(10) | unsigned | NO | NO | 0 | |
unit_flags2 | int(10) | unsigned | NO | NO | 0 | |
dynamicflags | int(10) | unsigned | NO | NO | 0 | |
family | tinyint(3) | unsigned | NO | NO | 0 | |
trainer_type | tinyint(3) | NO | NO | 0 | ||
trainer_class | tinyint(3) | unsigned | NO | NO | 0 | |
trainer_race | tinyint(3) | unsigned | NO | NO | 0 | |
minrangedmg | float | NO | NO | 0 | ||
maxrangedmg | float | NO | NO | 0 | ||
rangedattackpower | smallint(5) | unsigned | NO | NO | 0 | |
type | tinyint(3) | unsigned | NO | NO | 0 | Reference by CreatureType.dbc |
type_flags | int(10) | unsigned | NO | NO | 0 | |
type_flags2 | int(10) | unsigned | NO | NO | 0 | |
lootid | mediumint(7) | unsigned | NO | NO | 0 | |
pickpocketloot | mediumint(7) | unsigned | NO | NO | 0 | |
skinloot | mediumint(7) | unsigned | NO | NO | 0 | |
resistance1 | smallint(6) | NO | NO | 0 | ||
resistance2 | smallint(6) | NO | NO | 0 | ||
resistance3 | smallint(6) | NO | NO | 0 | ||
resistance4 | smallint(6) | NO | NO | 0 | ||
resistance5 | smallint(6) | NO | NO | 0 | ||
resistance6 | smallint(6) | NO | NO | 0 | ||
spell1 | mediumint(7) | unsigned | NO | NO | 0 | |
spell2 | mediumint(7) | unsigned | NO | NO | 0 | |
spell3 | mediumint(7) | unsigned | NO | NO | 0 | |
spell4 | mediumint(7) | unsigned | NO | NO | 0 | |
spell5 | mediumint(7) | unsigned | NO | NO | 0 | |
spell6 | mediumint(7) | unsigned | NO | NO | 0 | |
spell7 | mediumint(7) | unsigned | NO | NO | 0 | |
spell8 | mediumint(7) | unsigned | NO | NO | 0 | |
PetSpellDataId | mediumint(7) | unsigned | NO | NO | 0 | |
VehicleId | mediumint(7) | unsigned | NO | NO | 0 | |
mingold | mediumint(7) | unsigned | NO | NO | 0 | |
maxgold | mediumint(7) | unsigned | NO | NO | 0 | |
AIName | char(64) | NO | NO | |||
MovementType | tinyint(3) | unsigned | NO | NO | 0 | |
InhabitType | tinyint(3) | unsigned | NO | NO | 3 | |
HoverHeight | float | NO | NO | 1 | ||
Health_mod | float | NO | NO | 1 | ||
Mana_mod | float | NO | NO | 1 | ||
Mana_mod_extra | float | NO | NO | 1 | ||
Armor_mod | float | NO | NO | 1 | ||
RacialLeader | tinyint(3) | unsigned | NO | NO | 0 | |
questItem1 | int(10) | unsigned | NO | NO | 0 | |
questItem2 | int(10) | unsigned | NO | NO | 0 | |
questItem3 | int(10) | unsigned | NO | NO | 0 | |
questItem4 | int(10) | unsigned | NO | NO | 0 | |
questItem5 | int(10) | unsigned | NO | NO | 0 | |
questItem6 | int(10) | unsigned | NO | NO | 0 | |
movementId | int(10) | unsigned | NO | NO | 0 | |
RegenHealth | tinyint(3) | unsigned | NO | NO | 1 | |
mechanic_immune_mask | int(10) | unsigned | NO | NO | 0 | |
flags_extra | int(10) | unsigned | NO | NO | 0 | |
ScriptName | char(64) | NO | NO | |||
ModLevel | tinyint(3) | unsigned | NO | NO | 0 | |
WDBVerified | smallint(5) | NO | NO | 18414 |
Description of the fields
entry
entry# of the creature.
difficulty_entry_1
Some infos later
difficulty_entry_2
Some infos later
difficulty_entry_3
Some infos later
KillCredit1
Some infos later
KillCredit2
Some infos later
modelid1
Some infos later
modelid2
Some infos later
modelid3
Some infos later
modelid4
Some infos later
name
Some infos later
subname
Some infos later
IconName
Some infos later
Some infos later
minlevel
Some infos later
maxlevel
Some infos later
exp
Some infos later
exp_unk
Some infos later
faction_A
Some infos later
faction_H
Some infos later
npcflag
Some infos later
speed_walk
Some infos later
speed_run
Some infos later
scale
Some infos later
npc_rank
Creature NPC Rank | ||
---|---|---|
Rank | Id | Comment |
CREATURE_ELITE_NORMAL | 0 | |
CREATURE_ELITE_ELITE | 1 | |
CREATURE_ELITE_RAREELITE | 2 | |
CREATURE_ELITE_WORLDBOSS | 3 | |
CREATURE_ELITE_RARE | 4 | |
CREATURE_UNKNOWN | 5 | // found in 2.2.3 for 2 mobs |
mindmg
Some infos later
maxdmg
Some infos later
dmgschool
Some infos later
attackpower
Some infos later
dmg_multiplier
Some infos later
baseattacktime
Some infos later
rangeattacktime
Some infos later
unit_class
Some infos later
unit_flags
Some infos later
unit_flags2
Some infos later
dynamicflags
Some infos later
family
Reference by CreatureFamily.dbc
Creature Family Information | ||
---|---|---|
CREATURE_FAMILY_WOLF | 1 | |
CREATURE_FAMILY_CAT | 2 | |
CREATURE_FAMILY_SPIDER | 3 | |
CREATURE_FAMILY_BEAR | 4 | |
CREATURE_FAMILY_BOAR | 5 | |
CREATURE_FAMILY_CROCOLISK | 6 | |
CREATURE_FAMILY_CARRION_BIRD | 7 | |
CREATURE_FAMILY_CRAB | 8 | |
CREATURE_FAMILY_GORILLA | 9 | |
CREATURE_FAMILY_HORSE_CUSTOM | 10 | // Does not exist in DBC but used for horse like beasts in DB |
CREATURE_FAMILY_RAPTOR | 11 | |
CREATURE_FAMILY_TALLSTRIDER | 12 | |
CREATURE_FAMILY_FELHUNTER | 15 | |
CREATURE_FAMILY_VOIDWALKER | 16 | |
CREATURE_FAMILY_SUCCUBUS | 17 | |
CREATURE_FAMILY_DOOMGUARD | 19 | |
CREATURE_FAMILY_SCORPID | 20 | |
CREATURE_FAMILY_TURTLE | 21 | |
CREATURE_FAMILY_IMP | 23 | |
CREATURE_FAMILY_BAT | 24 | |
CREATURE_FAMILY_HYENA | 25 | |
CREATURE_FAMILY_BIRD_OF_PREY | 26 | |
CREATURE_FAMILY_WIND_SERPENT | 27 | |
CREATURE_FAMILY_REMOTE_CONTROL | 28 | |
CREATURE_FAMILY_FELGUARD | 29 | |
CREATURE_FAMILY_DRAGONHAWK | 30 | |
CREATURE_FAMILY_RAVAGER | 31 | |
CREATURE_FAMILY_WARP_STALKER | 32 | |
CREATURE_FAMILY_SPOREBAT | 33 | |
CREATURE_FAMILY_NETHER_RAY | 34 | |
CREATURE_FAMILY_SERPENT | 35 | |
CREATURE_FAMILY_MOTH | 37 | |
CREATURE_FAMILY_CHIMAERA | 38 | |
CREATURE_FAMILY_DEVILSAUR | 39 | |
CREATURE_FAMILY_GHOUL | 40 | |
CREATURE_FAMILY_SILITHID | 41 | |
CREATURE_FAMILY_WORM | 42 | |
CREATURE_FAMILY_RHINO | 43 | |
CREATURE_FAMILY_WASP | 44 | |
CREATURE_FAMILY_CORE_HOUND | 45 | |
CREATURE_FAMILY_SPIRIT_BEAST | 46 | |
CREATURE_FAMILY_WATER_ELEMENTAL | 49 | |
CREATURE_FAMILY_FOX | 50 | |
CREATURE_FAMILY_MONKEY | 51 | |
CREATURE_FAMILY_DOG | 52 | |
CREATURE_FAMILY_BEETLE | 53 | |
CREATURE_FAMILY_SHALE_SPIDER | 55 | |
CREATURE_FAMILY_ZOMBIE | 56 | |
CREATURE_FAMILY_QA_TEST_FAMILY | 57 | |
CREATURE_FAMILY_SILITHID_2 | 59 | |
CREATURE_FAMILY_WASP_2 | 66 | |
CREATURE_FAMILY_HYDRA | 68 | |
CREATURE_FAMILY_FEL_IMP | 100 | |
CREATURE_FAMILY_VOIDLORD | 101 | |
CREATURE_FAMILY_SHIVARRA | 102 | |
CREATURE_FAMILY_OBSERVER | 103 | |
CREATURE_FAMILY_WRATHGUARD | 104 | |
CREATURE_FAMILY_INFERNAL | 108 | |
CREATURE_FAMILY_FIRE_ELEMENTAL | 116 | |
CREATURE_FAMILY_EARTH_ELEMENTAL | 117 | |
CREATURE_FAMILY_CRANE | 125 | |
CREATURE_FAMILY_WATER_STRIDER | 126 | |
CREATURE_FAMILY_PORCUPINE | 127 | |
CREATURE_FAMILY_QUILEN | 128 | |
CREATURE_FAMILY_GOAT | 129 | |
CREATURE_FAMILY_BASILISK | 130 | |
CREATURE_FAMILY_DIREHORN | 138 |
trainer_type
Some infos later
trainer_class
Some infos later
trainer_race
Some infos later
minrangedmg
Some infos later
maxrangedmg
Some infos later
rangedattackpower
Some infos later
type
Reference by CreatureType.dbc
Creature Type Information | |
---|---|
Name | Id |
CREATURE_TYPE_BEAST | 1 |
CREATURE_TYPE_DRAGONKIN | 2 |
CREATURE_TYPE_DEMON | 3 |
CREATURE_TYPE_ELEMENTAL | 4 |
CREATURE_TYPE_GIANT | 5 |
CREATURE_TYPE_UNDEAD | 6 |
CREATURE_TYPE_HUMANOID | 7 |
CREATURE_TYPE_CRITTER | 8 |
CREATURE_TYPE_MECHANICAL | 9 |
CREATURE_TYPE_NOT_SPECIFIED | 10 |
CREATURE_TYPE_TOTEM | 11 |
CREATURE_TYPE_NON_COMBAT_PET | 12 |
CREATURE_TYPE_GAS_CLOUD | 13 |
CREATURE_TYPE_WILD_PET | 14 |
CREATURE_TYPE_ABERRATION | 15 |
type_flags
Creature Type Flags Information | ||
---|---|---|
CREATURE_TYPEFLAGS_TAMEABLE | 0x00000001 | // Tameable by any hunter |
CREATURE_TYPEFLAGS_GHOST | 0x00000002 | // Creature are also visible for not alive player. Allow gossip interaction if npcflag allow? |
CREATURE_TYPEFLAGS_BOSS | 0x00000004 | |
CREATURE_TYPEFLAGS_UNK3 | 0x00000008 | |
CREATURE_TYPEFLAGS_UNK4 | 0x00000010 | |
CREATURE_TYPEFLAGS_UNK5 | 0x00000020 | |
CREATURE_TYPEFLAGS_UNK6 | 0x00000040 | |
CREATURE_TYPEFLAGS_DEAD_INTERACT | 0x00000080 | // Player can interact with the creature if its dead (not player dead) |
CREATURE_TYPEFLAGS_HERBLOOT | 0x00000100 | // Can be looted by herbalist |
CREATURE_TYPEFLAGS_MININGLOOT | 0x00000200 | // Can be looted by miner |
CREATURE_TYPEFLAGS_UNK10 | 0x00000400 | |
CREATURE_TYPEFLAGS_MOUNTED_COMBAT | 0x00000800 | // Creature can remain mounted when entering combat |
CREATURE_TYPEFLAGS_AID_PLAYERS | 0x00001000 | // ? Can aid any player in combat if in range? |
CREATURE_TYPEFLAGS_UNK13 | 0x00002000 | |
CREATURE_TYPEFLAGS_UNK14 | 0x00004000 | // ? Possibly not in use |
CREATURE_TYPEFLAGS_ENGINEERLOOT | 0x00008000 | // Can be looted by engineer |
CREATURE_TYPEFLAGS_EXOTIC | 0x00010000 | // Can be tamed by hunter as exotic pet |
CREATURE_TYPEFLAGS_UNK17 | 0x00020000 | // ? Related to vehicles/pvp? |
CREATURE_TYPEFLAGS_UNK18 | 0x00040000 | // ? Related to vehicle/siege weapons? |
CREATURE_TYPEFLAGS_UNK19 | 0x00080000 | |
CREATURE_TYPEFLAGS_UNK20 | 0x00100000 | |
CREATURE_TYPEFLAGS_UNK21 | 0x00200000 | |
CREATURE_TYPEFLAGS_UNK22 | 0x00400000 | |
CREATURE_TYPEFLAGS_UNK23 | 0x00800000 | // ? First seen in 3.2.2. Related to banner/backpack of creature/companion? |
CREATURE_TYPEFLAGS_UNK24 | 0x01000000 | |
CREATURE_TYPEFLAGS_UNK25 | 0x02000000 | |
CREATURE_TYPEFLAGS_PARTY_MEMBER | 0x04000000 | //! Creature can be targeted by spells that require target to be in caster's party/raid |
CREATURE_TYPEFLAGS_UNK27 | 0x08000000 | |
CREATURE_TYPEFLAGS_UNK28 | 0x10000000 | |
CREATURE_TYPEFLAGS_UNK29 | 0x20000000 | |
CREATURE_TYPEFLAGS_UNK30 | 0x40000000 | |
CREATURE_TYPEFLAGS_UNK31 | 0x80000000 |
type_flags2
Creature TypeFlags2 Information | |
---|---|
CREATURE_TYPEFLAGS_2_UNK1 | 0x00000001 |
CREATURE_TYPEFLAGS_2_UNK2 | 0x00000002 |
CREATURE_TYPEFLAGS_2_UNK3 | 0x00000004 |
CREATURE_TYPEFLAGS_2_UNK4 | 0x00000008 |
CREATURE_TYPEFLAGS_2_UNK5 | 0x00000010 |
CREATURE_TYPEFLAGS_2_UNK6 | 0x00000020 |
CREATURE_TYPEFLAGS_2_UNK7 | 0x00000040 |
CREATURE_TYPEFLAGS_2_UNK8 | 0x00000080 |
lootid
Some infos later
pickpocketloot
Some infos later
skinloot
Some infos later
resistance1
Some infos later
resistance2
Some infos later
resistance3
Some infos later
resistance4
Some infos later
resistance5
Some infos later
resistance6
Some infos later
spell1
Some infos later
spell2
Some infos later
spell3
Some infos later
spell4
Some infos later
spell5
Some infos later
spell6
Some infos later
spell7
Some infos later
spell8
Some infos later
PetSpellDataId
Some infos later
VehicleId
Some infos later
mingold
Some infos later
maxgold
Some infos later
AIName
Some infos later
MovementType
Some infos later
InhabitType
Some infos later
HoverHeight
Some infos later
Health_mod
Some infos later
Mana_mod
Some infos later
Mana_mod_extra
Some infos later
Armor_mod
Some infos later
RacialLeader
Some infos later
questItem1
Some infos later
questItem2
Some infos later
questItem3
Some infos later
questItem4
Some infos later
questItem5
Some infos later
questItem6
Some infos later
movementId
Some infos later
RegenHealth
Some infos later
mechanic_immune_mask
Some infos later
flags_extra
Flags Extra Informations | ||
---|---|---|
Name | Byte | Comment |
CREATURE_FLAG_EXTRA_INSTANCE_BIND | 0x00000001 | // creature kill bind instance with killer and killer's group |
CREATURE_FLAG_EXTRA_CIVILIAN | 0x00000002 | // not aggro (ignore faction/reputation hostility) |
CREATURE_FLAG_EXTRA_NO_PARRY | 0x00000004 | // creature can't parry |
CREATURE_FLAG_EXTRA_NO_PARRY_HASTEN | 0x00000008 | // creature can't counter-attack at parry |
CREATURE_FLAG_EXTRA_NO_BLOCK | 0x00000010 | // creature can't block |
CREATURE_FLAG_EXTRA_NO_CRUSH | 0x00000020 | // creature can't do crush attacks |
CREATURE_FLAG_EXTRA_NO_XP_AT_KILL | 0x00000040 | // creature kill not provide XP |
CREATURE_FLAG_EXTRA_TRIGGER | 0x00000080 | // trigger creature |
CREATURE_FLAG_EXTRA_NO_TAUNT | 0x00000100 | // creature is immune to taunt auras and effect attack me |
CREATURE_FLAG_EXTRA_WORLDEVENT | 0x00004000 | // custom flag for world event creatures (left room for merging) |
CREATURE_FLAG_EXTRA_GUARD | 0x00008000 | // Creature is guard |
CREATURE_FLAG_EXTRA_NO_CRIT | 0x00020000 | // creature can't do critical strikes |
CREATURE_FLAG_EXTRA_NO_SKILLGAIN | 0x00040000 | // creature won't increase weapon skills |
CREATURE_FLAG_EXTRA_TAUNT_DIMINISH | 0x00080000 | // Taunt is a subject to diminishing returns on this creautre |
CREATURE_FLAG_EXTRA_ALL_DIMINISH | 0x00100000 | // Creature is subject to all diminishing returns as player are |
CREATURE_FLAG_EXTRA_DUNGEON_BOSS | 0x10000000 | // creature is a dungeon boss (SET DYNAMICALLY, DO NOT ADD IN DB) |
ScriptName
Some infos later
ModLevel
Some infos later