1. I have corrected the e-mail settings so that outgoing e-mails from these forums should be sent now. If you tried to Register or Reset your Password, please try again!
    Dismiss Notice

discrepancy between item.typeinfo.spellid and the spell collection

Discussion in 'Census: General Discussion' started by Quicktiger, Feb 9, 2012.

  1. Quicktiger

    Quicktiger Guest

    Items which are spells have a typeinfo.spellid field, which I expected to be set to the spell's ID and could be directly looked up in the spell collection.  However, this does not seem to be the case.  Instead, it seems to point to the spell.crc value rather than the spell.id value.

    Here is a listing of the spellid values for 6 Troubador spells, all of the same name.  All the values happen to be the same, which is no real surprise since it's mapping to the CRC not the ID.

    --- names ---

    irb(main):074:0> Item.where("displayname like 'Chaos Anthem III%'").map(&:displayname)

    => ["Chaos Anthem III (Master)", "Chaos Anthem III (Expert)", "Chaos Anthem III (Adept)", "Chaos Anthem III (Apprentice)", "Chaos Anthem III (Journeyman)", "Chaos Anthem III (Apprentice)"]

    --- spellid ---

    irb(main):073:0> Item.where("displayname like 'Chaos Anthem III%'").map(&:typeinfo_spellid)

    => [46715233, 46715233, 46715233, 46715233, 46715233, 46715233]



    Using this query census.daybreakgames.com/yaml/get/eq2/spell/?crc=46715233&c:limit=100&c:show=tier_name,crc,id,name shows the list of spells which have this CRC.

     
  2. feldon30

    feldon30 Guest

    spellcrc is a wonderful thing. I'm not entirely sure this needs to change to a raw spellid although maybe there is a detail that I'm not grasping.
     
  3. Dethdlr

    Dethdlr Guest

    spellcrc should tie them all together.  Tier separates them out to their individual spell.  spellcrc + tier is basically the id.  Not adding them, but the two together are basically the primary key I believe.

     
  4. Quicktiger

    Quicktiger Guest

    If it is spell crc, then it should be called "spellcrc" not "spellid"  :)

     

Share This Page