Биллинговая система Nodeny

 "SELECT `name`,`ip`,`adress`,`paket` FROM `users` WHERE `grp` IN (2,10)";

SELECT users.id,users.name,users.ip,users.paket,dopdata.field_value AS mac_modem,dopdata.revision
  FROM users,dopdata WHERE dopdata.parent_id=users.id AND dopdata.template_num=1 
  AND dopdata.field_alias='_mac_modem' AND users.grp IN (2,10) ORDER BY dopdata.revision 

$sql="SELECT * FROM dopdata WHERE revision=(SELECT MAX(revision) FROM dopdata 
		WHERE parent_id=$Mid AND template_num='$template_num')";

host d3132{
hardware ethernet 00:1f:d0:98:b1:06;
fixed-address 172.16.2.20;
}

host d3132-modem {
hardware ethernet 00:18:c0:17:e6:0e;
fixed-address 172.16.12.20;
filename "cm-91.bin";
}

# Select All ip <-> Mac pair
$query="SELECT u.ip AS ip, d.field_value AS mac FROM users u, dopvalues d, (
		SELECT u.ip AS ip, MAX(d.revision) AS rev FROM users u, dopvalues d
		    WHERE u.id=d.parent_id AND d.dopfield_id=".$config{'dopfield_id'}."
		    GROUP BY ip
		) AS tmp
    	    WHERE u.id=d.parent_id
            AND d.dopfield_id=".$config{'dopfield_id'}."
            AND u.ip=tmp.ip
            AND d.revision=tmp.rev
            AND TRIM(d.field_value) != ''";