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

[FTDave]

I've checked her IP. It is a static IP address. I checked all of her IPs when searching for her ips in vbulletin admin.

They are all the same. 98.249.54.16
http://whatismyipaddress.com/ip/98.249.54.16
culpepper virgina.
Also in the session table it has that address.
I checked with phpmyadmin with cpanel.
Is there anyway I could manually put a piece of code in the usermap.php to show her on the map if usermap sees that number in session table?

[digitalpoint]

If you look in the sessions table, does that user have more than one entry (based on userid)?

[FTDave]

No sir.
I click on userid in the session table and I only see her userid once.
Her userid is 3014 and host is 94.249.54.16 in the session table.

[TombstoneWarrior]

for this to work for most members we are going to need the geoip install instructions because i cant figure that install out and there site is not very helpful!!

[FTDave]

Yeah. I never messed with servers much. I just tinkered with my dedicated server and it finally worked.

[digitalpoint]

Originally Posted by FTDave

No sir.
I click on userid in the session table and I only see her userid once.
Her userid is 3014 and host is 94.249.54.16 in the session table.

Can you make a PHP script that is just this and post the output?

PHP Code:

<?php
print_r (geoip_record_by_name('94.249.54.16'));

[FTDave]

Array ( [continent_code] => NA [country_code] => US [country_code3] => USA [country_name] => United States [region] => VA [city] => Culpeper [postal_code] => 22701 [latitude] => 38.4347991943 [longitude] => -77.9866027832 [dma_code] => 511 [area_code] => 540 )

I swear. There is no pin anywhere near virginia.
Is it cached? Anyway to clear cache?
The first time I ran this output it said chatanooga.
So I downloaded file again and its output said culpepper

[FTDave]

I downloaded the geoipcity.dat file again and it moved her from chatanooga to culpepper but it does not show up on map.

[FTDave]

I checked the session file and she is still in the file.

[digitalpoint]

It does cache their location until they time out of the session/who's online (15m by default on vB for them to not be online).