- Registered User
Member for 14 years, 5 months, and 5 days
Last active Sat, Dec, 30 2017 17:26:57
- 0 Followers
- 146 Total Posts
- 0 Thanks
Apr 5, 2006Posted in: General ChatQuote from tekkub »
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:
Thefore an enchantment ID != a spell effect ID (or so it seems).
Apr 4, 2006Okay, 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.Posted in: General Chat
To see what I'm talking about:
Hope the question makes sense. :)
Apr 4, 2006Okay, completely non-Ace question. Hell, completely non-addon-coding question. :)Posted in: General Chat
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.)
- To post a comment, please login or register a new account.