Geo Redirects How are they done? Which apps, plug ins or db's do I need? (60)
Geo Redirects How are they done? Which apps, plug ins or db's do I need?
What do I need to self host geo redirect capabilities?
I know of the db's from MaxMind named GeoLite.
What do I do with that?
Do I use a plug in such as : geoplugin.com ?
Thank you.
Ok Support has installed the GeoLite Country db.
Does my any php or java scirpt i add to my page have to include the db's log in details?
This may help ya: woops wrong link, nevermind.
Don't use Geoplugin.class. You need to 1) test that your geoip PHP extension is working and 2) get a handle on the PHP scripting required to do redirects and things. Ugh I should have made my video by now. I will get that done asap.
I have searched and copied the various scripts I found here.
I'll take baby steps to learn how to employ the db onto a page.
I use Maxmind's database for geoip. Essentially, you have to first install the db on your server somewhere (look for example files on the maxmind site as to where to install it). Assuming you use PHP to interact with this database; when you want to actually use it, you'll include a PHP file that references that database. Its a little tricky the first time you do it, but after that it gets really easy 
Let me know if you want a tutorial or something.
~Ian
aeroian,
I sent you a PM of what my Host support said they did for installing the GeoLite Country DB.
I have no idea how to add the php or js to a page so I may redirect to a safe offer IF the visitor is from a wrong country for an offer.
Thank you.
Is this it? This goes on my pages? How does it log into the geolite db? I don't see any user or password for the db.
<?php
$keyword = $_GET['keyword'];
$geo = geoip_record_by_name( $_SERVER['REMOTE_ADDR'] );
$countrycode = $geo['country_code'];
switch($countrycode) {
case 'US':
$redirect[1] = 'http://domain.com/t/base.php?c=XX&key=xxxxxxxxxxxxxx&keyword=US-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'CA':
$redirect[1] = 'http://domain.com/t/base.php?c=XX&key=xxxxxxxxxxxxxx&keyword=US-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'GB':
$redirect[1] = 'http://domain.com/t/base.php?c=XX&key=xxxxxxxxxxxxxx&keyword=US-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'AU':
$redirect[1] = 'http://domain.com/t/base.php?c=XX&key=xxxxxxxxxxxxxx&keyword=US-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'NZ':
$redirect[1] = 'http://domain.com/t/base.php?c=XX&key=xxxxxxxxxxxxxx&keyword=US-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'IE':
$redirect[1] = 'http://domain.com/t/base.php?c=XX&key=xxxxxxxxxxxxxx&keyword=US-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
default:
$message = 'Traffic from: '.$countrycode.' : '.$keyword;
$timestamp = date('d/m/Y H:i:s');
$log_file = 'logs/Logs_script.log';
error_log('['.$timestamp.'] INFO: '.$message.PHP_EOL, 3, $log_file);
$redirect[1] = 'http://domain.com/t/base.php?c=XX&key=xxxxxxxxxxxxxx&keyword='.$countrycode.'-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
}
?>
Hmm - looks to me like that's the right code. If your host has installed php5-geoip, it should Just Work (TM).
Have you tried running it, and if so, what happened?
(Incidentally, I have "geolocation" on my Big List Of Useful Things To Have A Tutorial About, and will write a tutorial about it some time - but of course if anyone else wants to write a tutorial about it first, please do!)
Can someone please make a goddam video of how to redirect users of different countries to each offer? I tried asking Liquid Web but they have no fucking clue on how to do this.
You'd think that someone would have created an app for this by now.
Or incorporated it into their tracker.
I'm going to be writing a tutorial for geo-redirects at some point in the next couple of months. Given how many people are having trouble with it, I may look into doing it sooner rather than later!
This is the code i use in my geo landers;
if ( function_exists ('geoip_record_by_name') ) {
$geo = geoip_record_by_name( $_SERVER['REMOTE_ADDR'] );
extract($geo);
if ( $country_name == "Countryname" ) {
echo "<meta http-equiv=\"refresh\" content=\"0;url=http://www.website.com\">";
}
if ( $country_name == "Countryname2" ) {
echo "<meta http-equiv=\"refresh\" content=\"0;url=http://www.website2.com\">";
}
else {
echo "<meta http-equiv=\"refresh\" content=\"0;url=http://www.website3.com\">";
}
}
?>
Originally Posted by caurmen
Thank you very much for your work
Originally Posted by 2good4u
caurmen,
The sooner you devote your time to the things that interest me, the sooner we can all move on with our lives
Does using such a script cause an issue if the FB reviewer is redirected?
I saved the following as trythis.php and put it on one of my add on domains through its own cpanel , and it does nothing.
I was hoping it would redirect those listed nations , US,CA,GB,AUD etc to Vonage.com.
I have geolite installed on my VPS server.
I have no idea what to try next. Any help will be appreciated.
<?php
$keyword = $_GET['keyword'];
$geo = geoip_record_by_name( $_SERVER['REMOTE_ADDR'] );
$countrycode = $geo['country_code'];
switch($countrycode) {
case 'US':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'CA':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'GB':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'AU':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'NZ':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'IE':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
default:
$message = 'Traffic from: '.$countrycode.' : '.$keyword;
$timestamp = date('d/m/Y H:i:s');
$log_file = 'logs/Logs_script.log';
error_log('['.$timestamp.'] INFO: '.$message.PHP_EOL, 3, $log_file);
$redirect[1] = 'http://vonage.com'.$countrycode.'-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
}
?>
It looks to me like you're missing a ? symbol - so the URL that your script is trying to redirect to will end up being, say, http://vonage.comwomble if your keyword is "womble".
Try changing your redirects to
$redirect[1] = 'http://vonage.com/?keyword='.$keyword;
Just e heads up , the new STM mobile tracker does have this built in.
It will be released this week
I've been using MaxMind's web services for geoip. I can buy 200,000 country lookups for $20. http://www.maxmind.com/en/web_services
Does anyone know if there is a noticeable difference in speed when using the web service vs a self hosted database? It seems logical that a self hosted solution would be faster but I wonder if it's actually enough to be concerned about.
Here's my PHP code for invoking the service if anyone's interested
function getMaxMindData($ip)
{
$query = MAXMIND_URL . '?l=' . MAXMIND_KEY . '&i=' . $ip;
$url = parse_url($query);
$host = $url["host"];
$path = $url["path"] . "?" . $url["query"];
$timeout = 1;
$fp = fsockopen ($host, 80, $errno, $errstr, $timeout)
or die('Can not open connection to server.');
if ($fp) {
fputs ($fp, "GET $path HTTP/1.0\nHost: " . $host . "\n\n");
while (!feof($fp)) {
$buf .= fgets($fp, 128);
}
$lines = explode("\n", $buf);
$data = $lines[count($lines)-1];
fclose($fp);
}
else {
# enter error handing code here
}
writeToLog($data."\n\n\n");
return $data;
}
I'd be a little concerned about speed impacts with a web service, but fortunately there's a really easy way to check the impact on your page (which you may well already have thought of!)
Just create a test page using this code, set a variable with gettimeofday() before you do the lookup, then use gettimeofday() again after the lookup has returned a result, and echo the difference to screen.
If you do this, I'd be very interested to see the result!
Originally Posted by caurmen
-Aaron
Whoa. OK, that's pretty darn swift - can't imagine you'll see much of a CTR drop from a 1/20th of a second wait!
Nice one! Thanks for testing!
Originally Posted by bbrock32
It will be released this week
Great!
Then one could redirect as desired for mobile or non mobile!
Originally Posted by caurmen
Is the only way to redirect in conjunction with a keyword?
Can I just redirect using only a url sans any keywords?
Gracias!
Coud I remove the line with:
<?php
$keyword = $_GET['keyword'];
Also, I saved this with nothing but the php on a page, do I need to save this with any header info such as:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
</body>
</html>
You don't need a keyword at all - in fact, you could just simplify to
case 'US':
header("Location:http://vonage.com");
exit;
In the script does it require that I add where the geolite DB is?
I have now tested with the added question marks , without, in root of my addon domain, in the public_hrml of my doamin, with and without HTML header.
It does nothing at all.
$geo = geoip_record_by_name( $_SERVER['REMOTE_ADDR'] );
Hosting support has done the following for me several days ago:
"We have installed apache module "mod_geoip" in the server. Please verify the details given below.
---
root@host [~]# httpd -M | grep geoip
Syntax OK
geoip_module (shared)
---
We have enabled geoip in the server. Please verify the details given below.
---
root@host [~]# php -i | grep geoip
geoip
geoip support => enabled
geoip extension version => 1.0.8
geoip library version => 1004008
---
Also we have added geoIP country database in the server and added geoIP rules in the ".htaccess" file. They are working fine. Please check this from your end."
Originally Posted by doppelganger
Originally Posted by sandyone
Would 50 bucks be enough on Freelancer to get this done?
Originally Posted by sandyone
I tried that code in my server which has geolite installed and it did work.
Please, add this code to a php file to make sure geolite is installed, i m thinking they didn't install it properly;
if ( function_exists ('geoip_record_by_name') ) {
$geo = geoip_record_by_name( $_SERVER['REMOTE_ADDR'] );
extract($geo);
echo "<h1>How's the weather in $city, $region , $country_code</h1>";
}
phpinfo();
?>?>
I tried using the text in the root of the domain and the public_html as well- nothing happens at all.
I'll ask support to try the text php
You're speaking in riddles Sandy, I'm having a hard time understanding what it is you're actually doing o.O
Hey Sandyone,
I'm pretty sure if you want to use the Maxmind GEO IP Lite you need to include .dat at the top of your code.
Should be something like this in your code:
$gi = geoip_open('GeoIP.dat', GEOIP_MEMORY_CACHE);
$country = geoip_country_code_by_addr($gi, $_SERVER['REMOTE_ADDR']);
geoip_close($gi);
Use the absolute path to your .dat file. If it's in same folder as your php this example should work.
The .dat file is part of the download and it has all of the database info your code uses to reference things.
I am trying to add the ability to geo redirect based in code used by the MaxMind GeoLite database.
I am trying to ad this to my VPS in such as way that any add on domain can do geo redirects.
Example using the code beleow:
Send visitors from an IP that GeoLite MaxMind Database says are from the : US , CA, GB ,AU, NZ and IE would be sent to the url : www.vonage.com
<?php
$keyword = $_GET['keyword'];
$geo = geoip_record_by_name( $_SERVER['REMOTE_ADDR'] );
$countrycode = $geo['country_code'];
switch($countrycode) {
case 'US':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'CA':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'GB':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'AU':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'NZ':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
case 'IE':
$redirect[1] = 'http://vonage.com'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
default:
$message = 'Traffic from: '.$countrycode.' : '.$keyword;
$timestamp = date('d/m/Y H:i:s');
$log_file = 'logs/Logs_script.log';
error_log('['.$timestamp.'] INFO: '.$message.PHP_EOL, 3, $log_file);
$redirect[1] = 'http://vonage.com'.$countrycode.'-'.$keyword;
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
}
?>
Originally Posted by thomasbhm
So I need to ad that code and save the php in the same file where support put my GeoMAxMind?
I don't save the php in the root of my addon domains?
Thank you.
To clarify some things for ya:
1. Georedirection databases and corresponding PHP extension(s) are installed on your server - your server works with these, addon domains are meaningless - a "domain" doesn't process anything. An analogy would be wanting to install Microsoft Word (GeoIP stuff) on your computer (server), and then getting panicked about wanting Word documents (GeoIP stuff in PHP scripts) to be able to be opened from any folder (domain) on your computer.
2. PHP is a programming language. Think of it like javascript or HTML. You don't put 'it' in the 'root' of your server or any domains public_html folder. PHP files are basically web pages. They get loaded in your browser and then do something specific. Instead of displaying content, your PHP file redirects the user somewhere. So you would upload it wherever you would a normal webpage, and load it exactly like a normal webpage, and your advert would point to it as if it is a normal webpage. Because it is.
Originally Posted by sandyone
$gi = geoip_open('GeoIP.dat', GEOIP_MEMORY_CACHE);
$countrycode = geoip_country_code_by_addr($gi, $_SERVER['REMOTE_ADDR']);
geoip_close($gi);
replace these two lines w/ the code above:
$geo = geoip_record_by_name( $_SERVER['REMOTE_ADDR'] );
$countrycode = $geo['country_code'];
Extract the files from the .gzip for the GeoLite Country database from GeoMaxMind and you will get the the .dat file I'm referring to. Drop the .dat in the root (of your addon domain) along w/ your php file that is doing the redirecting.
http://dev.maxmind.com/geoip/geolite
Thank you.
I'll give it a go.
Originally Posted by thomasbhm
If guys that know this can't agree, I have no hope of being able to do this.
Ill try and outsource this.
Originally Posted by 2good4u
Support now says:
"The pear module Net_GeoIP was not installed in the server. I have installed it now.
--
# pear list | grep geo -i
Net_GeoIP 1.0.0 stable
--
I have checked the weather scripts you have used. I could see that you are using the following code.
--
echo "
How's the weather in $city, $region , $country_code
";
--
Here, you have not assigned any values to the variables $city, $region and $country_code. I am not sure how it will work without any value assignment.
Mod_geoIP is installed and configured in apache and PHP in the server.
Please contact your developer and check the scripts."
You should get the GeoIP C modules and PHP extension installed by your host rather than an outsourcer... reason being you need root access to do this properly and that's not really something you want to give to a random. Hiring someone for testing and showing you how to get things working is fine though.
Originally Posted by sandyone
Just unzip it and drop the files from the STM-GEO folder into the root of your add-on domain:
http://www.mediafire.com/download.php?nl7x5hs6785dbaj
index.php is the file w/ your code in it that does the re-direct.
Also, I changed all your instances of vonage to the appropriate google site per the country the person is in.
AND I removed the references to $keyword. I assume you copied that code from somewhere and it adds functionality to append a keyword to the end of the URL if there was one in the url string that called the page.
No reason to overcomplicate things.
Originally Posted by thomasbhm
Perfect! thanks a lot!
Originally Posted by thomasbhm
Thank you so much!
@thomashbm - Awesome stuff!
Thank you Sir Thomas!
I shall get to working on it!
Thank you!
There is something fundamentally wrong on my VPS.
It does nothing.
Think I'll close it down and start new service.
YEAH!
Thomas's files work for me.
When I place them in my domains public_html , I can redirect based on Geo-Ips !
We can all relax and go about our lives once again!
Thomashbm - pick any girl in my village and she is yours.
So the requirements to Geo Redirect using MaxMind GeoLite are:
Installation of:
The pear module Net_GeoIP was not installed in the server
The MaxMind GeoLite database
in ones public_html directory:
geoip.dat file
geoip.inc file
Your php code
So I may learn something, what does the following do:
Originally Posted by sandyone
It is a great place to start though for people who have little idea about what's going on.
As for all the other stuff:
The switch statement in PHP needs a default section for when the variable ($countrycode) does not match any cases you give it.
$message is a variable being set to "Traffic from: US" for example
$timestamp = a timestamp
Following this one might dump this info to a text file to log clicks that have come from outside of the geos you want and when they occurred. As it is right now, you can remove those lines as they are redundant.
$number = mt_rand(1,1) produces a number between 1 and 1. This is useful for rotating between links. Say you put $number = mt_rand(1,3), it will spit out 1, 2 or 3. Then you have 3 lines of links, $redirect[1], $redirect[2], $redirect[3]. At the header() bit you specify location as $redirect[$number] which causes it to randomly rotate through links 1, 2 and 3.
Originally Posted by sandyone
There is no need to install a database, it is reading the info from the .dat file, not a database.
There is also no need to install any other extensions, it's self inclusive, everything you need is in the zip.
If you want to use one geoip.dat file for multiple domains (so you dont have to update it in multiple locations) just install in a directory above your add-on domain and link to it using an absolute path. Your webhost should be able to help you with that if you get to that point.
Originally Posted by zeno
ex: google.com/us or google.com/uk etc.
If you want to change that just modify the default to this:
default:
$redirect[1] = 'http://google.com/';
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
Here is the updated code w/ the new default: http://www.mediafire.com/download.php?nl7x5hs6785dbaj
Originally Posted by zeno
Very useful!
i like maxmind..
That's what its using MAxMind GeoLite Db the country one.
No cities.
Came across this in case its useful:
1) Place the following in the <head>
<script language=”JavaScript” src=”http://j.maxmind.com/app/geoip.js”></script>
2) Use the following in the <body> where you want the information placed. Use one or all of them its up to you.
Country Code: ie US
<script language=”JavaScript”>document.write(geoip_country _code());</script>
Country Name: ie United States
<script language=”JavaScript”>document.write(geoip_country _name());</script>
City:
<script language=”JavaScript”>document.write(geoip_city()) ;</script>
Region: ie NY
<script language=”JavaScript”>document.write(geoip_region( ));</script>
Region Name: ie New York
<script language=”JavaScript”>document.write(geoip_region_ name());</script>
Latitude:
<script language=”JavaScript”>document.write(geoip_latitud e());</script>
Longitude:
<script language=”JavaScript”>document.write(geoip_longitu de());</script>
Postal Code:
<script language=”JavaScript”>document.write(geoip_postal_ code());</script>
Hi Johhny,
What will this do?
And it's using js?
Thomas,
If I only want to redirect traffic coming from one nation, is it ok to delete the other lines such as:
case 'GB':
$redirect[1] = 'http://www.google.com/';
$number = mt_rand(1,1);
header("Location:$redirect[$number]");
exit;
@sandy - unless the script is doing something very unusual, yes, that should be correct. If thomasbhm corrects me on this, though, listen to him as it's his script!
Home > Programming, Servers & Scripts >