Live Item DB

[MrPickles]

Looks like live made their item database public yesterday. It excludes trash loot but still loads of goodies:
Enjoy

http://www.darkageofcamelot.com/content ... m-database

[Sharp]

Looks like live made their item database public yesterday. It excludes trash loot but still loads of goodies:
Enjoy

http://www.darkageofcamelot.com/content ... m-database

Greetings,
Very interesting! Thank you for share this (will check after job for sure!)
Regards

[Leodagan]

I saw this during my lunch break today

This is a great news, and I started browsing the data, this is a Wonderful asset for DOL !

Not only this contains most equippable items but there is some other data coming with each items that could be useful to us :

• Items comes with their Material "Id" (which is probably linked to Craft Material "Id") and a Salvage Count !
  This means we could make salvage working live-like really easily !
• Items have "sources" data which list mob dropping the item, quests rewarding the Item or merchant selling the Item !
• The Delve Text is embedded with each item, which will be useful to make sure Spell Effect match their description
• Maybe other data that could be useful like icon Id, sell value, cannot be dropped, cannot be sold, etc...

We'll finally have an up to date source of Item Data without lurking ZAM, bdodaoc and other old fan-sourced websites

[MrPickles]

Looks like live made their item database public yesterday. It excludes trash loot but still loads of goodies:
Enjoy

http://www.darkageofcamelot.com/content ... m-database

Greetings,
Very interesting! Thank you for share this (will check after job for sure!)
Regards

Been chomping at the bit all day at work to get home and start playing with this data. Why must we have day jobs

[ontheDOL]

so, here is a little "teaser" i guess.
I parsed some of the data if anyone wants to take a look. It's a sql database with just one table with some of the data.

I will probably try to parse the whole lot when i have time to figure out parsing sub-arrays

#edit, removed link, full parsed file available here http://www.dolserver.net/viewtopic.php?f=63&t=23203

[Graveen]

In C#, you have the nuget package newtonsoft.json

[ontheDOL]

thanks, though i'm actually using a php script to parse the data and sql insert.. I think i've got it figured out, i'll post the completed DB in user files later when i find a host

[Leodagan]

I think you can parse JSON with a YAML parser if I'm not mistaken

You should try Yaml.Net for C#, I contributed to the library and it's pretty straightforward to use

I know that PHP can be so easy to handle some input data to forward to a database, but writing a parser in C# that only output a SQL file containing insert statement should be as easy (ADO.NET will be way harder than PHP database access...), then import the output in a database (any type of database...), and can be a fun exercise to improve C# skills

Tell me if you give it a try

[ontheDOL]

this would have been nice a few days ago! hehe
I already finished the file with a php script, which was kinda cool to check out a little how php works.

Although i can definitely say I prefer c# ! and will check out this avenue if something like this comes up again

[Loki]

I knocked something up to help with this.

Check it out.

Jay

http://www.dolserver.net/viewtopic.php?f=63&t=23207