Hello A.L.E.C,
Tuesday, July 13, 2004, 9:02:41 PM, you wrote:
ALEC> Przemek SAKO Galczewski wrote:
! $dbq = $dbase->prepare("SELECT userid, SUM(uprate) AS uprate, SUM(downrate) AS downrate 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) AND (datefrom <= dateto OR dateto = 0) GROUP BY userid"); $dbq->execute();
ALEC> dzieki, ale zdaje sie, ze wystarczy, tak jak jest w lms-payments: ALEC> WHERE users.id = userid AND deleted = 0 AND tariffid = ALEC> tariffs.id AND (datefrom <= $utsfmt OR datefrom = 0) AND (dateto > ALEC> $utsfmt OR dateto = 0) GROUP BY userid
mozna i tak, sorry, ale nie optymalizowalem tego i nie zagladalem do payments, po prostu poprawilem buga analogicznie do skladni wykorzystywanej w mgc.
najwazniejsze, ze jeden bug mniej :)