The IP to Country Database

toaster42,

hello, do you know how often is the ip-to-country.csv file updated???
it's quite important jejeje thanks.

jalanis

Hello!

I want to know if there is a news letter where you can subscribe ro know when there is new update on the ip list

Thanks


Rebel.

Please can add new IP addresses for Libya to ip-to-country.csv:
from 62.240.32.0 to 62.240.63.255 and decimal:
from 1055924224 to 1055932415

He Guys,
Here's a good-working script for importing your csv-file into your database.

http://willem.creationpoint.nl/ip2country/import_ip_to_country.phps

What is fastest?

A mysql lookup,
http://ip-to-country.webhosting.info/node/view/118

or locally stored files like php.net have?
http://www.php.net/source.php?url=/include/ip-to-country.inc

tnx!

Hi There,

do any one knws why down loaded csv file contain ip range with out first two zero's example.

"33996344","33996351","GB","GBR","UNITED KINGDOM"
"50331648","69956103","US","USA","UNITED STATES"
"69956104","69956111","BM","BMU","BERMUDA"

But in the exmaple page (http://ip-to-country.webhosting.info/node/view/54) in the site it shows as

"0033996344","0033996351","GB","GBR","UNITED KINGDOM"
"0050331648","0083886079","US","USA","UNITED STATES"
"0094585424","0094585439","SE","SWE","SWEDEN"

Could you please tell me what is the correct format of above 2

Cheers!
Sivalee

It appears South African IPs are mostly missing from the database. And it has been the case for quite some time now. Here's a few IPs that resolve to "some place we don't know", but should be assigned to "ZA":
196.39.85.147
196.23.43.3
165.165.16.136

---
online chess

@import_file[filename]
###
### Parser3 (http://www.parser.ru/en/)
### operator for importing IP-to-Country
### data into mysql
### (c) Redactor 2006
###
^if(!def $filename){

$filename[ip-to-country.csv]

}

$incoming_csv[^table::load[nameless;temp/ip-to-country.csv;$.encloser["] $.separator[,]]]
^connect[mysql://root@localhost/iptoc] {
^void:sql{TRUNCATE mirr_iptoc}
^incoming_csv.menu{

^void:sql{INSERT
INTO
iptoc
(ip_from,ip_to,country_code_2,country_code_3,country_name)
VALUES
("$incoming_csv.0","$incoming_csv.1","$incoming_csv.2","$incoming_csv.3","$incoming_csv.4")
}
}
}
$result[done]

is there any database available to convert ip into CITY rather than country?

I wrote a little script to convert the csv file to sql import script: #!/bin/php
$lines=file('ip-to-country.csv');
foreach($lines as $line){
$line=trim($line);
if(!preg_match('/^"([0-9]+)","([0-9]+)","(.{2})","(.{3})","(.*)"$/',$line,$matches)){
echo "error";
}else{
echo 'insert into ip2c values("'.($matches[1]).'","'.($matches[2]).'","'.($matches[3]).'","'.($matches[4]).'","'.($matches[5]).'");'."\n";
}
}
?>


Usage:
copy this script and .csv file in the same dir then run:
convert.php >ip2c.sql


Here is create table syntax:

CREATE TABLE `ip2c` (
`start` int(10) unsigned NOT NULL default '0',
`end` int(10) unsigned NOT NULL default '0',
`a2` char(2) NOT NULL default '',
`a3` char(3) NOT NULL default '',
`country` varchar(100) NOT NULL default '',
PRIMARY KEY (`start`,`end`)
);