diff options
| author | Yorhel <git@yorhel.nl> | 2014-08-16 20:05:14 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2014-08-16 20:05:57 +0200 |
| commit | aae112a5af748b69d1a7cda5431da9c03fa967e7 (patch) | |
| tree | 0de797fc828e9589c5e914c7b4a499aad57018be /lib/Multi/API.pm | |
| parent | 205e4c1b15ccf57a1c30a04ebdee3ac20ce8f67d (diff) | |
API: Add 'vn' filter to get character
Diffstat (limited to 'lib/Multi/API.pm')
| -rw-r--r-- | lib/Multi/API.pm | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/Multi/API.pm b/lib/Multi/API.pm index 365d7ec0..c7b1b882 100644 --- a/lib/Multi/API.pm +++ b/lib/Multi/API.pm @@ -925,7 +925,9 @@ sub get_character { [ str => 'cr.original ILIKE :value:', {'~',1}, process => \'like' ] ], [ 'search', [ str => '(cr.name ILIKE :value: OR cr.original ILIKE :value: OR cr.alias ILIKE :value:)', {'~',1}, process => \'like' ], - ], + ], [ 'vn', + [ 'int' => 'cr.id IN(SELECT cv.cid FROM chars_vns cv WHERE cv.vid = :value:)', {'=',1}, range => [1,1e6] ], + ] # TODO: More filters? ]; my $last = sqllast $get, 'id', { |