Publisher review:decimal_ip_converter.sql script will let you convert a normal ip address into a decimal ip address. decimal_ip_converter.sql script will let you convert a normal ip address into a decimal ip address.
On the internet one can find databases of ip-ranges and their country of origin. An example is: http://ip-to-country.webhosting.info/
These ranges however, are always in decimal form. And although it would be way faster to save your visitors ip in decimal form, instead of converting it on the spot when doing a lookup, this function might still be handy for short term purposes, or to use in an UPDATE on your table.
You must just simply copy-paste the script source code and replace ip & visitors with the right names.
decimal_ip_converter.sql is a SQL script for Database Tools scripts design by Excudo.net.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
will let you convert a normal ip address into a decimal ip address.
Operating system:Windows / Linux / Mac OS / BSD / Solaris