Auto-Detect User Location At Registration

Simple hack making use of the Directi Ip-to-Country Database (included).

What it does
Auto-detects which country user is from and auto-fills the location field on the registration form using their IP Address.

Installing
Import the 'ip2country' table attached into your forums database. Either use phpMyAdmin or from ssh.
(Make sure your mysql max_packet size is large enough to handle the ~2 Mb file -- otherwise try downloading this split table here)

Open up register.php and look for:

PHP Code:

        while ($profilefield=$DB_site->fetch_array($profilefields)) {
                $profilefieldname = "field$profilefield[profilefieldid]"; 


Above that place the following:

PHP Code:

// CUSTOM ADD AUTO LOCATION
$ip_number = sprintf("%u",ip2long($REMOTE_ADDR));
$ct_array = $DB_site->query_first("SELECT COUNTRY_NAME FROM ip2country WHERE $ip_number >= IP_FROM AND $ip_number <= IP_TO LIMIT 1");
$bbuserinfo['field2'] = ucwords(strtolower($ct_array['COUNTRY_NAME']));
// END CUSTOM ADD AUTO LOCATION 


Once you've done that, you're all set.

[Mike11212]

dont you have to pay for ip2country database?

[Raz]

From the site (link posted in first post):

The IP-to-Country Database and Tools are available FREE of charge.

[Broekie]

Today at 10:36 PM Mike11212 said this in Post #11
dont you have to pay for ip2country database?

Yes, you do. You should remit $100 to my swiss bank-account


Okay, I'm kidding...
Here's the serious part of this post:

The fourth line of text on http://www.ip-to-country.com:
The IP-to-Country Database and Tools are available FREE of charge.

[Boofo]

Today at 03:30 PM Raz said this in Post #10
Have you tried importing it from phpMyAdmin? It may be large, but its not impossible.

I tried to do a 2 meg file when I had the Weather hack installed and the author had to make smaller files so others could import them as well.

[Tim Wheatley]

Yes it works now.

I got it to work when someone updates their profile too:

In member.php above

PHP Code:

  while ($profilefield=$DB_site->fetch_array($profilefields)) {
    $profilefieldname="field$profilefield[profilefieldid]"; 


Add the same as in first post.

Works great, thank you. I'm using 2.3.0.

[Raz]

Today at 10:09 PM Boofo said this in Post #14
I tried to do a 2 meg file when I had the Weather hack installed and the author had to make smaller files so others could import them as well.

Feel free to do it yourself.

[AlexanderT]

Really nice! *installed*

I attached a split version of the ip2country table. Make sure you first insert part1 before inserting the other parts (in order to create the table).

Alex

[partang2]

Thanks a lot AlexanderT!!

[Raz]

I've added a link to the split table in the first post.

[Boofo]

Can someone tell me how many rows there are and what size the table should be? I want to make sure I got it in there right.