staff: Fix deleting of staff + use JSON to pass data + minor fixes

1 files changed, 5 insertions, 2 deletions

diff --git a/lib/VNDB/DB/Chars.pm b/lib/VNDB/DB/Chars.pm
index 50923941..15f00675 100644
--- a/lib/VNDB/DB/Chars.pm
+++ b/lib/VNDB/DB/Chars.pm
@@ -119,8 +119,11 @@ sub dbCharGet {
           JOIN vn_rev vr ON vr.id = vs.vid
           JOIN vn v ON v.latest = vs.vid
           !W
-          ORDER BY v.c_released, sa.name|,
-        { 'cr.id IN(!l)' => [[ keys %r ]], $o{vid} ? ('v.id = ?' => $o{vid}) : () }
+          ORDER BY v.c_released, sa.name|, {
+            's.hidden = FALSE' => 1,
+            'cr.id IN(!l)' => [[ keys %r ]],
+            $o{vid} ? ('v.id = ?' => $o{vid}) : (),
+          }
       )});
     }
   }