From e85dcb22da5dd7f08649fe27f1038c3d07b07284 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Mon, 15 Nov 2010 10:12:37 -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. --- admin/roadtype.pl | 8 -------- 1 files changed, 0 insertions(+), 8 deletions(-) diff --git a/admin/roadtype.pl b/admin/roadtype.pl index 544d488..a756594 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'}), -- 1.7.1