The IP to Country Database

Alternatively, if you're using MySQL you can use the functions inet_ntoa() and inet_aton() for converting to and from dotted representation respectively.
For example:

SELECT country_name FROM iptocountry
  WHERE inet_aton('$remote_addr') >= ip_from
  AND inet_aton('$remote_addr') <= ip_to;

The dotted ip to number conversion with bit shifting
Example

$ip = "194.109.136.80";
$ip_bytes = explode(".", $ip);
$longnum = ($ip_bytes[0] << 24) | ($ip_bytes[1] << 16) |
           ($ip_bytes[2] << 8) | $ip_bytes[3];
printf("%u\n", $longnum);

Just another way of doing it ;)

with 256 as our base multiplier, I will restate:
IP Number = A * m^3 + B * m^2 + C * m^1 + D * m^0

beautifully,
A = (IP Number / m^3) - Modulo(IP Number / m^3)

In words, devide the IP number by the multiplier for the octet you wish to retrieve and throw away the remainder.

Then reapply the multiplier to your result and subtract that result from the IP number before calculating the next octet.

wash, rinse, repeat....

and D. Sharma, if you can't make use of this, there are inet_aton and inet_ntoa in the wsock32.dll. You should be able to make use of them in MS SQL server through either DTS or extended procedures.....

Its good to use ip2long() function to get the IP Number. I any case, if you get a negative number as the result of ip2long(), what will you do? Here is a solution in PHP :

<?php
$ip = $_SERVER['REMOTE_ADDR'];
$ip_number = sprintf("%u", ip2long($ip));

here goes your own code......
?>

I think it will help you.

Hi, if this can help someone a vbscript (Visual Basic Scripting Edition) long2ip function I have wrote.

function vbLong2ip(ipLong)
	ipLong = abs(ipLong)
	ipA = fix(ipLong/256^3)
	ipB = fix((ipLong-ipA*256^3)/256^2)
	ipC = fix((ipLong-(ipA*256^3+ipB*256^2))/256)
	ipD = fix(ipLong-((ipA*256^3)+(ipB*256^2)+(ipC*256)))
	vbLong2ip=ipA & "." & ipB & "." & ipC & "." & ipD
end function

and with Excel you can do :
(with A1 = IP Number)

B1 = FLOOR (A1/256^3;1)
C1 = FLOOR ((A1-B1*256^3)/256^2;1)
D1 = FLOOR ((A1-(B1*256^3+C1*256^2))/256;1)
E1 = FLOOR ((A1-((B1*256^3)+(C1*256^2)+D1*256));1)
F1 = B1 & "." & C1 & "." & D1 & "." & E1

you will then have in Excel sheet :

 |     A     |     B    |    C     |     D    |    E     |   F        
-----------------------------------------------------------
1| IP number | ipA part | ipB part | ipC part | ipD part | IP Address (A.B.C.D)

of course all this can be write in others ways (by concatenating all formulas on one line) in both vbscript or excel ...
cheers
CP aka ECL

thought i'd share this, maybe it's of use to someone else, too.

def num2dot(c):
    assert c > 0 and c < 4294967295
    ip = []
    for i in xrange(3, 0, -1):
        p = 256 ** i
        ip.append(c/p)
        c -= (c/p)*p
    ip.append(c)
    return '.'.join([str(x) for x in ip])

def dot2num(s):
    ip = [int(x) for x in s.split('.')]
    i = 0
    for x in xrange(3, 0, -1):
        i += ip.pop(0) * (256 ** x)
    i += ip.pop(0)
    return i

What happened? fetish toons That fetish toons and cartoons. big boobs hardcore I see on her big boobs hardcore. asian teen sucking Asian teen sucking is very good. anal cream pies There are anal cream pies, isn't it? mature big dildos Mature big dildos are attractive. lesbian dildo movies Watch lesbian dildo movies on plasma. gay cock hard His gay cock hard moving into Jack. ass big wet His ass big wet and smooth. teens tricked Teens tricked are very interesting. cum pussy wet Her cum pussy wet is pretty. mature beauty ass Dan said: " mature beauty ass ." teens undressing There some teens undressing in the diner-room. lesbian double dildo What do you think about lesbian double dildo? big boobs in There are big boobs in her red dress. asian undressing See! That asian undressing! anal cum extreme Anna has anal cum extreme. It is weather.