Nastepny patch :) ################################################################## --- lms-mgc 2004-07-13 23:19:35.000000000 +0200 +++ lms-mgc-new 2004-07-14 15:22:26.000000000 +0200 @@ -410,6 +410,10 @@ my %uprates; my %downrates; + my %upceils; + my %downceils; + my %climits; + my %plimits; $dbq = $dbase->prepare("SELECT userid, SUM(uprate) AS uprate, SUM(downrate) AS downrate, SUM(upceil) AS upceil, SUM(downceil) AS downceil, SUM(climit) AS climit, SUM(plimit) AS plimit FROM assignments, users, tariffs WHERE users.id = userid AND deleted = 0 AND tariffid = tariffs.id AND (datefrom <= $utsfmt OR datefrom = 0) AND (dateto > $utsfmt OR dateto = 0) GROUP BY userid"); $dbq->execute(); ################################################################# -- Best regards, Przemek mailto:sako@infinity.waw.pl