martzuk/fail2ban-geo — pull request #1 by grooverdan (2013-04-28 23:04:44+00:00)
Title: Update fail2ban-geo.sql

your code seems to be looking up by iso so I've added an index here. Iso is always 2 characters.

Countries have all fields included.

For IPv6 support, IP addresses are longer hence 39.

hostnames are limited by the DNS rfc to 64 characters so I recommend using this.

Also with your php code, avoid doing select * in the sql. Pull out the field names you're using.

Keep up the good work.