From: Michael Andreen <michael@andreen.dev>
Date: Fri, 2 Jun 2023 19:06:07 +0000 (+0200)
Subject: Use new race infrastructure for members stats
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=HEAD

Use new race infrastructure for members stats
---

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