X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=updatecharges.pl;h=ba064706c26f9bf8ea0a48ab7ade466551f5dc17;hb=1d3d4602227e118d948ee28e934f069b4ba9f11e;hp=07f0985c786f3b26daaf77da791aaa3d051648d7;hpb=dbca39823f826d5e8d1cd7c0fc8d768be1f57b64;p=koha.git

diff --git a/updatecharges.pl b/updatecharges.pl
index 07f0985c78..ba064706c2 100755
--- a/updatecharges.pl
+++ b/updatecharges.pl
@@ -1,5 +1,7 @@
 #!/usr/bin/perl
 
+# $Id$
+
 #script to update charges for overdue in database
 #updates categoryitem
 # is called by charges.pl
@@ -39,16 +41,16 @@ my $dbh = C4::Context->dbh;
 my @names=$input->param();
 
 foreach my $key (@names){
-  
+
   my $bor=substr($key,0,1);
   my $cat=$key;
   $cat =~ s/[A-Z]//i;
   my $data=$input->param($key);
   my @dat=split(',',$data);
 #  print "$bor $cat $dat[0] $dat[1] $dat[2] <br> ";
-  my $sth=$dbh->prepare("Update categoryitem set fine=$dat[0],startcharge=$dat[1],chargeperiod=$dat[2] where 
-  categorycode='$bor' and itemtype='$cat'");
-  $sth->execute;
+  my $sth=$dbh->prepare("Update categoryitem set fine=?,firstremind=?,chargeperiod=? where
+  categorycode=? and itemtype=?");
+  $sth->execute($dat[0],$dat[1],$dat[2],$bor,$cat);
   $sth->finish;
 }
 print $input->redirect("/cgi-bin/koha/charges.pl");