Mercurial > hg > reproctool-df

comparison reproctool.cgi @ 11:f749981ad862

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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,