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 mana regen, hp regen, mindmg and maxdmg to 0 to auto-set based on level or to a base level and use scalerate 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 |