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 :) |
delete from spawn2 where zone='whateverzone';
not the cleanest way but its one way. |
heeh kk thanks :)
|
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.