From: Steinar H. Gunderson Date: Mon, 14 Feb 2005 23:44:44 +0000 (+0000) Subject: Added showing/selection of playmode and difficulty. X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=abdecc0f519228843c82f803158a82771ab30f05;hp=cf6d5eed376fa7626418562831fa178517e3be70 Added showing/selection of playmode and difficulty. --- diff --git a/html/show-tournament.pl b/html/show-tournament.pl index b02033d..fd78a3c 100755 --- a/html/show-tournament.pl +++ b/html/show-tournament.pl @@ -16,7 +16,7 @@ my $songs = ccbs::db_fetch_all($dbh, 'SELECT song,title FROM machinesongs NATURA # 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, - 'SELECT round,parallel,position,songnumber,nick,song,title,chosen,score FROM roundparticipation NATURAL JOIN players NATURAL JOIN scores NATURAL LEFT JOIN songs WHERE tournament=? ORDER BY round,parallel,position,songnumber', + 'SELECT round,parallel,position,playmode,difficulty,songnumber,nick,song,title,chosen,score FROM roundparticipation NATURAL JOIN players NATURAL JOIN scores NATURAL LEFT JOIN songs WHERE tournament=? ORDER BY round,parallel,position,songnumber', $id); my @rounds = (); diff --git a/html/templates/show-tournament.tmpl b/html/templates/show-tournament.tmpl index 9dc1083..3c1839b 100644 --- a/html/templates/show-tournament.tmpl +++ b/html/templates/show-tournament.tmpl @@ -112,7 +112,50 @@ [% pl.nick %] [% FOR s = pl.songs %] - + + + + + [% IF s.chosen %]