Creature_template

Back to world database list of tables.

See also Creature_template_tbc (for 2.4.3)
See also Creature_template_classic (for 1.12.x)

The `creature_template` table

This table contains the description of creatures. Each spawned creature is an instance of a template present in this table, this means every creature MUST be defined in this table.

Structure

Field	Type	Null	Key	Default	Extra
Entry	mediumint(8) unsigned	NO	PRI	0
Name	char(100)	NO		0
SubName	char(100)	YES		Null
IconName	char(100)	YES		Null
MinLevel	tinyint(3) unsigned	YES		1
MaxLevel	tinyint(3) unsigned	YES		1
DifficultyEntry1	mediumint(8) unsigned	NO		0
DifficultyEntry2	mediumint(8) unsigned	NO		0
DifficultyEntry3	mediumint(8) unsigned	NO		0
ModelId1	mediumint(8) unsigned	NO		0
ModelId2	mediumint(8) unsigned	NO		0
ModelId3	mediumint(8) unsigned	NO		0
ModelId4	mediumint(8) unsigned	NO		0
FactionAlliance	smallint(5) unsigned	NO		0
FactionHorde	smallint(5) unsigned	NO		0
Scale	float	NO		0
Family	tinyint(4)	YES		0
CreatureType	tinyint(3) unsigned	NO		0
InhabitType	tinyint(3) unsigned	NO		3
RegenerateHealth	tinyint(3) unsigned	NO		1
RacialLeader	tinyint(3) unsigned	NO		0
NpcFlags	int(10) unsigned	NO		0
UnitFlags	int(10) unsigned	NO		0
DynamicFlags	int(10) unsigned	NO		0
ExtraFlags	int(10) unsigned	NO		0
CreatureTypeFlags	int(10) unsigned	YES		0
SpeedWalk	float	YES		1
SpeedRun	float	YES		1.14286
UnitClass	int unsigned	NO		0
Rank	tinyint(3) unsigned	YES		0
Expansion	tinyint(3) unsigned	NO		0
HealthMultiplier	float	NO		1.0
ManaMultiplier	float	NO		1.0
DamageMultiplier	float	NO		1
DamageVariance	float	NO		1
ArmorMultiplier	float	NO		1
ExperienceMultiplier	float	NO		1
MinLevelHealth	int(10) unsigned	YES		0
MaxLevelHealth	int(10) unsigned	YES		0
MinLevelMana	int(10) unsigned	YES		0
MaxLevelMana	int(10) unsigned	YES		0
MinMeleeDmg	float	YES		0
MaxMeleeDmg	float	YES		0
MinRangedDmg	float	NO		0
MaxRangedDmg	float	NO		0
Armor	mediumint(8) unsigned	NO		0
MeleeAttackPower	int(10) unsigned	NO		0
RangedAttackPower	smallint(5) unsigned	NO		0
MeleeBaseAttackTime	int(10) unsigned	YES		0
RangedBaseAttackTime	int(10) unsigned	YES		0
DamageSchool	tinyint(4)	NO		0
MinLootGold	mediumint(8) unsigned	NO		0
MaxLootGold	mediumint(8) unsigned	NO		0
LootId	mediumint(8) unsigned	NO		0
PickpocketLootId	mediumint(8) unsigned	NO		0
SkinningLootId	mediumint(8) unsigned	NO		0
KillCredit1	int(11) unsigned	NO		0
KillCredit2	int(11) unsigned	NO		0
QuestItem1	int(11) unsigned	NO		0
QuestItem2	int(11) unsigned	NO		0
QuestItem3	int(11) unsigned	NO		0
QuestItem4	int(11) unsigned	NO		0
QuestItem5	int(11) unsigned	NO		0
QuestItem6	int(11) unsigned	NO		0
MechanicImmuneMask	int(10) unsigned	NO		0
ResistanceHoly	int(10) unsigned	NO		0
ResistanceFire	smallint(5)	NO		0
ResistanceNature	smallint(5)	NO		0
ResistanceFrost	smallint(5)	NO		0
ResistanceShadow	smallint(5)	NO		0
ResistanceArcane	smallint(5)	NO		0
PetSpellDataId	mediumint(8) unsigned	NO		0
MovementType	tinyint(3) unsigned	NO		0
MovementTemplateId	int(11) unsigned	NO		0
TrainerType	tinyint(4)	YES		0
TrainerSpell	mediumint(8) unsigned	YES		0
TrainerClass	tinyint(3) unsigned	YES		0
TrainerRace	tinyint(3) unsigned	YES		0
TrainerTemplateId	mediumint(8) unsigned	NO		0
VendorTemplateId	mediumint(8) unsigned	NO		0
EquipmentTemplateId	mediumint(8) unsigned	NO		0
VehicleTemplateId	mediumint(8) unsigned	NO		0
GossipMenuId	mediumint(8) unsigned	YES		0
AIName	char(64)	NO
ScriptName	char(64)	NO

