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())
{
--
_ _._. _ .|_
(_)| /_(/.(.| )
Tomek Orzechowski
Solitude, mon Dieu, solitude...
