# 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(_("There's still") . $ref->{'num_incomplete'} . _("songs left in this round which don't have all data registered.");
+ 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(_("There aren't any songs left in the song selector!");
+ ccbs::user_error(_("There aren't any songs left in the song selector!"));
}
$dbh->do('INSERT INTO randomsongsused (song) VALUES (?)',
undef, $ref->{'song'});