Description of the fields

Entry

This is the Primary NPC Entry Number and is Also the Dungeon Normal Mode / Raid 10-Man Normal Mode Entry.

DUNGEON_DIFFICULTY_NORMAL

RAID_DIFFICULTY_10MAN_NORMAL

Name

Base Name of the Creature.

SubName

The SubName of the Creature That Appears in <> Below the Creature’s Name.

IconName

Script Icon Used by Guards With Directions Menu.

MinLevel

The Minimum Level of the Creature if the Creature Has a Level Range. For Creature That Are Single Level MinLevel=MaxLevel.

MaxLevel

The Maximum Level of the Creature if the Creature Has a Level Range. For Creature That Are Single Level MinLevel=MaxLevel.

DifficultyEntry1

If This Value is NOT Zero Then This Field Refers to a Creature_Template Entry. This Field is to be Used for Specific Versions of an NPC in Certain Difficulty Settings, See Below:

DUNGEON_DIFFICULTY_HEROIC

RAID_DIFFICULTY_25MAN_NORMAL

DifficultyEntry2

If This Value is NOT Zero Then This Field Refers to a Creature_Template Entry. This Field is to be Used for Specific Versions of an NPC in Certain Difficulty Settings, See Below:

RAID_DIFFICULTY_10MAN_HEROIC

DifficultyEntry3

If This Value is NOT Zero Then This Field Refers to a Creature_Template Entry. This Field is to be Used for Specific Versions of an NPC in Certain Difficulty Settings, See Below:

RAID_DIFFICULTY_25MAN_HEROIC

ModelId1

Primary Graphical Model That The Client Applies On This Creature. This is a Creature_Model_Info.Entry

ModelId2

Optional Extra Graphical Model That The Client Applies On This Creature. This is a Creature_Model_Info.Entry

ModelId3

Optional Extra Graphical Model That The Client Applies On This Creature. This is a Creature_Model_Info.Entry

ModelId4

Optional Extra Graphical Model That The Client Applies On This Creature. This is a Creature_Model_Info.Entry

FactionAlliance

The Faction If The Creature Is On The Alliance Side. See FactionTemplate.dbc.. Just Because More Than One Faction Has The Same Name, The Inter-Faction Relationships Can Be Different.

Note: This Field Also Controls The Creature Family Assistance Mechanic. Only Creatures With The Same Faction Will Assist Each Other.

FactionHorde

The Faction If The Creature Is On The Horde Side. See FactionTemplate.dbc.. Just Because More Than One Faction Has The Same Name, The Inter-Faction Relationships Can Be Different.

Note: This Field Also Controls The Creature Family Assistance Mechanic. Only Creatures With The Same Faction Will Assist Each Other.

Scale

If This Is A Non-Zero Value, This Field Defines a Manual Over-Ride For The Size Of The Model That The Creature Appears In The Game. If Zero, The Creature Will Use The Default Model Size Taken From The DBC.

Family

This Defines The Family That This Creature Belongs To. This Is Only Used If CreatureType Is 1 (Beast).

ID	Family	ID	Family	ID	Family
1	Wolf	15	Doomguard	29	Nether Ray
2	Cat	16	Scorpid	30	Serpent
3	Spider	17	Turtle	31	Moth
4	Bear	18	Imp	32	Chimaera
5	Boar	19	Bat	33	Devilsaur
6	Crocolisk	20	Hyena	34	Ghoul
7	Carrion Bird	21	Bird of Prey	35	Silithid
8	Crab	22	Wind Serpent	36	Worm
9	Gorilla	23	Remote Control	37	Rhino
10	Raptor	24	Felguard	38	Wasp
11	Tallstrider	25	Dragonhawk	39	Core Hound
12	Felhunter	26	Ravager	40	Spirit Beast
13	Voidwalker	27	Warp Stalker
14	Succubus	28	Sporebat

CreatureType

This Field Defines The Type Of Creature This NPC Is.

ID	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

InhabitType

This Field Controls Where The Creature Can Move Into, Chase And Attack. The NPC Is Limited To ONLY This:

ID	Type
1	Ground Movement Only
2	Water Movement Only
3	Both Ground And Water Movement
4	Always Flying

RegenerateHealth

This Field Controls If The Creature Should Regenerate It’s Health When Out of Combat (Boolean Value 1 or 0)

Value	Description
0	NPC Does NOT Regenerate Health When Out Of Comabt
1	NPC DOES Regenerate Health When Out Of Comabt

RacialLeader

This Field Is a Boolean Flag Indicating That The Creature Is a Racial Leader. Killing Racial Leaders Grants 100 Honor Points.

Value	Description
0	NPC Is NOT a Racial Leader
1	NPC IS a Racial Leader

NpcFlags

This Field Is a Bitmask That Represents What NPC Flags The Creature Has Assigned To It. Each Bit Controls a Different Flag and to Combine Flags, You Can Add Each Flag That You Require, In Effect Activating The Respective Bits.

Bit	Value	Flag	Comment
0	1	Gossip	If creature has more gossip options, add this flag to bring up a menu.
1	2	Quest Giver	Any creature giving or taking quests needs to have this flag.
4	16	Trainer	Allows the creature to have a trainer list to teach spells
5	32	Trainer_Class	Allows the creature to have a class trainer list to teach spells. (MUST USE WITH FLAG: 16)
6	64	Trainer_Profession	Allows the creature to have a profession trainer list to teach spells. (MUST USE WITH FLAG: 16)
7	128	Vendor	Any creature selling items needs to have this flag.
8	256	Vendor_Ammo	Any creature selling ammo items needs to have this flag. (MUST USE WITH FLAG: 128)
9	512	Vendor_Food	Any creature selling food items needs to have this flag. (MUST USE WITH FLAG: 128)
10	1024	Vendor_Poison	Any creature selling poison items needs to have this flag. (MUST USE WITH FLAG: 128)
11	2048	Vendor_Reagent	Any creature selling reagent items needs to have this flag. (MUST USE WITH FLAG: 128)
12	4096	Repairer	Creatures with this flag can repair items.
13	8192	Flight Master	Any creature serving as fly master has this.
14	16384	Spirit Healer	Makes the creature invisible to alive characters and has the resurrect function.
15	32768	Spirit Guide
16	65536	Innkeeper	Creatures with this flag can set hearthstone locations.
17	131072	Banker	Creatures with this flag can show the bank
18	262144	Petitioner
19	524288	Tabard Designer	Allows the designing of guild tabards.
20	1048576	Battlemaster	Creatures with this flag port players to battlegrounds.
21	2097152	Auctioneer	Allows creature to display auction list.
22	4194304	Stable Master	Has the option to stable pets for hunters.
23	16777216	Instantloot	NPC could be loot immediately without killing, just after clicking on it. (Npc_spellclick_spells)
24	33554432	Player Vehicle	players with mounts that have vehicle data should have it set
25	268435456	Guard ????	Creatures with this flag act as guards in cities.

