Creature Spawns Question

[ardtard76]

Ok, well i am working on a custom lore server and i know it would take far too much work in order to delete most of the npc's. Is there any way i can unspawn all npcs from ingame but still stay in the database for id's and such? Would it require deleting everything in Creature_spawns?

+rep for any help

[Zudrik]

Yeah, I'm pretty sure if you want your server to be Npc-less, but still have them in the DB (Creature_names & creature_proto, and even vendors) Pretty much empty the whole creature_spawns table.

Don't delete the table itsself though. I would also make a backup of incase something goes horribly wrong.

[worldslayer]

Yeah, I'm pretty sure if you want your server to be Npc-less, but still have them in the DB (Creature_names & creature_proto, and even vendors) Pretty much empty the whole creature_spawns table.

Don't delete the table itsself though. I would also make a backup of incase something goes horribly wrong.

what would happen if you just cleared the spawning coordinates in the table?

[Zudrik]

what would happen if you just cleared the spawning coordinates in the table?

Hmm, I'm not sure. Have you tried it? I assume it would give you an error saying it cannot be 'NULL' or blank.

I guess if it did let you just delete the coords.. I don't know, all the Npcs would be floating around or all in 1 spot? Lol

I think it's safer to delete the entire record.

[worldslayer]

Hmm, I'm not sure. Have you tried it? I assume it would give you an error saying it cannot be 'NULL' or blank.

I guess if it did let you just delete the coords.. I don't know, all the Npcs would be floating around or all in 1 spot? Lol

I think it's safer to delete the entire record.

you could spawn them at some random off the map coordinate.

[latruwski]

you could spawn them at some random off the map coordinate.

if you do that with all creatures.. server will lagg hardcore

Just delete all entries from creature_spawns table
Creatures will still be in creature_names and proto tables but not spawned...