X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Fplayers.pl;fp=html%2Fplayers.pl;h=8158d4dad06fd3bf774a45828f0eb2179fc838d3;hp=0000000000000000000000000000000000000000;hb=576539ce9dfb2a74bc786d86e0f5c9131f2a452f;hpb=d2bf21e6f3f51a40b8901d570ac02e8a2061dc5f

diff --git a/html/players.pl b/html/players.pl
new file mode 100755
index 0000000..8158d4d
--- /dev/null
+++ b/html/players.pl
@@ -0,0 +1,18 @@
+#! /usr/bin/perl
+
+use ccbs;
+use strict;
+use warnings;
+
+my $cgi = new CGI;
+my $id = $cgi->param('id');
+
+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', {
+	players => $players,
+});
+$dbh->disconnect;