creature

Back-to:World

Table Structure

Contains individual creature spawn data for each individual spawn of each individual creature in the game world.

Field

Type

Attributes

Key

Null

Default

Extra

Comment

creature#guid

int(10)

unsigned

PRI

NO

NULL

Auto Increment

Global Unique Identifier

creature#id

mediumint(8)

unsigned


NO

0


Creature Identifier

creature#map

smallint(5)

unsigned


NO

0


Map Identifier

creature#spawnDifficulties

varchar(100)

unsigned


NO

0



creature#phaseUseFlagstinyint(3)unsigned
NO0

creature#PhaseId

int(10)

signed


YES

0



creature#PhaseGroupint(11)signed
YES0

creature#terrainSwapMapint(11)signed
NO-1

creature#modelid

mediumint(8)

unsigned


NO

0


0 core determined random model or model_id to prevent random model selection by core.

creature#equipment_id

tinyint(3)

unsigned


NO

1



creature#position_x

float

signed


NO

0



creature#position_y

float

signed


NO

0



creature#position_z

float

signed


NO

0



creature#orientation

float

signed


NO

0



creature#spawntimesecs

int(10)

unsigned


NO

120



creature#spawndist

float

signed


NO

5


Dist in yards for random movement.

creature#currentwaypoint

mediumint(8)

unsigned


NO

0


Storage used by core. "Always set as 0"

creature#curhealth

int(10)

unsigned


NO

1


Storage used by core. "Always set as 1"

creature#curmana

int(10)

unsigned


NO

0


Storage used by core. "Always set as 0"

creature#MovementType

tinyint(3)

unsigned


NO

0


0 No movement, 1 random, 2 path

creature#npcflag

int(10)

unsigned


NO

0



creature#unit_flags

int(10)

unsigned


NO

0



creature#dynamicflags

int(10)

unsigned


NO

0



Field Descriptions

guid

A unique identifier given to each creature to distinguish one creature from another. Two creatures can NOT have same GUID.

guid ranges:
1.x - 3.3.5 (Vanilla - Wrath of the Lich King)
1 - 249999

4.x (Cataclysm)
250000 - 449.999

6.x (Warlords of Draenor)
450000 - 649999

7.x (Legion)
650000 -849999

8.x (Battle for Azeroth)
850000 - 1049999

9.x (Shadowlands)
1050000 - (specified later)

id

The ID of the template that is used when instantiating this creature.

map

The ID of the map that the creature is spawned on.

spawnDifficulties

List of comma separated list of difficulties

Difficulty:

    DIFFICULTY_NONE                 = 0,
    DIFFICULTY_NORMAL               = 1,
    DIFFICULTY_HEROIC               = 2,
    DIFFICULTY_10_N                 = 3,
    DIFFICULTY_25_N                 = 4,
    DIFFICULTY_10_HC                = 5,
    DIFFICULTY_25_HC                = 6,
    DIFFICULTY_LFR                  = 7,
    DIFFICULTY_MYTHIC_KEYSTONE      = 8,
    DIFFICULTY_40                   = 9,
    DIFFICULTY_3_MAN_SCENARIO_HC    = 11,
    DIFFICULTY_3_MAN_SCENARIO_N     = 12,
    DIFFICULTY_NORMAL_RAID          = 14,
    DIFFICULTY_HEROIC_RAID          = 15,
    DIFFICULTY_MYTHIC_RAID          = 16,
    DIFFICULTY_LFR_NEW              = 17,
    DIFFICULTY_EVENT_RAID           = 18,
    DIFFICULTY_EVENT_DUNGEON        = 19,
    DIFFICULTY_EVENT_SCENARIO       = 20,
    DIFFICULTY_MYTHIC               = 23,
    DIFFICULTY_TIMEWALKING          = 24,
    DIFFICULTY_WORLD_PVP_SCENARIO   = 25,
    DIFFICULTY_5_MAN_SCENARIO_N     = 26,
    DIFFICULTY_20_MAN_SCENARIO_N    = 27,
    DIFFICULTY_PVEVP_SCENARIO       = 29,
    DIFFICULTY_EVENT_SCENARIO_6     = 30,
    DIFFICULTY_WORLD_PVP_SCENARIO_2 = 32,
    DIFFICULTY_TIMEWALKING_RAID     = 33,
    DIFFICULTY_PVP                  = 34,
    DIFFICULTY_NORMAL_ISLAND        = 38,
    DIFFICULTY_HEROIC_ISLAND        = 39,
    DIFFICULTY_MYTHIC_ISLAND        = 40,
    DIFFICULTY_PVP_ISLAND           = 45,
    DIFFICULTY_NORMAL_WARFRONT      = 147,
    DIFFICULTY_HEROIC_WARFRONT      = 149,
    DIFFICULTY_LFR_15TH_ANNIVERSARY = 151,
    DIFFICULTY_VISIONS_OF_NZOTH     = 152,
    DIFFICULTY_TEEMING_ISLAND       = 153

