Database:CoreNPCData

EQ2Emulator: Core NPC Configuration Data

The datasets configured here are provided as templates for server admins to assign to NPCs to create a more immersive gaming experience. This is considered CORE data merely because they can be used on any type of spawned NPC, and not tied to any specific Content setup.

Once you set up your spawn_npc_{type} table entries, you can then link a particular spawn_id to this configuration by using the fields in the spawn_npcs table:

• equipment_list_id
• skill_list_id
• secondary_skill_list_id (if you want an alternate skill set to be available)
• spell_list_id
• secondary_spell_list_id (if you want an alternate spell set to be available)

Examples of this at the end of this article.

spawn_npc_equipment

This table is used to grant your NPC the same bonuses offered by the gear you assign (eg., giving your NPC a +10 Str bonus because it is wearing a piece of armor that grants +10 Str). This is NOT appearance data! Do not confuse equipping an NPC with a piece of stats armor, with appearances. Visual appearances are handled much differently (see NPC Appearances table definitions)

Example: In my zone, I have spawned 'a sapswill invader'. That spawn has basic stats only, whatever you have set up in the spawn_npcs table. If I want this one spawn_id to have some bonuses, rather than create an entirely new spawn_id for that difference, I can create a series of spawn_npc_equipment table entries to reflect exactly how much gear-related bonus I want this NPC to have.

In my SQL GUI tool, I select the spawn_npc_equipment table, and insert a new record with a equipment_list_id of 1 (I picked 1 because it is my first unique equipment list), and the item_id of the item I wish the NPC to "wear":

In this example, it was item_id 54195, the 'tailored laborers vest':

Once I go to my sapswill invader NPC record and assign the equipment_list_id of 1, that now has a +2 sta, +2 agi, +2 int, and +5 noxious bonuses.

You can see the endless customization and configurability you can gain from this option!

spawn_npc_skills

You can build custom Skill assignments to your NPCs as well. Say you want your sapswill invader to also know how to use 1H Slashing, 1H Blunt and Piercing. Simply build a skill_list with those skill_ids set, assign it to your NPC, and you're done!

Alternately, NPC Skill Lists allow you to set up a secondary list of skills too, much like a player has a primary and secondary skill set.

spawn_npc_spells

Much like the NPC Skill Lists, your NPC can be allowed to cast any spell in the database on an attacker. Set the spell_id to the spell_list you create, assign it to the NPC and now your NPC can cast that spell during combat (see spawn_npcs field definitions for more information on casting spells)

Examples

We will now walk through 1 complete setup of a custom NPC with equipment bonuses, spells and skill sets designed and assigned.

In this walkthru, I am using SQLYog 9.2 as a DB editing tool.

Back to Content:Introduction

Content:Introduction