IP Address and Location
I am trying to match up IP addresses to determine the location of the IP address. I am primarily concerned with flagging IP addresses that are from outside the U.S. I was able to download a file...
Forum Discussion
IP addresses come in two varieties IPv4 and IPv6. You are expressing your IP addresses as decimal numbers which is uncommon for IPv4 and never done for IPv6. So I don't think your blacklist / whitelist technique is going to work based on saving the IP addresses in a table and using a formula to test for inclusion or exclusion. Moreover, IP addresses don't map cleanly to location and can easily be defeated by using a proxy of VPN.
If you want to prevent access from specific IP addresses or other geolocation information you probably have to use script and access a geolocation API service.
I do use a geo-location service in my Pastie database to record where users are located. If you want to pursue a IP address or geo-location solution fee free to contact me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt/
If you want to prevent access from specific IP addresses or other geolocation information you probably have to use script and access a geolocation API service.
I do use a geo-location service in my Pastie database to record where users are located. If you want to pursue a IP address or geo-location solution fee free to contact me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt/