From 14b66041f0dc08a5618985b44e1816a6c9978f45 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Mon, 15 Nov 2010 18:13:32 -0500 Subject: [PATCH] Another bug 5004 fix, this time for road types The road types interface didn't block deletion of road types in use, but the script included the same queries that cities.pl did, as if it intended to. Signed-off-by: Galen Charlton Signed-off-by: Chris Cormack --- admin/roadtype.pl | 8 -------- 1 file changed, 8 deletions(-) diff --git a/admin/roadtype.pl b/admin/roadtype.pl index 544d48850b..a75659437f 100755 --- a/admin/roadtype.pl +++ b/admin/roadtype.pl @@ -98,18 +98,10 @@ if ($op eq 'add_form') { } elsif ($op eq 'delete_confirm') { $template->param(delete_confirm => 1); my $dbh = C4::Context->dbh; - my $sth=$dbh->prepare("select count(*) as total from borrowers,roadtype where borrowers.streettype=roadtype.road_type and roadtypeid=?"); - $sth->execute($roadtypeid); - my $total = $sth->fetchrow_hashref; - $sth->finish; - $template->param(total => $total->{'total'}); my $sth2=$dbh->prepare("select roadtypeid,road_type from roadtype where roadtypeid=?"); $sth2->execute($roadtypeid); my $data=$sth2->fetchrow_hashref; $sth2->finish; - if ($total->{'total'} >0) { - $template->param(totalgtzero => 1); - } $template->param( road_type => ( $data->{'road_type'}), -- 2.39.2