snubbr.com

Orkut is not working due to Verisign SSL secured pls give me solution?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
First off, Orkut is not working due to Verisign SSL secured pls give me solution? Thanks in advance for any answer. Another question on my mind: Anyone know of a contribution that'll help me with this?.

I just want currency/language/default country in sign up form to automatically set itself based on cutsomer IP address..

I have an IPA to Country database (though I'm having trouble uploading it because it's so large), and also know of a few sites offering a free API to do it (but I don't know how to make these work)..

If there's a contribution, or someone has already done it, life would be simpler for me....

If anyone else wants to do this, you can find a database at.

Http://www.hostip.info/dl/index.html.

Or an API query:.

Http://api.wipmania.com/.

[IPADDR]?[URL] could work too. Where [IPADDR] is the IP address you want to ask about, and [URL] is your Verisign website URL..

If you choose to use that API query thingy, I'd appreciate it if you'd let me know how you did it, since I've shown you where to get it.

This post has been edited by.

Seb1188.

: 27 December 2008, 15:18..

Comments (68)

Good question... I dunno what is the answer to that question. I'll do some research and get back to you if I find an answer. You should email the people at Verisign as they probably can help you..

Comment #1

What would you recommend as an alternative?.

I gave the API a quick test - I'm on AOL in the UK and the majority of free IPA databases pick this up as a US IPA, but it seems to be fairly accurate even with mine..

I've figured out how to use the API so I'm going to work on implementing it into osCommerce. Unless someone fshows me a contribution that does this I'll upload it as one when I'm done..

I know it's not the best, but it does the job, and it doesn't cost anything. Antthing is better than nothing really..

If anyone would like to test the API, but can't figure out what I'm talking about up there, go to.

Http://www.thesebweb.com/shop/test.php.

The code used is also displayed there..

This post has been edited by.

Seb1188.

: 27 December 2008, 17:11..

Comment #2

Well, as someone who has been doing this, ie, manually updating own data, for the past one year or so, and the process is still on-going, I dont know any alternative other than using a commercial service or build your own. Here is one example: this ip 32.106.10.0.

Wipmania: EU;.

Hostip: US..

So, who you believe? and if you find out which country exactly it is, you can't update it as the data is hosted on someone else servers. I believe it is Germany..

If your Verisign site only has a few visitors daily then that would be OK for the host who offer the free service. what if you have hundreds (lets not talk about thousands) visitors daily (and you certainly are not the only one who use it), I think the host may start thinking their 'free lunch' is being abused, isn't it?.

Anyway, good luck and hope you come up with an easy, free and successful solution..

Ken.

If anyone would like to test the API, but can't figure out what I'm talking about up there, go to.

Http://www.thesebweb.com/shop/test.php.

The code used is also displayed there..

[/quote]..

Comment #3

Yeah I agree Ken. But I don't want to spend more money, so I'll live with what I'm given. If they complain, I'll continue uploading their free database (WIPmania do one too I think), it's just a pain because it doesn't upload properly due to it's size....

Here's the pseudocode for my plans, if you don't like it, let me know what I should be doing instead!.

I'm planning on putting it in application_top.php:.

//Auto change currencies.

// Your Verisign domain name here.

$site_name = "URL";.

//Function to get the 2 letter code of the country customer is from.

Function getUserCountry() {.

$url = 'http://api.wipmania.com/'.$_SERVER['REMOTE_ADDR'].'?'.$site_name;.

$ch = curl_init();.

$headers = "Typ: phpcurl\r\n";.

$headers .= "Ver: 1.0\r\n";.

$headers .= "Connection: Close\r\n\r\n";.

$timeout = 5;.

Curl_setopt($ch, CURLOPT_URL, $url);.

Curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);.

Curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);.

Curl_setopt($ch, CURLOPT_HTTPHEADER, array($headers));.

$content = curl_exec($ch);.

Curl_close($ch);.

Return $content;.

};.

//Check if customer location has already been determined.

Look for cookie URL_locationset.

If cookie does not exists then.

