Mass Spawning Question

[Xmaily]

Hey Ownedcore,

I come to you today with a some what weird question and I'm hoping that someone will have an answer!

A while back i didn't think I was going to use Orgrimmar for anything so I deleted all the npcs from that area. However, now I want players to attack Orgrimmar. I still have the creature_names, proto, and all that stuff but I'm wondering If there is a way that I can respawn all those npcs that i originally deleted from the city. I quickly compiled a 3.3.5a repack and added a fresh dbc to it so I could see the spawns in Orgrimmar. My plan was to take these spawns and copy it to my server, however, Arcemu doesn't track creatures through Zone Id's it only tracks creatures through Map Id's does anyone know how I can spawn all the creasture back into orgrimmar without me being OCD and sitting there for hours on end making sure their facing the right direction, having the right weapon, and so on.

Thanks!

[stoneharry]

Well, as I've said before and will keep saying, stop using ArcEmu.

But essentially you want to identify which creatures are in the zone of Orgrimmar.

If we assume you have not reused the same creature GUID entry's of the creatures that have been deleted it would be as simple as retrieving the creature_spawns table as single line queries and then running that on your database.

edit: always make backups before you do anything even remotely like this.

[Xmaily]

Well, as I've said before and will keep saying, stop using ArcEmu.

But essentially you want to identify which creatures are in the zone of Orgrimmar.

If we assume you have not reused the same creature GUID entry's of the creatures that have been deleted it would be as simple as retrieving the creature_spawns table as single line queries and then running that on your database.

edit: always make backups before you do anything even remotely like this.

I do have backup Creature_Spawns but what query would I run to obtain all the npcs that are located in Orgrimmar?

[Xmaily]

pls respond <3

[stoneharry]

I do have backup Creature_Spawns but what query would I run to obtain all the npcs that are located in Orgrimmar?

See:

it would be as simple as retrieving the creature_spawns table as single line queries and then running that on your database.

Because duplicate GUID's will throw an error and thus the transaction will be rolled back for these. The GUID's that are non-existant in your database would then be implemented and you would gain all the Blizzlike creatures back.

Alternatively you can run a script to search the database, find each creature entity by GUID, and then check it's zone via the emulators API. Delete where zone matches Orgrimmar.