Versions Compared

Version Old Version 7 New Version Current
Changes made by

Mikrole

Mikrole

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Add "67108864" to unit_flags2 but cant find the optino to add a new cell to this 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.

...

FieldTypeNullKeyDefaultExtraComment

74684811entry

mediumint(8) unsigned

NO

PRI

0



difficulty_entry_1

mediumint(8) unsigned

NO


0



difficulty_entry_2

mediumint(8) unsigned

NO


0



difficulty_entry_3

mediumint(8) unsigned

NO


0



74684811KillCredit1

int(10) unsigned

NO


0



74684811KillCredit2

int(10) 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



74684811name

char(100)

NO

MUL

0



74684811subname

char(100)

YES


(NULL)



74684811IconName

char(100)

YES


(NULL)



74684811gossip_menu_id

mediumint(8) unsigned

NO


0



74684811minlevel

tinyint(3) unsigned

NO


1



74684811maxlevel

tinyint(3) unsigned

NO


1



74684811exp

smallint(6)

NO


0



74684811faction

smallint(5) unsigned

NO


0



74684811npcflag

int(10) unsigned

NO


0



74684811speed_walk

float

NO


1


Result of 2.5/2.5, most common value

74684811speed_run

float

NO


1.14286


Result of 8.0/7.0, most common value

74684811scale

float

NO


1



74684811rank

tinyint(3) unsigned

NO


0



74684811dmgschool

tinyint(4)

NO


0



74684811BaseAttackTime

int(10) unsigned

NO


0



74684811RangeAttackTime

int(10) unsigned

NO


0



74684811BaseVariance

float

NO


1



74684811RangeVariance

float

NO


1



74684811unit_class

tinyint(3) unsigned

NO


0



74684811unit_flags

int(10) unsigned

NO


0



74684811unit_flags2

int(10) unsigned

NO


0



74684811dynamicflags

int(10) unsigned

NO


0



74684811family

tinyint(4)

NO


0



74684811trainer_type

tinyint(4)

NO


0



74684811trainer_spell

mediumint(8) unsigned

NO


0



74684811trainer_class

tinyint(3) unsigned

NO


0



74684811trainer_race

tinyint(3) unsigned

NO


0



74684811type

tinyint(3) unsigned

NO


0



74684811type_flags

int(10) unsigned

NO


0



74684811lootid

mediumint(8) unsigned

NO


0



74684811pickpocketloot

mediumint(8) unsigned

NO


0



skinloot

mediumint(8) unsigned

NO


0



resistance1

smallint(6)

NO


0



resistance2

smallint(6)

NO


0



resistance3

smallint(6)

NO


0



resistance4

smallint(6)

NO


0



resistance5

smallint(6)

NO


0



resistance6

smallint(6)

NO


0



spell1

mediumint(8) unsigned

NO


0



spell2

mediumint(8) unsigned

NO


0



spell3

mediumint(8) unsigned

NO


0



spell4

mediumint(8) unsigned

NO


0



spell5

mediumint(8) unsigned

NO


0



spell6

mediumint(8) unsigned

NO


0



spell7

mediumint(8) unsigned

NO


0



spell8

mediumint(8) unsigned

NO


0



74684811PetSpellDataId

mediumint(8) unsigned

NO


0



74684811VehicleId

mediumint(8) unsigned

NO


0



74684811mingold

mediumint(8) unsigned

NO


0



74684811maxgold

mediumint(8) unsigned

NO


0



74684811AIName

char(64)

NO





74684811MovementType

tinyint(3) unsigned

NO


0



74684811InhabitType

tinyint(3) unsigned

NO


3



74684811HoverHeight

float

NO


1



74684811HealthModifier

float

NO


1



74684811ManaModifier

float

NO


1



74684811ArmorModifier

float

NO


1



74684811DamageModifier

float

NO


1



74684811ExperienceModifier

float

NO


1



74684811RacialLeader

tinyint(3) unsigned

NO


0



74684811movementId

int(11) unsigned

NO


0



74684811RegenHealth

tinyint(3) unsigned

NO


1



74684811mechanic_immune_mask

int(10) unsigned

NO


0



74684811flags_extra

int(10) unsigned

NO


0



74684811ScriptName

char(64)

NO





74684811VerifiedBuild

smallint(5)

YES


0




Description of the fields

...

flags_extra

DecimalHexadecimalNameType
10x00000001CREATURE_FLAG_EXTRA_INSTANCE_BINDcreature kill binds instance to killer and killer's group
20x00000002CREATURE_FLAG_EXTRA_CIVILIANcreature does not aggro (ignore faction/reputation hostility)
40x00000004CREATURE_FLAG_EXTRA_NO_PARRYcreature does not parry
80x00000008CREATURE_FLAG_EXTRA_NO_PARRY_HASTENcreature does not counter-attack at parry
160x00000010CREATURE_FLAG_EXTRA_NO_BLOCKcreature does not block
320x00000020CREATURE_FLAG_EXTRA_NO_CRUSHcreature does not do crush-attacks
640x00000040CREATURE_FLAG_EXTRA_NO_XP_AT_KILLcreature kill does not give XP
1280x00000080CREATURE_FLAG_EXTRA_TRIGGERcreature is trigger-NPC (invisible to players only)
2560x00000100CREATURE_FLAG_EXTRA_NO_TAUNTcreature is immune to taunt-auras and "attack me"-effects
5120x00000200CREATURE_FLAG_EXTRA_NO_MOVE_FLAGS_UPDATEcreature won't update movement flags
10240x00000400CREATURE_FLAG_EXTRA_GHOST_VISIBILITY creature will be only visible for dead players
163840x00004000CREATURE_FLAG_EXTRA_WORLDEVENTcustom flag for world events (left room for merging)
327680x00008000CREATURE_FLAG_EXTRA_GUARDcreature is a guard (Will ignore feign death and vanish)
1310720x00020000CREATURE_FLAG_EXTRA_NO_CRITcreature does not do critical strikes
2621440x00040000CREATURE_FLAG_EXTRA_NO_SKILLGAINcreature won't increase weapon skills
5242880x00080000CREATURE_FLAG_EXTRA_TAUNT_DIMINISHcreature taunt is subject to diminishing returns
10485760x00100000CREATURE_FLAG_EXTRA_ALL_DIMINISHCreature is subject to all diminishing returns
20971520x00200000CREATURE_FLAG_EXTRA_NO_PLAYER_DAMAGE_REQ

NPCs can help with killing this creature and player will still be credited if he tags the creature

2684354560x10000000CREATURE_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.

5368709120x20000000CREATURE_FLAG_EXTRA_IGNORE_PATHFINDINGCreature will ignore pathfinding. This is like disabling Mmaps, only for one creature.
10737418240x40000000CREATURE_FLAG_EXTRA_IMMUNITY_KNOCKBACKcreature will immune all knockback effects

...