Open-AudIT

I'm thinking this may be a bug, but maybe someone can explain why it is how it currently is. On the admin_nmap_input.php page, if the submitted data doesn't list a MAC, it uses the following SQL query to get the IP/UUID so it can map the ports to the correct pc/device in the DB....

[code]
$sql = "SELECT net_uuid FROM network_card WHERE net_ip_address = '" . $ip_address . "'";
[/code]

The problem with this seems to be that all the IP addresses in the database, for the field it's looking at, are padded with zeros. So, it never finds it and thus the ports found for the device are never added to the DB.

If I just use the 'ip_trans_to' function, like all the other queries on the page seem to do when they use the ip address, then it pads the IP address with the zeros it needs and the data is happily uploaded to the DB . So should this query be changed to be the following, like the others? ...

[code]
$sql = "SELECT net_uuid FROM network_card WHERE net_ip_address = '" . ip_trans_to($ip_address) . "'";
[/code]

Edit: Should've mentioned, this is line 147 in current SVN.

_________________
OA Server: Debian Squeeze w/ Apache2
Auditing: 700 Workstations, 250 or so Retail Terminals, about 75 Servers
OS's: Windows XP/2003/2008/2008 R2/Vista/7, Debian
LDAP: Active Directory 2008 R2

Thank you, fixed at SVN rev. 1184.

_________________
Edoardo