Item DB , Excel File

Share files with other Dawn of Light users

Moderator: Support Team

Item DB , Excel File

Postby whria78 » Mon Jan 12, 2015 12:09 pm

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 294 times


Item spell data
item_spell.xls
(812.5 KiB) Downloaded 221 times


Item data, raw
item4.zip
mysql dump file
(1.29 MiB) Downloaded 227 times
Last edited by whria78 on Mon Jan 12, 2015 12:31 pm, edited 1 time in total.
User avatar
whria78
Contributor
 
Posts: 128
Joined: Fri Sep 21, 2007 11:27 pm

Re: Item DB , Excel File

Postby Leodagan » Mon Jan 12, 2015 12:21 pm

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")

viewtopic.php?f=5&t=22294
User avatar
Leodagan
Developer
 
Posts: 1350
Joined: Tue May 01, 2012 9:30 am
Location: Lyon

Re: Item DB , Excel File

Postby whria78 » Mon Jan 12, 2015 12:34 pm

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.
User avatar
whria78
Contributor
 
Posts: 128
Joined: Fri Sep 21, 2007 11:27 pm

Re: Item DB , Excel File

Postby Leodagan » Mon Jan 12, 2015 1:15 pm

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

I don't think we have any tools for this matter...
User avatar
Leodagan
Developer
 
Posts: 1350
Joined: Tue May 01, 2012 9:30 am
Location: Lyon

Re: Item DB , Excel File

Postby whria78 » Tue Apr 14, 2015 3:07 pm

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 41 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. :(
Attachments
zam.zip
(14.85 KiB) Downloaded 30 times
User avatar
whria78
Contributor
 
Posts: 128
Joined: Fri Sep 21, 2007 11:27 pm

Re: Item DB , Excel File

Postby Graveen » Wed Apr 22, 2015 8:14 am

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.
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 12595
Joined: Fri Oct 19, 2007 9:22 pm
Location: France


Return to User Files

Who is online

Users browsing this forum: No registered users and 1 guest