That sounds like a great challenge - great timing - I just came back from a business trip where I learned some pretty cool sql stuff, so I'm pretty prepared for writing this add-on.
Replication of a zone requires the following workflow (i'm just thinking out-loud)
easy parts
/1/ Creation of a replicate new zone entry in 'zone' table -- pretty easy.
/2/ Assign a new zone-id number in that table, and new shortname
moderately hard parts
/3/ Find NPC's from the zone - easy query (I already have this one made)
/4/ Replicate these NPC's with new id's -easy to do
/4a/ Ability to "wipe" zone clean of npc or it's loot - easy
Hard part
/5/ Find spawngroups from the zone (easy) but create new spawngroups with original npc's - brutal to write, but doable
That's the hard part because of the many table dependencies there. I'm confident i can manage the code. New Spawngroups are needed so as to create a distinct, and not a relational copy.
Easy
/6/ Have it re-use (if needed) grids - easy no issue there
/7/ Remove loot table IDs from the new copy or to carry over the existing ones - easy sql
I'll prototype this today, and start a progress log.
This can definitely be used for any zone, and assist in zone npc building better.
GeorgeS
|