[Venelar]

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:

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.