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

[mcyates]

Just got my host (Site5) to enable the GeoIP PHP extension but i'm stuck with these errors and no map!!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[digitalpoint]

Did you check the obvious?

(that the file /usr/local/share/GeoIP/GeoIPCity.dat exists)

[bpi007]

Hello,

I'm looking for a version of this mod without geoip and user's point manually where they live.

(geoip not installed on my server)

Thanks

[10 Gauge]

I'm having a similar error as above....

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

/var/lib directory only contains GeoIP.dat where do I acquire GeoIPCity.dat?

Edit: Figured it out. I copied GeoLiteCity.dat to /var/lib/GeoIP directory and renamed it to GeoIPCity.dat and it did the trick.

Great mod, thank you!

[reddyink]

SOLVED
It shows the map but doesn't show users on it for some reason. Who's online list for forum (near footer) shows users but doesn't display on this map.

IP address also shows on forum so I tried changing to
$user_location = geoip_record_by_name(IPADDRESS);
Appreciate help.

EDIT: I had to set up which usergroups showup on the map.

[PBRiot]

Ok, so my server is a shared server, and they will not install GeoIP.

Here's the conversation thread:
I'm attemping to install a mod to my vBulletin 4 forum - www.pbriot.com.

The mod is:
https://vborg.vbsupport.ru/showthrea...=digital+point

You can see an example of what the mod does here: http://forums.digitalpoint.com/usermap.php

The instructions for the mod indicate that I must have GeoIP (a free PHP script) installed on my server. I'm not sure if this is something I can do myself, or not, but simply uploading the files via FTP for GeoIP didn't do the trick (surprise, surprise ).

The error I am getting is this:
http://pbriot.com/usermap.php

Please let me know what I can do to get this up and running, thank you for your help!

They respond:
I'm sorry, but our servers don't meet the pre-requisite software requirements needed in order to run geoip. You're free to experiment with compiling/installing these requirements in your own account, however that is not something that we will be able to assist with.

Let us know if we can help with anything else, or if you have any additional questions.



When I asked further, it was basically "we need to maintain the same environment on all 2500+ servers, and we can't implement a massive thing like that for your request"

At any rate - he suggested that I could try installing myself... I just have no clue how to do that - any ideas - can you point me in the right direction, anyone? Thanks!

[GhoHan]

I'm installed today very nice mod working perfect..
http://i-comers.com/usermap.php

Installed & Tagged also MOTM
i hope next feature can display avatar and username also postcount in map when click the balloon/pin google map

Thanks

[Lester Wilson]

Hi, I run three vb4 forums

I've installed Digital Point User Map on all three, the users like it !

I have one issue, on two forums the map shows guests as spiders, i cannot see why

the setup is the same for all three systems ( on the same server) they are simply vhosted sites on one server.


http://www.myamicus.co.uk/usermap.php - guests seem to show as spiders

http://www.protonbasic.co.uk/usermap.php - i'm sure guests are showing as spiders AND i have a few users with user id 16, i dont think they show at all

http://www.picbasic.co.uk/forum/usermap.php - seems to show users as i'd expect.


any help would be appreciated.

[digitalpoint]

Do you have different usergroups possibly for the two forums?

[Lester Wilson]

Hello, yes there are differenet user groups on the forum protonbasic.co.uk

on that forum many users are in a group with id 16 and a few in groups with other ids. I've entered the admin and mods with id' of 95 96 97 etc they seem to show up on the map

looking atnthe xml file it should cater for anything greater than 3, but it does not seem to do so..

how do i add specifc id's fro registered users as you have actered for with the mods and admins.