X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;ds=sidebyside;f=members%2Fsetstatus.pl;h=a45a33136d382f7ccc0708e471e0ae18dcff175f;hb=b32c38f9f10e0e2ad6eff5c044a520a14f9f1eaf;hp=fc27c175d5b96e3c5ba682127f26b098711c073b;hpb=868b8cdbaa079a948a6015f713fa3384a7f404b5;p=koha_gimpoz diff --git a/members/setstatus.pl b/members/setstatus.pl index fc27c175d5..a45a33136d 100755 --- a/members/setstatus.pl +++ b/members/setstatus.pl @@ -6,6 +6,7 @@ # Copyright 2000-2002 Katipo Communications +# Parts copyright 2010 BibLibre # # This file is part of Koha. # @@ -18,9 +19,9 @@ # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR # A PARTICULAR PURPOSE. See the GNU General Public License for more details. # -# You should have received a copy of the GNU General Public License along with -# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place, -# Suite 330, Boston, MA 02111-1307 USA +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. use strict; use warnings; @@ -50,8 +51,8 @@ if ( $reregistration eq 'y' ) { # re-reregistration function to automatic calcul of date expiry $dateexpiry = ExtendMemberSubscriptionTo( $borrowernumber ); } else { - my $sth=$dbh->prepare("Update borrowers set debarred = ? where borrowernumber = ?"); - $sth->execute($status,$borrowernumber); + my $sth = $dbh->prepare("UPDATE borrowers SET debarred = ?, debarredcomment = '' WHERE borrowernumber = ?"); + $sth->execute( $status, $borrowernumber ); $sth->finish; }