diff options
author | Yorhel <git@yorhel.nl> | 2011-10-24 17:33:02 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-10-24 17:33:02 +0200 |
commit | 28f5f8eac96dc21791bda5df5f997f213178c2f6 (patch) | |
tree | 3ec3bb1c61be3b1cdcb3668f44133cb26f47814d /lib | |
parent | 683263176f20aba575428a2b03018316d5f45b06 (diff) |
Added 'role' filter to character browser
Diffstat (limited to 'lib')
-rw-r--r-- | lib/VNDB/DB/Chars.pm | 5 | ||||
-rw-r--r-- | lib/VNDB/Util/Misc.pm | 2 |
2 files changed, 5 insertions, 2 deletions
diff --git a/lib/VNDB/DB/Chars.pm b/lib/VNDB/DB/Chars.pm index 634e0078..86b3a859 100644 --- a/lib/VNDB/DB/Chars.pm +++ b/lib/VNDB/DB/Chars.pm @@ -9,7 +9,7 @@ our @EXPORT = qw|dbCharGet dbCharRevisionInsert dbCharImageId|; # options: id rev instance tagspoil trait_inc trait_exc char what results page gender bloodt -# bust_min bust_max waist_min waist_max hip_min hip_max height_min height_max weight_min weight_max +# bust_min bust_max waist_min waist_max hip_min hip_max height_min height_max weight_min weight_max role # what: extended traits vns changes sub dbCharGet { my $self = shift; @@ -48,6 +48,9 @@ sub dbCharGet { 'LOWER(SUBSTR(cr.name, 1, 1)) = ?' => $o{char} ) : (), defined $o{char} && !$o{char} ? ( '(ASCII(cr.name) < 97 OR ASCII(cr.name) > 122) AND (ASCII(cr.name) < 65 OR ASCII(cr.name) > 90)' => 1 ) : (), + $o{role} ? ( + 'EXISTS(SELECT 1 FROM chars_vns cvi WHERE cvi.cid = cr.id AND cvi.role IN(!l))', + [ ref $o{role} ? $o{role} : [$o{role}] ] ) : (), $o{trait_inc} ? ( 'c.id IN(SELECT cid FROM traits_chars WHERE tid IN(!l) AND spoil <= ? GROUP BY cid HAVING COUNT(tid) = ?)', [ ref $o{trait_inc} ? $o{trait_inc} : [$o{trait_inc}], $o{tagspoil}, ref $o{trait_inc} ? $#{$o{trait_inc}}+1 : 1 ]) : (), diff --git a/lib/VNDB/Util/Misc.pm b/lib/VNDB/Util/Misc.pm index b7df11c3..04114483 100644 --- a/lib/VNDB/Util/Misc.pm +++ b/lib/VNDB/Util/Misc.pm @@ -13,7 +13,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 ul_onlist|], release => [qw|type patch freeware doujin date_before date_after released minage lang olang resolution plat med voiced ani_story ani_ero|], - char => [qw|gender bloodt bust_min bust_max waist_min waist_max hip_min hip_max height_min height_max weight_min weight_max trait_inc trait_exc tagspoil|], + char => [qw|gender bloodt bust_min bust_max waist_min waist_max hip_min hip_max height_min height_max weight_min weight_max trait_inc trait_exc tagspoil role|], ); |