# HG changeset patch
# User Dominic Cleal <dominic@computerkb.co.uk>
# Date 1232890400 0
# Node ID f749981ad86289afc0654d6d6442762d6de85192
# Parent  de10d02dc7154f446197130a7304b8be2e9bbe4f
Fixes items with no metalevel attribute, improves sorting

diff -r de10d02dc715 -r f749981ad862 reproctool.cgi
--- 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);