X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Fplayers.pl;h=dcce199dbf30c49d76531cbf28695fff3345c6cb;hp=8158d4dad06fd3bf774a45828f0eb2179fc838d3;hb=2eb7f1827771ea7267c94bfe0c83adc9767872b8;hpb=3c8e4e7e075f55a77e313275479a41b057ca4fc1 diff --git a/html/players.pl b/html/players.pl index 8158d4d..dcce199 100755 --- a/html/players.pl +++ b/html/players.pl @@ -12,7 +12,7 @@ my $dbh = ccbs::db_connect(); my $players = ccbs::db_fetch_all($dbh, 'SELECT player,nick,countryname,clubname,count(*) AS num_songs,COUNT(DISTINCT song) AS num_unique_songs,COUNT(DISTINCT tournament) AS num_tournaments,AVG(score)::integer AS avg_score,MAX(score) AS high_score FROM scores NATURAL JOIN players NATURAL JOIN countries NATURAL LEFT JOIN clubs GROUP BY player,nick,countryname,clubname ORDER BY LOWER(nick)'); ccbs::print_header(); -ccbs::process_template('players.tmpl', 'Players', { +ccbs::process_template('players.tmpl', 'Spillere', { players => $players, }); $dbh->disconnect;