[Koha-cvs] CVS: koha deletemem.pl,1.3,1.3.2.1
Andrew Arensburger
arensb at users.sourceforge.net
Fri Oct 4 03:52:27 CEST 2002
Update of /cvsroot/koha/koha
In directory usw-pr-cvs1:/tmp/cvs-serv10842
Modified Files:
Tag: arensb-context
deletemem.pl
Log Message:
Use C4::Connect instead of C4::Database, C4::Connect->dbh instead
C4Connect.
Index: deletemem.pl
===================================================================
RCS file: /cvsroot/koha/koha/deletemem.pl,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -C2 -r1.3 -r1.3.2.1
*** deletemem.pl 14 Aug 2002 18:12:51 -0000 1.3
--- deletemem.pl 4 Oct 2002 01:52:25 -0000 1.3.2.1
***************
*** 25,32 ****
use strict;
- use C4::Search;
use CGI;
use C4::Output;
- use C4::Database;
use C4::Circulation::Circ2;
#use C4::Acquisitions;
--- 25,32 ----
use strict;
use CGI;
+ use C4::Context;
+ use C4::Search;
use C4::Output;
use C4::Circulation::Circ2;
#use C4::Acquisitions;
***************
*** 45,49 ****
}
my ($bor,$flags)=getpatroninformation(\%env, $member,'');
! my $dbh=C4Connect;
my $query="Select * from borrowers where guarantor='$member'";
my $sth=$dbh->prepare($query);
--- 45,49 ----
}
my ($bor,$flags)=getpatroninformation(\%env, $member,'');
! my $dbh = C4::Context->dbh;
my $query="Select * from borrowers where guarantor='$member'";
my $sth=$dbh->prepare($query);
***************
*** 51,55 ****
my $data=$sth->fetchrow_hashref;
$sth->finish;
- $dbh->disconnect;
--- 51,54 ----
***************
*** 75,79 ****
sub delmember{
my ($member)=@_;
! my $dbh=C4Connect;
my $query="Select * from borrowers where borrowernumber='$member'";
my $sth=$dbh->prepare($query);
--- 74,78 ----
sub delmember{
my ($member)=@_;
! my $dbh = C4::Context->dbh;
my $query="Select * from borrowers where borrowernumber='$member'";
my $sth=$dbh->prepare($query);
***************
*** 87,101 ****
$query=~ s/\,$/\)/;
# print $query;
$sth=$dbh->prepare($query);
$sth->execute;
$sth->finish;
$query = "Delete from borrowers where borrowernumber='$member'";
$sth=$dbh->prepare($query);
$sth->execute;
$sth->finish;
$query="Delete from reserves where borrowernumber='$member'";
$sth=$dbh->prepare($query);
$sth->execute;
$sth->finish;
- $dbh->disconnect;
}
--- 86,102 ----
$query=~ s/\,$/\)/;
# print $query;
+ # FIXME - Use $dbh->do()
$sth=$dbh->prepare($query);
$sth->execute;
$sth->finish;
+ # FIXME - Use $dbh->do()
$query = "Delete from borrowers where borrowernumber='$member'";
$sth=$dbh->prepare($query);
$sth->execute;
$sth->finish;
+ # FIXME - Use $dbh->do()
$query="Delete from reserves where borrowernumber='$member'";
$sth=$dbh->prepare($query);
$sth->execute;
$sth->finish;
}
More information about the Koha-cvs
mailing list