EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Removing NPCs From a Zone (https://www.eqemulator.org/forums/showthread.php?t=33989)

Kingmen30264 08-11-2011 06:45 PM

Removing NPCs From a Zone
 
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 08-11-2011 07:26 PM

delete from spawn2 where zone='whateverzone';

not the cleanest way but its one way.

Kingmen30264 08-11-2011 07:37 PM

heeh kk thanks :)

Robregen 08-11-2011 10:04 PM

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.


All times are GMT -4. The time now is 10:48 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.