Miscellaneous Hacks - Digital Point User Map

About
This is a system for geo-locating your currently online users and plotting them on a world Google Map. You can click any of the pins for a link to pull up the user's location in Google Earth.

This is something I originally made almost 5 years ago. Now that I rewrote it for vBulletin 4, I wrapped it up as a product package and released it for the world to use.

Installation

• Put the usermap.php file in your forum folder.
• Install the product-digitalpoint_usermap.xml product under AdminCP -> Plugins & Products -> Manage Products -> Add/Import Product

Notes

• Important! - this uses the free GeoIP PHP extension, so you must have it installed on your server in order for it to work.
• Uses datastore cache so it does not repeat GeoIP queries unnecessarily.
• Upgraded to Google Maps API v3.

You can see a live version in action here:
http://forums.digitalpoint.com/usermap.php

[digitalpoint]

What's the URL?

[Flightbase]

<a href="http://www.soaring-challenge.com/usermap.php" target="_blank">http://www.soaring-challenge.com/usermap.php</a>

[digitalpoint]

Originally Posted by Flightbase

http://www.soaring-challenge.com/usermap.php

Do you have the geoip PHP extensions? It looks like it might not be (or maybe the extension is installed, but without the database file)?

[Flightbase]

Hi,

root@rcns:~# dpkg -l |grep geo
ii  geoip-bin                          1.4.8+dfsg-1ubuntu1                     IP lookup command line tools that use the GeoIP library
ii  geoip-database                     20110709-1                              IP lookup command line tools that use the GeoIP library (country database)
ii  libapache2-mod-geoip               1.2.5-2                                 GeoIP support for apache2
ii  libgeoip1                          1.4.8+dfsg-1ubuntu1                     non-DNS IP-to-country resolver library
ii  php5-geoip                         1.0.7-3                                 GeoIP module for php5

root@rcns:~# ls -hal /usr/local/share/GeoIP/GeoLiteCity.dat 
-rwxr-xr-x 1 nikwww www-data 16M 2012-04-21 16:06 /usr/local/share/GeoIP/GeoLiteCity.dat

all services were restarted after placing the .dat file there.

greets, Nik

[datoneer]

My host told me this:

Can you please ask if there is any specific way or trick for centos and/or cpanel?

They also said that from here: http://imspot.org/info.php you can see that mod_geoip is loaded under the "Loaded Modules" section.

[digitalpoint]

You have an Apache module for it (you don't need that)... You want a PHP module for it.

http://pecl.php.net/package/geoip

[datoneer]

Ok, i see usermap page now just can't see the map.

Now this error shows under usermap:

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /opt/geoip/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Can you explain me what to do now to fix it?

[digitalpoint]

My first guess would be that you don't have the required database at /opt/geoip/share/GeoIP/GeoIPCity.dat

[datoneer]

It's working. Thanks dp

[paulket]

Link to map is lost in the Community drop-down with upgrade to 4.2.0