7 my $dbh = ccbs::db_connect();
8 my $tournaments = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournaments NATURAL JOIN seasons ORDER BY season, date');
10 # Translate the season names
12 for my $t (@$tournaments) {
14 $tt{'seasonname'} = Locale::gettext::gettext($t->{'seasonname'});
19 ccbs::process_template('tournaments.tmpl', _('Tournaments'), { tournaments => \@t_trans });