Page 1 of 1

1.123 live item DB

PostPosted: Tue Jul 11, 2017 11:17 pm
by ontheDOL
Disclaimer
This is not a working database for any dawn of light core revision. This is a database of parsed info from the .json file broadsword recently released http://www.dolserver.net/viewtopic.php?f=4&t=23199

This is just for infomation purposes , its a SQL database, so its more accessable for us to try and merge some data with a working DOL Database

Im about 95% sure i got all the data, but some items have a "random" fields (altought i think i got all of them)

download link
http://www.mediafire.com/file/s86rr3qgk ... eitemdb.7z

this is a separate DB to any dol DB so you should be able to import it as a new DB no problems.
Data on 18901 items

I take no responsibility for anything :D

edit# added datakey file which shows what the values mean

Re: 1.123 live item DB

PostPosted: Wed Jul 12, 2017 8:05 am
by HunabKu
Thanks for this work Unty !

Re: 1.123 live item DB

PostPosted: Wed Jul 12, 2017 12:02 pm
by Graveen
/worship :)

Re: 1.123 live item DB

PostPosted: Wed Jul 12, 2017 8:01 pm
by ontheDOL
attached in first post the metadata that was at bottom of file so people can see what the values represent :wink:

from what i can see, they didn't include data for what the "material" is referencing unfortunately

Re: 1.123 live item DB

PostPosted: Thu Jul 13, 2017 4:11 pm
by ontheDOL
well...i've been going through this data trying to find out what "material" number relates to what material name. I've found quite a few errors in the data (in the original .json)

for example, MP leather items dropped from high level ToA bosses 70 utility+ listed as 14 armor factor.... and salvaging for same material that torn leather from puny skeletons drops!

and 'Huldu Axe' ID 3131, and ID 20721, both different stats and salvage material.

So just a warning that not all the data broadsword provided is accurate! Im sure there is many more mistakes in here too!

Re: 1.123 live item DB

PostPosted: Sat Jul 15, 2017 9:12 am
by Graveen
Surely, this is BroadSword after all :D

Re: 1.123 live item DB

PostPosted: Thu Oct 19, 2017 8:14 am
by Xephor
I will not save this liveitemdb to my computer, I will not look to see what itemdatakey is! Man... Someone come save me