lms wrote:

Potrzebowalbym jakiegos skryptu (perl?) ktory zrzuci mi z poziomu konsoli z baz lmsa liste klientow zadluzonych w postaci

Imie Nazwisko,Adres IP, Kwota zadluzenia, Ile abonamentow nie zapalcil

Ma ktos cos takiego juz gotowego ewentualnie czy moglby ktos cos takiego napisac ? ;)

dla postgresa:

#!/bin/bash

/usr/local/pgsql/bin/psql -d lms -U lms -c \ "SELECT users.name || ' '|| users.lastname AS owner, inet_ntoa(ipaddr) AS ip, round(COALESCE(SUM((type * -2 + 7) * value), 0.00)/(CASE COUNT(DISTINCT nodes.id) WHEN 0 THEN 1 ELSE COUNT(DISTINCT nodes.id) END),2) AS balance FROM nodes LEFT JOIN users ON (ownerid = users.id) LEFT JOIN cash ON (cash.userid = users.id) GROUP BY nodes.id, ipaddr, users.lastname, users.name HAVING SUM((type * -2 + 7) * value) < 0"

zeby wyciagnac ilosc niezaplaconych abonamentów trzeba wiecej pokombinowac, móglbym ci to napisac za powiedzmy 100 PLN.

-- Aleksander 'A.L.E.C' Machniak http://alec.pl gg-2275252 Lan Management System Developer http://lms.alec.pl

************************************************************** Scanned by eScan Anti-Virus and Content Security Software. Visit http://www.mwti.net for more info on eScan and MailScan. **************************************************************