Add backend for resetting the song chooser.

[ccbs] / html / do-reset-randomsongs.pl

diff --git a/html/do-reset-randomsongs.pl b/html/do-reset-randomsongs.pl
new file mode 100755 (executable)
index 0000000..e470b73
--- /dev/null
+++ b/html/do-reset-randomsongs.pl
@@ -0,0 +1,14 @@
+#! /usr/bin/perl
+
+use ccbs;
+use strict;
+use warnings;
+
+my $dbh = ccbs::db_connect();
+my $cgi = new CGI;
+
+$dbh->do('DELETE FROM randomsongsused');
+
+ccbs::print_see_other('randomsongs.pl');
+
+$dbh->disconnect;