Well, I figured out why the npcs weren't casting spells. Almost all their npc_spells_ids were set to zero in the npc_types table.
So I ran this on them:
update npc_types set npc_spells_id=1 where class=2 or class=18;
update npc_types set npc_spells_id=2 where class=12 or class=28;
update npc_types set npc_spells_id=3 where class=11 or class=27;
update npc_types set npc_spells_id=4 where class=13 or class=29;
update npc_types set npc_spells_id=5 where class=14 or class=30;
update npc_types set npc_spells_id=6 where class=10 or class=26;
update npc_types set npc_spells_id=7 where class=6 or class=22;
update npc_types set npc_spells_id=8 where class=3 or class=19;
update npc_types set npc_spells_id=9 where class=5 or class=21;
update npc_types set npc_spells_id=10 where class=4 or class=20;
update npc_types set npc_spells_id=11 where class=8 or class=24;
update npc_types set npc_spells_id=12 where class=15 or class=31;
and now they cast.
But city defense is still not working, the city defense table has got all the correct npc ids and zone ids, must be a faction problem I think. I'll keep on checking the db.
|