its a rather non-trivial task to do this, but it is doable none the less, and if done right, such a script could be quite valuable to the community.
Basically, such a script would need to look in the spawn tables to build a list of NPCs which need to be moved. From that point, it would load all spawn the relavent data from the database, re-ID all of the NPCs, and then update all of the data loaded to reflect the new NPC IDs. (please note that PEQ numbers all of their NPCs by zoneID such that their IDs will not conflict). Then the script would need to insert all of the data into the new database, re-IDing each row of each table.
Here is a list of tables which would need to be touched:
grid
grid_entries
lootdrop
lootdrop_entries
loottable
loottable_entries
merchantlist
npc_faction
npc_faction_entries
npc_types
spawn2
spawnentry
spawngroup
not to mention all of the other zone-specific data which is not really related to spawns such as doors and world objects.
|