View Single Post
  #1  
Old 06-13-2009, 12:12 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote