Fetch all the "max score for song" entries in one go instead of one at a time.

[ccbs] / html / do-edit-scores.pl

diff --git a/html/do-edit-scores.pl b/html/do-edit-scores.pl
index 5db7cbf7cae69de9184cccc26fee688b2dd36007..a6a498ca89eee45b0cdf89c56a034e110bbf3dc4 100755 (executable)
--- a/html/do-edit-scores.pl
+++ b/html/do-edit-scores.pl
@@ -72,6 +72,10 @@ for my $p ($cgi->param()) {
        }
 }
 
+$dbh->do('UPDATE bigscreen.active_groups SET last_updated=now() WHERE tournament=? AND round=? AND parallel=?',
+       undef, $tournament, $round, $group);
+$dbh->do('NOTIFY scores');
+
 $dbh->commit;
 $dbh->disconnect;