Vbulletin World Map System

Vbulletin World Map Plotting System
Show Your Guest/Members From All Over The World !!!

Summary:

The core of this system I developed approximately 3 years ago but was unable to practically distribute it on vborg due to the fact the GEOIP City Database was a very expensive software product; and it is needed to map IP Addresses to Global Lat/Lon Coordinates.

With the recent availability of a "Lite" version of the City Database I have decided to build from the ground up a new hack that utilizes it to display 2 map structures.

1. Plots Your Current Members/Guest Online available on the Whos Online Page.
2. Plots Your Registered Members last known Coordinates on the Member List Page.
3. Coordinates are calculated from IP Addresses stored in your Forums Database.

Features:

• Automatic & Accurate plotting of your Guest & Members on the WorldMap.
• WorldMap Page to view Both Maps, added to your navbar.
• Enable WOL, Member Plotting Independently
• Control Panel Options
• Specify Plotting Image Type, Size, Color
• Specify Opaque, Alpha Transparency
• Support for Payed Full Version of City Database
• Updates on Scheduled Task Interval
• Map is shown small and expands on Mouseover, then contracts back.

Instructions:

1. Download Zip File
2. Read INSTALL.TXT
3. Run the crontask manually the first time, so it will generate your images.
4. Click Install if you like it

Updates:
3/14/2006 - Forgot to uncomment keep-alive code.
3/12/2006 12:54pm -
1. Added a new Realistic World map
2. Configuration Editor partially remade, allows easier selection of Maps.
3/8/2006 11:35pm - Added a worldmap.php Page, for viewing both maps.
3/8/2006 9:52am - Fixed the jpeg output problem.

Note:

The GEOIP Binary Database can be located here:

http://www.maxmind.com/download/geoi...iteCity.dat.gz

[ConqSoft]

It could be changed to fall back to their Registration IP I suppose. Not sure how it would affect performance to do two searches though.

[headrat]

actually, I don't want it to do both, I only have one map showing
Just want to pull from the registration IPs, any idea as to how to code that and where?

[headrat]

Oops, and what php are you pulling from, I can't seem to find that one.

[headrat]

Originally Posted by Trigunflame

PHP Code:

"SELECT post.ipaddress " .
"FROM " . TABLE_PREFIX . "post AS post, " . 
TABLE_PREFIX . "user AS user " .
"WHERE user.userid = post.userid " .
"AND user.lastpost = post.dateline" 


Its pulling up all of your members who have posted.

Is there a

"SELECT register.ipaddress"

I could use or something?

[gavinzac]

Originally Posted by Trigunflame

People should already have a location field per vbulletin default.

While this system could be setup to automatically insert information into that profile field it probably wouldnt be a good idea; the GEOIP city lite database while being the best 'free' IP database is still not very accurate in terms of hitting your city direct on.

So you would most likely have profiles with many false positives; the map was created to be a 'general' observation of where your members/guest are scattered throughout the world.

yeah, i understand, i suppose what i'm looking for is a city - based version of the exisiting GEOIP Country Targeting. it would be extremely cool and allow for lots of new mods such as location determined forums, ads, language selection etc.

i know, i know, go ask in the other thread its just that i've tried to do this myself by editing that code and it didnt quite work. im a jsp expert, not php

[headrat]

anyone got anything on this and getting ALL the REGISTERED IPs to by shown?

[ConqSoft]

To have it plot ALL registered members, and not just those that have posted, do this:

In class_wmp.php, change this:

                "SELECT post.ipaddress " .
                "FROM " . TABLE_PREFIX . "post AS post, " . 
                TABLE_PREFIX . "user AS user " .
                "WHERE user.userid = post.userid " .
                "AND user.lastpost = post.dateline"

To this:

                "SELECT ipaddress " .
                "FROM " . TABLE_PREFIX . "user"

It would be better to have it use their latest post IP if available, then fall back to their registration IP if they have never posted, but I haven't gotten around to trying to do that yet... Maybe the hack author will.

[headrat]

I think that did it, it at least put MORE on there.

[ConqSoft]

Yeah, I have 5200 members who haven't posted, so switching to the Registration IP filled the map in even more.

I guess it depends on if you want to show all members, or only those members who participate.

Also, their Registration IP never changes, so if they move to a new location, their location on the map will remain the same. If you get the IP from their last post, it will always get their latest location.

There should be a way to combine the two and use the Registration IP if they have 0 posts. I may play around with it, unless the hack author wants to....

[srpompon]

Originally Posted by Trigunflame

Maybe upload all the files first?

I put all the files, and show the error...




Thanks,

Ivan