RE: [PHP] IP and countries -- Discussion Continues

In a word no. eg nnn.x.x.x could contain any number of countries... Just depends on the ip ranges they assigned way back when the internet was young. You could do this by hand for the bigger isp's, but they tend to proxy things, and their proxy servers resolve anyway. Its the "third world" countries you have to worry about anyway*. For example I'm in China. My website logs have around 70% unresolved ip addresses in my stats pages This is because roughly 99% of the isp's here haven't setup their ip ranges to resolve to a given name. One possible way to resolve would be to look at the last router that they bounced off of, and use that - eg whois -h 202.96.197.15 which then does a tracert + ICMP echo request to the ip You can then attempt to determine what area they are in by looking at the routers. However, there are no standards for determining what common names for routers are, (although they all seem to be cisco's in my region!) *By third world, I mean countries where you can walk outside, get cash from a machine without worrying about being robbed, unlike those civilised western countries such as the us. ;) -----Original Message----- From: Maxim Maletsky [mailto:maxim.maletsky@japaninc.net] Sent: November 8, 2000 12:30 PM To: 'PHP General List. (E-mail)' Subject: RE: [PHP] IP and countries -- Discussion Continues But, is there a way to query databases for IP getting so the country = codes? like APNIC, but it is only one... what is bigger then APNIC? Where can I have ALL IP search? I could then make a class that inputs an IP and returns country code, = but I have no idea where to query better ...=20 -----Original Message----- From: Jason Murray [mailto:Jason.Murray@melbourneit.com.au] Sent: Wednesday, November 08, 2000 1:19 PM To: 'Lawrence.Sheed@dfait-maeci.gc.ca'; Jason Murray; nick.a.wilson@baesystems.com; Maxim Maletsky; dhill@bajan.org; jamoros@solohijos.com Cc: php-general@lists.php.net Subject: RE: [PHP] IP and countries -- (offtopic) Actually they *have* not *can* ... what they've done is created a = database of where every IP is in the world. They say in the US they hope to be specific down to postcode in the future. Using Quova's system would require licensing the tech from them, too. I suspect this will be quite pricey. Jason (who was wondering how long it'd be before Quova copped a mention :)) --=20 Jason Murray jasonm@melbourneit.com.au Web Design Team, Melbourne IT Give me ambiguity or give me something else. > -----Original Message----- > From: Lawrence.Sheed@dfait-maeci.gc.ca > [mailto:Lawrence.Sheed@dfait-maeci.gc.ca] > Sent: Wednesday, November 08, 2000 3:11 PM > To: Jason.Murray@melbourneit.com.au; nick.a.wilson@baesystems.com; > maxim.maletsky@japaninc.net; dhill@bajan.org; jamoros@solohijos.com > Cc: php-general@lists.php.net > Subject: RE: [PHP] IP and countries -- (offtopic) >=20 >=20 > One company says that they can >=20 > Quova.com - "Quova Inc. claim they have completed a global=20 > scanning system > [Note: first mentioned on Slashdot in July -- timothy] that=20 > pinpoints the > geographic location of Internet users in real time. The=20 > information gathered > is then sold as a tool called 'GeoPoint' that can be used by=20 > advertisers to > better target their advertisments to people based on their=20 > location. It > doesn't rely on cookies or voluntary submissions from users,=20 > instead, using > a data base built by scanning every host on the Internet. In=20 > gathering this > information, they set off alarms all over the world, and yet,=20 > it seems that > this is an accceptable practice in the eyes of the law.=20 > Individual people > are having their computers impounded and in some cases are being > incarcerated for doing the same. ...=20 > Have a look at the slashdot thread for more info >=20 > http://slashdot.org/article.pl?sid=3D00/11/06/0521235 >=20 >=20 >=20 > -----Original Message----- > From: Jason Murray [mailto:Jason.Murray@melbourneit.com.au] > Sent: November 8, 2000 11:56 AM > To: 'WILSON, Nick'; 'Maxim Maletsky'; 'Duncan Hill'; Jordi > Amor=F3s > Cc: php-general@lists.php.net > Subject: RE: [PHP] IP and countries -- Discussion Continues >=20 >=20 > > Is there more to this that I am missing ?=20 >=20 > Yes, aol.com could be in the USA, Australia, the UK or (I believe)=20 > Hong Kong. >=20 > An ISP in Melbourne Australia could also have a .com domain just > for the hell of it. >=20 > You *can't* reliably detect country of origin from the remote host. > (Not every IP address has a reverse lookup, anyway). >=20 > Jason >=20 > --=20 > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail:=20 > php-list-admin@lists.php.net >=20