From d59662a0ff4b78de82a0eae9a841045e5954909c Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Fri, 13 Aug 2010 01:42:23 +0000
Subject: Add missing filetypeid filter

---
 gentoobrowse/console/packageimport.xml | 1 +
 1 file changed, 1 insertion(+)

diff --git a/gentoobrowse/console/packageimport.xml b/gentoobrowse/console/packageimport.xml
index 82ab447..84872ed 100644
--- a/gentoobrowse/console/packageimport.xml
+++ b/gentoobrowse/console/packageimport.xml
@@ -17,6 +17,7 @@
 					(REGEXP_MATCHES(filename, '^[^/]+'))[1] AS cat,
 					(REGEXP_MATCHES(filename, '/(.+)-[0-9]'))[1] AS name
 				FROM files f
+				WHERE f.filetypeid = 1
 				GROUP BY cat, name) f LEFT OUTER JOIN filecache fc
 					ON fc.fileid = f.fileid AND fc.line = 8,
 					categories c
-- 
cgit v1.2.3