These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

How do I determine racial decryptor type required for an item [Eve DB dumps]?
Author
Previous Topic Next Topic
Maasu
Project Manhattan
#1 - 2012-05-02 15:37:24 UTC  |  Edited by: Maasu
I've been currently looking at the eve db dumps tables and I'm currently stuck in finding a way to determine what racial decryptor can be used on inventing certain tech 1 bpc's.

I know there is invType.raceID column but this is often null.

Any answers would be most welcome.

ex member of Curse Alliance, The Five, Fatal Alliance.
Ydnari
Estrale Frontiers
#2 - 2012-05-03 00:00:35 UTC
Look for an Interface in ramTypeRequirements for the invention activity on the T1 blueprint, and look up the decryptorID attribute on it, this points to the group containing the relevant decryptors.

e.g.

select t.typeName, g2.groupName, t2.typeName
from invGroups g
join invTypes t on (g.groupID = t.groupID)
join dgmTypeAttributes ta on (t.typeID = ta.typeID)
join dgmAttributeTypes at on (ta.attributeID = at.attributeID)
join invGroups g2 on (ta.valueInt = g2.groupID)
join invTypes t2 on (g2.groupID = t2.groupID)
where g.groupName = 'Data Interfaces'
and at.attributeName = 'decryptorID'
order by t.typeName, t2.typeName;

output too big for forum post, see http://pastebin.com/Psq5DkA2

--
Ydnari
Estrale Frontiers
#3 - 2012-05-03 00:11:07 UTC
or for a specific blueprint:

select tbpc.typeName, t.typeName, g2.groupName, t2.typeName
from invTypes tbpc
join ramTypeRequirements rtr on (tbpc.typeID = rtr.typeID)
join invTypes t on (rtr.requiredTypeID = t.typeID)
join invGroups g on (t.groupID = g.groupID)
join dgmTypeAttributes ta on (t.typeID = ta.typeID)
join dgmAttributeTypes at on (ta.attributeID = at.attributeID)
join invGroups g2 on (ta.valueInt = g2.groupID)
join invTypes t2 on (g2.groupID = t2.groupID)
where tbpc.typeName = 'Covetor Blueprint'
and rtr.activityID = 8
and g.groupName = 'Data Interfaces'
and at.attributeName = 'decryptorID'
order by t.typeName, t2.typeName;

+-------------------+-------------------------------+-----------------------+------------------------+
| typeName | typeName | groupName | typeName |
+-------------------+-------------------------------+-----------------------+------------------------+
| Covetor Blueprint | Incognito Ship Data Interface | Decryptors - Gallente | Collision Measurements |
| Covetor Blueprint | Incognito Ship Data Interface | Decryptors - Gallente | Engagement Plan |
| Covetor Blueprint | Incognito Ship Data Interface | Decryptors - Gallente | Stolen Formulas |
| Covetor Blueprint | Incognito Ship Data Interface | Decryptors - Gallente | Symbiotic Figures |
| Covetor Blueprint | Incognito Ship Data Interface | Decryptors - Gallente | Test Reports |
+-------------------+-------------------------------+-----------------------+------------------------+
5 rows in set (0.00 sec)

--
Maasu
Project Manhattan
#4 - 2012-05-03 19:25:05 UTC
Thanks, that works perfectly! :)

ex member of Curse Alliance, The Five, Fatal Alliance.