EQEmulator Forums - SQL To Give NPC Casters Their Spells

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - SQL To Give NPC Casters Their Spells (https://www.eqemulator.org/forums/showthread.php?t=7765)

SQL To Give NPC Casters Their Spells

I noticed by default that drawdes db has not assigned spell lists to npcs so here is some SQL statements to fix that.

--Add casting ability to all NPC classes:

Code:

UPDATE npc_types SET npc_spells_id = '1' WHERE class = 2;

UPDATE npc_types SET npc_spells_id = '8' WHERE class = 3;

UPDATE npc_types SET npc_spells_id = '10' WHERE class = 4;

UPDATE npc_types SET npc_spells_id = '9' WHERE class = 5;

UPDATE npc_types SET npc_spells_id = '7' WHERE class = 6;

UPDATE npc_types SET npc_spells_id = '11' WHERE class = 8;

UPDATE npc_types SET npc_spells_id = '6' WHERE class = 10;

UPDATE npc_types SET npc_spells_id = '3' WHERE class = 11;

UPDATE npc_types SET npc_spells_id = '2' WHERE class = 12;

UPDATE npc_types SET npc_spells_id = '4' WHERE class = 13;

UPDATE npc_types SET npc_spells_id = '5' WHERE class = 14;

UPDATE npc_types SET npc_spells_id = '12' WHERE class =  15;

Please note that the spell lists for some classes like bard, beastlord, paladin and shaman are empty and others are very incomplete.

I created a fairly good shaman list, i could not attach it to this post I will make a place to download it.

The last version of my DB -should- have a complete spell list for all classes, and spell lists are already assigned in npc_types (no need to have an "update npc_types" script).

Drawde, no disrespect intended but I just downloaded your latest and not all npc_types were assigned their default. This patch actually fixed that. :?

What are the NPCs that don't have spell lists assigned?
I thought I'd set them all up OK, but it seems like some errors have crept in.
Let me know what they are and I'll try and fix them for the next version.

I wish I could tell you, but after I patched in the above everything was fixed. I didn't think to zip the table up for you so you could have a look, sorry :?