<?php
include("./config.php");
$filename ="./dump_port.log";
$fp =fopen($filename, "r");
$pub = fread($fp, filesize($filename));
fclose($fp);
$arr = array();
$arr = preg_split('/\n/', $pub,-1, PREG_SPLIT_NO_EMPTY);
$count_port=0;

foreach ($arr as $idx=> $val) {
	$count_port++;
	$knot_par = explode(";", $arr[$idx]); 
	$knot_ip=trim($knot_par[3]);	
	$knot_port=trim($knot_par[1]);

	mysql_query("LOCK TABLES `net` WRITE;");
	$query_up = "UPDATE net SET port_to='$knot_port' where INET_NTOA(ip_for)='$knot_ip'";
       	if(!mysql_query($query_up))
       	{
       		echo "error update";
       	}
	mysql_query("UNLOCK TABLES");
}
echo"port  $count_port";
?>