X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=C4%2FReview.pm;h=e08d24ccc51803a87dffdf1dec188a4d7f26d9cd;hb=c0af4d18c2eecb7507423e5de6f000662e36d03e;hp=163efc621df56ab12f763f887faed1832c1c302b;hpb=5a68c161941f335ef7b256e9d932ccfae4dfcc01;p=koha.git diff --git a/C4/Review.pm b/C4/Review.pm index 163efc621d..e08d24ccc5 100644 --- a/C4/Review.pm +++ b/C4/Review.pm @@ -67,9 +67,7 @@ sub getreview { "SELECT * FROM reviews WHERE biblionumber=? and borrowernumber=?"; my $sth = $dbh->prepare($query); $sth->execute( $biblionumber, $borrowernumber ); - my $review = $sth->fetchrow_hashref(); - $sth->finish(); - return $review; + return $sth->fetchrow_hashref(); } sub savereview { @@ -80,7 +78,6 @@ sub savereview { (?,?,?,0,now())"; my $sth = $dbh->prepare($query); $sth->execute( $borrowernumber, $biblionumber, $review); - $sth->finish(); } sub updatereview { @@ -89,7 +86,6 @@ sub updatereview { my $query = "UPDATE reviews SET review=?,datereviewed=now(),approved=0 WHERE borrowernumber=? and biblionumber=?"; my $sth = $dbh->prepare($query); $sth->execute( $review, $borrowernumber, $biblionumber ); - $sth->finish(); } sub numberofreviews { @@ -138,7 +134,6 @@ sub approvereview { WHERE reviewid=?"; my $sth = $dbh->prepare($query); $sth->execute( 1, $reviewid ); - $sth->finish(); } =head2 deletereview @@ -156,7 +151,6 @@ sub deletereview { WHERE reviewid=?"; my $sth = $dbh->prepare($query); $sth->execute($reviewid); - $sth->finish(); } 1;