phaseUseFlags

Mask

    PHASE_USE_FLAGS_NONE            = 0x0,
    PHASE_USE_FLAGS_ALWAYS_VISIBLE  = 0x1,
    PHASE_USE_FLAGS_INVERSE         = 0x2,

phaseId

phaseId

phaseGroup

phaseGroup

modelid

The model ID associated with the creature. Note that two creatures that use the same template can have different models. See creature_model_info for more information on model-specific characteristics.

Note:

This can be left at 0 and a random model from its assigned models in creature_template will be assigned by the core.

equipment_id

The ID as defined within creature_equip_template corresponding to the entry. The value essential defines the equip:

position_x

The X position of the creatures spawn point.

position_y

The Y position of the creatures spawn point.

position_z

The Z position of the creatures spawn point.

orientation

The orientation of the creatures spawn point. (North = 0.0; South = pi (3.14159))

spawntimesecs

The respawn time, in seconds, of the creature.

spawndist

The maximum distance that the creature may spawn from its spawn point. Also controls how far away the creature can walk from its spawn point if its creature#MovementType = 1.

currentwaypoint

The current waypoint that the creature is on, if any.

curhealth

The health that the creature will spawn with.

curmana

The mana that the creature will spawn with.

MovementType

Same as creature_template.MovementType

NOTE: A creature.MovementType will override a creature_template.MovementType record.

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

npcflag

Same as creature_template.npcflag .

NOTE: A creature.npcflag record will override a creature_template.npcflag record.

FlagNameComment
10x0000 0001GossipIf creature has more gossip options, add this flag to bring up a menu.
20x0000 0002Quest GiverAny creature giving or taking quests needs to have this flag.
160x0000 0010TrainerAllows the creature to have a trainer list to teach spells
320x0000 0020Class Trainer
640x0000 0040Profession Trainer
1280x0000 0080VendorAny creature selling items needs to have this flag.
2560x0000 0100Vendor Ammo
5120x0000 0200Vendor Food
10240x0000 0400Vendor Poison
20480x0000 0800Vendor Reagent
40960x0000 1000RepairerCreatures with this flag can repair items.
81920x0000 2000Flight MasterAny creature serving as flight master has this.
163840x0000 4000Spirit HealerMakes the creature invisible to alive characters and has the resurrect function.
327680x0000 8000Spirit Guide
655360x0001 0000InnkeeperCreatures with this flag can set hearthstone locations.
1310720x0002 0000BankerCreatures with this flag can show the bank
2621440x0004 0000Petitioner
5242880x0008 0000Tabard DesignerAllows the designing of guild tabards.
10485760x0010 0000BattlemasterCreatures with this flag port players to battlegrounds.
20971520x0020 0000AuctioneerAllows creature to display auction list.
41943040x0040 0000Stable MasterHas the option to stable pets for hunters.
83886080x0080 0000Guild Banker
167772160x0100 0000SpellclickNeeds data on npc_spellclick_spells table
671088640x0400 0000MailboxNPC will act like a mailbox (opens mailbox with right-click)

unit_flags

Same as creature_template.unit_flags.

