Loading...   

Field Name Field Description Field Type Field Default Value
id The ID of the NPC. int(11) Auto Increment
name The name of the NPC. text(0) Empty
lastname The last name of the NPC. varchar(32) NULL
level The level of the NPC. tinyint(2) 0
race The race ID of the NPC. Races smallint(5) 0
class The class ID of the NPC. Classes tinyint(2) 0
bodytype The body type of the NPC. Body Types int(11) NULL
hp The health of the NPC. int(11) 0
mana The mana of the NPC. int(11) 0
gender The gender of the NPC. Genders tinyint(2) 0
texture The texture of the NPC. tinyint(2) 0
helmtexture The helmet texture of the NPC. tinyint(2) 0
size The size of the NPC. float(0) 0
hp_regen_rate The health regeneration rate of the NPC. int(11) 0
mana_regen_rate The mana regeneration rate of the NPC. int(11) 0
loottable_id The loottable ID used by the NPC. int(11) 0
merchant_id The merchant ID used by the NPC, must be Merchant class. Classes int(11) 0
alt_currency_id The alternate currency ID used in the merchant's shop. Alternate Currency int(11) 0
npc_spells_id The NPC spell list ID used by the NPC. int(11) 0
npc_spells_effects_id

The NPC spell effect list ID used by the NPC. npc_spells_effects

int(11) 0
npc_faction_id The faction ID of the NPC. int(11) 0
adventure_template_id The adventure template ID of the NPC. int(10) 0
trap_template The trap template ID of the NPC. int(10) 0
mindmg The minimum damage of the NPC. int(10) 0
maxdmg The maximum damage of the NPC. int(10) 0
attack_count The attack count of the NPC. smallint(6) -1
npcspecialattks DEPRECATED: The special attacks of the NPC. NPC Special Attacks varchar(36) Empty String
special_abilities The special abilities of the NPC. NPC Special Attacks text(0) Empty
aggroradius The aggro radius of the NPC. int(10) 0
assistradius The assist radius of the NPC. int(10) 0
face The face ID of the NPC. int(10) 1
luclin_hairstyle The hair ID of the NPC. int(10) 1
luclin_haircolor The hair color ID of the NPC. int(10) 1
luclin_eyecolor The eye one color ID of the NPC. int(10) 1
luclin_eyecolor2 The eye two color ID of the NPC. int(10) 1
luclin_beardcolor The beard color ID of the NPC. int(10) 1
luclin_beard The beard ID of the NPC. int(10) 0
drakkin_heritage The Drakkin heritage ID of the NPC. int(10) 0
drakkin_tattoo The Drakkin tattoo ID of the NPC. int(10) 0
drakkin_details The Drakkin details ID of the NPC. int(10) 0
armortint_id The armor tint ID of the NPC. int(10) 0
armortint_red The amount of Red coloring on the NPCs armor. tinyint(3) 0
armortint_green The amount of Green coloring on the NPCs armor. tinyint(3) 0
armortint_blue The amount of Blue coloring on the NPCs armor. tinyint(3) 0
d_melee_texture1 The model in the primary hand of the NPC. (Numeric part of raw field "IDFile" for melee item) int(10) 0
d_melee_texture2 The model in the secondary hand of the NPC. (Numeric part of raw field "IDFile" for melee item) int(10) 0
prim_melee_type The primary melee type of the NPC. (see Skills ) tinyint(4) 28
sec_melee_type The secondary melee type of the NPC.  (see Skills ) tinyint(4) 28
runspeed The run speed of the NPC. float(0) 0
MR The Magic Resistance of the NPC. smallint(5) 0
CR The Cold Resistance of the NPC. smallint(5) 0
DR The Disease Resistance of the NPC. smallint(5) 0
FR The Fire Resistance of the NPC. smallint(5) 0
PR The Posion Resistance of the NPC. smallint(5) 0
Corrup The Corruption Resistance of the NPC. smallint(5) 0
PhR The Physical Resistance of the NPC. smallint(5) 0
see_invis Determines whether or not the NPC can see players using Invisibility. 0 = No, 1 = Yes smallint(4) 0
see_invis_undead Determines whether or not the NPC can see players using Invisibility VS. Undead. 0 = No, 1 = Yes smallint(4) 0
qglobal Determines whether or not the NPC can load quest globals. 0 = No, 1 = Yes int(2) 0
AC The Armor Class of the NPC. smallint(5) 0
npc_aggro Determines whether or not the NPC can aggro on other NPCs. 0 = No, 1 = Yes tinyint(4) 0
spawn_limit The spawn limit of the NPC. tinyint(4) 0
attack_speed The attack speed of the NPC. The lower the number, the faster the NPC hits. (Deprecated) float(0)

0

attack_delay The delay between the NPCs attack arounds in 10ths of a second (same as weapon's display) tinyint(3) 30
findable Determines whether or not the NPC is findable. 0 = No, 1 = Yes tinyint(4) 0
STR The Strength of the NPC. mediumint(8) 75
STA The Stamina of the NPC. mediumint(8) 75
DEX The Dexterity of the NPC. mediumint(8) 75
AGI The Agility of the NPC. mediumint(8) 75
_INT The Intelligence of the NPC. mediumint(8) 80
WIS The Wisdom of the NPC. mediumint(8) 75
CHA The Charisma of the NPC. mediumint(8) 75
see_hide Determines whether or not the NPC can see players using Hide. 0 = No, 1 = Yes tinyint(4) 0
see_improved_hide Determines whether or not the NPC can see players using Improved Hide. 0 = No, 1 = Yes tinyint(4) 0
trackable Determines whether or not the NPC is trackable. 0 = No, 1 = Yes tinyint(4) 1
isbot Determines whether or not the NPC is a bot. 0 = No, 1 = yes tinyint(4) 0
exclude Leave this at 1. tinyint(4) 1
ATK The Attack of the NPC. mediumint(9) 0
Accuracy The Accuracy of the NPC. mediumint(9) 0
slow_mitigation The slow mitigation of the NPC. smallint(4) NULL
version The version of the NPC. smallint(5) 0
maxlevel The max level of the NPC. This makes the mob capable of spawning between levels 'level' to 'maxlevel'.  Optionally can set resists, mana regen, hp regen, mindmg and maxdmg to 0 to auto-set based on level or to a base level and use scale_level to scale these.  HP and stats are scaled-only and should not be set to 0. tinyint(3) 0
scalerate The rate at which the NPC scales based on level. 100 = 100%, 50 = 50%, 25 = 25%, etc. int(11) 100
private_corpse Determines whether or not the NPC, when killed, is a private corpse. 0 = No, 1 = Yes tinyint(3) 0
unique_spawn_by_name Determines whether or not the NPC is a unique spawn. 0 = No, 1 = Yes tinyint(3) 0
underwater Determines whether or not the NPC is underwater. 0 = No, 1 = Yes tinyint(3) 0
isquest Determines whether or not the NPC is a quest NPC. 0 = No, 1 = Yes tinyint(3) 0
emoteid The emote ID of the NPC. int(10) 0
spellscale The rate at which the NPC spells scale based on level. 100 = 100%, 50 = 50%, 25 = 25%, etc. float(0) 100
healscale The rate at which the NPC heals scale based on level. 100 = 100%, 50 = 50%, 25 = 25%, etc. float(0) 100
no_target_hotkey Determines whether or not players can target the NPC with their target hotkey. 0 = Yes, 1 = No tinyint(1) 0