diff options
| author | Yorhel <git@yorhel.nl> | 2021-03-18 12:24:56 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2021-03-23 11:16:22 +0100 |
| commit | a286672505ee3f6dfd9fb5d62cef460e7807176d (patch) | |
| tree | fae538cff1f1b6e1e1af67082dc633639fae854c /lib/Multi/API.pm | |
| parent | 7ffe7fa485c49b3d44150ed7b63d9062ae654ac8 (diff) | |
Traits: Convert to vndbids + add edit history
Much the same as the previous conversion of tags.
Diffstat (limited to 'lib/Multi/API.pm')
| -rw-r--r-- | lib/Multi/API.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/Multi/API.pm b/lib/Multi/API.pm index c7110585..b64319a1 100644 --- a/lib/Multi/API.pm +++ b/lib/Multi/API.pm @@ -859,7 +859,7 @@ my %GET_CHARACTER = ( fetch => [[ 'id', 'SELECT id, tid, spoil FROM chars_traits WHERE id IN(%s)', sub { my($n, $r) = @_; for my $i (@$n) { - $i->{traits} = [ map [ $_->{tid}*1, $_->{spoil}*1 ], grep $i->{id} eq $_->{id}, @$r ]; + $i->{traits} = [ map [ idnum($_->{tid}), $_->{spoil}*1 ], grep $i->{id} eq $_->{id}, @$r ]; } }, ]], @@ -930,8 +930,8 @@ my %GET_CHARACTER = ( [ inta => 'c.id IN(SELECT cv.id FROM chars_vns cv WHERE cv.vid IN(:value:))', {'=',1}, process => \'v', join => ',' ], ], traits => [ - [ int => 'c.id :op:(SELECT tc.cid FROM traits_chars tc WHERE tc.tid = :value:)', {'=' => 'IN', '!=' => 'NOT IN'}, range => [1,1e6] ], - [ inta => 'c.id :op:(SELECT tc.cid FROM traits_chars tc WHERE tc.tid IN(:value:))', {'=' => 'IN', '!=' => 'NOT IN'}, join => ',', range => [1,1e6] ], + [ int => 'c.id :op:(SELECT tc.cid FROM traits_chars tc WHERE tc.tid = :value:)', {'=' => 'IN', '!=' => 'NOT IN'}, process => \'i' ], + [ inta => 'c.id :op:(SELECT tc.cid FROM traits_chars tc WHERE tc.tid IN(:value:))', {'=' => 'IN', '!=' => 'NOT IN'}, join => ',', process => \'i' ], ], }, ); |