X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Ftournaments.pl;h=aedd416dbef607efc77d54dbd010c2a74c0119c9;hp=fce241e83fca1ce25b96153ef2cb59f651cc58fe;hb=HEAD;hpb=eef57263709c5dc7e1f361075e5ce8cb7b7b2367 diff --git a/html/tournaments.pl b/html/tournaments.pl index fce241e..aedd416 100755 --- a/html/tournaments.pl +++ b/html/tournaments.pl @@ -5,8 +5,16 @@ use strict; use warnings; my $dbh = ccbs::db_connect(); -my $tournaments = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournaments NATURAL JOIN seasons ORDER BY season, date'); +my $tournaments = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournaments NATURAL JOIN seasons ORDER BY season, date, tournamentname'); + +# Translate the season names +my @t_trans = (); +for my $t (@$tournaments) { + my %tt = %$t; + $tt{'seasonname'} = Locale::gettext::gettext($t->{'seasonname'}); + push @t_trans, \%tt; +} ccbs::print_header(); -ccbs::process_template('tournaments.tmpl', _('Tournaments'), { tournaments => $tournaments }); +ccbs::process_template('tournaments.tmpl', _('Tournaments'), { tournaments => \@t_trans }); $dbh->disconnect;