my $rankings;
if ($tournament->{'country'} == 1) {
- $rankings = ccbs::db_fetch_all($dbh, 'SELECT ranking,nick || \' (\' || countrycode::varchar || \')\' AS nick,COALESCE(points,-1) AS points FROM tournamentrankings NATURAL JOIN players NATURAL JOIN countries WHERE tournament=? ORDER BY ranking', $id);
+ $rankings = ccbs::db_fetch_all($dbh, 'SELECT ranking,player,nick || \' (\' || countrycode::varchar || \')\' AS nick,COALESCE(points,-1) AS points FROM tournamentrankings NATURAL JOIN players NATURAL JOIN countries WHERE tournament=? ORDER BY ranking', $id);
} else {
- $rankings = ccbs::db_fetch_all($dbh, 'SELECT ranking,COALESCE(nick || \' (\' || clubcode::varchar || \')\', nick) AS nick,COALESCE(points,-1) AS points FROM tournamentrankings NATURAL JOIN players NATURAL LEFT JOIN clubs WHERE tournament=? ORDER BY ranking', $id);
+ $rankings = ccbs::db_fetch_all($dbh, 'SELECT ranking,player,COALESCE(nick || \' (\' || clubcode::varchar || \')\', nick) AS nick,COALESCE(points,-1) AS points FROM tournamentrankings NATURAL JOIN players NATURAL LEFT JOIN clubs WHERE tournament=? ORDER BY ranking', $id);
}
my $songs = ccbs::db_fetch_all($dbh, 'SELECT song,title FROM machinesongs NATURAL JOIN songs WHERE machine=? ORDER BY LOWER(title)', $tournament->{'machine'});
<ul>
[% FOR r = rankings %]
[% IF r.points == -1 %]
- <li>[% r.ranking %]. plass: [% r.nick %]</li>
+ <li>[% r.ranking %]. plass: <a href="player.pl?id=[% r.player %]">[% r.nick %]</a></li>
[% ELSE %]
- <li>[% r.ranking %]. plass: [% r.nick %], med [% r.points %] poeng.</li>
+ <li>[% r.ranking %]. plass: <a href="player.pl?id=[% r.player %]">[% r.nick %]</a>, med [% r.points %] poeng.</li>
[% END %]
[% END %]
</ul>
[% IF r.locked %]
<tr>
<th>
- [% pl.nick %]
+ <a href="player.pl?id=[% pl.player %]">[% pl.nick %]</a>
</th>
[% FOR s = pl.songs %]
<td class="score">[% s.score %]</td>
</tr>
[% ELSE %]
<tr>
- <th>[% pl.nick %]</th>
+ <th><a href="player.pl?id=[% pl.player %]">[% pl.nick %]</a></th>
[% FOR s = pl.songs %]
<td class="score">
<input type="hidden" name="old-score[% pl.player %]-[% s.songnumber %]" value="[% s.score %]" />