I find myself needing to create a mysql database with the stats for around 300 items in it. Basically I need to to store the name of the item, plus the int, stamina, healing, crit, etc., each item has.
Entering all of those numbers manually would be rather a pain, so I thought I might ask - is anyone aware of any code floating around that could parse the item entries on, say, Allakhazam and return the stats? It shouldn't bee too hard to do, but it's a bit beyond my abilities, so I thought I might ask if someone had already solved this problem. :)
The eventual plan is to make a gear calculator for priests, where a user can enter in some assumptions about a fight, and the calculator will return a list of items sorted by how appropriate they'd be for the fight. (ie, high int items if the user asks about a short fight, high spirit items if the user asks about a longer one). I think I've got the calculations needed for ranking items down - all I really need is the items. :) Anyone got a suggestion?
Alla's pages have raw XML available for every item, perhaps that will be easiest for you? The other option would be to parse the stats out of item links, the details on the enchant IDs are on WoWWiki.
Okay, I'm about 90% of the way there. Question though - you mentioned enchant IDs, but I'm more interested in what I guess you'd call spell effect IDs (unsure of correct name). For example, Gloves of Prophecy have +6 mp5s on them which is spell effect 21626. Don't suppose you know of a list of those floating around? WoWWiki doesn't seem to have one.
Erm. I'm either being more retarded than is my wont, or you may have misunderstood my problem. :)
Gloves of Prophecy has the spell effect 21626, which happens to be +6 mp5s. 21626 is not found on that wiki page, and the enchantment IDs listed which give +6 mp5s are 2376, 2377, and 2378 - none of which are found on the gloves.
For another example, the gloves also have spell effect 9406, which happens to be +18 healing. 9406 does not appear on that wiki page, and the +18 healing enchant ID is 2314 (which isn't on the gloves).
I'm a bit hazy on the details, but as near as I can tell the two kinds of numbers refer to different things. Enchantment ID 2376 is listed on the wiki as +6 mp5s, but on Thottbot and Allakhazam, spell ID 2376 is listed as Lesser Intellect (+4 int for 1 hour). See:
<description>
Increases healing done by spells and effects by up to 18.
</description>
That's totally useless - it hasn't been parsed to determine the effect type and the effect ammount. :( I'm currently adding spells manually. I've picked up 83 so far - mostly +healing, mp5s, or +dmg, since the focus of my project is related to priests. When I'm done I'll post the info I've gathered somewhere so people don't have to duplicate the effort. :)
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
I find myself needing to create a mysql database with the stats for around 300 items in it. Basically I need to to store the name of the item, plus the int, stamina, healing, crit, etc., each item has.
Entering all of those numbers manually would be rather a pain, so I thought I might ask - is anyone aware of any code floating around that could parse the item entries on, say, Allakhazam and return the stats? It shouldn't bee too hard to do, but it's a bit beyond my abilities, so I thought I might ask if someone had already solved this problem. :)
The eventual plan is to make a gear calculator for priests, where a user can enter in some assumptions about a fight, and the calculator will return a list of items sorted by how appropriate they'd be for the fight. (ie, high int items if the user asks about a short fight, high spirit items if the user asks about a longer one). I think I've got the calculations needed for ranking items down - all I really need is the items. :) Anyone got a suggestion?
(Edited for clarity.)
...
It does! ZOMG! How did I miss that?
Thanks Tek!
To see what I'm talking about:
http://wow.allakhazam.com/db/spell.html?wspell=21626
http://thottbot.com/?sp=21626
Hope the question makes sense. :)
Erm. I'm either being more retarded than is my wont, or you may have misunderstood my problem. :)
Gloves of Prophecy has the spell effect 21626, which happens to be +6 mp5s. 21626 is not found on that wiki page, and the enchantment IDs listed which give +6 mp5s are 2376, 2377, and 2378 - none of which are found on the gloves.
For another example, the gloves also have spell effect 9406, which happens to be +18 healing. 9406 does not appear on that wiki page, and the +18 healing enchant ID is 2314 (which isn't on the gloves).
I'm a bit hazy on the details, but as near as I can tell the two kinds of numbers refer to different things. Enchantment ID 2376 is listed on the wiki as +6 mp5s, but on Thottbot and Allakhazam, spell ID 2376 is listed as Lesser Intellect (+4 int for 1 hour). See:
http://wow.allakhazam.com/db/spell.html?wspell=2376
http://thottbot.com/?sp=2376
Thefore an enchantment ID != a spell effect ID (or so it seems).
However, wowguru.com also has XML data for items, and the spell effects *are* included in that data. Of course, Allakhazam has more data...
Let me know if you figure out a way to get at the Allakhazam spell data!
http://www.wowguru.com/db/syndicate/spells/increase-healing-18-id9406.xml
Closest it gets:
That's totally useless - it hasn't been parsed to determine the effect type and the effect ammount. :( I'm currently adding spells manually. I've picked up 83 so far - mostly +healing, mp5s, or +dmg, since the focus of my project is related to priests. When I'm done I'll post the info I've gathered somewhere so people don't have to duplicate the effort. :)