EXAMPLE:
So If You Want An NPC That Is a Quest Giver, a Vendor And Can Also Repair You Just Add The Specific Flags Together:

1 + 2 + 128 + 4096 = 4227.
NpcFlags = 4227

UnitFlags

This Field Allows The Manual Application Of Unit Flags To NPC. This Is a Bitmask Field And To Apply More Then One Flag, Just Add The Different Flags Together.

Some Known Possible Flags Are:

Bit	Flag	Name	Comments
0	1	UNIT_FLAG_UNK_0
1	2	UNIT_FLAG_NON_ATTACKABLE
2	4	UNIT_FLAG_DISABLE_MOVE
3	8	UNIT_FLAG_PVP_ATTACKABLE	(allow apply pvp rules to attackable state in addition to faction dependent state)
4	16	UNIT_FLAG_RENAME
5	32	UNIT_FLAG_RESTING
6	64	UNIT_FLAG_UNK_6
7	128	UNIT_FLAG_NOT_ATTACKABLE_1	(??) ((UNIT_FLAG_PVP_ATTACKABLE + UNIT_FLAG_NOT_ATTACKABLE_1) is NON_PVP_ATTACKABLE)
8	256	UNIT_FLAG_OOC_NOT_ATTACKABLE	(2.0.8 – Can not be attacked when not in combat. Removed if unit for some reason enter combat.) (2.4.3, Seems to make the unit unattackable)
9	512	UNIT_FLAG_PASSIVE	(makes unable to attack everything. Almost identical to "civilian". Will not engage in combat unless "called upon" or engaged by another unit.)
10	1024	UNIT_FLAG_LOOTING	(loot animation)
11	2048	UNIT_FLAG_PET_IN_COMBAT	(in combat?, 2.0.8)
12	4096	UNIT_FLAG_PVP	Allows item spells to be casted upon (?)
13	8192	UNIT_FLAG_SILENCED	Can’t cast spells
14	16384	UNIT_FLAG_UNK_14	(2.0.8)
15	32768	UNIT_FLAG_UNK_15
16	65536	UNIT_FLAG_UNK_16
17	131072	UNIT_FLAG_PACIFIED
18	262144	UNIT_FLAG_DISABLE_ROTATE	(stunned, 2.1.1)
19	524288	UNIT_FLAG_IN_COMBAT
20	1048576	UNIT_FLAG_TAXI_FLIGHT	(disable casting at client side spell not allowed by taxi flight (mounted?), probably used with 0×4 flag)
21	2097152	UNIT_FLAG_DISARMED	(disable melee spells casting…, "Required melee weapon" added to melee spells tooltip.)
22	4194304	UNIT_FLAG_CONFUSED
23	8388608	UNIT_FLAG_FLEEING
24	16777216	UNIT_FLAG_PLAYER_CONTROLLED	(used in spell Eyes of the Beast for pet…)
25	33554432	UNIT_FLAG_NOT_SELECTABLE	Can’t be selected by mouse
26	67108864	UNIT_FLAG_SKINNABLE
27	134217728	UNIT_FLAG_MOUNT	(the client seems to handle it perfectly)
28	268435456	UNIT_FLAG_UNK_28
29	536870912	UNIT_FLAG_UNK_29	(used in Feing Death spell)
30	1073741824	UNIT_FLAG_SHEATHE
31	2147483648	UNIT_FLAG_UNK_31	(set skinnable icon and also changes color of portrait)

DynamicFlags

This Field Flags Controls The Visual Appearance Of The Creature. These Flag Values Can Be Added Together For Any Desired Combination.

Some Known Flag Values Are:

