geotargeting block content

Worker Joined: Nov 22, 2004 Posts: 208 Location: Italy

hi I need to Geo-target the content of a block
I alredy have a variable $countrycode from nsnst_ip2country table

So what i need is

If $countrycode = US or CA or UK or AU show thisstuff (links to pages in diff languages)
if $counrtycode = FR or BE show thisother
if $countrycode = DE or NL show thisone
else show whatever i need to there...

easyest way?
Thanks
Guido

Posted: Thu Jun 22, 2006 6:09 am

Just to make absolutely sure here, are you saying that you have already written code that takes the user's remote IP address and does a look-up on the nsnst_ip2country table to get his/her c2c value? I want to make sure, because that, to me, is the most difficult task at hand.

Because, once you have the $countrycode variable, it is simply a matter of checking it with IF statements possibly like this:

Code:




if ($countrycode = 'US' OR $countrycode = 'CA' OR $countrycode = 'UK' OR $countrycode = 'AU') {


   <<show this stuff>>


} elseif ($countrycode = 'FR' or $countrycode = 'BE') {


  <<show thisother>>


} elseif ($countrycode = 'DE' or $countrycode = 'NL') {


  <<show thisone>>


} else {


  <<show whatever i need to there>>


}

Posted: Thu Jun 22, 2006 6:22 am

Thanks!
I dont know why I was stuck thinking of an array with countrycodes..
Didn't even think of a simple if

anyway this is the code to get c2c form ip2country:

Code:




$ip = $_SERVER['REMOTE_ADDR'];


$res = mysql_query("SELECT c2c,country FROM nuke_nsnst_ip2country WHERE ip_lo<=inet_aton('$ip') AND ip_hi>=inet_aton('$ip')");//look up IP address


 


$Codes = mysql_fetch_array($res); //get result


$CountryCode = $Codes['c2c']; //two-letter country code


$CountryName = $Codes['country']; //full country name

I stole it from another script and adapted to the nuke database Smile

Guido

Posted: Thu Jun 22, 2006 7:01 am

Too funny! I was originally working up that code and stole most of it from nukesentinel.php! Then, I reread your message and realized you might already have it.

Posted: Thu Jun 22, 2006 7:30 am

It's common for me to Bang Head

trying to make a little script, or a function and then realize I already had it done inside another one....
That's why I love forums LOL

Posted: Thu Jun 22, 2006 9:51 am

Excellent stuff!