{.

//If it has not been determined, change currency to match location.

If getUserCountry() function returns GB then redirect to URL.php?currency=GBP.

Elseif (getUserCountry()="US") redirect to URL.php?currency=USD.

//create cookie to stop unecessary checking/setting currency when user has specified one.

Create/write cookie URL_locationset.

}.

Else if original cookie DID exist then do nothing.

Obviously would need more currency/location if statements, or be read from a database. for me, the statements will do as I only have a few currencies..

In theory that should only set the currency once, so a customer can change it and not wsee it reset on every page load..

I appreciate that this won't work if cookies aren't enabled and a store is set to work with cookies disabled. I don't know how to do this stuff with sessions tho. any ideas?.

This post has been edited by.

Seb1188.

: 27 December 2008, 17:54..

Comment #4

Ok session variables don't look so complicated. maybe it'd be best just to use those instead of using a cookie at all....

But cookies last longer. don't know which to do now....

..... sessions it is..

This post has been edited by.

Seb1188.

: 27 December 2008, 18:34..

Comment #5

This is what I've got so far:.

/*Auto change currencies.

// Your Verisign domain name here.

$site_name = "URL";.

//Function to get the 2 letter code of the country customer is from.

Function getUserCountry() {.

$url = 'http://api.wipmania.com/'.$_SERVER['REMOTE_ADDR'].'?'.$site_name;.

$ch = curl_init();.

$headers = "Typ: phpcurl\r\n";.

$headers .= "Ver: 1.0\r\n";.

$headers .= "Connection: Close\r\n\r\n";.

$timeout = 5;.

Curl_setopt($ch, CURLOPT_URL, $url);.

Curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);.

Curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);.

Curl_setopt($ch, CURLOPT_HTTPHEADER, array($headers));.

$content = curl_exec($ch);.

Curl_close($ch);.

Return $content;.

};.

//Check if customer location has already been determined by checking session variable.

If(isset($_SESSION['currency']));.

//if session variable was already present, don't bother doing anything.

Else {.

//otherwise set variable to location.

$location = getUserCountry();.

//since it has not been determined, find the currency it needs to be changed to.

$currency_id_result=tep_db_query("SELECT countries_currencyid FROM countries WHERE countries_iso_code_2='".$location."'");.

While($currency_row=tep_db_fetch_array($currency_id_result)) {.

$currency_id=$currency_row['countries_currencyid'];.

};.

//create session variable to show that it has now been determined.

$currency=$currency_id;.

$_SESSION['locationset']=$location;.

$_SESSION['currency']=$currency;.

//redirectio not necessary as variable already set.

};.

//END OF ALTERATIONS.

I wanted to replace the application_top.php currency code with that, so a redirect won't be necessary (it'll just change the session variable that tells the rest of the page what currency to display). It works, but it stops a customer from changing the currency manually. As I can make little sense of the original code, I was wondering if anybody could explain why, or tell me how to fix it?.

Thanks..

This post has been edited by.

Seb1188.

: 27 December 2008, 20:07..

Comment #6

Anyone know of a contribution that'll help me with this?.

I just want currency/language/default country in sign up form to automatically set itself based on cutsomer IP address..

I have an IPA to Country database (though I'm having trouble uploading it because it's so large), and also know of a few sites offering a free API to do it (but I don't know how to make these work)..

If there's a contribution, or someone has already done it, life would be simpler for me....

If anyone else wants to do this, you can find a database at.

Http://www.hostip.info/dl/index.html.

Or an API query:.

Http://api.wipmania.com/.

[IPADDR]?[URL] could work too. Where [IPADDR] is the IP address you want to ask about, and [URL] is your Verisign website URL..

If you choose to use that API query thingy, I'd appreciate it if you'd let me know how you did it, since I've shown you where to get it.

This post has been edited by.

Seb1188.

: 27 December 2008, 15:18..

Comment #7

IMO, the key of this exercise depends on how good is the data. I personally dont think that free database mentioned in your post is workable in practical terms, and I dont think using external data via free API calls would be a workable solution either. But you could try as that API call as mentioned in your post is simple enough to use..

Good luck!.

Ken..

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.