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

[nhawk]

Originally Posted by imported_stefan

Thanks for the quick response. I thought different. Is the db located somewhere by default in a different place and can I copy it to this place?

Depending on the version of Linux you're running and whether or not it was installed using an RPM for that package or some other source, it could also be in usr/share/GeoIP.

But, digitalpoint is correct about having to re-compile it if you move the database.

[digitalpoint]

The DB is not located *anywhere* by default... you need to install it (it comes from maxmind.com).

On a side note, you *can* change the default directory location I found out with a php.ini setting:

[geoip]
geoip.custom_directory=/yourdirectory/

[imported_stefan]

So I first installed on my server:

Geoip

apt-get isntall php5-geoip libapache2-mod-geoip
/etc/init.d/apache2 restart


Than I installed your addon


Now I have also install on my server the database?
Both? Only one of them? Which one? :-)

GeoLite Country GeoLite City

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

using this Install:

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

Sorry for the questions :-)

[digitalpoint]

I'm not sure, I've never tried to install just one... I've always installed both.

[svyrydov]

Good day,
I asked my admin to enable GeoIP PHP extension
they told me, that is activated now.
But still getting:

Fatal error: Call to undefined function geoip_record_by_name() in /home/procrew/public_html/test.php on line 2

HERE IS LINK http://procrewing.com/test.php

Any suggestions?
Thanks.

[digitalpoint]

I would suggest going back to your admin because it's not activated.

[imported_stefan]

- so databes both installed
- geoip with phphinfo checked
- mod installed

empty pages :-)

any more hints ???

error reporting on does not show up errors

[goc-forum.de]

I am getting this error code:

Warnung: geoip_record_by_name(): Required database not available at /usr/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 100)

I uploaded your test.php and this is the result:

Array ( [1] => Array ( [available] => 1 [description] => GeoIP Country Edition [filename] => /usr/share/GeoIP/GeoIP.dat ) [2] => Array ( [available] => [description] => GeoIP City Edition, Rev 1 [filename] => /usr/share/GeoIP/GeoIPCity.dat ) [3] => Array ( [available] => [description] => GeoIP Region Edition, Rev 1 [filename] => /usr/share/GeoIP/GeoIPRegion.dat ) [4] => Array ( [available] => [description] => GeoIP ISP Edition [filename] => /usr/share/GeoIP/GeoIPISP.dat ) [5] => Array ( [available] => [description] => GeoIP Organization Edition [filename] => /usr/share/GeoIP/GeoIPOrg.dat ) [6] => Array ( [available] => [description] => GeoIP City Edition, Rev 0 [filename] => /usr/share/GeoIP/GeoIPCity.dat ) [7] => Array ( [available] => [description] => GeoIP Region Edition, Rev 0 [filename] => /usr/share/GeoIP/GeoIPRegion.dat ) [8] => Array ( [available] => [description] => GeoIP Proxy Edition [filename] => /usr/share/GeoIP/GeoIPProxy.dat ) [9] => Array ( [available] => [description] => GeoIP ASNum Edition [filename] => /usr/share/GeoIP/GeoIPASNum.dat ) [10] => Array ( [available] => [description] => GeoIP Netspeed Edition [filename] => /usr/share/GeoIP/GeoIPNetSpeed.dat ) [11] => Array ( [available] => [description] => GeoIP Domain Name Edition [filename] => /usr/share/GeoIP/GeoIPDomain.dat ) [12] => Array ( [available] => 1 [description] => GeoIP Country V6 Edition [filename] => /usr/share/GeoIP/GeoIPv6.dat ) [13] => Array ( [available] => [description] => GeoIP LocationID ASCII Edition [filename] => /usr/share/GeoIP/GeoIPLocA.dat ) [14] => Array ( [available] => [description] => GeoIP Accuracy Radius Edition [filename] => /usr/share/GeoIP/GeoIPDistance.dat ) [15] => Array ( [available] => [description] => GeoIP City with Confidence Edition [filename] => /usr/share/GeoIP/GeoIPCityConfidence.dat ) [16] => Array ( [available] => [description] => GeoIP City with Confidence and Accuracy Edition [filename] => /usr/share/GeoIP/GeoIPCityConfidenceDist.dat ) )

Whats wrong? I am using a "managed" root server! So i can`t do anything myself so the support must do it if its a server side problem....

[svyrydov]

Mine is working now. Problem was with admins
procrewing.com/usermap.php
all you need is to ask your hosting to enable GeoIP

[digitalpoint]

Originally Posted by imported_stefan

- so databes both installed
- geoip with phphinfo checked
- mod installed


empty pages :-)

any more hints ???

error reporting on does not show up errors

Nope, you will need to talk to your server admins really...

Originally Posted by goc-forum.de

I am getting this error code:

Warnung: geoip_record_by_name(): Required database not available at /usr/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 100)

I uploaded your test.php and this is the result:

Array ( [1] => Array ( [available] => 1 [description] => GeoIP Country Edition [filename] => /usr/share/GeoIP/GeoIP.dat ) [2] => Array ( [available] => [description] => GeoIP City Edition, Rev 1 [filename] => /usr/share/GeoIP/GeoIPCity.dat ) [3] => Array ( [available] => [description] => GeoIP Region Edition, Rev 1 [filename] => /usr/share/GeoIP/GeoIPRegion.dat ) [4] => Array ( [available] => [description] => GeoIP ISP Edition [filename] => /usr/share/GeoIP/GeoIPISP.dat ) [5] => Array ( [available] => [description] => GeoIP Organization Edition [filename] => /usr/share/GeoIP/GeoIPOrg.dat ) [6] => Array ( [available] => [description] => GeoIP City Edition, Rev 0 [filename] => /usr/share/GeoIP/GeoIPCity.dat ) [7] => Array ( [available] => [description] => GeoIP Region Edition, Rev 0 [filename] => /usr/share/GeoIP/GeoIPRegion.dat ) [8] => Array ( [available] => [description] => GeoIP Proxy Edition [filename] => /usr/share/GeoIP/GeoIPProxy.dat ) [9] => Array ( [available] => [description] => GeoIP ASNum Edition [filename] => /usr/share/GeoIP/GeoIPASNum.dat ) [10] => Array ( [available] => [description] => GeoIP Netspeed Edition [filename] => /usr/share/GeoIP/GeoIPNetSpeed.dat ) [11] => Array ( [available] => [description] => GeoIP Domain Name Edition [filename] => /usr/share/GeoIP/GeoIPDomain.dat ) [12] => Array ( [available] => 1 [description] => GeoIP Country V6 Edition [filename] => /usr/share/GeoIP/GeoIPv6.dat ) [13] => Array ( [available] => [description] => GeoIP LocationID ASCII Edition [filename] => /usr/share/GeoIP/GeoIPLocA.dat ) [14] => Array ( [available] => [description] => GeoIP Accuracy Radius Edition [filename] => /usr/share/GeoIP/GeoIPDistance.dat ) [15] => Array ( [available] => [description] => GeoIP City with Confidence Edition [filename] => /usr/share/GeoIP/GeoIPCityConfidence.dat ) [16] => Array ( [available] => [description] => GeoIP City with Confidence and Accuracy Edition [filename] => /usr/share/GeoIP/GeoIPCityConfidenceDist.dat ) )


Whats wrong? I am using a "managed" root server! So i can`t do anything myself so the support must do it if its a server side problem....

I'd say this is a pretty good indicator of what's wrong...

Required database not available at /usr/share/GeoIP/GeoIPCity.dat