Mercurial > hg > reproctool-df
comparison 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 |
comparison
equal
deleted
inserted
replaced
10:de10d02dc715 | 11:f749981ad862 |
---|---|
63 SUM(CASE WHEN m1.requiredTypeID = 38 THEN m1.quantity ELSE 0 END), -- [Nocxium] | 63 SUM(CASE WHEN m1.requiredTypeID = 38 THEN m1.quantity ELSE 0 END), -- [Nocxium] |
64 SUM(CASE WHEN m1.requiredTypeID = 39 THEN m1.quantity ELSE 0 END), -- [Zydrine] | 64 SUM(CASE WHEN m1.requiredTypeID = 39 THEN m1.quantity ELSE 0 END), -- [Zydrine] |
65 SUM(CASE WHEN m1.requiredTypeID = 40 THEN m1.quantity ELSE 0 END), -- [Megacyte] | 65 SUM(CASE WHEN m1.requiredTypeID = 40 THEN m1.quantity ELSE 0 END), -- [Megacyte] |
66 SUM(CASE WHEN m1.requiredTypeID = 11399 THEN m1.quantity ELSE 0 END) -- [Morphite] | 66 SUM(CASE WHEN m1.requiredTypeID = 11399 THEN m1.quantity ELSE 0 END) -- [Morphite] |
67 FROM invTypes types | 67 FROM invTypes types |
68 INNER JOIN dgmTypeAttributes attrs ON types.typeID = attrs.typeID AND attrs.attributeID = 633 | 68 LEFT JOIN dgmTypeAttributes attrs ON types.typeID = attrs.typeID AND attrs.attributeID = 633 |
69 INNER JOIN typeActivityMaterials m1 ON types.typeID = m1.typeID | 69 INNER JOIN typeActivityMaterials m1 ON types.typeID = m1.typeID |
70 INNER JOIN invGroups groups ON types.groupID = groups.groupID | 70 INNER JOIN invGroups groups ON types.groupID = groups.groupID |
71 INNER JOIN eveGraphics graphics ON types.graphicID = graphics.graphicID | 71 INNER JOIN eveGraphics graphics ON types.graphicID = graphics.graphicID |
72 WHERE $sql_typenames | 72 WHERE $sql_typenames |
73 GROUP BY types.typeID | 73 GROUP BY types.typeID |
74 ORDER BY groupName ASC, typeName ASC | 74 ORDER BY groups.categoryID DESC, groupName ASC, typeName ASC |
75 END | 75 END |
76 my $pre_reprocess = $db->prepare($sql_reprocess); | 76 my $pre_reprocess = $db->prepare($sql_reprocess); |
77 | 77 |
78 # Execute, bring back one row per item | 78 # Execute, bring back one row per item |
79 my ($tid, $tname, $gname, $meta, $basePrice, $icon, | 79 my ($tid, $tname, $gname, $meta, $basePrice, $icon, |