X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Ftournaments.pl;h=aedd416dbef607efc77d54dbd010c2a74c0119c9;hp=3fc353172d2f23f5b46b6869ecc6d453dca79062;hb=HEAD;hpb=f968c8b90cb9b15473e7648758afc3f341d9f560 diff --git a/html/tournaments.pl b/html/tournaments.pl index 3fc3531..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;