Sync with --pgweb.

[ccbs] / html / players.pl

diff --git a/html/players.pl b/html/players.pl
new file mode 100755 (executable)
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;