This is a great idea - I've been looking for something like this so that I can geo-target my newsletter to people in specific countries. I don't suppose there is any planned plugin support for this in the future?

Well this module will support any such application you'd like to build with it. It depends what you mean by "plugin support" - the support for a plugin is there, but someone still has to write it - this mod simply takes a lot of the hard work out of writing such a plugin.

Are you talking about the "Generate Mailing List" function in the admincp? If so, you should be aware that the file that makes these mailing lists has no hooks at all, so such a modification would have to involve file edits, not plugins.

Version 1.1 of GLA will make it even easier for developers to write code in the own plugins, for example - you could take the registration IP address and pass it through a function and have the country data returned. Only 2 lines of code needed to test any IP address.

Hey,

I was thinking more along the lines of integration w/ Commbull or VBGazette (newsletter products).

If those products could import data from another source, it would be fairly easy. All you'd need is a bit of code that spits out your usertable, or specifically the email address, registration ip, and username and adds the country name at the same time. You could then import the data into excel and do whatever you wanted with it.

Free IP to country database (CSV) that claims daily updates.
http://software77.net/cgi-bin/ip-country/geo-ip.pl

That is awesome, thanks for that. The timing is excellent as I am getting version 1.1 ready. This database looks much better than the one I am using in 1.0, and they seem to certainly try to keep it up-to-date!

There are extra country codes used however, meaning that there could be some issues with flags not being available.

I'm also thinking about things like a cron job for auto downloads and updates each week, as well as a list of exceptions, for the case for example when some of your users post from a company where the proxy server is in one country, but assigned to the address space of the head office (e.g. USA).

The accuracy issue will become even more important when I release the flag in the postbit mod that I've just finished writing.

I've attached an updated database file, which I reformatted from software77.net (see above post for details). Future versions of GLA will support this file format without modifications, but for the moment I had to make a custom version so that 1.0 would import it.

I believe that this database should be better than the one which is currently bundled with GLA 1.0. I'd be interested to hear comments from people who reported some problems with the existing database - maybe this updated one improves the situation?

How to upgrade your database? Easy, just follow the upgrade instructions in the original install.txt file included with the GLA zip file. Updating should take less than a minute.

I'm also going to need a bit of help from you guys. There are new country codes added to this version of the database, namely these countries:
AP - non-specific Asia-Pacific location
CS - Serbia and Montenegro (Formally Czechoslovakia)
YU - Serbia and Montenegro (Formally Yugoslavia) (Being phased out)
EU - non-specific European Union location
FX - France, Metropolitan
PS - Palestinian Territory, Occupied
UK - United Kingdom (standard says GB)
* ZZ - IETF RESERVED address space.

I need some assistance from other people for the following tasks:

• Check if the existing flag set contains all flags in the ISO-3166 list (in other words, are there other countries missing from the current flag set?)
• Check that the current flagset actually represents the flags of the country codes (some flags may have changed)
• Draw (or copy and adapt) any new flags missing from the current flag set, and possibly extend the flag sets linked here.

The idea would then be to put these extended flag sets up for download at software77.net to allow everyone using their free database (not just GLA users) the chance to get flags to match the most current database. If you enjoy GLA and think it is useful, I'd be grateful if you could help me out with any of the above tasks.

There's a very tasteful flag set at http://www.famfamfam.com/lab/icons/flags/ . It incldes all the missing countries, although users will probably need to rename europeanunion.png to eu.png, and make a copy of uk.png as gb.png.

http://img263.imageshack.us/img263/4...ewlargexl5.png

Nice link! Flags look good, but for the default set (packaged with GLA) I really need something to match the size (height) of the current set. The reason is that the height of the flags matches the various IM icons displayed in the postbit, so it looks good. It also doesn't look too bad when stacked next to text in the default size.

This would be a nice addition if Stonyack updates the vbgoogle hacks