Add information to the SQL schema saying when the group was last updated. Make the...

[ccbs] / html / do-set-active-round.pl

diff --git a/html/do-set-active-round.pl b/html/do-set-active-round.pl
index 1d892b1e1ff111ca135a78d31b2883df475e020e..c98a478dc9a1320804cde5020167e50506fdcb58 100755 (executable)
--- a/html/do-set-active-round.pl
+++ b/html/do-set-active-round.pl
@@ -16,7 +16,7 @@ $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 (?,?,?)',
+       $dbh->do('INSERT INTO bigscreen.active_groups (tournament, round, parallel, last_updated) VALUES (?,?,?,now())',
                undef, $tournament, $round, $parallel);
 }