My information might be out of date with current peq table structure, but I will try to help.
I would start by running a query to get a scope of how many exist, and where they are.
i.e.
Quote:
select npt.id,npt.name,npt.bodytype,npt.race,spt.chance,s p2.zone
from spawnentry spt
left join npc_types npt on (npt.id=spt.npcid)
left join spawn2 sp2 on (sp2.spawngroupid = spt.spawngroupID)
where spt.chance > '0' and npt.bodytype = '11' and npt.race in (127,240)
|
That should show id,name,bodytype (11 is untargetable), race (127 and 240 are invisible men), its chance to spawn in a spawngroup, and the zone it spawns in.
And just fine tune it from there. Search for the invisible men races were bodytype isn't 11, to make sure they are set up properly. If you want to remove them all, create a query to either 0% the chance in spawnentry or remove the spawn2 ids. I would look further into it before deleting everything because as demonstar said, you shouldn't be seeing them.