X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Fdo-add-player.pl;h=39b46f70d3c3c163bf9abc0d2edb0dcfd47a9728;hp=2ed4b6c18b78aab0eab9872041cf2f7f09290574;hb=7b746dbde2f6ca885b27056df96cd028b805bb1c;hpb=2eb7f1827771ea7267c94bfe0c83adc9767872b8 diff --git a/html/do-add-player.pl b/html/do-add-player.pl index 2ed4b6c..39b46f7 100755 --- a/html/do-add-player.pl +++ b/html/do-add-player.pl @@ -11,8 +11,12 @@ my $cgi = new CGI; my $tournament = $cgi->param('tournament'); my $nick = $cgi->param('nick'); +my $country = $cgi->param('country'); +my $club = $cgi->param('club'); -$dbh->do('INSERT INTO players (nick) VALUES (?)', undef, $nick); +$club = undef if ($club == -1); + +$dbh->do('INSERT INTO players (nick, country, club) VALUES (?, ?, ?)', undef, $nick, $country, $club); my $ref = $dbh->selectrow_hashref('SELECT player FROM players WHERE nick=?', undef, $nick);