Here’s a great resource for IP geo-location, there’s a guy who’s made a MySQL table for it, so all you need to do is check the IP address against the database. I have personally been thinking of making such a site and this is going to help me do that, awesome! I hope it helps you too.
The IP addresses are listed in table ip_group_city. The data is not in the 1.1.1.1 format since it would need to be stored as text and we dont want that for obvious reasons. Let say for ip A.B.C.D, the formula is ip = (A*256+B)*256+C (I assu
