diff options
author | Yorhel <git@yorhel.nl> | 2011-02-06 17:01:05 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-02-06 17:01:05 +0100 |
commit | b53d0e8f54ca7e4cc397bb68638a19099f1cb160 (patch) | |
tree | 4af99c1d9054dd777ce1840643609b364a2c5213 /lib/VNDB | |
parent | e59b9670b930b4a16d3c8e512d1d195c81151730 (diff) |
Added new VN filter: on user VN list or not
Diffstat (limited to 'lib/VNDB')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 2 | ||||
-rw-r--r-- | lib/VNDB/Util/Misc.pm | 2 |
2 files changed, 3 insertions, 1 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 ) : (), diff --git a/lib/VNDB/Util/Misc.pm b/lib/VNDB/Util/Misc.pm index 9a056b8a..5406fe06 100644 --- a/lib/VNDB/Util/Misc.pm +++ b/lib/VNDB/Util/Misc.pm @@ -11,7 +11,7 @@ our @EXPORT = qw|filFetchDB ieCheck|; my %filfields = ( - vn => [qw|length hasani tag_inc tag_exc taginc tagexc tagspoil lang olang plat ul_notblack ul_onwish ul_voted|], + vn => [qw|length hasani tag_inc tag_exc taginc tagexc tagspoil lang olang plat ul_notblack ul_onwish ul_voted ul_onlist|], release => [qw|type patch freeware doujin date_before date_after released minage lang olang resolution plat med voiced ani_story ani_ero|], ); |