From 07d0555058636b2b6ebb8c6bd757f9dfde072dba Mon Sep 17 00:00:00 2001
From: Michael Andreen <michael@andreen.dev>
Date: Fri, 2 Jun 2023 21:06:07 +0200
Subject: [PATCH] Use new race infrastructure for members stats

---
 lib/NDWeb/Controller/Members.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm
index 5c600e6..52bcb4c 100644
--- 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
-- 
2.39.2