How to despawn every creature in world?

[svarder]

Hello!

I was woundering if there is a command or something to despawn ALL creatures in the world?
Im using MaNGOS, with trinity core. I've tried to delete the creature table but I still need some creatures from that table. There has to be a easier way. Any help would be aprecciated!

[Blackboy0]

Go into creature_spawns (or the equivalent of it, for MaNGOS) and then create a SQL that will DELETE creature_spawns WHERE id LIKE '1' THROUGH '900000000' or something. That is sort of PHP and SQL mixed together, so that won't work :P I'm in a rush xD

[Wheeze201]

Go to your navicat or whatever you're using as a SQL manager and then open up creature_spawns table.

Now select the first entry at the top ( by pressing the arrow to the left ) scroll down to the bottom and hold down shift and click at the bottom entry. Now you've selected all entries on that one page. Hit delete and click ok.

Now repeat until no entries exsist in the creature_spawns table.

[svarder]

Go to your navicat or whatever you're using as a SQL manager and then open up creature_spawns table.

Now select the first entry at the top ( by pressing the arrow to the left ) scroll down to the bottom and hold down shift and click at the bottom entry. Now you've selected all entries on that one page. Hit delete and click ok.

Now repeat until no entries exsist in the creature_spawns table.

Thanks for answer, but i only have these tables that includes the frase "spawn" :

creature_respawn
gameobject_respawn

If I delete the entries in these tables will it have the same affect?

Edit: I tried to delete every entry in creature_respawn, creatures was still there.

[Wheeze201]

Well are you sure you deleted them in the right DB and you do know you need to restart the server for things to take effect.

Oh and leave gameobject_spawn ( it said respawn in your post.. maybe it's different for mangos ) alone.

[svarder]

Yes I know.

It's _respawn and it doesnt work.

[Vindicated]

Also make sure you save your database after making these changes. Then re-boot your server.

[LJN]

lol. Just trunacate your creature_spawns table. Its that simple.

[svarder]

lol. Just trunacate your creature_spawns table. Its that simple.

Have you read the thread?....

[gangstagreen]

lolz. I would suggest not do anything to the respawns table because that will only affect there "getting back up". If you delete it and then do massive killing you could succesfully destroy every creature. lolz