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.
...
Field | Type | Null | Key | Default | Extra | Comment |
---|---|---|---|---|---|---|
mediumint(8) unsigned | NO | PRI | 0 | |||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
char(100) | NO | MUL | 0 | |||
char(100) | YES | (NULL) | ||||
char(100) | YES | (NULL) | ||||
mediumint(8) unsigned | NO | 0 | ||||
tinyint(3) unsigned | NO | 1 | ||||
tinyint(3) unsigned | NO | 1 | ||||
smallint(6) | NO | 0 | ||||
smallint(5) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
float | NO | 1 | Result of 2.5/2.5, most common value | |||
float | NO | 1.14286 | Result of 8.0/7.0, most common value | |||
float | NO | 1 | ||||
tinyint(3) unsigned | NO | 0 | ||||
tinyint(4) | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
float | NO | 1 | ||||
float | NO | 1 | ||||
tinyint(3) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
tinyint(4) | NO | 0 | ||||
tinyint(4) | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
tinyint(3) unsigned | NO | 0 | ||||
tinyint(3) unsigned | NO | 0 | ||||
tinyint(3) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
smallint(6) | NO | 0 | ||||
smallint(6) | NO | 0 | ||||
smallint(6) | NO | 0 | ||||
smallint(6) | NO | 0 | ||||
smallint(6) | NO | 0 | ||||
smallint(6) | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
mediumint(8) unsigned | NO | 0 | ||||
char(64) | NO | |||||
tinyint(3) unsigned | NO | 0 | ||||
tinyint(3) unsigned | NO | 3 | ||||
float | NO | 1 | ||||
float | NO | 1 | ||||
float | NO | 1 | ||||
float | NO | 1 | ||||
float | NO | 1 | ||||
float | NO | 1 | ||||
tinyint(3) unsigned | NO | 0 | ||||
int(11) unsigned | NO | 0 | ||||
tinyint(3) unsigned | NO | 1 | ||||
int(10) unsigned | NO | 0 | ||||
int(10) unsigned | NO | 0 | ||||
char(64) | NO | |||||
smallint(5) | YES | 0 |
Description of the fields
...
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:
unit_flags2 | |||
Decimal | Hexadecimal | Name | Comments |
---|---|---|---|
1 | 0x0000 0001 | UNIT_FLAG2_FEIGN_DEATH | |
2 | 0x0000 0002 | UNIT_FLAG2_UNK1 | Hide unit model (show only player equip) |
4 | 0x0000 0004 | UNIT_FLAG2_IGNORE_REPUTATION | |
8 | 0x0000 0008 | UNIT_FLAG2_COMPREHEND_LANG | |
16 | 0x0000 0010 | UNIT_FLAG2_MIRROR_IMAGE | |
32 | 0x0000 0020 | UNIT_FLAG2_INSTANTLY_APPEAR_MODEL | Unit model instantly appears when summoned (does not fade in) |
64 | 0x0000 0040 | UNIT_FLAG2_FORCE_MOVEMENT | |
128 | 0x0000 0080 | UNIT_FLAG2_DISARM_OFFHAND | |
256 | 0x0000 0100 | UNIT_FLAG2_DISABLE_PRED_STATS | Player has disabled predicted stats (Used by raid frames) |
1024 | 0x0000 0400 | UNIT_FLAG2_DISARM_RANGED | this does not disable ranged weapon display (maybe additional flag needed?) |
2048 | 0x0000 0800 | UNIT_FLAG2_REGENERATE_POWER | |
4096 | 0x0000 1000 | UNIT_FLAG2_RESTRICT_PARTY_INTERACTION | Restrict interaction to party or raid |
8192 | 0x0000 2000 | UNIT_FLAG2_PREVENT_SPELL_CLICK | Prevent spellclick |
16384 | 0x0000 4000 | UNIT_FLAG2_ALLOW_ENEMY_INTERACT | |
32768 | 0x0000 8000 | UNIT_FLAG2_DISABLE_TURN | |
65536 | 0x0001 0000 | UNIT_FLAG2_UNK2 | |
131072 | 0x0002 0000 | UNIT_FLAG2_PLAY_DEATH_ANIM | Plays special death animation upon death |
262144 | 0x0004 0000 | UNIT_FLAG2_ALLOW_CHEAT_SPELLS | allows casting spells with AttributesEx7 & SPELL_ATTR7_IS_CHEAT_SPELL |
67108864 → 0X0400 0000 not select able but shows mouse over information's |
Ancladynamicflags dynamicflags
dynamicflags
dynamicflags | |
dynamicflags |
...
flags_extra | |||
Decimal | Hexadecimal | Name | Type |
---|---|---|---|
1 | 0x00000001 | CREATURE_FLAG_EXTRA_INSTANCE_BIND | creature kill binds instance to killer and killer's group |
2 | 0x00000002 | CREATURE_FLAG_EXTRA_CIVILIAN | creature does not aggro (ignore faction/reputation hostility) |
4 | 0x00000004 | CREATURE_FLAG_EXTRA_NO_PARRY | creature does not parry |
8 | 0x00000008 | CREATURE_FLAG_EXTRA_NO_PARRY_HASTEN | creature does not counter-attack at parry |
16 | 0x00000010 | CREATURE_FLAG_EXTRA_NO_BLOCK | creature does not block |
32 | 0x00000020 | CREATURE_FLAG_EXTRA_NO_CRUSH | creature does not do crush-attacks |
64 | 0x00000040 | CREATURE_FLAG_EXTRA_NO_XP_AT_KILL | creature kill does not give XP |
128 | 0x00000080 | CREATURE_FLAG_EXTRA_TRIGGER | creature is trigger-NPC (invisible to players only) |
256 | 0x00000100 | CREATURE_FLAG_EXTRA_NO_TAUNT | creature is immune to taunt-auras and "attack me"-effects |
512 | 0x00000200 | CREATURE_FLAG_EXTRA_NO_MOVE_FLAGS_UPDATE | creature won't update movement flags |
1024 | 0x00000400 | CREATURE_FLAG_EXTRA_GHOST_VISIBILITY | creature will be only visible for dead players |
16384 | 0x00004000 | CREATURE_FLAG_EXTRA_WORLDEVENT | custom flag for world events (left room for merging) |
32768 | 0x00008000 | CREATURE_FLAG_EXTRA_GUARD | creature is a guard (Will ignore feign death and vanish) |
131072 | 0x00020000 | CREATURE_FLAG_EXTRA_NO_CRIT | creature does not do critical strikes |
262144 | 0x00040000 | CREATURE_FLAG_EXTRA_NO_SKILLGAIN | creature won't increase weapon skills |
524288 | 0x00080000 | CREATURE_FLAG_EXTRA_TAUNT_DIMINISH | creature taunt is subject to diminishing returns |
1048576 | 0x00100000 | CREATURE_FLAG_EXTRA_ALL_DIMINISH | Creature is subject to all diminishing returns |
2097152 | 0x00200000 | CREATURE_FLAG_EXTRA_NO_PLAYER_DAMAGE_REQ | NPCs can help with killing this creature and player will still be credited if he tags the creature |
268435456 | 0x10000000 | CREATURE_FLAG_EXTRA_DUNGEON_BOSS | Creature is a dungeon boss. This flag is generically set by core during runtime. Setting this in database will give you startup error. |
536870912 | 0x20000000 | CREATURE_FLAG_EXTRA_IGNORE_PATHFINDING | Creature will ignore pathfinding. This is like disabling Mmaps, only for one creature. |
1073741824 | 0x40000000 | CREATURE_FLAG_EXTRA_IMMUNITY_KNOCKBACK | creature will immune all knockback effects |
...