From abdecc0f519228843c82f803158a82771ab30f05 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Mon, 14 Feb 2005 23:44:44 +0000 Subject: [PATCH] Added showing/selection of playmode and difficulty. --- html/show-tournament.pl | 2 +- html/templates/show-tournament.tmpl | 45 ++++++++++++++++++++++++++++- 2 files changed, 45 insertions(+), 2 deletions(-) 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 %]