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)

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