Add front end for resetting the song chooser.

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

diff --git a/html/templates/index.tmpl b/html/templates/index.tmpl
index ccb16c261ee52aea650148a482238ad8a204318b..06f4e322ac371995fb3f7b37ce4cb53252b90517 100644 (file)
--- a/html/templates/index.tmpl
+++ b/html/templates/index.tmpl
@@ -10,5 +10,6 @@
   <ul>
     <li><a href="tournaments.pl">Turneringer</a></li>
     <li><a href="add-tournament.pl">Legg til turnering</a></li>
   <ul>
     <li><a href="tournaments.pl">Turneringer</a></li>
     <li><a href="add-tournament.pl">Legg til turnering</a></li>

+    <li><a href="randomsongs.pl">Sangvelger</a></li>

   </ul>
 </div>
   </ul>
 </div>

diff --git a/html/templates/randomsongs.tmpl b/html/templates/randomsongs.tmpl
new file mode 100755 (executable)
index 0000000..f8ff24f
--- /dev/null
+++ b/html/templates/randomsongs.tmpl
@@ -0,0 +1,11 @@
+[%# vim:set filetype=html: %]
+<div>
+  <p>For øyeblikket er <strong>[% num_used %]</strong> sanger satt som
+    brukt i sangvelgeren. Nullstiller du sangvelgeren, går den tilbake
+    til 0 og alle sanger kan potensielt trekkes ut når du lager en ny
+    gruppe.</p>
+
+  <form action="do-reset-randomsongs.pl" method="post">
+    <p><input type="submit" value="Nullstill sangvelger" /></p>
+  </form>
+</div>