Iptocountry database iptocountry database error updating database error updating database blind dating movie online
Run this once ' on the second day of each month. - Run import Maxmind Geo prior to running this script - ! - Follow the instructions in or this won't work - ! You must download "unzip.exe" either from my server at ' Maxmind Geo ' and save it in your ' PATH (ie. You must execute the SQL statements found in the zip ' Maxmind Geo prior to running this ' script ' ' 3.
The SQL Script creates a new database called Max Mind Geo IP ' as well as some stored procs and UDFs.
If you don't have a trusted connection (a domain), change ' the BCP parameters below (remove -T and add -u,-p). Downloads the Geo Lite CSVs from to the %TEMP% directory ' 2. Once the tables are populated, you can do just about anything you’d like with the information.
If you’d like to see it in action, click here for a demo on your IP address.
A huge thanks goes out to Lee Holmes for helping with that. The SQL file creates a database called maxmind Geo IP.
I was so focused on the indexes that I didn’t pay attention to the actual data. It then creates 3 tables, 3 sample UDFs and 3 stored procedures. IF YOU ALREADY HAVE A DB NAMED MAXMINDGEOIP, THIS SCRIPT WILL DROP IT. Creates a 'bcp prep' stored procedure which creates the necessary tables - This stored proc is run each time the import Maxmind Geo file is run 3.
I also created a SQL Server UDF to access the data.
Resolving the location of an IP is then as easy as running the following query: SELECT dbo.
This import takes 2-10 minutes to run, depending on a whole lot of variables.
To install this plugin, follow standard Word Press steps: Download the distribution archive from Word Press repository or directly this page, extract it to some directory and upload it to your blog.
Then activate the plugin from administrator’s Plugins menu.
Update works the same way, you can also use the automatic update from Word Press plugin repository.
Geolocation in its most common form uses a list of IP addresses with countries assigned to each. There is a number of possible sources, after an „exahausting research“ (=running a Google search and choosing the first acceptable result) I have decided to use data from ip-to-country.webhosting.info, which have a stable download address (which allows easy updating) and an easily-parsed file: it’s a standard CSV file with 5 columns: starting IP address, ending IP address (both define an interval of addresses which belong to the same country), two-letter ISO code of the country, three-letter ISO code of the country and full ISO name of the country.
Just as an FYI, if you keep track of the IPs that hit your website, here’s some sample code The GROUP BY basically makes the ipaddr DISTINCT so this shows you where your visitors have come from for the past 24 hours.