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

Nice to see. Thanks!

Cool beans!

Thanks much, installed!

*edit*

nm, can't use it. My webhost doesn't have the PHP extension required for this mod. Had to uninstall.

Looks awesome... will investigate further soon..

Yeah, sorry... I knew that was going to be the biggest sticking point, but it *is* a fairly common PHP extension so some people hosting on managed servers might have some luck. For those that run their own servers, it's pretty easy to install from RPM or just compile it.

Sadly there isn't a way around needing some sort of geotargetting mechanism though. I thought about making it geotarget against my servers for people, but then people would complain about privacy and such with all the geotargetting requests going to a central server. Can't make everyone happy unfortunately. :)

good deal, thanks Shawn

good work ... thanks alot

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

I am using vB_Datastore_Filecache

Thank you for the release Shawn..

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

Thanks!

dope :D Works wonderfully ty!

same problem

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.

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.

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.

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

voglermc: There is another modification that will let you create profiles and pin them on google maps. It can be found here: https://vborg.vbsupport.ru/showthread.php?t=123148 but there is no official release for 4.0 yet :(

If you want to make it work with registration IP addresses instead of currently online users, in the usermap.php file, change this:
to this:
I haven't tested it, but I think it should work (it's still going to limit it to 5000 users/pins... anything more than that probably would cause issues for Google Maps anyway).

Obviously it's not going to show pins for spiders/guests (only registered users and admins/mods).

Aaaw dang, and I thought this was possible with this AddOn as well.
I run a Suzuki Jimny Club :D and we have the same need ... ;)

?$%& I really liked the looks of this ... *grmpf*

Hope there will be a good alternative for vb4 soon!

Thank you both!

error

Fatal error: Call to undefined function geoip_record_by_name() in /home/tarheel/public_html/usermap.php on line 97

vo, you dont have GEOIP on your server. Talk to your server host to install it.

Thanks

My host won't install on a shared server
Marked as uninstalled, wish I didn't have to

Yeah pretty much any shared hosting doesn't allow the geoip plugin as I've been told over and over its "too resource intensive". (was looking for stats generated by awstats)
But I moved over to my own dedicated server and runs wonderfully :)

thanks shawn

Can you create a converter from the old vb membermap?

Sounds like a generic answer from your host because they didn't feel like installing it. It's INCREDIBLY *not* resource intensive...

http://www.maxmind.com/app/benchmark

Benchmarked at being able to do 22k+ lookups per second without any sort of caching.

No idea what that is, sorry.

Works great, Any way of getting registered users, admins, etc usernames to appear on the pins instead or along with View in Google Earth?

I had thought about doing it that way originally, but decided against it because if all the potential complaints from end-users about privacy issues.

An importer for this modifcation: https://vborg.vbsupport.ru/showthread.php?t=154533 would be very very nice.

Would this be something fairly simple to add or would it require a lot of work? I don't know much about modding. I think it might be possible to add a check box to the registration page to accept being added to the member map. Might be cool to look into :-)

Can anyone explain how to successfully install geoip on a xampp windows server??

I tried the mod_geoip as well but in any case I cannot get the php or the apache version running with windows...

There's nothing really *to* import since mine is locating the user in realtime based on their IP address. That one appears to really just be a system where each user can put an arbitrary pin on the map (since the user can put it anywhere they want). If you want something like that, you probably would just want to ask the developer to update it since it's really something different.

Eh... it would be possible, but having people opt-into it would also have the affect of very few users actually using it. Personally, I like it the way it is now where it's a little more anonymous, but all users are on it.

unistalled because no GeoIP on my server. Now I've an MySQL error...

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_usermap AS phrasegroup_usermap,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM vb_language
WHERE languageid = 2;

MySQL Error : Unknown column 'phrasegroup_usermap' in 'field list'
Error Number : 1054
Request Date : Friday, June 11th 2010 @ 08:13:14 AM
Error Date : Friday, June 11th 2010 @ 08:13:14 AM
Script : http://www.mysite.it/usermap.php
Referrer :
Username :
Classname : vB_Database
MySQL Version :

How can I solve this?

If you uninstalled it, you would also want to delete the usermap.php file. :)