[Koha-patches] [PATCH] Another bug 5004 fix, this time for road types

Owen Leonard oleonard at myacpl.org
Mon Nov 15 16:14:11 CET 2010


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



More information about the Koha-patches mailing list