Change initial seeding from alphabetical to random.

[ccbs] / html / do-start-round.pl

diff --git a/html/do-start-round.pl b/html/do-start-round.pl
index 36844233cc019663b6f8b06cfb813345e09a6371..ff02c26a62a6d4b85582b52f8cce8e1ef1960afb 100755 (executable)
--- a/html/do-start-round.pl
+++ b/html/do-start-round.pl
@@ -34,7 +34,7 @@ if ($num_groups == 1) {
 # Seed people into groups (quite preliminary for now)
 my $people;
 if ($round == 1) {
-       $people = ccbs::db_fetch_all($dbh, 'SELECT * FROM players WHERE player IN ( SELECT player FROM tournamentparticipation WHERE tournament=? ) ORDER BY lower(nick)',
+       $people = ccbs::db_fetch_all($dbh, 'SELECT * FROM players WHERE player IN ( SELECT player FROM tournamentparticipation WHERE tournament=? ) ORDER BY random()',
                $tournament);
 } else {
        # First of all, check that there are no null values!