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.
 

DB DUMP > Select possible decryptors
Author
Previous Topic Next Topic
Tek Handle
Vanishing Point.
The Initiative.
#1 - 2012-01-15 07:45:28 UTC

Hey, I wonder how to select possible decryptors according to a t2 blueprint id from the static (mysql) db dump.

I found this thread in the old forums, but I guess the db structure has changed in the meantime.

http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1057216
Talos Katuma
Helion Production Labs
Independent Operators Consortium
#2 - 2012-01-15 10:29:22 UTC
The query updated to the new DB structure:

SELECT *
FROM ramTypeRequirements t, dgmTypeAttributes a, invTypes d
WHERE t.typeID =984
AND t.activityID =8
AND a.typeID = t.requiredTypeID
AND d.groupID = a.valueInt
AND a.attributeID =1115
Tek Handle
Vanishing Point.
The Initiative.
#3 - 2012-01-15 18:05:35 UTC

Cheers! \o/