rewards: Apply supporters badge and unicode name (almost) everywhere

Only place where this isn't applied (yet?): Sorting user lists still
goes by the old username and board names don't use the new unicode
names.

I have to say, I quite like the sql_user() and user_() pattern. It's not
without problems when applied to everything, but it's good enough for
several use cases.

1 files changed, 2 insertions, 2 deletions

diff --git a/lib/VNDB/DB/Misc.pm b/lib/VNDB/DB/Misc.pm
index e1a1103c..27494380 100644
--- a/lib/VNDB/DB/Misc.pm
+++ b/lib/VNDB/DB/Misc.pm
@@ -79,11 +79,11 @@ sub dbRevisionGet {
   );
 
   my($r, $np) = $self->dbPage(\%o, q|
-    SELECT c.id, c.type, c.itemid, c.requester, c.comments, c.rev, extract('epoch' from c.added) as added, u.username
+    SELECT c.id, c.type, c.itemid, c.comments, c.rev, extract('epoch' from c.added) as added, !s
       FROM changes c
       JOIN users u ON c.requester = u.id
       !W
-      ORDER BY c.id DESC|, \%where
+      ORDER BY c.id DESC|, VNWeb::DB::sql_user(), \%where
   );
 
   # I couldn't find a way to fetch the titles the main query above without slowing it down considerably, so let's just do it this way.