Mercurial > hg > reproctool-df
diff reproctool.cgi @ 11:f749981ad862
Fixes items with no metalevel attribute, improves sorting
author | Dominic Cleal <dominic@computerkb.co.uk> |
---|---|
date | Sun, 25 Jan 2009 13:33:20 +0000 |
parents | de10d02dc715 |
children | 6d5296efb9ef |
line wrap: on
line diff
--- a/reproctool.cgi Sun Jan 25 13:14:07 2009 +0000 +++ b/reproctool.cgi Sun Jan 25 13:33:20 2009 +0000 @@ -65,13 +65,13 @@ SUM(CASE WHEN m1.requiredTypeID = 40 THEN m1.quantity ELSE 0 END), -- [Megacyte] SUM(CASE WHEN m1.requiredTypeID = 11399 THEN m1.quantity ELSE 0 END) -- [Morphite] FROM invTypes types -INNER JOIN dgmTypeAttributes attrs ON types.typeID = attrs.typeID AND attrs.attributeID = 633 +LEFT JOIN dgmTypeAttributes attrs ON types.typeID = attrs.typeID AND attrs.attributeID = 633 INNER JOIN typeActivityMaterials m1 ON types.typeID = m1.typeID INNER JOIN invGroups groups ON types.groupID = groups.groupID INNER JOIN eveGraphics graphics ON types.graphicID = graphics.graphicID WHERE $sql_typenames GROUP BY types.typeID -ORDER BY groupName ASC, typeName ASC +ORDER BY groups.categoryID DESC, groupName ASC, typeName ASC END my $pre_reprocess = $db->prepare($sql_reprocess);