From a11e76a86aa9b636558eef41498e79feaae90584 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sesse@samfundet.no>
Date: Sat, 19 Feb 2005 14:34:53 +0000
Subject: [PATCH] Add back end for adding/removing groups to be shown on the
 bigscreen.

---
 html/do-set-active-round.pl | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100755 html/do-set-active-round.pl

diff --git a/html/do-set-active-round.pl b/html/do-set-active-round.pl
new file mode 100755
index 0000000..1d892b1
--- /dev/null
+++ b/html/do-set-active-round.pl
@@ -0,0 +1,29 @@
+#! /usr/bin/perl
+
+use ccbs;
+use strict;
+use warnings;
+
+my $dbh = ccbs::db_connect();
+my $cgi = new CGI;
+
+my $tournament = $cgi->param('tournament');
+my $round = $cgi->param('round');
+my $parallel = $cgi->param('parallel');
+
+$dbh->{AutoCommit} = 0;
+
+$dbh->do('DELETE FROM bigscreen.active_groups WHERE tournament=? AND round=? AND parallel=?', undef,
+	$tournament, $round, $parallel);
+if ($cgi->param('show') eq 'true') {
+	$dbh->do('INSERT INTO bigscreen.active_groups (tournament, round, parallel) VALUES (?,?,?)',
+		undef, $tournament, $round, $parallel);
+}
+
+$dbh->do('NOTIFY active_groups');
+
+$dbh->commit;
+$dbh->disconnect;
+
+ccbs::print_see_other('show-tournament.pl?id=' . $tournament);
+
-- 
2.39.2