Advanced Armor Layering

[Black_Madness]

ol

I am running the following query to get back groups and skills:

  SELECT 
       t."typeID",
       t."typeName",
       g."groupID",
       g."groupName"
  FROM "invTypes" t
  JOIN "invGroups" g ON g."groupID" = t."groupID"
  JOIN "invCategories" c on c."categoryID" = g."categoryID"
  WHERE g."categoryID" = 16      -- The “Skill” category
  AND t."published" = true     -- Optional: only published skills
  ORDER BY g."groupName" asc;

I cannot find the Advanced Armor Layering in the results. Where is that skill ? I might be missing something…

Thanks

[EC_Trade_NPSI]

You’re pulling this data from a source - is the source up-to-date?

EC Trade

It’s present in the current SDE under category 16 (skills) and is published, so if it’s in the db you’re trying to pull that data from, it should load.

[Black_Madness]

Uh, interesting, I am using fuzzworks dump. Is it still a valid source ?

[Namdor]

Advanced armor layering is a very new skill and the most recent fuzzworks SDE export is from July. The latest SDE is available at Static Data - EVE: Developers but you’ll have to convert it yourself.