EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   Export Zone data from DB (https://www.eqemulator.org/forums/showthread.php?t=40171)

jpyou127 11-12-2015 02:50 PM

Export Zone data from DB
 
I am wondering if there is a way to export the zone data from a DB. Everything that makes the zone work: doors, objects, NPCs, etc.. into an SQL file that could be imported into another DB.


Celestial

Akkadius 11-12-2015 04:29 PM

Quote:

Originally Posted by jpyou127 (Post 244982)
I am wondering if there is a way to export the zone data from a DB. Everything that makes the zone work: doors, objects, NPCs, etc.. into an SQL file that could be imported into another DB.


Celestial

No

/10char

Shendare 11-12-2015 04:37 PM

Right. No-one's written a program to go through all the tables and package up their contents by individual zones. Things like NPCTypes, SpawnGroups, Spawn2 locations, interact in a way that makes separating out by zone a complicated endeavor.

Akkadius 11-12-2015 04:41 PM

http://www.eqemulator.org/forums/sho...ight=universaL

Shendare 11-12-2015 04:43 PM

Awesome! So it's been on the radar, just hasn't been able to be done yet.

jpyou127 11-12-2015 05:08 PM

Yep that would be awesome!!

Celestial

N0ctrnl 11-13-2015 10:06 PM

I actually do this all the time using the zone import/export tool in EoC. As part of the operations, it prints what it's done at the bottom of the page. You can use that inserted into a fresh DB to get what you're after.

Edit: It is worth noting that loot tables don't get exported, so that's a thing.


All times are GMT -4. The time now is 08:48 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.