Loading...   

[Show Table of Contents]


npc_spells_entries database schema
Field Name Field Description Field Type Field Default Value
id Represents an auto_increment field (passive field, not used) int(11) auto_increment
npc_spells_id This is the primary key that is linked to npc_spells table int(11) 0
spellid The actually spell id, specified from table spells_new smallint(5) 0
type Determines type of spell
  • 1 = Nuke
    2 = Heal
    4 = Root
  • 8 = Buff
  • 16 = Escape
  • 32 = Pet
  • 64 = Lifetap
  • 128 = Snare
  • 256 = Damage over Time (DOT)
  • 512 = Dispell
  • 1024 = In Combat Buff
  • 2048 = Mez
  • 4096 = Charm
  • 8192 = Slow
  • 16384 = Debuff
  • 32768 = Cure
  • 65536 = Resurrect
  • 131072 = HateRedux
  • 262144 = InCombatBuffSong
  • 524288 = OutofCombatBuffSong
smallint(5) unsigned 0
minlevel The minimum level required for the actual NPC to be in order to be able to cast this spell in the npc_types table tinyint(3) unsigned 0
maxlevel The maximum level required for the actual NPC to be in order to be able to cast this spell in the npc_types table tinyint(3) unsigned 255
manacost The mana that costs the NPC to use this spell smallint(5) -1
recast_delay The recast delay in which the NPC could use this spell again int(11) -1
priority Spell with lowest priority will always be chosen over a higher priority value smallint(5) 0
resist_adjust ? int(11) NULL

ยงnpc_spells_entries

Used With
Loaded When
  • On zone init/boot (static zone on its initial boot, dynamics on each startup of a zone) spells are then cached from the database
Loaded From ZoneDatabase::GetNPCSpells in zone/MobAI.cpp
Related Commands