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.
 

Help with a MySQL query for reprocessing t2 items
Author
Previous Topic Next Topic
Sergie Wallbanger
Deep Core Mining Inc.
Caldari State
#1 - 2012-04-26 20:35:14 UTC
Ive been playign with this query from the dev wiki

Quote:
SELECT
t1.typeID,
t1.typeName,
coalesce(t2.valueFloat, t2.valueInt) AS metalevel,
t1.groupID,
t3.groupName,
t1.volume,
t1.basePrice,
SUM(CASE WHEN m1.materialTypeID = 34 THEN m1.quantity ELSE 0 END) AS Tritanium,
SUM(CASE WHEN m1.materialTypeID = 35 THEN m1.quantity ELSE 0 END) AS Pyerite,
SUM(CASE WHEN m1.materialTypeID = 36 THEN m1.quantity ELSE 0 END) AS Mexallon,
SUM(CASE WHEN m1.materialTypeID = 37 THEN m1.quantity ELSE 0 END) AS Isogen,
SUM(CASE WHEN m1.materialTypeID = 38 THEN m1.quantity ELSE 0 END) AS Nocxium,
SUM(CASE WHEN m1.materialTypeID = 39 THEN m1.quantity ELSE 0 END) AS Zydrine,
SUM(CASE WHEN m1.materialTypeID = 40 THEN m1.quantity ELSE 0 END) AS Megacyte,
SUM(CASE WHEN m1.materialTypeID = 11399 THEN m1.quantity ELSE 0 END) AS Morphite
FROM invTypes t1
INNER JOIN dgmTypeAttributes t2 ON t1.typeID = t2.typeID AND t2.attributeID = 633 AND t1.published = 1 AND t2.valueInt IN (0, 1, 2, 3, 4) -- metaLevel
INNER JOIN invGroups t3 ON t1.groupID = t3.groupID
INNER JOIN invTypeMaterials m1 ON t1.typeID = m1.typeID
GROUP BY
t1.typeID,
t1.typeName,
coalesce(t2.valueFloat,t2.valueInt),
t1.groupID,
t3.groupName,
t1.volume,
t1.basePrice
ORDER BY t1.typeName;



This only works for t1 items and i need it to work for tech 2 aswel
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-04-26 20:55:35 UTC
tip for you. Tech 2 is meta 5. try adding it to the list of meta levels in there.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter