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
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
