The IP to Country Database

Its actually easy to do Item 1 in Excel/MS Access:
Start With Column E (Columns A though D will end up being the IP Address: A.B.C.D)

Col A is the formulae: @floor([Column E]/16777216,1)
Col B is the formulae: @floor([Column F]/65536,1)
Col C is the formulae: @floor([Column G]/256,1)
Col D is the formulae: @floor[Column H]

Col E is the IP Number
Col F is a Formulae: @sum([Column E] - ([Column A] * 16,777,216))
Col G is a Formulae: @sum((Column F] - ([Column B] * 65536)))
Col H is a formulae: @sum([Column G] - ([Column C] * 256))

You can, of cource, copy the formulaes and then paste them as many columns below that in Excel so ift performs the same function over and over.

Take Columns A, B, C and D and copy it. Go to word, select EDIT and "Paste Special" (as TEXT)

Hit CTRL-H. (Find and Relplace)
Enter ^t in the top and . in the bottom. That will replace all the tabs with decimal points. You then have ALL of the IP addresses to copy and paste back into Excel or wherever you want.

Hi yorktown
You can simply modify the code provided in our handbook - Example code to detect country to block Nigeria...

After the line

$country_code=$ccode_array['country_code2'];

Just type :

if ($country_code=="NG")
{
header("Location: http://www.domain/your-blocked-page.htm");
}

and then just close the data base connection.
You dont really need to bother about the exact IP Ranges of Nigeria :-)
-
Amit Bhawnani
another humble employee.

Have you even read the manual?? :-)
In PHP 4 you can use the following to convert a dotted IP Address to its corresponding IP Number:

$ip_number = sprintf("%u", ip2long($dotted_ip_address));

and this to convert IP Number to its corresponding dotted IP Address:

$dotted_ip_address = long2ip($ip_number);

and

//Warning PHP code!

//---------------------------------------------------
// Sample code to display Visitor Country information
// PHP 4
//---------------------------------------------------


// Establishing a database connection
$dbh=mysql_connect
("localhost:3306","$MYSQL_USERNAME","$MYSQL_PASSWORD");
mysql_select_db("$MYSQL_DBNAME");


// Query for getting visitor countrycode
$country_query = "SELECT country_code2,country_name FROM iptoc ".
"WHERE IP_FROM<=inet_aton('$REMOTE_ADDR') ".
"AND IP_TO>=inet_aton('$REMOTE_ADDR') ";


// Executing above query
$country_exec = mysql_query($country_query);


// Fetching the record set into an array
$ccode_array=mysql_fetch_array($country_exec);


// getting the country code from the array
$country_code=$ccode_array['country_code2'];


// getting the country name from the array
$country_name=$ccode_array['country_name'];


// Display the Visitor coountry information
echo "$country_code - $country_name";


// Closing the database connection
mysql_close($dbh);




:-))))))))))))


Min's

• La vie est une maladie mortelle sexuellement transmissible
• Life is a letal desease sexually transmissible Corret me if it's a bad translation... ;-)