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

Galen Charlton gmcharlt at gmail.com
Tue Nov 16 00:13:32 CET 2010


From: Owen Leonard <oleonard at myacpl.org>

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 <gmcharlt at gmail.com>
---
 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.0



More information about the Koha-patches mailing list