aboutsummaryrefslogtreecommitdiff
path: root/src/vgstash/__init__.py
diff options
context:
space:
mode:
Diffstat (limited to 'src/vgstash/__init__.py')
-rwxr-xr-xsrc/vgstash/__init__.py6
1 files changed, 4 insertions, 2 deletions
diff --git a/src/vgstash/__init__.py b/src/vgstash/__init__.py
index 48ac055..d28e587 100755
--- a/src/vgstash/__init__.py
+++ b/src/vgstash/__init__.py
@@ -23,7 +23,8 @@ OWNERSHIP = {
'unowned': 0,
'physical': 1,
'digital': 2,
- 'both': 3
+ 'both': 3,
+ 'member': 4
}
DEFAULT_CONFIG = {
@@ -40,9 +41,10 @@ FILTERS = {
'digital': "SELECT * FROM games WHERE ownership = 2 ORDER BY system, title ASC",
'done': "SELECT * FROM games WHERE progress > 2 ORDER BY system, title ASC",
'incomplete': "SELECT * FROM games WHERE progress = 3 AND ownership > 0 ORDER BY system, title ASC",
+ 'members': "SELECT * FROM games WHERE ownership = 4 ORDER BY system, title ASC",
'new': "SELECT * FROM games WHERE progress = 1 ORDER BY system, title ASC",
'notes': "SELECT * FROM games WHERE notes NOT LIKE '' ORDER BY system, title ASC",
- 'owned': "SELECT * FROM games WHERE ownership > 0 ORDER BY system, title ASC",
+ 'owned': "SELECT * FROM games WHERE ownership > 0 AND ownership < 4 ORDER BY system, title ASC",
'physical': "SELECT * FROM games WHERE ownership = 1 ORDER BY system, title ASC",
'playlog': "SELECT * FROM games WHERE ownership > 0 AND progress = 2 ORDER BY system, title ASC",
'unowned': "SELECT * FROM games WHERE ownership = 0 ORDER BY system, title ASC",