Item DB , Excel File

[whria78]

This is Item DB , Excel File.

It would be helpful to correct the item options , if someone make transfer tool.

Item bonus data

item_20150112.xls

(13.79 MiB) Downloaded 402 times

Item spell data

item_spell.xls

(812.5 KiB) Downloaded 313 times

Item data, raw

item4.zip

mysql dump file

(1.29 MiB) Downloaded 316 times

[Leodagan]

I don't know what you expect as "transfer tool" but the XML Auto Update Package can easily handle data objects records that have a unique primary key (which item table is, with "id_nb")

http://www.dolserver.net/viewtopic.php?f=5&t=22294

[whria78]

To make database is very boring job.

So, I have tried to make automation tool to collect and fix item DB.

The data I uploaded are extracted from http://camelot.allakhazam.com/

It's correct DB but, as you said, it need to connect itemname to "id_nb" of DOLSERVER.

[Leodagan]

Yes this a totally different subject to "shape" data from another source !

I don't think we have any tools for this matter...

[whria78]

Here I made translator tool, " Allakhazam to Dolsever SQL DB " ... I named it ZamToSQL

http://daoc.dynu.com/control


It generate SQL query for update or create Dolserver DB.

I attached all result data generated from around 35000 allakhazam items.

whria_zam.zip

SQL Result Collections

(5.37 MiB) Downloaded 79 times

Because there are similar bonus-type names ( "focus" and "skill" ) , some misinterpretation may exist, but it is helpful to fix the item DB.

ps)

I attached zam.zip , php script to get info from allakazam. but the script is extremely messed because I thought it would be very small project at start, but grow up grow up.. messed messed.

[Graveen]

thank you ! although the model is not precise, this could totally be a good start for livelike servers.

for me your database is full of html. I think the parse is not correct.