probuje przelaczyc damona tc-new tak aby mi generowal regulki dla komputerow z zawieszonymi zobowiazaniami, ale w zapytaniu o komputery nie widze nic na temat suspended, moze powinienem gdzies jeszcze poszukac?: tc-new.c :
// nodes query = strdup("SELECT t.downrate AS downrate, t.downceil AS downceil, t.uprate AS uprate, " "t.upceil AS upceil, t.climit AS climit, t.plimit AS plimit, " "n.id, n.ownerid, n.name, INET_NTOA(n.ipaddr) AS ip, n.mac, " "na.assignmentid, " #ifdef USE_PGSQL "TRIM(c.lastname || ' ' || c.name) AS customer " #else "TRIM(CONCAT(c.lastname, ' ', c.name)) AS customer " #endif "FROM nodeassignments na " "JOIN assignments a ON (na.assignmentid = a.id) " "JOIN tariffs t ON (a.tariffid = t.id) " "JOIN %nodes n ON (na.nodeid = n.id) " "JOIN customers c ON (a.customerid = c.id) " "%night_debtors" "WHERE " "(a.datefrom <= %NOW% OR a.datefrom = 0) " "AND (a.dateto >= %NOW% OR a.dateto = 0) " "AND n.access = 1 " "AND (t.downrate > 0 OR t.downceil > 0 OR t.uprate > 0 OR t.upceil > 0) " "%groups" "ORDER BY a.customerid, a.id");