IP-to-Country is a plugin which doesn't provide any output to users, but which\nmay be used by plugin authors to quickly and easily find, in which country an\nIP address is located.<\/p>\n\n
To do so the plugin uses data files from either http:\/\/ip-to-country.webhosting.info\n(IPv4 only) or http:\/\/software77.net\/geo-ip\/ (both IPv4 and IPv6).\nOther sources are possible as long as they have the same format: CSV file, \nfields enclosed with quotes (\") and separated with comma (,), lines ending\nwith LF (\\n). Five columns:<\/p>\n\n
Note: In order to import IPv6 addresses, IPv4 must be imported first. The \nreason is, IPv6 database does not carry the full country information with\nit, while the IPv4 database does.<\/p>\n\n
Operations:<\/p>\n\n
To detect if IP-to-Country plugin is installed:<\/p>\n\n
$ip2c_available = class_exists('PepakIpToCountry');<\/p><\/li>\n
To find information about a numeric IP address:<\/p>\n\n
$country = PepakIpToCountry::IP_to_Country_Full('8.8.8.8');\n \/\/ returns 'UNITED STATES'\n $country = PepakIpToCountry::IP_to_Country('8.8.8.8');\n $country = PepakIpToCountry::IP_to_Country_XX('8.8.8.8');\n \/\/ both return 'US'\n $country = PepakIpToCountry::IP_to_Country_XXX('8.8.8.8');\n \/\/ returns 'USA'\n $country = PepakIpToCountry::IP_to_Country_Info('8.8.8.8');\n \/\/ returns Array('iso_name'=>'UNITED STATES', 'iso_code2'=>'US', 'iso_code3'=>'USA')\n$image = PepakIpToCountry::IP_to_Country_Flag('8.8.8.8');\n\/\/ returns ''<\/p>\n\n
You may leave the IP address empty; in that case, IP address of currently\nactive user is used instead.<\/p>\n\n
Note: All requests are cached, so there shouldn't be a noticeable difference\nbetween reading IP_to_Country_Info and reading all three pieces of information\nseparately using the _Full, _XX and _XXX functions.<\/p><\/li>\n
To interface your plugin's tables to IP-to-Country plugin's tables within SQL, \na function $subselect = PepakIpToCountry::Subselect($ip, $countryfield);<\/p>\n\n Note: No checking or validation is done on either of these parameters. It is assumed\nthey are field names<\/em>, NOT<\/strong> strings. DO NOT EVER USE VALUES THAT YOUR USERS CAN\nINFLUENCE! This is important! If you let users supply arguments to Subselect(), you\nare letting them to do whatever they like with your database!<\/p>\n\n This function only works with IPv4 addresses.<\/p>\n\n Example usage:<\/p>\n\n if (class_exists('PepakIpToCountry'))\n $field = PepakIpToCountry(\"INET_ATON(b.ip_addr)\", 'iso_code2');\n else\n $field = 'NULL';\n $sql = \"SELECT b.*, ${field} country_code FROM ${wpdb->prefix}banlist b WHERE ...\";<\/p><\/li>\n<\/ul>\n\n Note: This plugin requires<\/em> PHP5. If you want it to work with ZIP files\n(e.g. for updating IP-country info from the default location), your PHP\nmust have extension php_zip enabled.<\/p>\n\n\n On my webpage I have a support forum http:\/\/forum.pepak.net with english section\nwhere you can ask. At the time of writing, the forum is open for everybody without\nregistration.<\/p><\/dd>\n\n<\/dl>\n\n\nSubselect<\/code> is published:<\/p>\n\n\n
$ip<\/code> is a field that contains IP address in the form of one 32bit number, e.g.<\/li>\n<\/ul>\n\n\n
\n
$countryfield<\/code> is the field you want returned. It can be one of the following:\niso_name - returns the same string as PepakIpToCountry::IP_to_Country_Full(...)\niso_code2 - returns the same string as PepakIpToCountry::IP_to_Country_XX(...)\niso_code3 - returns the same string as PepakIpToCountry::IP_to_Country_XX(...)<\/li>\n<\/ul>\n\n\n
\n
0.08<\/h4>\n\n
\n
0.07<\/h4>\n\n
\n
0.06<\/h4>\n\n
\n
0.05<\/h4>\n\n
\n
0.04<\/h4>\n\n
\n
0.03<\/h4>\n\n
\n
0.02<\/h4>\n\n
\n
0.01<\/h4>\n\n
\n