diff options
author | Yorhel <git@yorhel.nl> | 2011-02-06 16:39:58 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-02-06 16:39:58 +0100 |
commit | e59b9670b930b4a16d3c8e512d1d195c81151730 (patch) | |
tree | c243fdaa40f665d3f4c3a4bfa2d9ee1dbae9b1ab /lib/VNDB/DB/VN.pm | |
parent | c96ace5f64c198459213e234d01e2da2ecff2adc (diff) |
Added new VN filter: voted on or not
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index 00d1c9a5..bb8611b1 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -61,6 +61,8 @@ sub dbVNGet { 'v.id NOT IN(SELECT vid FROM wlists WHERE uid = ? AND wstat = 3)' => $uid ) : (), $uid && defined $o{ul_onwish} ? ( '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 ] ) : (), # don't fetch hidden items unless we ask for an ID !$o{id} && !$o{rev} ? ( 'v.hidden = FALSE' => 0 ) : (), |