X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Fshow-tournament.pl;h=7be00367df10cb0b4077e6d4d968c1ea809f40f8;hp=3a407f80e99dafa1848bcc03c697f261179c7940;hb=99d0a3d132ab8dce72e51935ca67ea85be8158a2;hpb=49e5792858da785cf814fe529b6e9ddbfb326595 diff --git a/html/show-tournament.pl b/html/show-tournament.pl index 3a407f8..7be0036 100755 --- a/html/show-tournament.pl +++ b/html/show-tournament.pl @@ -24,6 +24,9 @@ if ($ref->{'num_incomplete'} == 0) { $closing_valid = 0; } +# Find all groups currently shown on the bigscreen. +my $active_groups = ccbs::db_fetch_all($dbh, 'SELECT * FROM bigscreen.active_groups WHERE tournament=?', $id); + # Swoop all the data in in a big join, then order it over to quasi-sane Perl objects. # (round -> parallel -> player -> songs -> title,chosen,score) my $scores = ccbs::db_fetch_all($dbh, @@ -45,15 +48,24 @@ for my $score (@$scores) { push @$p, { parallel => $parallel, players => [], songs => [], num_songs => 0 }; $player = ''; + # suboptimal, but heck :-) + $p->[$#$p]->{'bigscreen'} = 0; + for my $ag (@$active_groups) { + if ($ag->{'round'} == $round && $ag->{'parallel'} == $parallel) { + $p->[$#$p]->{'bigscreen'} = 1; + last; + } + } + # Information on songs is not selected from roundrandomsongs etc., # but is filled in the first time the song is seen for this round # (ie. below) } if ($score->{'position'} == 1) { if ($score->{'chosen'}) { - push @{$p->[$#$p]->{'songs'}}, ''; + push @{$p->[$#$p]->{'songs'}}, { song => -1, title => '' }; } else { - push @{$p->[$#$p]->{'songs'}}, $score->{'title'}; + push @{$p->[$#$p]->{'songs'}}, $score; } $p->[$#$p]->{'num_songs'}++; } @@ -61,9 +73,9 @@ for my $score (@$scores) { my $pl = $p->[$#$p]->{'players'}; if ($score->{'nick'} ne $player) { $player = $score->{'nick'}; - push @$pl, { player => $score->{'player'}, nick => $player, songs => [], total => 0 }; + push @$pl, { player => $score->{'player'}, nick => $player, songs => [], total => 0, rank => 1 }; } - + push @{$pl->[$#$pl]->{'songs'}}, $score; if (defined($score->{'score'})) { @@ -71,6 +83,24 @@ for my $score (@$scores) { } } +# Find the rank of all the players in every group, via simple insertion-like +# sort +for my $r (@rounds) { + for my $p (@{$r->{'parallels'}}) { + my $pls = $p->{'players'}; + for my $i (0..$#$pls) { + my $rank = 1; + for my $j (0..($i-1)) { + if ($pls->[$i]->{'total'} < $pls->[$j]->{'total'}) { + $pls->[$i]->{'rank'}++; + } elsif ($pls->[$i]->{'total'} > $pls->[$j]->{'total'}) { + $pls->[$j]->{'rank'}++; + } + } + } + } +} + # FIXME: In some odd cases, there _might_ be an empty group right at the end. Fix this when # we are able to add/delete people in groups. @@ -84,7 +114,7 @@ for my $r (0..$#rounds-1) { # If there's only one group left and it's valid for closing, we can also finish # the entire tournament if we'd like -if ($closing_valid && (scalar @{$rounds[$#rounds]->{'parallels'}}) == 1) { +if ($closing_valid && (scalar @rounds > 0 && scalar @{$rounds[$#rounds]->{'parallels'}}) == 1) { $finishing_valid = 1; } @@ -99,6 +129,14 @@ if ($num_rounds == 0) { $num_qualified = $ref->{'numqualifying'}; } +# And last: If there is a ranking list, the tournament is closed and we really can't +# do anything more +if ($num_rankings > 0) { + $closing_valid = 0; + $finishing_valid = 0; + $rounds[$#rounds]->{'locked'} = 1; +} + ccbs::print_header(); ccbs::process_template('show-tournament.tmpl', $tournament->{'tournamentname'}, { tournament => $tournament,