Flag	Name	Comments
0	UNIT_DYNFLAG_NONE
1	UNIT_DYNFLAG_LOOTABLE
2	UNIT_DYNFLAG_TRACK_UNIT
4	UNIT_DYNFLAG_OTHER_TAGGER	Makes creatures name appear grey (good for simulating dead creatures)
8	UNIT_DYNFLAG_ROOTED
16	UNIT_DYNFLAG_SPECIALINFO	Shows creatures basic stats (Health, damage, resistances, tamable).
32	UNIT_DYNFLAG_DEAD	Makes the creature appear dead (this DOES NOT make the creatures name grey)
64	UNIT_DYNFLAG_TAPPED_BY_ALL_THREAT_LIST

ExtraFlags

This Field Controls the Application Of Flags That Controls Certain NPC Specific Attributes.

Bit	Name	Description
1	CREATURE_FLAG_EXTRA_INSTANCE_BIND	Bounds killer’s party to the instance they are in
2	CREATURE_FLAG_EXTRA_CIVILIAN	Makes creature ignore aggro
4	CREATURE_FLAG_EXTRA_NO_PARRY	Prohibits creature from parrying
8	CREATURE_FLAG_EXTRA_NO_PARRY_HASTEN	Creatures parries do not speed up its next attack
16	CREATURE_FLAG_EXTRA_NO_BLOCK	Prohibits creature from blocking
32	CREATURE_FLAG_EXTRA_NO_CRUSH	Prohibits creature from dealing crushing blows
64	CREATURE_FLAG_EXTRA_NO_XP_AT_KILL	Makes creature reward no XP at kill
128	CREATURE_FLAG_EXTRA_INVISIBLE	Makes creature invisible for player. Use this for triggers etc.
256	CREATURE_FLAG_EXTRA_NOT_TAUNTABLE	creature is immune to taunt auras and effect attack me
512	CREATURE_FLAG_EXTRA_AGGRO_ZONE	creature sets itself in combat with zone on aggro
1024	CREATURE_FLAG_EXTRA_GUARD	creature is a guard, for Zone under attack announce if guard death
2048	CREATURE_FLAG_EXTRA_NO_TALKTO_CREDIT	creature doesn’t give quest-credits when talked to (temporarily flag).

CreatureTypeFlags

This Field Controls If a Mob Is Minable or Herbable. If Any Of These Flags Are Used Then The Loot Given When It Is Herb Picked / Mined Will Be Stored In The Skinning_Loot_Template Table. Aside From These Two Flags, This Field Has No Special Meaning Server-Side.

It will be send to the client in SMSG_CREATURE_QUERY_RESPONSE

Some values provided from the community:

Flag	Name	Comments
1		Makes the mob tameable (must also be a beast and have family set)
2	UNIT_FLAG_NOT_ATTACKABLE
8	UNIT_FLAG_ATTACKABLE
128	UNIT_FLAG_NOT_ATTACKABLE_1
136	UNIT_FLAG_NON_PVP_PLAYER
256		Makes mob herbable
512		Makes mob minable
1024	UNIT_FLAG_ANIMATION_FROZEN
4096	UNIT_FLAG_WAR_PLAYER

SpeedWalk

This Field Controls How Fast An NPC Moves When Walking. This Value Comes From Sniff Data.
Used when moving between waypoints. 5 is speed of running kentaur.

(Default Value Is: 1)

SpeedRun

This Field Controls How Fast An NPC Moves When Running. This Value Comes From Sniff Data.

(Default Value Is: 1.14286)

UnitClass

The NPC Unit Class. This Field is a Critical Value That Dictates An NPC’s Base Stats System.
An NPC’s Unit Class Is A Corner Stone Value Used In Creature_Template_Classlevelstats To Determine An NPC’s Stats.

NPC Stats Refers To: (Health/Mana/Damage/Armor).

In WOTLK and CATA There Are 4 Possible NPC Classes Available For Creatures (Class: 1,2,4,8)
In Classic and TBC There Are 3 Possible NPC Classes Available For Creatures (Class: 1,2,8)

ID	Name
CLASS_WARRIOR	1
CLASS_PALADIN	2
CLASS_ROGUE	4
CLASS_MAGE	8

