From 281b71a52302c6645fd0317d44754616ee21f0d1 Mon Sep 17 00:00:00 2001 From: raylu Date: Sun, 9 Sep 2012 14:02:41 -0700 Subject: filter out faction items --- manufacturing.py | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/manufacturing.py b/manufacturing.py index f3ee03d..3a2ac4e 100755 --- a/manufacturing.py +++ b/manufacturing.py @@ -26,9 +26,16 @@ def get_systemid(name): def iter_blueprints(): curs = conn.cursor() try: + # metaGroupID's: + # NULL or 1: Tech I + # 2: Tech II + # 14: Tech III + # filtering for these excludes storyline (3), faction (4), officer (5), and deadspace (6) curs.execute(''' SELECT b.productTypeID, t.typeName FROM invBlueprintTypes as b INNER JOIN invTypes AS t ON b.productTypeID = t.typeID + LEFT JOIN invMetaTypes AS m ON m.typeID = b.productTypeID + WHERE m.metaGroupID IS NULL or m.metaGroupID in (1,2,14) ''') while True: r = curs.fetchone() -- cgit v1.2.3