You can create up to 3 sub accounts if you are a paid customer, granting them different rights to access the features in the customer area. Below are the access rights that you may grant for each module. License Download Invoice IP2Location Batch Service IP2Proxy Batch Service The sub account […]
Using CLR code in SQL Server 2017 to convert IPv6 to IP number
Intro One of the useful things in SQL Server 2017 is the ability to use any Common Language Runtime (CLR) languages to create user-defined functions. This is a good way to bypass some limitations in SQL Server such as the ability to convert an IPv6 address into a 128-bit number. […]
How to block IP addresses from a country using IPset
Introduction Blocking IP addresses from a specific country is a practice known as geoblocking or IP geolocation filtering. Organizations may implement geoblocking for various reasons, depending on their specific needs and circumstances. Steps to block IP address In this tutorial, we’ll cover how we can block large IP ranges using […]
Report of Firewall List in Year 2019
IP2Location Firewall List by Country is a free web service allowing users to export an IP address list of the targeted countries for firewall filtering purposes. The service supports a wide range of formats such as Apache .htaccess, Linux iptables, CIDR, Netmask, Inverse Netmask, IIS web.config, Cisco ACL, PeerGuardian2, network-object, […]
How to add an attribution in WordPress when Using IP2Location LITE Database
IP2Location LITE databases are free databases distributed under licensed under Creative Commons Attribution-ShareAlike 4.0 International License. It is free for personal or commercial use with attribution. If you are using the free IP2Location LITE database for any WordPress project, or within the plugins, you should mention the below attribution on […]
What are the Proxy Types Supported in IP2Proxy
Intro IP2Proxy database contains data about which IP address is a proxy. This daily updated data also contains info about what type of proxy server the IP address is operating. Below we’ll delve into the various types of proxies that are supported by IP2Proxy. VPN Virtual Private Network. A Virtual […]
Collection of IP2Location & IP2Proxy CSV data import articles
Intro IP2Location and IP2Proxy both provides data in the form of CSV files that can be easily imported into various databases for queries. To make it easier for our users, we have collected all the relevant article links in a single page. We’ll split them into 2 sections. The first […]
Importing IP2Proxy data into IBM Db2 and querying with PHP (IPv6)
Intro The guide will demonstrate how to import IP2Proxy Proxy Detection data (PX12 IPv6) in CSV form into IBM Db2 and then query the data in a PHP page. First of all, you will need to download the IP2Proxy PX12 IPv6 CSV file. Download commercial version at https://ip2location.com/download?code=PX12IPV6 Extract out […]
Importing IP2Proxy data into Db2 and querying with PHP (IPv4)
Intro The guide will demonstrate how to import IP2Proxy Proxy Detection data (PX12) in CSV form into IBM Db2 and then query the data in a PHP page. First of all, you will need to download the IP2Proxy PX12 CSV file. Download commercial version at https://ip2location.com/download?code=PX12 Extract out the IP2PROXY-IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP-DOMAIN-USAGETYPE-ASN-LASTSEEN-THREAT-RESIDENTIAL-PROVIDER-FRAUDSCORE.CSV […]
Importing IP2Location data into IBM Db2 and querying with PHP (IPv6)
Intro The guide will demonstrate how to import IP2Location data (DB26 IPv6) in CSV form into IBM Db2 and then query the data in a PHP page. First of all, you will need to download the IP2Location DB26 IPv6 CSV file. Download commercial version at https://www.ip2location.com/download?code=DB26IPV6 Extract out the IPV6-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED-AREACODE-WEATHER-MOBILE-ELEVATION-USAGETYPE-ADDRESSTYPE-CATEGORY-DISTRICT-ASN.CSV […]