This Value is Contained in Sniff Data: UNIT_FIELD_BYTES_0 located in SMSG_UPDATE_OBJECT
It is a Critical Field in Determining Class Level Stats For the NPC. Typically ONLY Vehicles Are Class=4

Warriors Do Not Have Mana and Maximum Health and Damage
Paladins Have a Small Amount Of Mana and Slightly Less Health and Damage From a Warrior
Rogues (Little is Known Currently But They All Seem To Be Vehicles)
Mages Have Lots of Mana But Have Very Low Health and Damage

Rank

This Field Determines The Rank of the NPC:

Rank	Name	Comments
0	Normal
1	Elite	Higher damage, more health, better loot.
2	Rare Elite	A rare mob but with elite damage and health.
3	World Boss	Highest rank, best loot, longest respawn time.
4	Rare	Somewhat better loot, longer respawn time.

Expansion

This Field Determines The Expansion Value of the NPC:

This Value Is a Critical Value in Determining an NPC’s Stats From Creature_Template_ClassLevelStats And Directly Affects An NPC’s Health and Damage.

Value	Expansion
0	Classic
1	Burning Crusades
2	Wrath of the Lich King
3	Cataclysm

NOTE: Now Everyone Has Trouble Understanding This Concept. An NPC’s Expansion Value Has NOTHING To Do With What Expansion An NPC Is From. This Value Determines How Difficult An NPC Is In Regards To An NPC At The Same Level From A Different Expansion. As An Example a Classic Level 60 NPC Will Have Less Base Health and Less Base Damage Then An NPC That Is Level 60 From A TBC NPC.

Each Expansion Value Has a Different Base Health and Base Damage (Each Expansion Having Higher Values Then The Previous). ONLY Health And Damage Scale With Expansion Values. Mana / Armor / Attack Power Are Static Values For All Expansions For A Particular Level and Unit Class.

An NPC’s Health and Damage Is Calculated From Creature_Template_ClassLevelStats Based On HealthMultiplier And DamageMultiplier Multiplied By BaseHealthExp? and BaseDamageExp? From Creature_Template_ClassLevelStats Where ? = Expansion Value.

HealthMultiplier

This Value Comes From WDB and Sniff Data. This Is The PRIMARY DB Value That Calculates An NPC’s Specific Health Value. NPC Have Various HealthMultipliers But Typically They Are Fairly Rounded Values (Bosses Have Large Very Rounded Values Normally)

This Is The Multiplier Used Against The BaseHealthExp? Value From Creature_Template_ClassLevelStats To Calculate An NPC’s Final Health Values Where ? = Expansion Value.

Formula:
MinLevelHealth = ROUND (BaseHealthExp? * HealthMultiplier)
MaxLevelHealth = ROUND (BaseHealthExp? * HealthMultiplier)

Example:

Field	Value	Comments
Entry	871	Saltscale Warrior
MinLevel	35	(Sniff Data)
MaxLevel	36	(Sniff Data)
MinLevelHealth	1403	(Sniff Data)
MaxLevelHealth	1469	(Sniff Data)
UnitClass	1	(Sniff Data)
Expansion	0	Determined From Calculations / Sniff Data / MoP DBC
HealthMultiplier	1.15	(Sniff Data)

Level 35 BaseHealthExp0: 1220
(From Creature_Template_ClassLevelStats – BaseHealth Values Calculated From Sniff Data And Extensive Research)

Level 36 BaseHealthExp0: 1277
(From Creature_Template_ClassLevelStats – BaseHealth Values Calculated From Sniff Data And Extensive Research)

MinLevelHealth = ROUND (1220*1.15) = 1403 (1403)
MaxLevelHealth = ROUND (1277*1.15) = 1468.55 (1469)

ManaMultiplier

This Value Comes From WDB and Sniff Data. This Is The PRIMARY DB Value That Calculates An NPC’s Specific Mana Value. All NPC Have Nice Rounded Values For Mana Multipliers.

