discrepancy between item.typeinfo.spellid and the spell collection

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.

 

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.

 

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.

 

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