diff --git a/jtserv/jtserv.rb b/jtserv/jtserv.rb index b5b1f42..cb1ddcb 100755 --- a/jtserv/jtserv.rb +++ b/jtserv/jtserv.rb @@ -330,10 +330,10 @@ end def ranking(text, mode=nil, user=nil) rankbase = <<~EOF - SELECT "User", "Team", "Score", "Step", "Try", "Minutes", "Time" + SELECT "User", "Team", "Score", "Step", "Try", "Minutes", "Time", "Gecos" UNION SELECT user, team, max(score) hs, max(step), count(score), - cast(round(sum(time)/60) as INT), max(at) + cast(round(sum(time)/60) as INT), max(at), gecos FROM score NATURAL LEFT JOIN users WHERE text=? %s GROUP BY user ORDER BY hs DESC; EOF