X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Frandomsongs.pl;fp=html%2Frandomsongs.pl;h=daa36cb529d90b0ada9696cb20c57613a4202887;hp=0000000000000000000000000000000000000000;hb=c7283b6a8ab12956329719e4b73f4cbe9450a681;hpb=efc02d027e49929855ab8b076609a11ac1f358d6

diff --git a/html/randomsongs.pl b/html/randomsongs.pl
new file mode 100755
index 0000000..daa36cb
--- /dev/null
+++ b/html/randomsongs.pl
@@ -0,0 +1,16 @@
+#! /usr/bin/perl
+
+use ccbs;
+use strict;
+use warnings;
+
+my $dbh = ccbs::db_connect();
+
+my $ref = $dbh->selectrow_hashref('SELECT COUNT(*) AS num_used FROM randomsongsused');
+
+ccbs::print_header();
+ccbs::process_template('randomsongs.tmpl', 'Sangvelger', {
+		num_used => $ref->{'num_used'}
+	});
+
+$dbh->disconnect;