Gunner

vehichleCursor

Driver

Attack

Buy

Speak

Pickup

Interact

Note 2:

Note 3:

mindmg

Minimum damage the creature deals in melee. This field isno longercombined with theattackpowerfield to calculate the damage.

maxdmg

Maximum damage the creature deals in melee. This field isno longercombined with theattackpowerfield to calculate the damage.

dmgschool

Creature's melee damage school.

attackpower

The attack power for the creature's melee attacks. This field along withmindmgandmaxdmgdictate 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.

dmg_multiplier

Multiplier for mindmg and maxdmg

Example: mindmg=200 maxdmg = 500 dmg_multiplier = 10

Outcome: mob will hit for 2000-5000

baseattacktime

This is the base time that determines how long a creature must wait between melee attacks. This time is in milliseconds.

rangeattacktime

This is the base time that determines how long a creature must wait between ranged attacks. This time is in milliseconds.

unit_class

This is the creature's class, and it dictates levels of health and mana. Also note that health and mana will change according toexp,health_mod, andmana_mod. Not setting this value will report a minor warning in the DB_Errors.log.

unit_flags

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:

unit_flags2

Allows additional 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

Flags that control visual appearance of the creature.

A few known flags and their use are:

family

The family this creature belongs to.

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.

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). Seecharacters/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. Seecharacters/race

minrangedmg

Minimum ranged damage the creature inflicts.

maxrangedmg

Maximum range damage the creature inflicts.

rangedattackpower

This field also refers to the damage multiplier.

Example: If the creature is using a ranged weapon and its rangedattackpower = 500 and thedmg_multiplieris 10 the max that it can hit for with ranged attacks would be 5000

type

The type of the creature.

type_flags

This field can control whether a mob is minable or herbable or lootable by enineer. If it is either of those three, then the loot given when it is skinned/mined will be stored in theskinning_loot_templatetable. It also controls, whether this mob can be tamed by a hunter. Other fields have no special meaning on the serverside. The entire field will be send to the client in SMSG_CREATURE_QUERY_RESPONSE

lootid

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

pickpocketloot

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

skinloot

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

resistance1

Holy resistance.

resistance2

Fire resistance.

resistance3

Nature resistance.

resistance4

Frost resistance.

resistance5

Shadow resistance.

resistance6

Arcane resistance.

spell1

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 1st spell on action bar

spell2

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 2nd spell on action bar

spell3

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 3rd spell on action bar

spell4

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 4th spell on action bar

spell5

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 5th spell on action bar

spell6

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 6th spell on action bar

spell7

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 7th spell on action bar

spell8

Spell ID that can be used for Mind Control of this creature.
For vehicle creatures: 8th spell on action bar

PetSpellDataId

ID, found in CreatureSpellData.dbc, that displays what spells the pet has in the client.

VehicleId

Entryid of Vehicle if creature is/has a vehicle entry. This field determines how the player appears on the vehicle, how the vehicle moves, and whether or not the vehicle action bar is shown. For example, a VehicleID of 292 will make the player invisible, prevent the vehicle from strafing left/right (but will allow fowards/backwards), and will show the vehicle action bar spells (which are defined inspell1-8). An npc_spellclick_spells entry must be made for this creature entry in order for this to work.

mingold

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

maxgold

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

AIName

This field is overridden by ScriptName field if both are set.

MovementType

The creature's default movement type.

InhabitType

Controls where the creature can move and attack.

(This is a bitmask'ed value. You can add values together: 1+4=5 would make the creature walk on ground and fly.)

Note:If your vehicle is a flying vehicle then your accessoryMUSThave itsInhabitTypeset to (4 - Flying). This being if you set it for both ground and flying it will spawn on the ground if the vehicle is initially spawned on the ground.

HoverHeight

Distance above the ground that the creature will hover if it has MOVEMENTFLAG_DISABLE_GRAVITY enabled. Value taken from sniffs.

Health_mod

Used to modify the base Level/Class health of a creature. This field comes from WDB.

Mana_mod

Used to modify the base Level/Class mana of a creature. This field comes from WDB.

Armor_mod

Used to modify the base Level/Class armor of a creature.

RacialLeader

A flag indicating wheather the creature is a racial leader. Killing racial leaders grants 100 honor.

QuestItem1-6

Tells the client (mouse-hovering this creature -> tooltip) that this creature will drop the item specified in this field.

movementID

We have no idea what this field does. It is passed directly to the client.

RegenHealth

Boolean 1 or 0 controlling if the creature should regenerate its health or not.

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/

To combine immunities just add values. Immune to everything corresponds to the value 2147483647 (0x3FFF FFFF).

flags_extra

These flags control certain creature specific attributes. Flags can be added together to apply more than one.

Example: