]> git.sesse.net Git - ccbs/commitdiff
Add back end for adding/removing groups to be shown on the bigscreen.
authorSteinar H. Gunderson <sesse@samfundet.no>
Sat, 19 Feb 2005 14:34:53 +0000 (14:34 +0000)
committerSteinar H. Gunderson <sesse@samfundet.no>
Sat, 19 Feb 2005 14:34:53 +0000 (14:34 +0000)
html/do-set-active-round.pl [new file with mode: 0755]

diff --git a/html/do-set-active-round.pl b/html/do-set-active-round.pl
new file mode 100755 (executable)
index 0000000..1d892b1
--- /dev/null
@@ -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);
+