#! /usr/bin/perl

use ccbs;
use strict;
use warnings;

ccbs::admin_only();

my $dbh = ccbs::db_connect();
my $cgi = new CGI;

my $tournament = $cgi->param('tournament');
my $round = $cgi->param('round');
my $parallel = $cgi->param('parallel');
my $num_machines = $cgi->param('nummachines');
my $players_per_machine = $cgi->param('playerspermachine');

$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, num_machines, last_updated, players_per_machine) VALUES (?,?,?,?,now(),?)',
		undef, $tournament, $round, $parallel, $num_machines, $players_per_machine);
}

$dbh->do('NOTIFY active_groups');

$dbh->commit;
$dbh->disconnect;

ccbs::print_see_other('show-tournament.pl?id=' . $tournament);

