$val) { $knot_par = explode(";", $arr[$idx]); $knot_ip=trim($knot_par[0]); $knot_mac=trim($knot_par[1]); if($knot_mac==""){ fwrite($fperr, $knot_ip."\n"); }else{ $knot_mac_exp = explode(":", $knot_mac); $knot_mac = sprintf("%02s:%02s:%02s:%02s:%02s:%02s", $knot_mac_exp[0], $knot_mac_exp[1], $knot_mac_exp[2], $knot_mac_exp[3], $knot_mac_exp[4], $knot_mac_exp[5]); } $query = "select k.id FROM knot k LEFT JOIN net as n ON k.id=n.id_knot where n.ip_for=INET_ATON('$knot_ip')"; $param=mysql_query($query); if($param){ while($rows_id_knot=mysql_fetch_array($param)){ $db_id_knot=$rows_id_knot['id']; $db_id_mac=""; $query_mac = "select m.id as id_mac FROM knot k,mac as m where k.id=m.id_knot and k.id=$db_id_knot and m.name='$knot_mac'"; $param_mac=mysql_query($query_mac); if($param_mac){ while($rows_mac=mysql_fetch_array($param_mac)){ $db_id_mac=$rows_mac['id_mac']; } if(($db_id_mac=="") and ($knot_mac<>"")){ $count_mac++; echo"$knot_ip ; $knot_mac
"; $query_up = "insert into `mac` values(NULL,'$knot_mac',0,$db_id_knot)"; if(!mysql_query($query_up)){ echo"error insert"; } } } } } } echo"Count mac: $count_mac"; fclose($fp_err); ?>