This Is The Multiplier Used Against The BaseMana Value From Creature_Template_ClassLevelStats To Calculate An NPC’s Final Mana Values. Note, BaseMana Values Do NOT Scale With Expansion Values Unlike Health And Damage.

Formula:
MinLevelMana = ROUND (BaseMana * ManaMultiplier)
MaxLevelMana = ROUND (BaseMana * ManaMultiplier)

Example:

Field	Value	Comments
Entry	7335	Death’s Head Geomancer
MinLevel	35	(Sniff Data)
MaxLevel	35	(Sniff Data)
MinLevelMana	5360	(Sniff Data)
MaxLevelMana	5360	(Sniff Data)
UnitClass	8	(Sniff Data)
Expansion	0	Determined From Calculations / Sniff Data / MoP DBC
ManaMultiplier	2	(Sniff Data)

Level 35 BaseMana: 2680
(From Creature_Template_ClassLevelStats – BaseMana Values Calculated From Sniff Data And Extensive Research)

MinLevelMana = ROUND (2680*2) = 5360 (5360)
MaxLevelMana = ROUND (2680*2) = 5360 (5360)

=== BELOW IS OLD DATA =====

gossip_menu_id

Reference to a gossip_menu_id.

minhealth

The minimum health of the creature if the creature has variable health.

maxhealth

The maximum health of the creature if the creature has a variable health. When added to world, the health value is chosen in proportion to the level chosen.

minmana

The miminum mana of the creature if the creature has variable mana.

maxmana

The maximum mana of the creature if the creature has variable mana. When added to world, the mana value is chosen in proportion to the level chosen.

armor

The armor value of the creature. It controls how much damage reduction the creature gets from physical attacks.

mindmg

Minimum damage the creature deals in melee. This field is combined with the attackpower field to calculate the damage. Look at attackpower to see the formula.

maxdmg

Maximum damage the creature deals in melee. This field is combined with the attackpower field to calculate the damage. Look at attackpower to see the formula.

dmgschool

Creature’s melee damage school.

ID	Name
0	SPELL_SCHOOL_NORMAL
1	SPELL_SCHOOL_HOLY
2	SPELL_SCHOOL_FIRE
3	SPELL_SCHOOL_NATURE
4	SPELL_SCHOOL_FROST
5	SPELL_SCHOOL_SHADOW
6	SPELL_SCHOOL_ARCANE

attackpower

The attack power for the creature’s melee attacks. This field along with mindmg and maxdmg dictate how much the creature will hit for. The formula in applying correct damages is as follows:

UPDATE `creature_template` SET 
    `mindmg` = <#1>, 
    `maxdmg` = <#2>, 
    `attackpower` = ROUND((`mindmg` + `maxdmg`) / 4 * 7), 
    `mindmg` = ROUND(`mindmg` - `attackpower` / 7), 
    `maxdmg` = ROUND(`maxdmg` - `attackpower` / 7) 
  WHERE `entry` = ...

In the query above, substitute ‘<#1>’ with the minimum damage you want the creature to deal and ‘<#2>’ with the maximum damage you want the creature to deal.

NOTE: You might also want to double check the values calculated after the query is run because if the difference between mindmg and maxdmg is too high, mindmg will end up being a negative value.

baseattacktime

Creature’s melee attack time in milliseconds.

rangeattacktime

trainer_type

If the NPC is a trainer (has the trainer flag), then this field controls what kind of trainer it is. Both this field and the related field must be filled in for a trainer to work correctly.

ID	Type	Related Field	Comments
0	TRAINER_TYPE_CLASS	trainer_class	Trains class spells
1	TRAINER_TYPE_MOUNTS	trainer_race	Trains riding skill
2	TRAINER_TYPE_TRADESKILLS	trainer_spell	Trains professions
3	TRAINER_TYPE_PETS	trainer_class	Trains pet skills

trainer_spell

If the NPC is a trainer that teaches professions (trainer_type == 2), then the player must already know the spell ID specified here to be able to talk to this NPC.

trainer_class

