Parsing Raw Item Data
 

My question is this. I have a database of all the raw item data off of Lucy and I was wondering exactly how race, class, and equippable slots are assigned to an item. Say I wanted to dig through the database and return only <insert class here> usable items and if it is equippable in <insert slot here>. Most of the rest of the raw data is self explanatory.

Much thanks in advance for responses. :D

How exactly did you manage to get thier database? Lucy only provides dumps of the spells "database." And all they're doing there is giving you the spells_us.txt file as a DB.

As long as it's something that you aquired legally, then I'd love to get my pads. . . err HANDS on a copy!

As for the class thing. . .
In the items table, the class is actually determined by a bit being turned on. For example, a Paladin is (in binary) "00000100" or (in decimal) "4." All you have to do is check the corresponding bit. if it's a "1", then that class can wear it, if it's a "0" then they can't (if an item had "5" - "00000101" in binary - in the class field, then it would be wearable by both Pallys - class "00000100" or "4" - and Warriors - class "00000001" or "1".

As for slos. . .
I haven't looked into those too much yet so I can't help ya there. I would assume it's set up in a similar fashion though.

To get all the raw item data I scraped the site. Lucy organizes it's database such as:

• http://lucy.allakhazam.com/itemraw.html?id=1001
  http://lucy.allakhazam.com/itemraw.html?id=1002
  http://lucy.allakhazam.com/itemraw.html?id=1003

etc.,

So I just used a program that grabbed the html source for each item's raw data and parsed the HTML into a database file the has the raw data listed such as:

Now I just need to parse that out so that I can return items that are usable by a certain class and filter out which slot(s) the item is assigned to.

Btw, what would the value be assigned to for usable classes? I see race, which is self-explanatory, and I see slots, which is self-explanatory (although I don't understand the algorythm for it yet), but I just need a little help figuring out how to parse it all.

Thanks again for any responses.

Okay, with a little help I was able to figure out race/class, but I'm still confused with the slots field. According to a post on eqbeastlord forums, slots are assigned using the following method. The problem is, the other two use binary. People on the eqbeastlord forums originally thought that the value in the slots field determined proc rate (such as normal proc vs. high proc rate, such as the cleric summoned hammer), which is false, and the author of the post suggests that:

He then continues to give examples of the slot values in whatever form he is using (whatever his 'h' suffix suggests; I'm not thinking it's hex, I'm not sure though). I have simplified his slot values into a table (Please forgive the sloppiness. I had it formatted all pretty, but I couldn't copy the formatting :?):

Now what I guess I need to know is if those values are actually converted to binary to determine what slots the item is allowed or just how exactly. Also, he had a single field labelled "Finger" and it's value it "018000" that doesn't seem to follow the pattern, so it seems as though that would be wrong.

Thank you for any help :D

The EQEMu source code says this:

I have yet to really decipher what that means though. I'll post here later this evening with what I find. . .

I don't think that has to do with designating what fields an item can go in, but instead is the actual slot you see in the inventory. I don't know how else to describe it.

It's the location of the "active bit" actually.

Arms = 7

That means that something that can be put in ONLY that slot would have a value of "000000000000001000000" (binary) or 128 (decimal). I'll go ahead and build a chart up for these slots (after I do a little more verifying) later tonight.

Thank you very much :)