Removing NPCs From a Zone

[Kingmen30264]

Is there an easier way of removing ALL NPCS from a single zone instead of /target #npcspawn remove on each individual one?

For example, to remove ALL NPCs from Draniksscar, what command could I use in MySQL to do this? I have looked around in my DB and I don't recall seeing anything that mentions these NPCs aside from in the npc_type table, but I don't want to delete them from the DB, I just want to remove them from the zone, making it a clean "slate" and allowing me to add my own custom NPCs.

Thanks to all that answer

[devn00b]

delete from spawn2 where zone='whateverzone';

not the cleanest way but its one way.

[Kingmen30264]

heeh kk thanks

[Robregen]

or you can make chance to spawn to 0. like

Update spawnentry SET chance = 0 Where npcID >= 302000 and npcID <= 302999;

zone for dranikscar is 302 and npcid usually starts with the zoneID + (000 to 999)

That way nothing is removed from the database. just zero chance to spawn.