Jan Łukasz wrote:

Czy ktos wie jak szybko wlaczyc zawieszenie naliczania zobowizan wszystkim klientom nalezacym do danej sieci w LMS

UPDATE customers SET cutoffstop = X WHERE id IN ( SELECT DISTINCT ownerid FROM nodes, networks WHERE networks.name = Y AND (address = (nodes.ipaddr & inet_aton(mask)) OR address = (nodes.ipaddr_pub & inet_aton(mask))) ) coś w ten deseń -- Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252 LAN Management System Developer http://lms.org.pl !DSPAM:47e9fa6d19161804284693!