Po dodaniu PIN lms-notify przestaje działać. Poprawka:
--- lms-notify 2004-09-27 18:49:47.592842060 +0200 +++ /usr/share/lms/scripts/lms-notify 2004-09-27 18:50:54.692044457 +0200 @@ -163,7 +163,7 @@ my @mtempl = <MTFILE>; close MTFILE;
-my $dbq = $dbase->prepare("SELECT users.id AS id, pin, lastname, name, email, phone1, SUM((type * -2 + 7) * cash.value) AS balance FROM users LEFT JOIN cash ON users.id = cash.userid GROUP BY users.id, lastname, name, email, phone1 HAVING SUM((type * -2 + 7) * cash.value) < 0"); +my $dbq = $dbase->prepare("SELECT users.id AS id, pin, lastname, name, email, phone1, SUM((type * -2 + 7) * cash.value) AS balance FROM users LEFT JOIN cash ON users.id = cash.userid GROUP BY users.id, pin, lastname, name, email, phone1 HAVING SUM((type * -2 + 7) * cash.value) < 0"); $dbq->execute(); while (my $row = $dbq->fetchrow_hashref()) {