Auto XML Public Database Package

[Leodagan]

For those that want to Load the Public Database throuh XML Auto Package provided in recent Revision (Revision 3408 - See Topic http://www.dolserver.net/viewtopic.php?f=5&t=22294)

I commited a small Experimental Export to Git : https://github.com/dol-leodagan/DOLAutoXMLPublic.git

Copy those files in your "./scripts/dbupdater/insert" directory, and all objects will be created at first launch...

If you'd like to edit some of these file for "reloading" after changes, I suggest you move some of them to "./scripts/dbupdater/replace" directory.

Be Careful when editing some of these file, there are objects that will not be able to match "duplicate", so trying to insert or replace any of these objects can and will result in duplicate (that include most linking table that aren't using a primary key, linexspell, mobs, merchantitem, npcequipement etc...)

Most Skills or Item tables should support unique fields for collision match and edit your records accordingly.

Remember even after errors Auto XML Updater will never run the same file Twice, watch for the AutoXMLUpdate Table for records of already played scripts !

This package is from Public Database version 3.1a, some data may be missing I made this quickly

This is best used for a fresh Shard start !!

• For other use case please merge your data from SQL import script and do a lot of backups and database copies...

[Eudes]

Hi Leo,

I do not find any xml for the serverproperty_category, is there one somewhere in your package?

Thanks

[Leodagan]

Yes I have one with some records in the Public DB... (24)

I'll export it to update the package

[Eudes]

Thanks! Anyway, the updater works well, really easy to import stuff in the database.

[Leodagan]

I updated the Git Repository with the serverproperty_category package.

[Graveen]

thanks, very usefull for using with DOLConfig.exe

[Eudes]

Hello Leo,

I added serverproperty_category.xml and now the DB is ok. But, there is nothing in the DOLConfig.exe tab. For your information, most of the database fields are using Storm as name.

Thanks for your help.
Eudes

[Leodagan]

Well for that part I never used DOLConfig, so I don't know what's expected in this table

Anyway they should be the same as actual public DB