- my $dbh = C4::Context->dbh;
- my $query = "replace printers (printername,printqueue,printtype) values (";
- $query.= $dbh->quote($input->param('printername')).",";
- $query.= $dbh->quote($input->param('printqueue')).",";
- $query.= $dbh->quote($input->param('printtype')).")";
- my $sth=$dbh->prepare($query);
- $sth->execute;
- $sth->finish;
+ if ($input->param('add')){
+ my $sth=$dbh->prepare("INSERT INTO printers (printername,printqueue,printtype) VALUES (?,?,?)");
+ $sth->execute($input->param('printername'),$input->param('printqueue'),$input->param('printtype'));
+ } else {
+ my $sth=$dbh->prepare("UPDATE printers SET printqueue=?,printtype=? WHERE printername=?");
+ $sth->execute($input->param('printqueue'),$input->param('printtype'),$input->param('printername'));
+ }