From d56eb10d90387a86f0cd94fddd1fa0b007d5af10 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Sun, 15 May 2016 10:42:56 +0200
Subject: API: Allow sorting 'get vn' on stats fields

---
 lib/Multi/API.pm | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'lib/Multi/API.pm')

diff --git a/lib/Multi/API.pm b/lib/Multi/API.pm
index b73ec58c..2b35d0d3 100644
--- a/lib/Multi/API.pm
+++ b/lib/Multi/API.pm
@@ -381,6 +381,9 @@ my %GET_VN = (
     id => 'v.id %s',
     title => 'v.title %s',
     released => 'v.c_released %s',
+    popularity => 'v.c_popularity %s NULLS LAST',
+    rating => 'v.c_rating %s NULLS LAST',
+    votecount => 'v.c_votecount %s',
   },
   flags  => {
     basic => {
@@ -785,7 +788,7 @@ my %GET_CHARACTER = (
       fetch => [[ 'id', 'SELECT id, vid, rid, spoil, role FROM chars_vns WHERE id IN(%s)',
         sub { my($n, $r) = @_;
           for my $i (@$n) {
-            $i->{vns} = [ map [ $_->{vid}*1, $_->{rid}*1, $_->{spoil}*1, $_->{role} ], grep $i->{id} == $_->{id}, @$r ];
+            $i->{vns} = [ map [ $_->{vid}*1, ($_->{rid}||0)*1, $_->{spoil}*1, $_->{role} ], grep $i->{id} == $_->{id}, @$r ];
           }
         },
       ]],
-- 
cgit v1.2.3