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]

It shouldn't display differently regardless of the user. Are you able to confirm it yourself?

[Janmaat]

Yes!

After I have removed usergroup id# 6 from the settings in ACP to be shown as Admin on the user map, the user map is now showing only yellow pins (guests) and white pins (bots) but no green pins (registered users).

[Lpspider]

This plugin only works for currently active users, correct? Is there another mod (or an easy way to modify this) that would allow users to confirm their location and treat it as a quasi-permanent member map

[grey_goose]

Looks like a cool mod -- but my map is blank?

http://nwod.org/forum/usermap.php

[digitalpoint]

Are you sure? This is what I see at the URL...

[datoneer]

Ok here is my problem,
Linux Systems Administrator from hostgator told me this:
I've added the Net_GeoIP PHP module for you.

But still when i open user map i see this

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

[digitalpoint]

It's not installed then.

[grey_goose]

Originally Posted by digitalpoint

Are you sure? This is what I see at the URL...

[high]* grey_goose scratches head and goes to ponder what foul trickery is at play
[/high]

Thanks

[Dave Hybrid]

Hi Shawn,

Any way to show this on forumhome?

Thanks, Dave.

[Dave Hybrid]

$forumusers = $db->query_read_slave("
    SELECT userid, usergroupid, ipaddress AS host, '' AS useragent, IF(usergroupid IN(" . iif($vbulletin->options['digitalpoint_usermap_admins'], $db->escape_string($vbulletin->options['digitalpoint_usermap_admins']), 0) . "), 1, IF(userid > 0, 2, 3)) AS sortorder
    FROM " . TABLE_PREFIX . "user AS user
    ORDER BY sortorder
    LIMIT 5000" . "
");

One other thing, I'm using the above code for registered users, is it also possible to have the pins link to the members profile, rather than Google Earth?