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 | |
parent | 205e4c1b15ccf57a1c30a04ebdee3ac20ce8f67d (diff) |
API: Add 'vn' filter to get character
-rw-r--r-- | data/docs/11 | 7 | ||||
-rw-r--r-- | lib/Multi/API.pm | 4 |
2 files changed, 10 insertions, 1 deletions
diff --git a/data/docs/11 b/data/docs/11 index 09a8c40d..eafe7d5f 100644 --- a/data/docs/11 +++ b/data/docs/11 @@ -1123,6 +1123,12 @@ however still required.<br /> <td>~</td> <td>Not an actual field. Performs a search on the name, original and aliases fields.</td> </tr> + <tr class="odd"> + <td>vn</td> + <td>id</td> + <td>=</td> + <td>Find characters linked to the given visual novel ID.</td> + </tr> </table> @@ -1465,6 +1471,7 @@ however still required.<br /> <li>Added "tags" flag and member to "get vn"</li> <li>Added "stats" flag to "get vn"</li> <li>Added "firstchar" filter to "get vn"</li> + <li>Added "vn" filter to "get character"</li> </ul> <b>2.15</b> <ul> 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', { |