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]

Is your server suppressing errors by chance?

Try making it this:

PHP Code:

<?php 
error_reporting(E_ALL);
print_r (geoip_record_by_name($_SERVER['REMOTE_ADDR']));

[Poppet]

Tried that and still a blank page, cleared the cache in my browser just to be sure.

[digitalpoint]

Well something is wrong with your server... you are probably going to want to talk to your server admin to figure it out. geoip_record_by_name() is returning nothing for you (not even an error) on your server.

[Poppet]

My hosts have fixed the problem and it's working great now. They are going to let me know what the problem was and if it's a PHP config issue it might help out other people...

[Poppet]

It was the database location, it needs to be at,

/usr/local/share/GeoIP

[addamroy]

Originally Posted by digitalpoint

Make a script on your server with just this:

PHP Code:

<?php 
print_r (geoip_record_by_name($_SERVER['REMOTE_ADDR']));

What does it output?

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

Also, don't forget those closing ?> tags in your php code up there lol

[digitalpoint]

Originally Posted by addamroy

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

Also, don't forget those closing ?> tags in your php code up there lol

That error means you don't have the GeoIP extension installed in your version of PHP.

?> was intentionally left out (it's not required).

[imported_stefan]

Originally Posted by Poppet

It was the database location, it needs to be at,

/usr/local/share/GeoIP

I have maybe the same here. How can I switch the db location and where. I looked at this directory and its empty.

[digitalpoint]

The only way to change the db location would be to recompile geoip from scratch.

[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?