";
// Выводим сами ip-адреса
?>
0)
{
$i=1;
while($ip = mysql_fetch_array($ips))
{
$query = "SELECT city_name, region_name
FROM $tbl_ip_compact, $tbl_cities, $tbl_regions
WHERE INET_ATON('$ip[ip]') BETWEEN init_ip AND end_ip AND
$tbl_cities.city_id = $tbl_ip_compact.city_id AND
$tbl_cities.region_id = $tbl_regions.region_id";
$reg = mysql_query($query);
if(!$reg)
{
throw new ExceptionMySQL(mysql_error(),
$query,
"Ошибка при определении
местоположения IP-адреса");
}
$region = mysql_fetch_array($reg);
echo "
$i |
$ip[ip] | ";
if(HOST_BY_ADDR) echo "".(@gethostbyaddr($ip['ip']))." | ";
else echo "- | ";
if ($region['city_name'])
echo "$region[city_name] | ";
else echo "нет данных | ";
if ($region['region_name'])
echo "$region[region_name] | ";
else echo "нет данных | ";
echo "$ip[hits] | $ip[putdate] | ";
$i++;
}
}
echo "
";
// Включаем завершение страницы
require_once("../utils/bottomcounter.php");
}
catch(ExceptionObject $exc)
{
require("../utils/exception_object.php");
}
catch(ExceptionMySQL $exc)
{
require("../utils/exception_mysql.php");
}
catch(ExceptionMember $exc)
{
require("../utils/exception_member.php");
}
?>