diff options
author | Yorhel <git@yorhel.nl> | 2010-12-21 10:53:32 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-12-21 10:53:32 +0100 |
commit | e77484d81461c322656615759ba77ea25713a8d6 (patch) | |
tree | b750f8e165ead267bdd2fc4ad900f181997535cb /lib/VNDB/DB/ULists.pm | |
parent | 19e353c480091ec607324ee09a8821dd3d895975 (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.pm | 1 |
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 ) : (), |