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.

[Raz]

Here are my stats:

Data 1,448 KB
Index 699,392 Bytes
Total 2,131 KB

Rows 56,576
Row length ø 26
Row size ø 39 Bytes

[Boofo]

Bingo! We have a winner. Thank you, sir.

[high]* Boofo sneaks off to click install[/high]

[zajako]

is there a free city listing set of tables, or does this one list the city,Country

i know its possible to determine city from ip but im sure that would make the db jump several megs. Im willing to do it if there is one avaliable.

of course ill use it a lot more than just showing in their location

[Boofo]

That would be a great idea if the IPs always returned to correct city. Mine shows Alexandria, Virginia, USA and I am in Des Moines, Iowa USA. Sometimes it shows the headquarters of your ISP instead.

[S.Shady]

or the proxie your on as i found out today thought somone was in la turns out they were in washington :-\

[Boofo]

That's true, but I am not on a proxy and it still shows my city and state wrong.

[S.Shady]

i didnt mean you i ment a general user - but its weird its wrong.

[Boofo]

No, No, I know you weren't talking about me. I was just trying to let you know that proxies aren't the only ones that can be wrong. You're right. It is weird.

[zajako]

yeah but even if it is worng sometimes, it still captures a majority of the users.

[S.Shady]

Today at 01:55 AM zajako said this in Post #29
yeah but even if it is worng sometimes, it still captures a majority of the users.

true