Use new race infrastructure for members stats

diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm
index 5c600e6396a29a3fa3e7b1aa9d67f1fead9f4fd5..52bcb4c0f2a251304b6e7da4cebfb7e16e9b092e 100644 (file)
--- a/lib/NDWeb/Controller/Members.pm
+++ b/lib/NDWeb/Controller/Members.pm
@@ -246,7 +246,7 @@ sub stats : Local {
        my $limit = 'LIMIT 10';
        $limit = '' if $c->check_user_roles(qw/members_points_nolimit/);
 
-       my ($races) = $dbh->selectrow_array(q{SELECT enum_range(null::race)::text[]});
+       my ($races) = $dbh->selectrow_array(q{SELECT array_agg(race ORDER BY race_id) FROM races WHERE race_id >= 0});
        $c->stash(races => $races);
        my $query = $dbh->prepare(q{
 SELECT nick