Monday, November 24, 2003, 5:27:03 PM, you wrote:

Witam.

...

A z changeloga wynika ze kolumny users.tariff juz niema. Czy ktos obeznany moze mi podac co powinno byc wpisane?

wersja 1.1.4 Tanith (03/10/2003):

(...)

<ciach> To zrobilem, i nadal byly problemy. Pomoglo podgladniecie jak wygladaja wpisy w module do demona. Zmienilem sobie: my $dbq = $dbase->prepare("SELECT users.id AS id, 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 HAVING SUM((type * -2 + 7) * cash.value) < 0"); na: my $dbq = $dbase->prepare("SELECT users.id AS id, email, name, lastname, SUM((type * -2 +7) * cash.value) AS balance FROM users LEFT JOIN cash ON users.id = cash.userid AND (cash.type = 3 OR cash.type = 4) WHERE deleted = 0 GROUP BY users.id, name, lastname, email"); I drugi wpis jaki sie wywalal (przynajmniej u mnie): my $last10_dbq = $dbase->prepare("SELECT comment,value,type,time FROM cash WHERE userid='$row->{'id'}' AND (type>='3' ) ORDER BY time DESC LIMIT 0,10") ; na: my $last10_dbq = $dbase->prepare("SELECT comment,value,type,time FROM cash WHERE userid='$row->{'id'}' AND (type>='3' ) ORDER BY time DESC LIMIT 10") ; i teraz wyglada ze dziala juz bez zastrzezen. -- [ Krzysztof Zagórski GG:147848 ICQ: 236331820 GSM: +48 1E 0B 20 BC ] [ ircname: Maverick rlu:215007 PGP Key: http://3281429070/pgp ] [ http://znirevpx.wrfg.gjbvz.theh.cy mailto: maverick@irc.pl ]