summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/ULists.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-12-21 10:53:32 +0100
committerYorhel <git@yorhel.nl>2010-12-21 10:53:32 +0100
commite77484d81461c322656615759ba77ea25713a8d6 (patch)
treeb750f8e165ead267bdd2fc4ad900f181997535cb /lib/VNDB/DB/ULists.pm
parent19e353c480091ec607324ee09a8821dd3d895975 (diff)
Added vnlists.status filter to /u+/list
Can only filter on one option. If there are more things to filter on it would make sense to use the filter selector, but for now this will do.
Diffstat (limited to 'lib/VNDB/DB/ULists.pm')
-rw-r--r--lib/VNDB/DB/ULists.pm1
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/VNDB/DB/ULists.pm b/lib/VNDB/DB/ULists.pm
index 09cfac23..a1f02786 100644
--- a/lib/VNDB/DB/ULists.pm
+++ b/lib/VNDB/DB/ULists.pm
@@ -58,6 +58,7 @@ sub dbVNListList {
my %where = (
'vl.uid = ?' => $o{uid},
defined($o{voted}) ? ('vo.vote !s NULL' => $o{voted} ? 'IS NOT' : 'IS') : (),
+ defined($o{status})? ('vl.status = ?' => $o{status}) : (),
$o{char} ? ('LOWER(SUBSTR(vr.title, 1, 1)) = ?' => $o{char} ) : (),
defined $o{char} && !$o{char} ? (
'(ASCII(vr.title) < 97 OR ASCII(vr.title) > 122) AND (ASCII(vr.title) < 65 OR ASCII(vr.title) > 90)' => 1 ) : (),