Geo-Targetting Your Visitors: How? [HELP]

[rayanman10]

Hey guys, I spent hours searching on G about how to set this up, but up till now I still can't figure out how. I guess I'm that dumb I just couldn't understand anything about setting this up.

This thread here: http://www.blackhatworld.com/blackhat-seo/general-programming-chat/44539-free-ip-country-database.html

The guy there is sharing a Free IP-Country database, the thing is, I don't quite know what to do with it. Like I searched on G but still I can't figure out how.

I just need to redirect any of my US traffic to a certain site, that's it. Just US traffic, other traffic uses the same.

Can anyone help me out? Thanks.

 

[zone69]

Here is an example I posted some time ago that should help you out. It uses the maxmind free binary file db which is updated monthly so no need for any mysql database.

http://www.blackhatworld.com/blackh...ne-code-me-php-geo-targetting.html#post410382

hope that helps you out. If you have any questions feel free to PM me.

 

[rayanman10]

hey man thanks for the reply yeah i just read that before u even posted reply here. Anyway thats quite simple, but the only thing I'm concern with is this:

quoted from maxmind that geolite country returns US on all AOL users. what does this exactly mean? does it reflect all AOL users eventho my site has no connection with AOL?

I know i shudnt have asked you but just thot u might know about it.

Thanks.

 

[Boxic]

Here is an example I posted some time ago that should help you out. It uses the maxmind free binary file db which is updated monthly so no need for any mysql database.




hope that helps you out. If you have any questions feel free to PM me.

Problem with that is it does it within php, faster methods exist and these typicaly do the lookup within the httpd, the next step down but still faster than doing it in php code is to load the php module directly into the php proccess much like the httpd module method.

Google <your httpd> + geoip that should put you on the right track. I use lighttpd and i suspect you dont so cant provide much more info.

quoted from maxmind that geolite country returns US on all AOL users. what does this exactly mean? does it reflect all AOL users eventho my site has no connection with AOL?

I think this is because AOL is retarded and must register their IPs "wrongly" as such, making the information they provide not trustable so he just marks them all as being within the USA. Failing that he does run a paid version of the geoip db which perhaps contains AOL info correctly. Its not really an issue for anything i have ever done.

 

[zone69]

hey man thanks for the reply yeah i just read that before u even posted reply here. Anyway thats quite simple, but the only thing I'm concern with is this:

quoted from maxmind that geolite country returns US on all AOL users. what does this exactly mean? does it reflect all AOL users eventho my site has no connection with AOL?

I know i shudnt have asked you but just thot u might know about it.

Thanks.

Using the free database, users who access your site using AOL as their internet service provider will be seen as US users even if they were customers of AOL UK for example. You would have to use the pay version of the maxmind db for this to not occur.

 

[zone69]

Problem with that is it does it within php, faster methods exist and these typicaly do the lookup within the httpd, the next step down but still faster than doing it in php code is to load the php module directly into the php proccess much like the httpd module method.

Google <your httpd> + geoip that should put you on the right track. I use lighttpd and i suspect you dont so cant provide much more info.



I think this is because AOL is retarded and must register their IPs "wrongly" as such, making the information they provide not trustable so he just marks them all as being within the USA. Failing that he does run a paid version of the geoip db which perhaps contains AOL info correctly. Its not really an issue for anything i have ever done.

I use the php method with 300K pageviews a day and there is no performance issues at all. The country is return in milliseconds 100% of the time.

I do agree running an apache module would be faster but absolutely not necessary unless you run into millions of hits per day and not worth the trouble otherwise.

Here is the perl module for Apache should you want to use that:

http://search.cpan.org/~rkobes/Apache-GeoIP-1.63/Apache/Geo/IP.pm

 

[rayanman10]

Ok guys this is getting confusing for me, im a genius about some things and other things im very stupid and this is one of those things.

So this far I found out that the first method posted here is quite easy to implement. But I also had a look again at this thread http://www.blackhatworld.com/blackhat-seo/general-programming-chat/44539-free-ip-country-database.html and managed to download the db which in csv format, any easy way to use this format? can I use the same method as the first posted here?

 

[zone69]

Ok guys this is getting confusing for me, im a genius about some things and other things im very stupid and this is one of those things.

So this far I found out that the first method posted here is quite easy to implement. But I also had a look again at this thread http://www.blackhatworld.com/blackh...ming-chat/44539-free-ip-country-database.html and managed to download the db which in csv format, any easy way to use this format? can I use the same method as the first posted here?

You would need a way to import the csv file into a mysql database and then use some php with the logic to look up the IP based on the source IP of the visitor and translate that to a country.

I have not personally used that db and am not sure if they offer the php code to do this or if you need to write your own.

I have always used the maxmind db with great success.