summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/VN.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-02-06 17:01:05 +0100
committerYorhel <git@yorhel.nl>2011-02-06 17:01:05 +0100
commitb53d0e8f54ca7e4cc397bb68638a19099f1cb160 (patch)
tree4af99c1d9054dd777ce1840643609b364a2c5213 /lib/VNDB/DB/VN.pm
parente59b9670b930b4a16d3c8e512d1d195c81151730 (diff)
Added new VN filter: on user VN list or not
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r--lib/VNDB/DB/VN.pm2
1 files changed, 2 insertions, 0 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index bb8611b1..0f6c5731 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -63,6 +63,8 @@ sub dbVNGet {
'v.id !s IN(SELECT vid FROM wlists WHERE uid = ?)' => [ $o{ul_onwish} ? '' : 'NOT', $uid ] ) : (),
$uid && defined $o{ul_voted} ? (
'v.id !s IN(SELECT vid FROM votes WHERE uid = ?)' => [ $o{ul_voted} ? '' : 'NOT', $uid ] ) : (),
+ $uid && defined $o{ul_onlist} ? (
+ 'v.id !s IN(SELECT vid FROM vnlists WHERE uid = ?)' => [ $o{ul_onlist} ? '' : 'NOT', $uid ] ) : (),
# don't fetch hidden items unless we ask for an ID
!$o{id} && !$o{rev} ? (
'v.hidden = FALSE' => 0 ) : (),