If the NPC is a class trainer or a pet trainer (trainer_type == 0 or 3), then the player’s class must be the same as the value specified here to talk to this trainer. For pet trainers, this value must be 3 (hunter). See character.class

trainer_race

If the NPC is a mount trainer (trainer_type == 1), then the player’s race must be the same as the value specified here to talk to this trainer. See character.race

minrangedmg

Minimum ranged damage the creature inflicts.

NOTE: This is Damage Inflicted From RANGED WEAPON ATTACK ONLY (Cross-Bow Arrows, Knives, Thrown Axes, ect)

maxrangedmg

Maximum range damage the creature inflicts.

NOTE: This is Damage Inflicted From RANGED WEAPON ATTACK ONLY (Cross-Bow Arrows, Knives, Thrown Axes, ect)

rangedattackpower

lootid

The ID of the loot template ID that this creature should use to generate loots. See creature_loot_template.entry

pickpocketloot

The ID of the pickpocketing loot template that this creature should use to generate pickpocketing loots. See pickpocketing_loot_template.entry

skinloot

The ID of the skinning loot template that this creature should use to generate skinning loots. See skinning_loot_template.entry

resistance1

Holy resistance.

resistance2

Fire resistance.

resistance3

Nature resistance.

resistance4

Frost resistance.

resistance5

Shadow resistance.

resistance6

Arcane resistance.

PetSpellDataId

ID that displays what spells the pet has in the client.

mingold

Minimum money that the creature drops when killed, in copper.

maxgold

Maximum money that the creature drops when killed, in copper.

AIName

Overrides AI used for the creature.

Name	Description
NullAI	Empty AI, creature does nothing.
AggressorAI	Creature attacks as soon as something is in aggro range.
ReactorAI	Creature attacks only if aggroed by attack, spell etc.
GuardAI
PetAI	Creature is a pet.
TotemAI	Creature casts spell from field spell1, otherwise like NullAI.
EventAI	Creature uses event based AI.

MovementType

The creature’s default movement type.

ID	Type
0	Idle; stay in one place
1	Random movement inside the spawndist radius
2	Waypoint movement

questItem

The entry of the item that creature drops and is required within an active quest.

equipment_id

The default ID of the equipment that this creature should display. See creature_equip_template.entry

trainer_id

The id refers to the npc_trainer_template..

vendor_id

The id refers to the npc_vendor_template..

mechanic_immune_mask

This makes the creature immune to specific spell natures. See Spell.dbc at row effect_X_mechanic_id.

Uses references from SpellMechanic.dbc.

Bit	Type	Bit	Type
1	MECHANIC_CHARM	32768	MECHANIC_BANDAGE
2	MECHANIC_CONFUSED	65536	MECHANIC_POLYMORPH
4	MECHANIC_DISARM	131072	MECHANIC_BANISH
8	MECHANIC_DISTRACT	262144	MECHANIC_SHIELD
16	MECHANIC_FEAR	524288	MECHANIC_SHACKLE
32	MECHANIC_FUMBLE	1048576	MECHANIC_MOUNT
64	MECHANIC_ROOT	2097152	MECHANIC_PERSUADE
128	MECHANIC_PACIFY	4194304	MECHANIC_TURN
256	MECHANIC_SILENCE	8388608	MECHANIC_HORROR
512	MECHANIC_SLEEP	16777216	MECHANIC_INVULNERABILITY
1024	MECHANIC_SNARE	33554432	MECHANIC_INTERRUPT
2048	MECHANIC_STUN	67108864	MECHANIC_DAZE
4096	MECHANIC_FREEZE	134217728	MECHANIC_DISCOVERY
8192	MECHANIC_KNOCKOUT	268435456	MECHANIC_IMMUNE_SHIELD
16384	MECHANIC_BLEED	536870912	MECHANIC_SAPPED

To combine immunities just add values. Immune to everything corresponds to the value 1073741823.

ScriptName

The name of the script that this creature uses, if any. This ties a script from a scripting engine to this creature.