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]

Yep, looks like databases are not installed. Otherwise the "available" key would be "true".

[sadaar]

UPDATE:
I SSH'd into the server and the /var/lib/GeoIP/ directory is empty. Anything I can do? I have the GeoLiteCity.dat file.

[Boofo]

You need to change the name of GeoLiteCity.dat to GeoIPCity.dat and upload it along with GeoIP.dat to the directory on the server, if they have GeoIP installed correctly.

[sadaar]

I emailed by Host, and got this response:

Regarding GeoIP, the database had been installed at /usr/share/GeoIP, I have moved the file to /var/lib/GeoIP.

I renamed the file above and uploaded it into both locations. Still have the same issue. I can see everything buy the actual map.

Sad.. It seems like a really cool mod.

[digitalpoint]

Does the output of the previously mentioned PHP script show it as available now?

[sadaar]

Output is now as follows. I can verify that the /var/lib/GroIP/GeoIP.dat file is present, but the only other file in that directory is GeoIPCity.dat

Array ( [1] => Array ( [available] => 1 [description] => GeoIP Country Edition [filename] => /var/lib/GeoIP/GeoIP.dat ) [2] => Array ( [available] => 1 [description] => GeoIP City Edition, Rev 1 [filename] => /var/lib/GeoIP/GeoIPCity.dat ) [3] => Array ( [available] => [description] => GeoIP Region Edition, Rev 1 [filename] => /var/lib/GeoIP/GeoIPRegion.dat ) [4] => Array ( [available] => [description] => GeoIP ISP Edition [filename] => /var/lib/GeoIP/GeoIPISP.dat ) [5] => Array ( [available] => [description] => GeoIP Organization Edition [filename] => /var/lib/GeoIP/GeoIPOrg.dat ) [6] => Array ( [available] => 1 [description] => GeoIP City Edition, Rev 0 [filename] => /var/lib/GeoIP/GeoIPCity.dat ) [7] => Array ( [available] => [description] => GeoIP Region Edition, Rev 0 [filename] => /var/lib/GeoIP/GeoIPRegion.dat ) [8] => Array ( [available] => [description] => GeoIP Proxy Edition [filename] => /var/lib/GeoIP/GeoIPProxy.dat ) [9] => Array ( [available] => [description] => GeoIP ASNum Edition [filename] => /var/lib/GeoIP/GeoIPASNum.dat ) [10] => Array ( [available] => [description] => GeoIP Netspeed Edition [filename] => /var/lib/GeoIP/GeoIPNetSpeed.dat ) [11] => Array ( [available] => [description] => GeoIP Domain Name Edition [filename] => /var/lib/GeoIP/GeoIPDomain.dat ) [12] => Array ( [available] => [description] => GeoIP Country V6 Edition [filename] => /var/lib/GeoIP/GeoIPv6.dat ) )

[digitalpoint]

Looks fine from the output. Are you getting an error, or?

[sadaar]

No errors at all, just no map. I have recorded a short screencast to better illustrate my issue. I really do appreciate your help in getting this resolved.

http://screencast.com/t/I5Gv4erMXxI

[digitalpoint]

What's the URL you have it running it at? I'll check it out... maybe you are getting some sort of JS error or something with the Google Map API.

[sadaar]

Sent a PM with login credentials for you.