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?
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:
Increases healing done by spells and effects by up to 18.
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. :)