if (array_key_exists('typeid',$_GET))
{
?>
Item | Quantity of Material | Volume of item | Compression Rate, units per m3 |
$sql='select prod.typeid typeid,prod.typeName name,quantity, prod.typename,prod.volume*prod.portionsize volume, quantity/(prod.volume*prod.portionsize) compression from invTypes mats,invTypeMaterials,invTypes prod,invBlueprintTypes bt left join dgmTypeAttributes on (bt.producttypeid=dgmTypeAttributes.typeid and attributeID=1692) where invTypeMaterials.materialTypeID=mats.typeID and mats.TypeID=? and invTypeMaterials.typeid=bt.producttypeid and prod.typeid=bt.producttypeid and bt.techLevel=1 and valueFloat is null and prod.published=1 and prod.typename not like "%II" and prod.typename not like "%Gas Cloud Harvester%" and prod.typename not like "%Deactivated Station Key Pass%" and prod.typename not like "%Large Micro Jump Drive%" order by compression desc limit 20';
$stmt = $dbh->prepare($sql);
$stmt->execute(array($typeid));
while ($row = $stmt->fetchObject()){
if ($row->compression>100)
{
echo "".$row->name." | ".$row->quantity." | ".$row->volume." | ".floor($row->compression)." |
";
}
}
?>
}
else
{
?>
This tool is still in the experimental stage. Needs to have blueprints with extra materials eliminated. Otherwise, it's just about right.
}
?>