creature_template

Description of the 'creature_template' table for MaNGOSTwo

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.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

Entry mediumint(8) unsigned

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

Name char(100)

The creature's name that will be displayed.

SubName char(100)

An optional tag, which will be shown below the creature's name.

IconName char(100)

MinLevel tinyint(3) unsigned

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

MaxLevel tinyint(3) unsigned

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

DifficultyEntry1 mediumint(8) unsigned

DifficultyEntry2 mediumint(8) unsigned

DifficultyEntry3 mediumint(8) unsigned

ModelId1 mediumint(8) unsigned

A display model identifier for the creature_template. This references the unique ID in table "creature_model_info" [See creature_model_info] for which this entry is valid.

ModelId2 mediumint(8) unsigned

A display model identifier for the creature_template. This references the unique ID in table "creature_model_info" [See creature_model_info] for which this entry is valid.

ModelId3 mediumint(8) unsigned

A display model identifier for the creature_template.
This references the unique ID in table "creature_model_info" [See creature_model_info] for which this entry is valid.

ModelId4 mediumint(8) unsigned

A display model identifier for the creature_template.
This references the unique ID in table "creature_model_info" [See creature_model_info] for which this entry is valid.

FactionAlliance smallint(5) unsigned

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 smallint(5) unsigned

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 float

The scale/size of the creature.

Normal => 1 (100%)

Family tinyint(4)

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

CreatureType tinyint(3) unsigned

This Field Defines The Type Of Creature This NPC Is.

InhabitType tinyint(3) unsigned

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

RegenerateStats tinyint(3) unsigned

This flag is a bitmask field which controls if a creature template should regenerate it's Health and/or Power. i.e. To Regenerate both Health and Mana, you would set the template to 3 (1+2).

RacialLeader tinyint(3) unsigned

Determines if a creature template is a racial leader. Racial leaders will grant increased honor points upon death.

NpcFlags int(10) unsigned

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.

UnitFlags int(10) unsigned

Allows the manual application of unit flags to creatures. Again this is a bitmask field and to apply more than one flag, just add the different numbers. Some possible flags are:

DynamicFlags int(10) unsigned

Dynamic flags are used to control the visual appearance of a creature template. The following table provides a list of valid values. Multiple flags may be combined.

ExtraFlags int(10) unsigned

The extra flags allow to modify special behaviour for a creature_template. The following table contains a list of combinable flags.

CreatureTypeFlags int(10) unsigned

This Field Controls If a Mob Is Mineable 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

SpeedWalk float

Controls how fast the creature can move in walking mode.

SpeedRun float

Controls how fast the creature can move in running mode.

UnitClass tinyint(3) unsigned

A creature's class. The following table describes the available classes.

Rank tinyint(3) unsigned

The rank of a creature determines which border the game client will draw around the creature tooltip in the user interface.
The following table lists all valid values:

Expansion tinyint(3)

HealthMultiplier float

Setting this value to a value smaller or larger than 1 will modify the creature template's health by this factor.

PowerMultiplier float

Setting this value to a value smaller or larger than 1 will modify the creature template's power by this factor.

DamageMultiplier float

Setting this value to a value smaller or larger than 1 will modify the creature template's damage by this factor.

DamageVariance float

Damage Variance is a Co-Efficient used in Damage Calculations To Limit the Min/Max Damage Range.

Default Value is 1 (Normal) ===> See DamageMultiplier for More Information

ArmorMultiplier float

Setting this value to a value smaller or larger than 1 will modify the creature template's armor by this factor.

ExperienceMultiplier float

Setting this value to a value smaller or larger than 1 will modify experience gained from the creature template by this factor.

MinLevelHealth int(10) unsigned

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

MaxLevelHealth int(10) unsigned

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.

MinLevelMana int(10) unsigned

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

MaxLevelMana int(10) unsigned

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.

MinMeleeDmg float

Minimum damage the creature deals in melee combat. This field is combined with the attackpower field to calculate the damage.

MaxMeleeDmg float

Maximum damage the creature deals in melee combat. This field is combined with the attackpower field to calculate the damage.

MinRangedDmg float

Minimum damage the creature deals in ranged combat. This field is combined with the ranged attackpower field to calculate the damage.

MaxRangedDmg float

Maximum damage the creature deals in ranged combat. This field is combined with the ranged attackpower field to calculate the damage.

Armor int(10) unsigned

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

MeleeAttackPower int(10) unsigned

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

UPDATE `creature_template` SET
    `MinMeleeDmg` = <#1>,
    `MaxMeleeDmg` = <#2>,
    `MeleeAttackPower` = ROUND((`MinMeleeDmg` + `MaxMeleeDmg`) / 4 * 7),
    `MinMeleeDmg` = ROUND(`MinMeleeDmg` - `MeleeAttackPower` / 7),
    `MaxMeleeDmg` = ROUND(`MaxMeleeDmg` - `MeleeAttackPower` / 7)
WHERE `Entry` = ...

RangedAttackPower smallint(5) unsigned

The attack power for the creature's ranged attacks.

MeleeBaseAttackTime int(10) unsigned

A creature's melee attack time in milliseconds.

RangedBaseAttackTime int(10) unsigned

The delay between ranged attacks, in milliseconds.

DamageSchool tinyint(4)

A damage school for melee combat. The following table provides a list of valid values.

MinLootGold mediumint(8) unsigned

Minimum money the creature drops when killed, in copper.

MaxLootGold mediumint(8) unsigned

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

LootId mediumint(8) unsigned

The field adds loot to a creature template and references the "creature_loot_template" table unique ID for which the entry is valid.

PickpocketLootId mediumint(8) unsigned

The field adds pickpocketing loot to a creature template and references the "pickpocketing_loot_template" tables unique ID for which the entry is valid.

SkinningLootId mediumint(8) unsigned

The field adds skinning loot to a creature template and references the "skinning_loot_template" tables unique ID for which the entry is valid.

KillCredit1 int(11) unsigned

If killing a creature should credit towards a different creature_template, this should be set to the creature template's identifier.

KillCredit2 int(11) unsigned

If killing a creature should credit towards a different creature_template, this should be set to the creature template's identifier.

QuestItem1 int(11) unsigned

QuestItem2 int(11) unsigned

QuestItem3 int(11) unsigned

QuestItem4 int(11) unsigned

QuestItem5 int(11) unsigned

QuestItem6 int(11) unsigned

MechanicImmuneMask int(10) unsigned

This mask can be used to make creatures immune to spell mechanics. Multiple immunities can be combined.

ResistanceHoly smallint(5)

The Holy resistance of the creature.

ResistanceFire smallint(5)

The Fire resistance of the creature.

ResistanceNature smallint(5)

The Nature resistance of the creature.

ResistanceFrost smallint(5)

The Frost resistance of the creature.

ResistanceShadow smallint(5)

The Shadow resistance of the creature.

ResistanceArcane smallint(5)

The Arcane resistance of the creature.

PetSpellDataId mediumint(8) unsigned

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

MovementType tinyint(3) unsigned

The movement type defines what a creature spawn will behave like after spawning.

MovementTemplateId int(11) unsigned

TrainerType tinyint(4)

For creature templates set to be trainers, this details what kind of trainer the creature is. The following table provides a list of valid trainer types.

TrainerSpell mediumint(8) unsigned

If set to a valid spell identifier from Spell.dbc [See Spell.dbc], this will restrict access to a profession trainer so that the player needs to already have access to the spell to access the trainer.

TrainerClass tinyint(3) unsigned

The value of this field will restrict access to class and/or pet trainers, if set to a value corresponding with the class identifiers from ChrClasses.dbc.

TrainerRace tinyint(3) unsigned

This field allows to restrict a riding trainer to a specific race. Players not from that race will require exalted reputation with the trainers race before being able to buy from him. Values in this field correspond with the content of ChrRaces.dbc [See ChrRaces.dbc].

TrainerTemplateId mediumint(8) unsigned

This field adds a training spells to a creature template and references the "npc_trainer_template" tables unique ID for which the entry is valid.

VendorTemplateId mediumint(8) unsigned

This field adds a vendor items to a creature template and references the "npc_vendor_template" tables unique ID for which the entry is valid.

EquipmentTemplateId mediumint(8) unsigned

The field adds equipment to a creature template and references the "creature_equip_template" tables unique ID for which the entry is valid.

VehicleTemplateId mediumint(8) unsigned

GossipMenuId mediumint(8) unsigned

This references the "gossip_menu" tables unique ID for which the entry is valid, if the creature_template should have a gossip dialogue.

AIName char(64)

This string determines which built-in AI script will be used for the creature template. By default and empty string will lead to the creature doing nothing. The following table lists all valid entries.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module