[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