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 to get datacore requirements for t2 missiles (and other charges)
Author
Previous Topic Next Topic
murphinator
Deep Core Mining Inc.
Caldari State
#1 - 2012-07-05 04:41:04 UTC
Howdy,

I have a nice query that will pull datacore requirements for ships and modules, but I can't figure out how to do it for charges. Here's my query. I'm sure I'm missing something obvious...
SELECT it_material.typeID, it_material.typeName, ram.quantity, it_product.typeName
FROM dbo_invTypes AS it_material INNER JOIN (dbo_ramTypeRequirements AS ram INNER JOIN (dbo_invTypes AS it_product INNER JOIN dbo_invBlueprintTypes AS bp
ON it_product.typeID = bp.productTypeID) ON ram.typeID = bp.blueprintTypeID) ON it_material.typeID = ram.requiredTypeID
WHERE ram.quantity>1 AND ram.activityID=8 AND it_product.typeID=578;
the above produces:
20171 Datacore - Hydromagnetic Physics 2 Adaptive Invulnerability Field I
20414 Datacore - Quantum Physics 2 Adaptive Invulnerability Field I

tia for your help

-murph
Louis Vitton
Viziam
Amarr Empire
#2 - 2012-07-06 05:56:11 UTC  |  Edited by: Louis Vitton
These querys are for the t1 products that invent those t2 ones - jsut reread ur querys sorry
I use this query for findin the datacores

Quote:
SELECT invtypes.typeName
, ramtyperequirements.requiredTypeID
, ramtyperequirements.quantity
, ramtyperequirements.damagePerJob
, ramtyperequirements.recycle
, invtypes.groupID
, ramtyperequirements.typeID
FROM
invtypes invtypes
INNER JOIN ramtyperequirements ON invtypes.typeID = ramtyperequirements.requiredTypeID
INNER JOIN invblueprinttypes ON invblueprinttypes.blueprintTypeID = ramtyperequirements.typeID
WHERE
ramtyperequirements.activityID = 8
AND invblueprinttypes.productTypeID = ?????
AND invtypes.published = 1
ORDER BY invtypes.groupID


I use this query for the items that this item can invent

Quote:
SELECT invtypes.typeName, invtypes.typeID
FROM
invblueprinttypes
INNER JOIN invmetatypes ON invblueprinttypes.productTypeID = invmetatypes.parentTypeID
INNER JOIN invtypes ON invmetatypes.typeID = invtypes.typeID
WHERE
invblueprinttypes.productTypeID = ?????????
AND invtypes.published = 1
AND invmetatypes.metaGroupID = 2
GROUP BY invtypes.typeName


Where the ? are is the type id of the product
murphinator
Deep Core Mining Inc.
Caldari State
#3 - 2012-07-07 05:22:04 UTC
You are the man!

I had invMetaTypes completely missing from the equation.

Thanks!
-murph