Removing NPCs

[Shendare]

IIRC, you can log in with a GM account, target the NPC, and type #npcspawn delete.

Removes the npc_type and all spawning references to it.

Alternatively, #npcspawn remove clears all spawns for the npc_type, but leaves the npc_type in the database.

[AdrianD]

Thanks Shendare.

That will be useful to me for immediate resolution.

I build expansions from a main DB with a set of queries to isolate rows based on various criteria. In a few tables, I added a column to assist with isolation.

Here is a specific example for what I am doing with anything before Luclin; I don't update every time:

use main_db;
update npc_types set expansion = 3 where race = 130;

run all expansion_build queries

use live_db;
update spawnentry set chance = 0 select spawnentry.* from npc_types join spawnentry 
     where spawnentry.npcid = npc_types.id and npc_types.race = 130;

ALTER TABLE  npc_types DROP column  `expansion`;

This won't remove the npc_types entries for the zones where race = 130 but, it will disable the spawn from occuring. My concern/question was if there is a better or more efficient way.