database extraction

General discussion on Budabot.
Assx
Member
Posts: 11
Joined: Fri May 27, 2016 11:48 am
antispam: Rimor

database extraction

Postby Assx » Wed Mar 08, 2017 1:01 pm

Maybe someone could help me creating a tool which can ectract not only items and nanos but also perks AND icons.

Once I got that I would like to start a project like auno.org. Too bad, that it's out of date.
Tyrence
The Team
Posts: 1875
Joined: Sat Jan 09, 2010 1:32 am

Re: database extraction

Postby Tyrence » Thu Mar 09, 2017 1:28 am

Xyphos made his XRDB util available to anyone that wants it. You may want to read through it to see how it is handling things. Also, there is http://aodevs.com/forums/ which has some topics on it. Additionally, I have open-sourced the code for the Budabot Items Extractor. The code related to reading the rdb files is in the com.jkbff.ao.itemsextractor.rdb package (see: https://github.com/Budabot/ItemsExtract ... ractor/rdb).

The db files are in "\Anarchy Online\cd_image\data\db". Currently, these are the files there are: ResourceDatabase.idx, ResourceDatabase.dat, ResourceDatabase.dat.001, ResourceDatabase.dat.002. The idx file is an index file. It has a list of all the item ids, and the offset of the item values. So if you are looking for item with id 534334, and the idx file says the offset is at 1033044, then you would go to that position in ResourceDatabase.dat and that's where you find all the values pertaining to that item. If the offset is past the end of the first file, it goes to the second, and then the third file. The code for reading the idx file is here: https://github.com/Budabot/ItemsExtract ... /rdb/index

Once you have the records from the idx file, you can start to read the actual item values. This file describes how to read an item from the files: https://github.com/Budabot/ItemsExtract ... ctor.scala Note that it is not completely implemented. You may have to do some trial and error to figure out what the values mean.

I guess that is a good start for now. Let me know if you have questions.
"Those who expect to reap the blessings of freedom, must, like men, undergo the fatigues of supporting it." — Thomas Paine
"Nearly all men stand adversity, but if you want to test a man's character, give him power." — Abraham Lincoln
Budabot Releases and Downloads: https://github.com/Budabot/Budabot/releases

Return to “General Discussion”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest