[Tutorial] GeoIP and handling rangebans with MySQL

Linear Mode

Evocator
Huge Clucker

Posts: 470
Threads: 7
Joined: Nov 2013
Reputation: 0

#31

10.09.2017, 08:52

( Последний раз редактировалось Evocator; 10.09.2017 в 09:27. )

Anyone importing an updated .csv file from maxmind note that they added new geo codes:

HM which refers to a mountain in the Australian territory -
https://en.wikipedia.org/wiki/Heard_...Donald_Islands
EH Western Sahara - https://en.wikipedia.org/wiki/Western_Sahara

So either add these to the ISO 3166 list or remove them from the list_ipv4 INSERT statement before running the query.

Find

« Next Oldest | Next Newest »

Messages In This Thread

GeoIP and handling rangebans with MySQL - by Vince - 18.08.2015, 13:29

Re: GeoIP and handling rangebans with MySQL - by Abagail - 18.08.2015, 14:52

Re: GeoIP and handling rangebans with MySQL - by Crystallize - 18.08.2015, 15:17

Re: GeoIP and handling rangebans with MySQL - by ThePhenix - 19.08.2015, 04:31

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 19.08.2015, 09:59

Re: GeoIP and handling rangebans with MySQL - by Glossy42O - 19.08.2015, 10:04

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 20.08.2015, 11:29

Re: GeoIP and handling rangebans with MySQL - by Kar - 21.08.2015, 00:14

Re: GeoIP and handling rangebans with MySQL - by Vince - 21.08.2015, 07:04

Re: GeoIP and handling rangebans with MySQL - by Kyle - 21.08.2015, 19:56

Re: GeoIP and handling rangebans with MySQL - by PaulDinam - 22.08.2015, 02:40

Re: GeoIP and handling rangebans with MySQL - by Pottus - 22.08.2015, 02:59

Re: GeoIP and handling rangebans with MySQL - by Kyle - 22.08.2015, 15:06

Re: GeoIP and handling rangebans with MySQL - by Abagail - 23.08.2015, 02:50

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 23.08.2015, 07:08

Re: GeoIP and handling rangebans with MySQL - by Vince - 23.08.2015, 09:49

Re: GeoIP and handling rangebans with MySQL - by Kyle - 23.08.2015, 10:05

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 23.08.2015, 11:10

Re: GeoIP and handling rangebans with MySQL - by Yousha - 15.01.2016, 22:17

Re: GeoIP and handling rangebans with MySQL - by Vince - 15.01.2016, 22:47

Re: GeoIP and handling rangebans with MySQL - by raddetine - 13.04.2016, 15:34

Re: GeoIP and handling rangebans with MySQL - by ScIrUsna - 13.04.2016, 17:00

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 21.11.2016, 07:18

Re: GeoIP and handling rangebans with MySQL - by Konstantinos - 21.11.2016, 10:53

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 14.12.2016, 11:56

Re: GeoIP and handling rangebans with MySQL - by Konstantinos - 14.12.2016, 13:33

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 14.12.2016, 14:03

Re: GeoIP and handling rangebans with MySQL - by Konstantinos - 14.12.2016, 14:10

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 14.12.2016, 14:47

Re: GeoIP and handling rangebans with MySQL - by X337 - 14.12.2016, 14:53

Re: GeoIP and handling rangebans with MySQL - by Evocator - 10.09.2017, 08:52

Re: GeoIP and handling rangebans with MySQL - by Vince - 10.09.2017, 09:34

Re: GeoIP and handling rangebans with MySQL - by eSPeZet - 13.02.2018, 21:09

View a Printable Version

Forum Jump:

Users browsing this thread: 2 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me