• 0

    posted a message on Item Databases
    Hmm, glad to hear someone else is running into the same problems, at least. :)
    Posted in: General Chat
  • 0

    posted a message on Item Databases


    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).
    Posted in: General Chat
  • 0

    posted a message on Item Databases
    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.

    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. :)
    Posted in: General Chat
  • 0

    posted a message on Item Databases
    They do? It does?

    ...

    It does! ZOMG! How did I miss that?

    Thanks Tek!
    Posted in: General Chat
  • 0

    posted a message on Item Databases
    Okay, completely non-Ace question. Hell, completely non-addon-coding question. :)

    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.)
    Posted in: General Chat
  • To post a comment, please or register a new account.