creature_spawns
This table contains spells that creatures use instead of advanced scripting.
Structure
Field | Type | Default | Comment |
---|---|---|---|
id | int(11) | key, auto | |
min_build | smallint(6) | 12340 | key |
max_build | smallint(6) | 12340 | |
entry | mediumint(10) | ||
map | smallint(5) | ||
position_x | float(0) | ||
position_y | float(0) | ||
position_z | float(0) | ||
orientation | float(0) | ||
movetype | tinyint(3) | 0 | |
displayid | mediumint(10) | 0 | |
faction | mediumint(10) | 14 | |
flags | int(10) | 0 | |
pvp_flagged | tinyint(1) | 0 | |
bytes0 | int(10) | 0 | |
emote_state | smallint(5) | 0 | |
npc_respawn_link | int(10) | 0 | |
channel_spell | int(10) | 0 | |
channel_target_sqlid | int(10) | 0 | |
channel_target_sqlid_creature | int(10) | 0 | |
standstate | tinyint(3) | 0 | |
death_state | tinyint(3) | 0 | |
mountdisplayid | int(10) | 0 | |
sheath_state | tinyint(1) | 0 | |
slot1item | int(10) | 0 | |
slot2item | int(10) | 0 | |
slot3item | int(10) | 0 | |
CanFly | smallint(3) | 0 | |
phase | int(10) | 0 | |
event_entry | int(6) | 0 | |
wander_distance | int(6) | 0 | |
waypoint_group | int(6) | 0 |
id
Spawn ID of the creature (unique, auto)
min_build
Build number this spawn was introduced.
max_build
Max Build number this spawn is valid for.
entry
Entry ID of the creature from creature_properties table.
map
Map ID of the spawned creature.
positions
Coordinates of the spawned creature. (Home position).
movetype
Pure Flags | Decimal | Description |
---|---|---|
MOVEMENTTYPE_NONE | 0 | No WP movement |
MOVEMENTTYPE_RANDOMWP | 1 | Walks random through waypoints (WP4, WP2, WP3, WP1) |
MOVEMENTTYPE_CIRCLEWP | 2 | Walks in cirlce (WP1, WP2, WP3, WP1, WP2…) |
MOVEMENTTYPE_WANTEDWP | 3 | Coreside WP, walking only if script calls “Walk to WPx”) |
MOVEMENTTYPE_DONTMOVEWP | 4 | Coreside, if a creature has WPs, don’t move it automatically. |
MOVEMENTTYPE_QUEST | 10 | If quest started, follow WPs |
MOVEMENTTYPE_FORWARDTHENSTOP | 11 |
displayid
The ID for the display/skin of the creature.
faction
The ID of the faction of the creature. Should match the faction ID in the creature’s creature_proto.
flags
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.
Pure Flags | Decimal | Binary (32 Bit) | Remarks |
---|---|---|---|
UNIT_NPC_FLAG_NONE | 0 | 0000 0000 0000 0000 0000 0000 0000 0000 | |
UNIT_NPC_FLAG_GOSSIP | 1 | 0000 0000 0000 0000 0000 0000 0000 0001 | (If NPC has more gossip options, add this flag to bring up a menu.) |
UNIT_NPC_FLAG_QUESTGIVER | 2 | 0000 0000 0000 0000 0000 0000 0000 0010 | (Any NPC giving or taking quests needs to have this flag.) |
UNIT_NPC_FLAG_UNKNOWN1 | 4 | 0000 0000 0000 0000 0000 0000 0000 0100 | |
UNIT_NPC_FLAG_UNKOWN2 | 8 | 0000 0000 0000 0000 0000 0000 0000 1000 | |
UNIT_NPC_FLAG_TRAINER | 16 | 0000 0000 0000 0000 0000 0000 0001 0000 | (Allows the NPC to have a trainer list to teach spells, all trainers must have this flag) |
UNIT_NPC_FLAG_TRAINER_CLASS | 32 | 0000 0000 0000 0000 0000 0000 0010 0000 | |
UNIT_NPC_FLAG_TRAINER_PROF | 64 | 0000 0000 0000 0000 0000 0000 0100 0000 | |
UNIT_NPC_FLAG_VENDOR | 128 | 0000 0000 0000 0000 0000 0000 1000 0000 | (Any NPC selling items needs to have this flag) |
UNIT_NPC_FLAG_VENDOR_AMMO | 256 | 0000 0000 0000 0000 0000 0001 0000 0000 | |
UNIT_NPC_FLAG_VENDOR_FOOD | 512 | 0000 0000 0000 0000 0000 0010 0000 0000 | |
UNIT_NPC_FLAG_VENDOR_POISON | 1024 | 0000 0000 0000 0000 0000 0100 0000 0000 | |
UNIT_NPC_FLAG_VENDOR_REAGENT | 2048 | 0000 0000 0000 0000 0000 1000 0000 0000 | |
UNIT_NPC_FLAG_ARMORER | 4096 | 0000 0000 0000 0000 0001 0000 0000 0000 | (NPC with this flag can repair items.) |
UNIT_NPC_FLAG_TAXIVENDOR | 8192 | 0000 0000 0000 0000 0010 0000 0000 0000 | (Any NPC serving as fly master has this.) |
UNIT_NPC_FLAG_SPIRITHEALER | 16384 | 0000 0000 0000 0000 0100 0000 0000 0000 | (Makes the NPC invisible to alive characters and has the resurrect function.) |
UNIT_NPC_FLAG_SPIRITGUIDE | 32768 | 0000 0000 0000 0000 1000 0000 0000 0000 | |
UNIT_NPC_FLAG_INNKEEPER | 65536 | 0000 0000 0000 0001 0000 0000 0000 0000 | (NPC with this flag can set hearthstone locations.) |
UNIT_NPC_FLAG_BANKER | 131072 | 0000 0000 0000 0010 0000 0000 0000 0000 | (NPC with this flag can show the bank) |
UNIT_NPC_FLAG_ARENACHARTER | 262144 | 0000 0000 0000 0100 0000 0000 0000 0000 | |
UNIT_NPC_FLAG_TABARDVENDOR | 524288 | 0000 0000 0000 1000 0000 0000 0000 0000 | (Allows the designing of guild tabards.) |
UNIT_NPC_FLAG_BATTLEFIELDPERSON | 1048576 | 0000 0000 0001 0000 0000 0000 0000 0000 | (NPC with this flag port players to battlegrounds. Like battlemasters, arena organzier etc.) |
UNIT_NPC_FLAG_AUCTIONEER | 2097152 | 0000 0000 0010 0000 0000 0000 0000 0000 | (Allows NPC to display auction list.) |
UNIT_NPC_FLAG_STABLE | 4194304 | 0000 0000 0100 0000 0000 0000 0000 0000 | (Has the option to stable pets for hunters.) |
UNIT_NPC_FLAG_GUILD_BANK | 8388608 | 0000 0000 1000 0000 0000 0000 0000 0000 | |
UNIT_NPC_FLAG_SPELLCLICK | 16777216 | 0000 0001 0000 0000 0000 0000 0000 0000 | (Needs data on npc_spellclick_spells table) |
UNIT_NPC_FLAG_PLAYER_VEHICLE | 33554432 | 0000 0010 0000 0000 0000 0000 0000 0000 | (Needs data on npc_spellclick_spells table) |
UNIT_NPC_FLAG_MAILBOX | 67108864 | 0000 0100 0000 0000 0000 0000 0000 0000 | (Needs data on npc_spellclick_spells table) |
pvp_flagged
Creature’s pvp flag state. Creature’s faction must be either horde or alliance for this to work.
0 = No pvp flag 1 = Pvp flagged
bytes0
See creature_spawns bytes.
emote_state
Emote ID of the creature.
0 - ONESHOT_NONE 1 - ONESHOT_TALK(DNR) 2 - ONESHOT_BOW 3 - ONESHOT_WAVE(DNR) 4 - ONESHOT_CHEER(DNR) 5 - ONESHOT_EXCLAMATION(DNR) 6 - ONESHOT_QUESTION 7 - ONESHOT_EAT 10 - STATE_DANCE 11 - ONESHOT_LAUGH 12 - STATE_SLEEP 13 - STATE_SIT (USE bytes1 1 INSTEAD) 14 - ONESHOT_RUDE(DNR) 15 - ONESHOT_ROAR(DNR) 16 - ONESHOT_KNEEL 17 - ONESHOT_KISS 18 - ONESHOT_CRY 19 - ONESHOT_CHICKEN 20 - ONESHOT_BEG 21 - ONESHOT_APPLAUD 22 - ONESHOT_SHOUT(DNR) 23 - ONESHOT_FLEX 24 - ONESHOT_SHY(DNR) 25 - ONESHOT_POINT(DNR) 26 - STATE_STAND 27 - STATE_READYUNARMED 28 - STATE_WORK_SHEATHED 29 - STATE_POINT(DNR) 30 - STATE_NONE 33 - ONESHOT_WOUND 34 - ONESHOT_WOUNDCRITICAL 35 - ONESHOT_ATTACKUNARMED 36 - ONESHOT_ATTACK1H 37 - ONESHOT_ATTACK2HTIGHT 38 - ONESHOT_ATTACK2HLOOSE 39 - ONESHOT_PARRYUNARMED 43 - ONESHOT_PARRYSHIELD 44 - ONESHOT_READYUNARMED 45 - ONESHOT_READY1H 48 - ONESHOT_READYBOW 50 - ONESHOT_SPELLPRECAST 51 - ONESHOT_SPELLCAST 53 - ONESHOT_BATTLEROAR 54 - ONESHOT_SPECIALATTACK1H 60 - ONESHOT_KICK 61 - ONESHOT_ATTACKTHROWN 64 - STATE_STUN 65 - STATE_DEAD 66 - ONESHOT_SALUTE 68 - STATE_KNEEL 69 - STATE_USESTANDING 70 - ONESHOT_WAVE_NOSHEATHE 71 - ONESHOT_CHEER_NOSHEATHE 92 - ONESHOT_EAT_NOSHEATHE 93 - STATE_STUN_NOSHEATHE 94 - ONESHOT_DANCE 113 - ONESHOT_SALUTE_NOSHEATH 133 - STATE_USESTANDING_NOSHEATHE 153 - ONESHOT_LAUGH_NOSHEATHE 173 - STATE_WORK 193 - STATE_SPELLPRECAST 213 - ONESHOT_READYRIFLE 214 - STATE_READYRIFLE 233 - STATE_WORK_MINING 234 - STATE_WORK_CHOPWOOD (lazy-peon) 253 - STATE_APPLAUD 254 - ONESHOT_LIFTOFF 273 - ONESHOT_YES(DNR) 274 - ONESHOT_NO(DNR) 275 - ONESHOT_TRAIN(DNR) 293 - ONESHOT_LAND 313 - STATE_AT_EASE 333 - STATE_READY1H 353 - STATE_SPELLKNEELSTART 373 - STAND_STATE_SUBMERGED 374 - ONESHOT_SUBMERGE 375 - STATE_READY2H 376 - STATE_READYBOW 377 - ONESHOT_MOUNTSPECIAL 378 - STATE_TALK 379 - STATE_FISHING 380 - ONESHOT_FISHING 381 - ONESHOT_LOOT 382 - STATE_WHIRLWIND 383 - STATE_DROWNED 384 - STATE_HOLD_BOW 385 - STATE_HOLD_RIFLE 386 - STATE_HOLD_THROWN 387 - ONESHOT_DROWN 388 - ONESHOT_STOMP 389 - ONESHOT_ATTACKOFF 390 - ONESHOT_ATTACKOFFPIERCE 391 - STATE_ROAR 392 - STATE_LAUGH 393 - ONESHOT_CREATURE_SPECIAL 394 - ONESHOT_JUMPLANDRUN 395 - ONESHOT_JUMPEND 396 - ONESHOT_TALK_NOSHEATHE 397 - ONESHOT_POINT_NOSHEATHE 398 - STATE_CANNIBALIZE 399 - ONESHOT_JUMPSTART 400 - STATE_DANCESPECIAL 401 - ONESHOT_DANCESPECIAL 402 - ONESHOT_CUSTOMSPELL01 403 - ONESHOT_CUSTOMSPELL02 404 - ONESHOT_CUSTOMSPELL03 405 - ONESHOT_CUSTOMSPELL04 406 - ONESHOT_CUSTOMSPELL05 407 - ONESHOT_CUSTOMSPELL06 408 - ONESHOT_CUSTOMSPELL07 409 - ONESHOT_CUSTOMSPELL08 410 - ONESHOT_CUSTOMSPELL09 411 - ONESHOT_CUSTOMSPELL10 412 - STATE_EXCLAIM 413 - STATE_DANCE_CUSTOM 415 - STATE_SIT_CHAIR_MED 416 - STATE_CUSTOM_SPELL_01 417 - STATE_CUSTOM_SPELL_02 418 - STATE_EAT 419 - STATE_CUSTOM_SPELL_04 420 - STATE_CUSTOM_SPELL_03 421 - STATE_CUSTOM_SPELL_05 422 - STATE_SPELLEFFECT_HOLD 423 - STATE_EAT_NO_SHEATHE 424 - STATE_MOUNT 425 - STATE_READY2HL 426 - STATE_SIT_CHAIR_HIGH 427 - STATE_FALL 428 - STATE_LOOT 429 - STATE_SUBMERGED 430 - ONESHOT_COWER(DNR) 431 - STATE_COWER 432 - ONESHOT_USESTANDING 433 - STATE_STEALTH_STAND 434 - ONESHOT_OMNICAST_GHOUL (W/SOUND) 435 - ONESHOT_ATTACKBOW 436 - ONESHOT_ATTACKRIFLE 437 - STATE_SWIM_IDLE 438 - STATE_ATTACK_UNARMED 439 - ONESHOT_SPELLCAST (W/SOUND) 440 - ONESHOT_DODGE 441 - ONESHOT_PARRY1H 442 - ONESHOT_PARRY2H 443 - ONESHOT_PARRY2HL 444 - STATE_FLYFALL 445 - ONESHOT_FLYDEATH 446 - STATE_FLY_FALL 447 - ONESHOT_FLY_SIT_GROUND_DOWN 448 - ONESHOT_FLY_SIT_GROUND_UP 449 - ONESHOT_EMERGE 450 - ONESHOT_DRAGONSPIT 451 - STATE_SPECIALUNARMED 452 - ONESHOT_FLYGRAB 453 - STATE_FLYGRABCLOSED 454 - ONESHOT_FLYGRABTHROWN 455 - STATE_FLY_SIT_GROUND 456 - STATE_WALKBACKWARDS 457 - ONESHOT_FLYTALK 458 - ONESHOT_FLYATTACK1H 459 - STATE_CUSTOMSPELL08 460 - ONESHOT_FLY_DRAGONSPIT 461 - STATE_SIT_CHAIR_LOW 462 - ONE_SHOT_STUN 463 - ONESHOT_SPELLCAST_OMNI 465 - STATE_READYTHROWN 466 - ONESHOT_WORK_CHOPWOOD 467 - ONESHOT_WORK_MINING 468 - STATE_SPELL_CHANNEL_OMNI 469 - STATE_SPELL_CHANNEL_DIRECTED 470 - STAND_STATE_NONE 471 - STATE_READYJOUST 473 - STATE_STRANGULATE 474 - STATE_READYSPELLOMNI 475 - STATE_HOLD_JOUST 476 - ONESHOT_CRY (JAINA PROUDMOORE ONLY)
4.3.4.15595
477 - ONESHOT_SPECIALUNARMED 478 - STATE_DANCE_NOSHEATHE 479 - ONESHOT_SNIFF 480 - ONESHOT_DRAGONSTOMP 482 - ONESHOT_KNOCKDOWN 483 - STATE_READ 485 - ONESHOT_FLYEMOTETALK 492 - STATE_READ_ALLOWMOVEMENT 505 - STATE_READY1H_ALLOW_MOVEMENT 506 - STATE_READY2H_ALLOW_MOVEMENT 507 - ONESHOT_MONKOFFENSE_ATTACKUNARMED 508 - ONESHOT_MONKOFFENSE_SPECIALUNARMED 509 - ONESHOT_MONKOFFENSE_PARRYUNARMED 510 - STATE_MONKOFFENSE_READYUNARMED 511 - ONESHOT_PALMSTRIKE 512 - STATE_CRANE 517 - ONESHOT_OPEN 518 - STATE_READ_CHRISTMAS
5.4.8.18414
526 - ONESHOT_FLYATTACK2HL 527 - ONESHOT_FLYATTACKTHROWN 528 - STATE_FLYREADYSPELLDIRECTED 531 - STATE_FLY_READY_1H 533 - STATE_MEDITATE 534 - STATE_FLY_READY_2HL 535 - ONESHOT_TOGROUND 536 - ONESHOT_TOFLY 537 - STATE_ATTACKTHROWN 538 - STATE_SPELL_CHANNEL_DIRECTED_NOSOUND 539 - ONESHOT_WORK 540 - STATE_READYUNARMED_NOSOUND 543 - ONESHOT_MONKOFFENSE_ATTACKUNARMEDOFF 546 - RECLINED_MOUNT_PASSENGER 547 - ONESHOT_QUESTION 549 - ONESHOT_SPELL_CHANNEL_DIRECTED_NOSOUND 550 - STATE_KNEEL 551 - ONESHOT_FLYATTACKUNARMED 552 - ONESHOT_FLYCOMBATWOUND 553 - ONESHOT_MOUNTSELFSPECIAL 554 - ONESHOT_ATTACKUNARMED_NOSOUND 555 - STATE_WOUNDCRITICAL (DOESNT WORK) 556 - ONESHOT_ATTACK1H (No Sound - Doesn't Work) 557 - STATE_MOUNT_SELF_IDLE 558 - ONESHOT_WALK 559 - STATE_OPENED 560 - ONESHOT_YELL (do not use, use ONESHOT_SHOUT) 565 - ONESHOT_BREATHOFFIRE 567 - STATE_ATTACK1H 572 - STATE_USESTANDING 574 - ONESHOT_LAUGH (No Sound)
npc_respawn_link
…
channel_spell
ID of a Spell that the creature will channel.
channel_target_sqlid
…
channel_target_sqlit_creature
…
standstate
0 = Stand 1 = Sitting on the ground 2 = Sitting on chair 3 = Sleep 4 = Sit (Low) 5 = Sit (Medium) 6 = Sit (Elevated High) 7 = Lying Dead 8 = Kneel
death_state
0 = alive (Creature acts normal) 1 = just died (Creature appears dead, but is acting like alive - can speak with you, you can make gossip with this NPC) 2 = corpse (This creature is dead and acts as dead body)
mountdisplayid
The Display ID of a mount to be used to make the creature appear mounted. The value here overrides the value for the creature’s unit field UNIT_FIELD_MOUNTDISPLAYID.
sheath_state
0 = Creature's weapons are non prepared 1 = Creature's melee weapon is prepared 2 = Creature's ranged weapon is prepared
slot1item
Entry ID of an item to be equipped in the Right Hand (Main Hand).
slot2item
Entry ID of an item to be equipped in the Left Hand (Off-Hand).
slot3item
Entry ID of a ranged item to be equipped.
CanFly
0 = Flying disabled 1 = Flying enabled
phase
The phase of the creature.
event_entry
entry from table event_properties
wander_distance
the distance the creature will move from initiated spawn point (only applied on random movement)
waypoint_group
entry from table creature_waypoints