X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Ftournaments.pl;h=aedd416dbef607efc77d54dbd010c2a74c0119c9;hp=8417b3c3af24bdd8e4baa57ea2e95607a739a271;hb=HEAD;hpb=61fbc22bd19a5888abae2ff8b8bdf4b385e4d6ee diff --git a/html/tournaments.pl b/html/tournaments.pl index 8417b3c..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', 'Turneringer', { tournaments => $tournaments }); +ccbs::process_template('tournaments.tmpl', _('Tournaments'), { tournaments => \@t_trans }); $dbh->disconnect;