Note:

A creature.unit_flags record will override a creature_template.unit_flags record.


FlagNameComments
10x0000 0001UNIT_FLAG_SERVER_CONTROLLED
20x0000 0002UNIT_FLAG_NON_ATTACKABLE
40x0000 0004UNIT_FLAG_REMOVE_CLIENT_CONTROL
80x0000 0008UNIT_FLAG_PLAYER_CONTROLLEDcontrolled by player, use _IMMUNE_TO_PC instead of _IMMUNE_TO_NPC
160x0000 0010UNIT_FLAG_RENAME
320x0000 0020UNIT_FLAG_PREPARATIONDon't take reagents for spells with SPELL_ATTR_EX5_NO_REAGENT_WHILE_PREP
640x0000 0040UNIT_FLAG_UNK_6not sure what it does, but it is needed to cast nontriggered spells in smart_scripts
1280x0000 0080UNIT_FLAG_NOT_ATTACKABLE_1UNIT_FLAG_PVP_ATTACKABLE| UNIT_FLAG_NOT_ATTACKABLE_1 is NON_PVP_ATTACKABLE
2560x0000 0100UNIT_FLAG_IMMUNE_TO_PCdisables combat/assistance with PlayerCharacters (PC)
5120x0000 0200UNIT_FLAG_IMMUNE_TO_NPCdisables combat/assistance with NonPlayerCharacters (NPC)
10240x0000 0400UNIT_FLAG_LOOTINGLoot animation
20480x0000 0800UNIT_FLAG_PET_IN_COMBATIn combat? 2.0.8
40960x0000 1000UNIT_FLAG_PVPChanged in 3.0.3
81920x0000 2000UNIT_FLAG_SILENCEDCan't cast spells
163840x0000 4000UNIT_FLAG_CANNOT_SWIM2.0.8
327680x0000 8000UNIT_FLAG_SWIMMINGshows swim animation in water
655360x0001 0000UNIT_FLAG_NON_ATTACKABLE_2removes attackable icon, if on yourself, cannot assist self but can cast TARGET_SELF spells - added by SPELL_AURA_MOD_UNATTACKABLE
1310720x0002 0000UNIT_FLAG_PACIFIEDCreature will not attack
2621440x0004 0000UNIT_FLAG_STUNNED3.0.3 ok
5242880x0008 0000UNIT_FLAG_IN_COMBAT('AffectingCombat' from UnitFlags.cs in WPP)
10485760x0010 0000UNIT_FLAG_TAXI_FLIGHTDisable casting at client side spell not allowed by taxi flight (mounted?), probably used with 0x4 flag
20971520x0020 0000UNIT_FLAG_DISARMED3.0.3, disable melee spells casting..., "Required melee weapon" added to melee spells tooltip.
41943040x0040 0000UNIT_FLAG_CONFUSEDConfused.
83886080x0080 0000UNIT_FLAG_FLEEING('Feared' from UnitFlags.cs in WPP)
167772160x0100 0000UNIT_FLAG_POSSESSEDunder direct client control by a player (possess or vehicle)
335544320x0200 0000UNIT_FLAG_NOT_SELECTABLECan't be selected by mouse or with /target {name} command.
671088640x0400 0000UNIT_FLAG_SKINNABLESkinnable
1342177280x0800 0000UNIT_FLAG_MOUNTThe client seems to handle it perfectly. Also used when making custom mounts.
2684354560x1000 0000UNIT_FLAG_UNK_28(PreventKneelingWhenLooting from UnitFlags.cs in WPP)
5368709120x2000 0000UNIT_FLAG_PREVENT_EMOTES_FROM_CHAT_TEXTPrevent automatically playing emotes from parsing chat text, for example "lol" in /say, ending message with ? or !, or using /yell
10737418240x4000 0000UNIT_FLAG_SHEATHE
21474836480x8000 0000UNIT_FLAG_IMMUNEImmune to damage

dynamicflags

Same as creature_template.dynamicflags.

Note:

A creature.dynamicflags record will override a creature_template.dynamicflags record.