X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FMembers.pm;h=52bcb4c0f2a251304b6e7da4cebfb7e16e9b092e;hp=5c600e6396a29a3fa3e7b1aa9d67f1fead9f4fd5;hb=HEAD;hpb=fe30a773e99e2ef4d560caa91e0dfc9ff72a3bdc 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