# 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!
my $ref = $dbh->selectrow_hashref('SELECT COUNT(*) AS num_incomplete FROM scores WHERE tournament=? AND round=? AND (song IS NULL OR playmode IS NULL OR difficulty IS NULL OR chosen IS NULL or score IS NULL)', undef, $tournament, $round-1);
if ($ref->{'num_incomplete'} != 0) {
- ccbs::user_error("Det er fortsatt $ref->{'num_incomplete'} sanger igjen i denne runden som ikke har alle data registrert.");
+ ccbs::user_error(_("There's still") . $ref->{'num_incomplete'} . _("songs left in this round which don't have all data registered."));
}
# Find out how many people will go on from the _current_ group (ie. the one
my $ref = $dbh->selectrow_hashref('SELECT * FROM machinesongs NATURAL JOIN songratings WHERE song NOT IN ( SELECT song FROM randomsongsused ) AND machine=( SELECT machine FROM tournaments WHERE tournament=? ) AND playmode=\'single\' AND difficulty=\'expert\' ORDER BY random() LIMIT 1',
undef, $tournament);
if (!defined($ref)) {
- ccbs::user_error('Det er ikke flere sanger igjen i sangvelgeren!');
+ ccbs::user_error(_("There aren't any songs left in the song selector!"));
}
$dbh->do('INSERT INTO randomsongsused (song) VALUES (?)',
undef, $ref->{'song'});