From da5c8dd25b318cc82d69d1a05e0061b95cf6f4eb Mon Sep 17 00:00:00 2001 From: tipaul Date: Mon, 13 Sep 2004 15:20:28 +0000 Subject: [PATCH] fixes for notforloan management --- admin/itemtypes.pl | 21 +++++---------------- 1 file changed, 5 insertions(+), 16 deletions(-) diff --git a/admin/itemtypes.pl b/admin/itemtypes.pl index cd24949b11..8564c9c068 100755 --- a/admin/itemtypes.pl +++ b/admin/itemtypes.pl @@ -113,22 +113,11 @@ if ($op eq 'add_form') { # called by add_form, used to insert/modify data in DB } elsif ($op eq 'add_validate') { my $dbh = C4::Context->dbh; - my $query = "replace itemtypes (itemtype,description,renewalsallowed,rentalcharge,notforloan) values ("; - $query.= $dbh->quote($input->param('itemtype')).","; - $query.= $dbh->quote($input->param('description')).","; - if ($input->param('renewalsallowed') ne 1) { - $query.= "0,"; - } else { - $query.= "1,"; - } - $query.= $dbh->quote($input->param('rentalcharge')).","; - if ($input->param('notforloan') ne 1) { - $query.= "0)"; - } else { - $query.= "1)"; - } - my $sth=$dbh->prepare($query); - $sth->execute; + my $sth=$dbh->prepare("replace itemtypes (itemtype,description,renewalsallowed,rentalcharge,notforloan) values (?,?,?,?,?)"); + $sth->execute( + $input->param('itemtype'),$input->param('description'), + $input->param('renewalsallowed'),$input->param('rentalcharge'), + $input->param('notforloan')?1:0); $sth->finish; print "Content-Type: text/html\n\n"; exit; -- 2.39.5