Items Database

Development forum for the EQ2Emulator Database project.

Moderator: Team Members

Post Reply
User avatar
Arremis
Retired
Posts: 388
Joined: Sun Sep 02, 2007 10:11 am
Location: Memphis, TN

Items Database

Post by Arremis » Sat Mar 22, 2008 2:48 am

I don't know if this will be of any use, but it's an item database for EQ2.
http://www.eq2idb.com

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Post by John Adams » Mon Mar 24, 2008 5:27 pm

I actually installed this, hoping it used a Jet DB back-end that I could simply open and read - but alas it is some off-the-wall obscure proprietary "bob's database" type thing that I couldn't take the time to figure out how to crack into.
If you have the tools and can get inside this DB, the info in there might be helpful. I just didn't have the patience.

chrrox
Content Designer
Posts: 177
Joined: Wed Oct 17, 2007 8:12 pm

Post by chrrox » Mon Mar 24, 2008 6:59 pm

we should be able to pull from the php search on the website. but the actual file format looks very basic just plain text with an item number to identify it.
I found out how to extract the database no problem :)
It uses absolute database 5
Its a free program :) http://www.soft32.com/Download/free-tri ... 405-3.html
I downloaded it renamed the dat file to an .abs and chose file open and bam I got the tables.
If you want the details or the files let me know..
Here are the extracted excel spreadsheets enjoy :)
http://rapidshare.com/files/102131596/Desktop.rar.html

User avatar
Arremis
Retired
Posts: 388
Joined: Sun Sep 02, 2007 10:11 am
Location: Memphis, TN

Post by Arremis » Tue Mar 25, 2008 3:17 am

WOOT I did something useful :D

LethalEncounter
Team: Zombie
Posts: 2717
Joined: Wed Jul 25, 2007 10:10 pm

Post by LethalEncounter » Tue Mar 25, 2008 2:39 pm

I loaded his database into mysql a while back. Eventually I will create a macro that will collect all the items from live.

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Post by John Adams » Tue Mar 25, 2008 3:43 pm

Thanks, chroxx, nice work. Yeah, absolute db... that's the name. Like there needs to be yet one more database type out there.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests