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]

Originally Posted by CoZmicShReddeR

I added extension=php_geoip.dll and restarted apache server and when I click on the map link I get

Fatal error: Call to undefined function geoip_record_by_name() \usermap.php on line 100

Well for whatever reason it didn't get installed correctly if the functions aren't there...

[Kolbi]

Thanks!

[TeknoSounds]

dope Works wonderfully ty!

[twitch]

Originally Posted by digitalpoint

Well for whatever reason it didn't get installed correctly if the functions aren't there...

same problem

[noppid]

It's not like the GeoIP site hands you the install instructions over there. But, I'm pretty sure a resourceful person could do the geoip pure install at the php file level rather then the apache server level if a shared host won't add it. http://geolite.maxmind.com/download/geoip/api/php/ Then you need the city database IIRC. http://www.maxmind.com/app/geolitecity and it looks like an edit to the DP php file to include the geoip api and initialize it.

[Tubbietoeter]

I asked my provider to install geoip and they did.

phpinfo says
geoip extension version 1.0.7
geoip library version 1004006
geoip.custom_directory no value no value

I get errors anyway:
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 100)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 128)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 133)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 152)
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 158)

am I doing something wrong?

[noppid]

Originally Posted by Tubbietoeter

I asked my provider to install geoip and they did.

phpinfo says
geoip extension version 1.0.7
geoip library version 1004006
geoip.custom_directory no value no value

I get errors anyway:
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 100)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 128)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 133)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 152)
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 158)

am I doing something wrong?

They installed the default country database or provided the wrong path. You need GeoIP City.

[voglermc]

Would a different version be possible to build out based on profile field information and populate with certain info in profile fields of members?

I run a MINI Cooper Club site and it would be nice to see where our members are

[digitalpoint]

Originally Posted by voglermc

Would a different version be possible to build out based on profile field information and populate with certain info in profile fields of members?

I run a MINI Cooper Club site and it would be nice to see where our members are

In theory you could modify it to run based on the location of the IP address they used to register, but I don't think Google Maps could handle that many pins on the map to be honest.

[voglermc]

We have around 1300 members right now. I'd just like members to see they have others close by. I'm not to up to date on google's api so I don't know what it can and can't do