Fix for hanging join page

[Jutaky]

This patch fixes lookupIp() function, which causes join page to hang when resolving IP to country text. The patch requires ip2nation country database.

File to edit: /includes/functions.php

Find following piece of code:

Code:

function lookupIp($ip) {
        // http://www.webservicex.net/geoipservice.asmx/GetGeoIP?IPAddress=
        if($ip == "") return false;
        $script = "http://www.webservicex.net/geoipservice.asmx/GetGeoIP";
        $params = "?IPAddress=".$ip;
        $r=@file_get_contents($script.$params);
        if(strpos($r, "No Record Found") === false && ($r != false)) {
//      if(true) {
                $result = html_entity_decode($r);
                $start = strpos($result,"<CountryName>")+13;
                $end = strpos($result,"</CountryName>");
                $co = strtolower(substr($result,$start, ($end-$start)));
                if($co != "reserved" && $start && $end) return $co;
                else return false;
        }
        else {
                return false;
        }
}

Replace above code with new lookupIp() function:

Code:

function lookupIp($ip) {
    global $Db1;
    return $Db1->querySingle("SELECT c.country FROM ip2nationCountries as c
                    LEFT JOIN ip2nation as i ON c.code = i.country
                    WHERE i.ip < INET_ATON('". mysql_real_escape_string($ip) ."')
                    ORDER BY i.ip DESC
                    LIMIT 1",'country');
}

Do you want a professional to install the patch for you? Contact me for installation service, only $4.90, via helpdesk at http://polarwebservices.com/helpdesk.php and I will install the patch for you including ip2nation, if your site does not have it.

[damage11]

It did not work for me?

[757jterrell]

What version of the script do you have?  you must have the ip2nation database, which is included in the SDR 1,2, and 3 series.  

This fix is now included in the

SDR 3, Sept 1,2011 update
SDR 2, Sept 1, 2011 update.

For SDR Basics, you have 2 options, you can contact one of the resellers or jutaky to have the ip2nation database installed, or you can follow the steps below to remove the country from being added on the join file.  The SDR Basic Sept 1, 2011 update will have the ip2nation database added.

Here is the fix for the SDR Basics to remove the country:

go to your members/join.php file, and remove the following line of code, line 102;

$co = lookupIp($vip);

and line 168:

country='$co',

[damage11]

I have a Sdr2 script?

[Addons]

This patch fixes lookupIp() function, which causes join page to hang when resolving IP to country text. The patch requires ip2nation country database.

File to edit: /includes/functions.php

Find following piece of code:

Code:

function lookupIp($ip) {
        // http://www.webservicex.net/geoipservice.asmx/GetGeoIP?IPAddress=
        if($ip == "") return false;
        $script = "http://www.webservicex.net/geoipservice.asmx/GetGeoIP";
        $params = "?IPAddress=".$ip;
        $r=@file_get_contents($script.$params);
        if(strpos($r, "No Record Found") === false && ($r != false)) {
//      if(true) {
                $result = html_entity_decode($r);
                $start = strpos($result,"<CountryName>")+13;
                $end = strpos($result,"</CountryName>");
                $co = strtolower(substr($result,$start, ($end-$start)));
                if($co != "reserved" && $start && $end) return $co;
                else return false;
        }
        else {
                return false;
        }
}

Replace above code with new lookupIp() function:

Code:

function lookupIp($ip) {
    global $Db1;
    return $Db1->querySingle("SELECT c.country FROM ip2nationCountries as c
                    LEFT JOIN ip2nation as i ON c.code = i.country
                    WHERE i.ip < INET_ATON('". mysql_real_escape_string($ip) ."')
                    ORDER BY i.ip DESC
                    LIMIT 1",'country');
}

Do you want a professional to install the patch for you? Contact me for installation service, only $4.90, via helpdesk at http://polarwebservices.com/helpdesk.php and I will install the patch for you including ip2nation, if your site does not have it.

If i upgrade it, it will affect any gptmaster addon ? http://auroraadmintraining.info/index.php/topic,643.0.html

bcz i m using gptmaster country show up in join page...
plz let me know
thanks

[757jterrell]

You would have to check to see where the ip is checked, it you are using a country database different than ip2nation, than you will need to reference those files instead.

[amidamaru34]

so should i fix the script like the first post ??

I have SDR 3 script

[757jterrell]

so should i fix the script like the first post ??

I have SDR 3 script

Depends on your update date, all Sept 1, 2011 updates of the scripts have this fix already added.

[Mr__Bill]

I have an MRV5.5 updated script. New signups  are having problems with the signup page, saying they are getting sent to another page while registering or just can  not enter info in the boxes. Tried to copy the join.php file from my other site (upgraded the same) but it still does not work right. Will this fix work for me as well?
 Launched last week and if nobody can sign up, losing perspective members daily. HELP!!

[Mr__Bill]

Never mind, the upgraded functions.php file is encoded. I'll have to contact the installer.