Digital Point User Map

[digitalpoint]

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 (http://forums.digitalpoint.com/showthread.php?t=36474) 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 (http://www.php.net/manual/en/book.geoip.php), 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

[noppid]

Nice to see. Thanks!

[Reeve of shinra]

Cool beans!

[Trek]

Thanks much, installed!

*edit*

nm, can't use it. My webhost doesn't have the PHP extension required for this mod. Had to uninstall.

[karlm]

Looks awesome... will investigate further soon..

[digitalpoint]

Thanks much, installed!

*edit*

nm, can't use it. My webhost doesn't have the PHP extension required for this mod. Had to uninstall.Yeah, sorry... I knew that was going to be the biggest sticking point, but it *is* a fairly common PHP extension so some people hosting on managed servers might have some luck. For those that run their own servers, it's pretty easy to install from RPM or just compile it.

Sadly there isn't a way around needing some sort of geotargetting mechanism though. I thought about making it geotarget against my servers for people, but then people would complain about privacy and such with all the geotargetting requests going to a central server. Can't make everyone happy unfortunately. :)

[Brandon Sheley]

good deal, thanks Shawn

[as7apcool]

good work ... thanks alot

[CoZmicShReddeR]

I added extension=php_geoip.dll and restarted apache server and when I click on the map link I get

Fatal error: Call to undefined function geoip_record_by_name() \usermap.php on line 100

I am using vB_Datastore_Filecache

[Abhik]

Thank you for the release Shawn..

[digitalpoint]

I added extension=php_geoip.dll and restarted apache server and when I click on the map link I get

Fatal error: Call to undefined function geoip_record_by_name() \usermap.php on line 100Well for whatever reason it didn't get installed correctly if the functions aren't there... :)

[Kolbi]

Thanks!

[TeknoSounds]

dope :D Works wonderfully ty!

[twitch]

Well for whatever reason it didn't get installed correctly if the functions aren't there... :)

same problem

[noppid]

It's not like the GeoIP site hands you the install instructions over there. But, I'm pretty sure a resourceful person could do the geoip pure install at the php file level rather then the apache server level if a shared host won't add it. http://geolite.maxmind.com/download/geoip/api/php/ Then you need the city database IIRC. http://www.maxmind.com/app/geolitecity and it looks like an edit to the DP php file to include the geoip api and initialize it.

[Tubbietoeter]

I asked my provider to install geoip and they did.

phpinfo says
geoip extension version 1.0.7
geoip library version 1004006
geoip.custom_directory no value no value

I get errors anyway:
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 100)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 128)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 133)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 152)
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 158)

am I doing something wrong?

[noppid]

I asked my provider to install geoip and they did.

phpinfo says
geoip extension version 1.0.7
geoip library version 1004006
geoip.custom_directory no value no value

I get errors anyway:
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 100)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 128)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 133)
Warnung: Invalid argument supplied for foreach() in [path]/usermap.php (Zeile 152)
Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 158)

am I doing something wrong?

They installed the default country database or provided the wrong path. You need GeoIP City.

[voglermc]

Would a different version be possible to build out based on profile field information and populate with certain info in profile fields of members?

I run a MINI Cooper Club site and it would be nice to see where our members are

[digitalpoint]

Would a different version be possible to build out based on profile field information and populate with certain info in profile fields of members?

I run a MINI Cooper Club site and it would be nice to see where our members areIn theory you could modify it to run based on the location of the IP address they used to register, but I don't think Google Maps could handle that many pins on the map to be honest.

[voglermc]

We have around 1300 members right now. I'd just like members to see they have others close by. I'm not to up to date on google's api so I don't know what it can and can't do

[Diablotic]

voglermc: There is another modification that will let you create profiles and pin them on google maps. It can be found here: https://vborg.vbsupport.ru/showthread.php?t=123148 but there is no official release for 4.0 yet :(

[digitalpoint]

We have around 1300 members right now. I'd just like members to see they have others close by. I'm not to up to date on google's api so I don't know what it can and can't doIf you want to make it work with registration IP addresses instead of currently online users, in the usermap.php file, change this:
$forumusers = $db->query_read_slave("
SELECT
session.userid, user.usergroupid, session.host, session.useragent, IF(user.usergroupid IN(" . iif($vbulletin->options['digitalpoint_usermap_admins'], $db->escape_string($vbulletin->options['digitalpoint_usermap_admins']), 0) . "), 1, IF(user.userid > 0, 2, 3)) AS sortorder
FROM " . TABLE_PREFIX . "session AS session
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > $datecut
ORDER BY sortorder
LIMIT 5000" . "
");
to this:
$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" . "
");
I haven't tested it, but I think it should work (it's still going to limit it to 5000 users/pins... anything more than that probably would cause issues for Google Maps anyway).

Obviously it's not going to show pins for spiders/guests (only registered users and admins/mods).

[Tubbietoeter]

Would a different version be possible to build out based on profile field information and populate with certain info in profile fields of members?

I run a MINI Cooper Club site and it would be nice to see where our members are

Aaaw dang, and I thought this was possible with this AddOn as well.
I run a Suzuki Jimny Club :D and we have the same need ... ;)

?$%& I really liked the looks of this ... *grmpf*

Hope there will be a good alternative for vb4 soon!

[voglermc]

Thank you both!

[voglermc]

error

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

[docvader]

vo, you dont have GEOIP on your server. Talk to your server host to install it.

[voglermc]

Thanks

[voglermc]

My host won't install on a shared server
Marked as uninstalled, wish I didn't have to

[TeknoSounds]

Yeah pretty much any shared hosting doesn't allow the geoip plugin as I've been told over and over its "too resource intensive". (was looking for stats generated by awstats)
But I moved over to my own dedicated server and runs wonderfully :)

[funmasti]

thanks shawn

[Kolbi]

Can you create a converter from the old vb membermap?

[digitalpoint]

Yeah pretty much any shared hosting doesn't allow the geoip plugin as I've been told over and over its "too resource intensive". (was looking for stats generated by awstats)
But I moved over to my own dedicated server and runs wonderfully :)Sounds like a generic answer from your host because they didn't feel like installing it. It's INCREDIBLY *not* resource intensive...

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

Benchmarked at being able to do 22k+ lookups per second without any sort of caching.

Can you create a converter from the old vb membermap?No idea what that is, sorry.

[Tryppnotic69]

Works great, Any way of getting registered users, admins, etc usernames to appear on the pins instead or along with View in Google Earth?

[digitalpoint]

Works great, Any way of getting registered users, admins, etc usernames to appear on the pins instead or along with View in Google Earth?I had thought about doing it that way originally, but decided against it because if all the potential complaints from end-users about privacy issues.

[Kolbi]

An importer for this modifcation: https://vborg.vbsupport.ru/showthread.php?t=154533 would be very very nice.

[Tryppnotic69]

I had thought about doing it that way originally, but decided against it because if all the potential complaints from end-users about privacy issues.

Would this be something fairly simple to add or would it require a lot of work? I don't know much about modding. I think it might be possible to add a check box to the registration page to accept being added to the member map. Might be cool to look into :-)

[CoZmicShReddeR]

Can anyone explain how to successfully install geoip on a xampp windows server??

I tried the mod_geoip as well but in any case I cannot get the php or the apache version running with windows...

[digitalpoint]

An importer for this modifcation: https://vborg.vbsupport.ru/showthread.php?t=154533 would be very very nice.There's nothing really *to* import since mine is locating the user in realtime based on their IP address. That one appears to really just be a system where each user can put an arbitrary pin on the map (since the user can put it anywhere they want). If you want something like that, you probably would just want to ask the developer to update it since it's really something different.

Would this be something fairly simple to add or would it require a lot of work? I don't know much about modding. I think it might be possible to add a check box to the registration page to accept being added to the member map. Might be cool to look into :-)Eh... it would be possible, but having people opt-into it would also have the affect of very few users actually using it. Personally, I like it the way it is now where it's a little more anonymous, but all users are on it.

[giorgino]

unistalled because no GeoIP on my server. Now I've an MySQL error...

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_usermap AS phrasegroup_usermap,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM vb_language
WHERE languageid = 2;

MySQL Error : Unknown column 'phrasegroup_usermap' in 'field list'
Error Number : 1054
Request Date : Friday, June 11th 2010 @ 08:13:14 AM
Error Date : Friday, June 11th 2010 @ 08:13:14 AM
Script : http://www.mysite.it/usermap.php
Referrer :
Username :
Classname : vB_Database
MySQL Version :

How can I solve this?

[digitalpoint]

If you uninstalled it, you would also want to delete the usermap.php file. :)

[docvader]

error

Fatal error: Call to undefined function geoip_record_by_name() in /home/tarheel/public_html/usermap.php on line 97
OK, so much for me giving people advice....

I now have GEOIP installed in my apache and environment, and I get this above error. What am I missing????

[ahmedipa]

so nice thank you so much

[mikey1991]

Can you 'backport' this to 3.8 and release it? I have a client who would love something like this.

[digitalpoint]

OK, so much for me giving people advice....

I now have GEOIP installed in my apache and environment, and I get this above error. What am I missing????Does GeoIP show up in phpinfo() for you?

[docvader]

No, it shows up in Apache as a mod, and in the environment. They installed the Apache end of it, not the PHP end. According to Maxmind, it's another way of doing it, but, apparently, it doesn't work.

I've asked them to put the PHP extension in for geoip. we're using Linux. Finding the right directions for Linux was not clear; if you have a good link, I'd appreciate it.

[Tryppnotic69]

No, it shows up in Apache as a mod, and in the environment. They installed the Apache end of it, not the PHP end. According to Maxmind, it's another way of doing it, but, apparently, it doesn't work.

I've asked them to put the PHP extension in for geoip. we're using Linux. Finding the right directions for Linux was not clear; if you have a good link, I'd appreciate it.

Softlayer just installed it on my Linux server using these instructions, and it worked great.

http://www.maxmind.com/app/installation?city=1

On step 3 (http://www.maxmind.com/app/api), they used Apache Module (mod_geoip) as the API. Everything works great at my forum.

[LbR]

Yeah, sorry... I knew that was going to be the biggest sticking point, but it *is* a fairly common PHP extension so some people hosting on managed servers might have some luck. For those that run their own servers, it's pretty easy to install from RPM or just compile it.

Sadly there isn't a way around needing some sort of geotargetting mechanism though. I thought about making it geotarget against my servers for people, but then people would complain about privacy and such with all the geotargetting requests going to a central server. Can't make everyone happy unfortunately. :)

will that work with a VPS?

[TeknoSounds]

No, it shows up in Apache as a mod, and in the environment. They installed the Apache end of it, not the PHP end. According to Maxmind, it's another way of doing it, but, apparently, it doesn't work.

I've asked them to put the PHP extension in for geoip. we're using Linux. Finding the right directions for Linux was not clear; if you have a good link, I'd appreciate it.

I just installed the extension myself the other day on my Fedora box.

Just used YUM to grab the latest geoip packages (theres two you need), then just made sure the folder with the geoip.so was in my included path, restarted apache, and np :)

[digitalpoint]

Well, depending on the operating system you are running for your server, there probably is a pre-packaged RPM installer for it.

I just compiled mine from source...

Install the libraries by downloading and compiling as per the instructions here:
http://www.maxmind.com/app/c

Then download and compile/install the PHP module for it:
http://pecl.php.net/package/geoip

For my installation, the GeoCity .dat files go into /usr/local/share/GeoIP/ (I think that's the default... don't think I would have changed the path for them).

You can download the .dat files from:
http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz
http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz

[pete_brady]

i had to manually compile from source as above but also rename GeoLiteCity.dat to GeoIPCity.dat & copy it to /var/lib/GeoIP

i was probably doing it wrong though

installed & working just fine now. thanks!

(& thanks also for your vb optimisation article at digitalpoint)

[digitalpoint]

Yeah... they changed the name of their .dat file they distribute a few months ago for some reason and they haven't updated the libraries to reflect that. Not sure why they changed the name of the file, but renaming it to the old name works fine (as you found).

[docvader]

thanks for all the extra info.
Got it working. Great job DP

[Boko577]

I added extension=php_geoip.dll and restarted apache server and when I click on the map link I get

Fatal error: Call to undefined function geoip_record_by_name() \usermap.php on line 100

I am using vB_Datastore_Filecache

Same problem??? Why won't it work?

[TeknoSounds]

pretty sure the windows version will need the .dat file too

[MikeF]

Is there any way to completely exclude guests from this mod? It eats up a huge amount of resources, but is of no relevance to our full time members.

[docvader]

Boko, that GeoLiteCity.dat file needs to be in usr/local/share/ directory, and it needs to be renamed to GeoIPCity.dat.

[syrn]

not working ......??

[imranbaig]

Hey, Thanks for sharing with us.

[Megatr0n]

Any chance this will be updated for 3.8?

[digitalpoint]

Is there any way to completely exclude guests from this mod? It eats up a huge amount of resources, but is of no relevance to our full time members.
What resources is it overloading on your server?
Any chance this will be updated for 3.8?
No, sorry... I don't run any 3.x forums, so...

[Kaitou Ace]

Would the map be able to show usernames and link to profile? Maybe for staff groups only, or all users, but a configurable option for that could be handy.

[Gamershosting]

Hi all great mod and like the idea of it. However I have an issue. IT won't show up. I tried using Firefox and IE8. The page will display but no map.

In IE8 there is an error icon in the bottom left stating Done but with errors. When clicked I get this error message:

Webpage error details

Message: Syntax error
Line: 369
Char: 41
Code: 0
URI: http://www.gamershosting.net/usermap.php

In my phpinfo.php it shows this:

geoip
geoip support enabled
geoip extension version 1.0.7
geoip library version 1004006

Directive Local Value Master Value
geoip.custom_directory no value no value


Your help would be greatly appreciated.

Thanks

[wcguy]

Hi, nice ap too.

I am getting similar errors as above.

In IE8 a blank page, with these errors:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; WOW64; Trident/4.0; GTB6.5; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Alexa Toolbar; .NET4.0C)
Timestamp: Tue, 29 Jun 2010 12:49:40 UTC


Message: Syntax error
Line: 333
Char: 41
Code: 0
URI: http://www.XXXXX.com/usermap.php


Message: Object doesn't support this property or method
Line: 248
Char: 1
Code: 0
URI: http://www.XXXXX.com/usermap.php



and

phpinfo

geoip
geoip support enabled
geoip extension version 1.0.6
geoip library version 1004006

Directive Local Value Master Value
geoip.custom_directory no value no value

[Pashaali]

install but it cant work http://www.desifunbox.com/usermap.php

just seen blank page . im use vbseo have to edit something ?

please help for it

[digitalpoint]

Did the USERMAP template not get installed somehow or something (the package installer should have done it automatically). Search your templates for a template named "USERMAP".

[wcguy]

I had an install error for the database.

all fixed now. Thanks!

Good app.

[Pashaali]

Fatal error: Call to undefined function geoip_record_by_name() in /------/desifunbox.com/usermap.php on line 100

[digitalpoint]

Fatal error: Call to undefined function geoip_record_by_name() in /------/desifunbox.com/usermap.php on line 100
See first post/install instruction...

Important! - this uses the free GeoIP PHP extension (http://www.php.net/manual/en/book.geoip.php), so you must have it installed on your server in order for it to work.

[Xencored]

Awesome installed Thanks its a ace touch :)

[sinucello]

Hi,

thanks for sharing this. I really like that your are using GeoIP. Unfortunately this map won`t be very useful for my community members without showing the usernames in the bubbles. So I dare to ask if you could add this as an option in a future release.

thank you - all the best,
Sacha

[digitalpoint]

Hi,

thanks for sharing this. I really like that your are using GeoIP. Unfortunately this map won`t be very useful for my community members without showing the usernames in the bubbles. So I dare to ask if you could add this as an option in a future release.

thank you - all the best,
SachaIt intentionally doesn't show username. It's not a tool to track down/stalk users... and revealing a user's exact location with info that ties them to who they are specifically (username) just runs into all sorts of privacy issues.

[sinucello]

It intentionally doesn't show username. It's not a tool to track down/stalk users... and revealing a user's exact location with info that ties them to who they are specifically (username) just runs into all sorts of privacy issues.I get your point and agree. The vBmembermap showed the names in the bubbles but it allowed the users to choose if and where their markers were set and I understand that this makes a big difference to the way your plugin is working. But yours the only one working for vB4 so I guess you`ll receive a couple more requests like mine ;-).

all the best,
Sacha

[digitalpoint]

I get your point and agree. The vBmembermap showed the names in the bubbles but it allowed the users to choose if and where their markers were set and I understand that this makes a big difference to the way your plugin is working. But yours the only one working for vB4 so I guess you`ll receive a couple more requests like mine ;-).

all the best,
SachaYeah, this one is automatic and not an opt-in system where the user can choose to set their location arbitrarily. Instead it just does it and the user can't hide or lie about it to the public. So that's where the privacy issues can potentially come into play. Imagine if you could look at any Facebook profile and know exactly where they last logged in from. :)

[Prox0001]

Very nice, works great except that it only shows guests (yellow pins) and spiders (white pins). Even when I pick "show yourself" it shows the correct area but no pin whatsoever... any ideas?

[digitalpoint]

Very nice, works great except that it only shows guests (yellow pins) and spiders (white pins). Even when I pick "show yourself" it shows the correct area but no pin whatsoever... any ideas?What's the URL where it's installed?

[andyv72]

How du install this ????

I dont have any idea....

pls help me

[ubcforums]

Thanks for sharing ..

[Nomar86]

very cool map. tagged this post for future download, thanks again

[dd365media]

Alright... I have error on line 100 too.

I have GeoIP.dat in /share/ directory. I uploaded it there manually.

http://www.maxmind.com/app/installation?city=1

I don't get why is there "GeoIP-133_20051201.tar.gz"

And I just figured out there's old installation which is in /usr/share and not /usr/local/share

[KevinL]

OK I am having an issue with this.

GeoIP is installed in PHPinfo I can see it. I installed this and I go to usermap and I see everything but the actual map. I changed the settings and everything but nothing. I am not even getting an error.

What did I do wrong? lol

[KevinL]

GeoIP has been re-installed and I am still having the same problem...

The template is there but no map..

Anyone? Please?

OK I am having an issue with this.

GeoIP is installed in PHPinfo I can see it. I installed this and I go to usermap and I see everything but the actual map. I changed the settings and everything but nothing. I am not even getting an error.

What did I do wrong? lol


In IE8 a blank page, with these errors:

Code:
Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; WOW64; Trident/4.0; GTB6.5; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Alexa Toolbar; .NET4.0C)
Timestamp: Tue, 29 Jun 2010 12:49:40 UTC


Message: Syntax error
Line: 333
Char: 41
Code: 0
URI: http://www.XXXXX.com/usermap.php


Message: Object doesn't support this property or method
Line: 248
Char: 1
Code: 0
URI: http://www.XXXXX.com/usermap.php
and

phpinfo

geoip
geoip support enabled
geoip extension version 1.0.6
geoip library version 1004006

Directive Local Value Master Value
geoip.custom_directory no value no value

[digitalpoint]

What version of vBulletin are you using?

[KevinL]

What version of vBulletin are you using?
4.0.6

Thanks for the reply!

[digitalpoint]

What's the URL?

[KevinL]

Since it is not my forum I will PM you the url?

Thanks :)

[digitalpoint]

It's choking because you have no $_SERVER['REMOTE_ADDR'] set to determine the location of the user looking at the page.

Maybe some weird security system where somewhere along the way it unsets $_SERVER globals?

At the end of the usermap.php, change this:
$user_location = geoip_record_by_name($_SERVER['REMOTE_ADDR']);

to this:
$user_location = geoip_record_by_name(IPADDRESS);

Maybe that will work if $_SERVER is disappearing somehow.

[KevinL]

nah didn't work. I don't think they have anything out of the ordinary installed.

Thanks for looking into it for me.

[digitalpoint]

Well either way, $user_location isn't getting a valid array. So either $_SERVER['REMOTE_ADDR'] isn't set properly or geoip_record_by_name() isn't working... but I assume geoip_record_by_name() is working because it's able to look up addresses from the session table.

[KevinL]

I will look into it further. Thanks!

[spillage]

I confirmed that the GeoIP files exist on my server, uploaded the usermap.php file to my Forums folder, imported the xml file, and rebooted the server.
I get User Map listed in the Community dropdown, but when I click on it I get the 500 Internal Server Error.

Any direction would be appreciated.

[digitalpoint]

Have you checked your error logs for your web server? It should give you some detailed info about the internal server error.

I would double check that the geoip extensions are not only installed, but also the necessary databases (maybe your server sees the function, but it's missing the DB files... although I would think the function would throw an error then).

[junaid]

How I can add What's Going On? (view map) like digital point?
"There are currently 1,819 users online. 364 members and 1,455 guests (view map)"

Also is it possible list user-groups separately? with original forum html colour?

[BadgerDog]

Installed ..thank you ... :up:

Anyone else have their Registered members (supposed to be green) showing up in RED as Admin/Moderator group?

Is there somewhere to configure this so Admins DO NOT show up?

Thanks .. :)

Regards,
Badger

Edit: How about this question. Is there some way to simply have this mod re-start and re-gather information from scratch, to reset the pins on the map to a current state? .. thanks ... :)

[Cust0ms]

Is it possible to add GeoIP PHP via .htaccess? I use shared hosting and hosting's owner do not want to add GeoIP PHP :/

[RWerksman]

Is there an easy way to modify the main user generation query to show folks who have been online in the last 30, 60, or 90 days?

[digitalpoint]

if you showed a pin for everyone that was online in the last 90 days you probably would crash the web browser with trying to dynamically place so many pins.

[Pro-eSports.com]

Is this the download link for the stuff my provider has to install?
http://pecl.php.net/package/geoip

I need the correct download link.

[digitalpoint]

Yes... that is a PHP wrapper for the C API, so you would need that also (installed first) if you don't have it already:

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

[joeldaviddc]

instaled http://pecl.php.net/package/geoip

instaled http://www.maxmind.com/app/c

geoip on phpinfo.


no, errors en error.log... but no map in screen,

firebug message:

syntax error
[Break on this error] map.setCenter(new google.maps.LatLng(, ));\n

usermap.php (line 353)


firebug details:
case "india":
345 map.setCenter(new google.maps.LatLng(22.350076, 80.859375));
346 map.setZoom(4);
347 break;
348 case "oceania":
349 map.setCenter(new google.maps.LatLng(-23.805450, 144.140625));
350 map.setZoom(3);
351 break;
352 case "me":
353 map.setCenter(new google.maps.LatLng(, ));
354 map.setZoom(9);
355 break;
356 default:
357 map.setCenter(new google.maps.LatLng(24, -10));
358 map.setZoom(2);
359 break;

[Pro-eSports.com]

I get the following error above the header:

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 128

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 133

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 152

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 158

http://i107.photobucket.com/albums/m287/Jerichool/Random/ScreenHunter_01Oct142044.gif

My host said they installed the php-geoip module. Did they forget something?

[joeldaviddc]

Well, depending on the operating system you are running for your server, there probably is a pre-packaged RPM installer for it.

I just compiled mine from source...

Install the libraries by downloading and compiling as per the instructions here:
http://www.maxmind.com/app/c

Then download and compile/install the PHP module for it:
http://pecl.php.net/package/geoip

For my installation, the GeoCity .dat files go into /usr/local/share/GeoIP/ (I think that's the default... don't think I would have changed the path for them).

You can download the .dat files from:
http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz
http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz


i have donwloaded the geolite city...



Boko, that GeoLiteCity.dat file needs to be in usr/local/share/ directory, and it needs to be renamed to GeoIPCity.dat.

i have renamed it...

instaled http://pecl.php.net/package/geoip

instaled http://www.maxmind.com/app/c

geoip on phpinfo.


no, errors en error.log... but no map in screen,

firebug message:

syntax error
[Break on this error] map.setCenter(new google.maps.LatLng(, ));\n

usermap.php (line 353)


firebug details:
case "india":
345 map.setCenter(new google.maps.LatLng(22.350076, 80.859375));
346 map.setZoom(4);
347 break;
348 case "oceania":
349 map.setCenter(new google.maps.LatLng(-23.805450, 144.140625));
350 map.setZoom(3);
351 break;
352 case "me":
353 map.setCenter(new google.maps.LatLng(, ));
354 map.setZoom(9);
355 break;
356 default:
357 map.setCenter(new google.maps.LatLng(24, -10));
358 map.setZoom(2);
359 break;

then working...

solved...

[junaid]

My website is hosted shared host work fine
http://www.maldiviandigital.com/usermap.php

If u want ant info send PM

[Guest191216]

Hi,
my provider stated I do have "mod_geoip" module, not GeoIP PHP extension :o(.
Is there any way to get the map working ?
(I assume - NO- but still hope ...)

txs
KH

[tpearl5]

I'm seeing that all guests are showing as spiders. Any ideas?

[Boofo]

I just installed this and have downloaded the files and uploaded them to there server. I am getting the following errors now and no map:

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 128
Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 133
Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 152

Any ideas what is happening?

[Boofo]

Figured it out. Apparently, I was not logged in when the errors were shown. Do I need to turn it off for guests then? Apparently, if there are no users and only guests on the site, is when the error occurs.

[digitalpoint]

It should be fine if guests can/can't view as long as at least you have a user online.

[Boofo]

It should be fine if guests can/can't view as long as at least you have a user online.

I have the links only show to members now. Since I am still working on the site, there are times I come in as a guest and if there are no spiders or registered users online at the time, I get the error. There are quite a few smaller sites that run into that every now and then.

[reefland]

Hey digitalpoint,

I just tried to get this rolling on my new server today and am not having any luck.

GeoIP is installed and can be seen here (http://www.nationofblue.com/info.php)
Product is imported and USERMAP template is installed.
The page loads but there is no Google Map. No errors are displayed anywhere.
Tried to change $_SERVER['REMOTE_ADDR'] to IPADDRESS at the bottom of usermap.php as you mentioned previously with no different results.

http://www.nationofblue.com/usermap.php

Any thoughts?

[reefland]

Hey digitalpoint, please ignore my previous post. The problem was that the usermap.css was not getting added to my styles directory in vbulletin_css. I am not sure why but manually creating it solved my problem.

[Boofo]

Shawn, is there a way to set the width of the map? On a widescreen monitor is starts to repeat itself.

[ShadowStalker]

Awesome mod. Unfortunately don't have the extension needed.

[Boofo]

What extension?

[digitalpoint]

Shawn, is there a way to set the width of the map? On a widescreen monitor is starts to repeat itself.You could change the CSS width directive for #map... it's set to 100% by default, but you could set it to a specific pixel width if you wanted.

[Boofo]

You could change the CSS width directive for #map... it's set to 100% by default, but you could set it to a specific pixel width if you wanted.

Thank you, sir. I will play with it and see what I can figure out.

[sadaar]

My host gladly installed the extension... for a small fee... but after install I get the no map thing. No errors. Trued changing the code to

$user_location = geoip_record_by_name(IPADDRESS);

No luck.

vBulletin 4.1.0 PL2

Suggestions? I would hate to have paid that install fee for a mod I cannot get to work :(

[digitalpoint]

Did they install the extension, but not the database that goes with it maybe?

[sadaar]

How may I check?

[digitalpoint]

You could make a PHP script with the following:

<?php
print_r(geoip_db_get_all_info());
?>

That will give you various info about the databases available...

[sadaar]

Output of requested command is:

Array ( [1] => Array ( [available] => [description] => GeoIP Country Edition [filename] => /var/lib/GeoIP/GeoIP.dat ) [2] => Array ( [available] => [description] => GeoIP City Edition, Rev 1 [filename] => /var/lib/GeoIP/GeoIPCity.dat ) [3] => Array ( [available] => [description] => GeoIP Region Edition, Rev 1 [filename] => /var/lib/GeoIP/GeoIPRegion.dat ) [4] => Array ( [available] => [description] => GeoIP ISP Edition [filename] => /var/lib/GeoIP/GeoIPISP.dat ) [5] => Array ( [available] => [description] => GeoIP Organization Edition [filename] => /var/lib/GeoIP/GeoIPOrg.dat ) [6] => Array ( [available] => [description] => GeoIP City Edition, Rev 0 [filename] => /var/lib/GeoIP/GeoIPCity.dat ) [7] => Array ( [available] => [description] => GeoIP Region Edition, Rev 0 [filename] => /var/lib/GeoIP/GeoIPRegion.dat ) [8] => Array ( [available] => [description] => GeoIP Proxy Edition [filename] => /var/lib/GeoIP/GeoIPProxy.dat ) [9] => Array ( [available] => [description] => GeoIP ASNum Edition [filename] => /var/lib/GeoIP/GeoIPASNum.dat ) [10] => Array ( [available] => [description] => GeoIP Netspeed Edition [filename] => /var/lib/GeoIP/GeoIPNetSpeed.dat ) [11] => Array ( [available] => [description] => GeoIP Domain Name Edition [filename] => /var/lib/GeoIP/GeoIPDomain.dat ) [12] => Array ( [available] => [description] => GeoIP Country V6 Edition [filename] => /var/lib/GeoIP/GeoIPv6.dat ) )

[digitalpoint]

Yep, looks like databases are not installed. Otherwise the "available" key would be "true".

[sadaar]

UPDATE:
I SSH'd into the server and the /var/lib/GeoIP/ directory is empty. Anything I can do? I have the GeoLiteCity.dat file.

[Boofo]

You need to change the name of GeoLiteCity.dat to GeoIPCity.dat and upload it along with GeoIP.dat to the directory on the server, if they have GeoIP installed correctly.

[sadaar]

I emailed by Host, and got this response:

Regarding GeoIP, the database had been installed at /usr/share/GeoIP, I have moved the file to /var/lib/GeoIP.

I renamed the file above and uploaded it into both locations. Still have the same issue. I can see everything buy the actual map.

Sad.. It seems like a really cool mod.

[digitalpoint]

Does the output of the previously mentioned PHP script show it as available now?

[sadaar]

Output is now as follows. I can verify that the /var/lib/GroIP/GeoIP.dat file is present, but the only other file in that directory is GeoIPCity.dat

Array ( [1] => Array ( [available] => 1 [description] => GeoIP Country Edition [filename] => /var/lib/GeoIP/GeoIP.dat ) [2] => Array ( [available] => 1 [description] => GeoIP City Edition, Rev 1 [filename] => /var/lib/GeoIP/GeoIPCity.dat ) [3] => Array ( [available] => [description] => GeoIP Region Edition, Rev 1 [filename] => /var/lib/GeoIP/GeoIPRegion.dat ) [4] => Array ( [available] => [description] => GeoIP ISP Edition [filename] => /var/lib/GeoIP/GeoIPISP.dat ) [5] => Array ( [available] => [description] => GeoIP Organization Edition [filename] => /var/lib/GeoIP/GeoIPOrg.dat ) [6] => Array ( [available] => 1 [description] => GeoIP City Edition, Rev 0 [filename] => /var/lib/GeoIP/GeoIPCity.dat ) [7] => Array ( [available] => [description] => GeoIP Region Edition, Rev 0 [filename] => /var/lib/GeoIP/GeoIPRegion.dat ) [8] => Array ( [available] => [description] => GeoIP Proxy Edition [filename] => /var/lib/GeoIP/GeoIPProxy.dat ) [9] => Array ( [available] => [description] => GeoIP ASNum Edition [filename] => /var/lib/GeoIP/GeoIPASNum.dat ) [10] => Array ( [available] => [description] => GeoIP Netspeed Edition [filename] => /var/lib/GeoIP/GeoIPNetSpeed.dat ) [11] => Array ( [available] => [description] => GeoIP Domain Name Edition [filename] => /var/lib/GeoIP/GeoIPDomain.dat ) [12] => Array ( [available] => [description] => GeoIP Country V6 Edition [filename] => /var/lib/GeoIP/GeoIPv6.dat ) )

[digitalpoint]

Looks fine from the output. Are you getting an error, or?

[sadaar]

No errors at all, just no map. I have recorded a short screencast to better illustrate my issue. I really do appreciate your help in getting this resolved.

http://screencast.com/t/I5Gv4erMXxI

[digitalpoint]

What's the URL you have it running it at? I'll check it out... maybe you are getting some sort of JS error or something with the Google Map API.

[sadaar]

Sent a PM with login credentials for you.

[digitalpoint]

Did you edit the usermap.php file by chance? It *really* looks like it's been edited to me.

[sadaar]

Hmm. No I didn't edit the file. I just re-downloaded the zip, uploaded it and overwrote what was already there, and re-imported the XML (with overwrite on), with the same results.

[Mattske]

I am getting the following errors, I confirmed with host that everything was successfully installed and renamed as per some of the comments listed above however a series of errors appears at the top of the page before the map.

No map is shown either.

Any help or assistance would be superb.

Cheers!

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /opt/geoip/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100


Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 128

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 133

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 152

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /opt/geoip/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 158


EDIT:
This is a listing of the two directories - am I missing anything?


-bash-3.2# ls -aslh /var/lib/GeoIP
total 29M
2.0K drwxr-xr-x 2 root root 2.0K Dec 20 19:06 .
2.0K drwxr-xr-x 19 root root 2.0K Dec 20 18:38 ..
1.2M -rw-r--r-- 1 root root 1.2M Dec 20 19:06 GeoIP.dat
28M -rw-r--r-- 1 root root 28M Dec 20 18:38 GeoIPCity.dat



-bash-3.2# ls -aslh /usr/local/share/GeoIP/
total 57M
2.0K drwxr-xr-x 2 root root 2.0K Dec 20 18:38 .
2.0K drwxr-xr-x 6 root root 2.0K Dec 20 10:32 ..
1.2M -rw-r--r-- 1 root root 1.2M Dec 20 10:32 GeoIP.dat
28M -rw-r--r-- 1 root root 28M Dec 20 18:38 GeoIPCity.dat
28M -rw-r--r-- 1 root root 28M Dec 3 19:41 GeoLiteCity.dat

[digitalpoint]

The error shows it's looking in a different path for the database.

[Mattske]

Sorry, I am rather new at this, should I change .....

( /usr/local/share/GeoIP/ ) to match what it is looking for ( /opt/geoip/share/GeoIP/ ) ??

Would that solve my issues?

[Boofo]

Just upload the GeoIP files to the directory it shows in the error.

[Mattske]

Thanks, got it working.

[Boofo]

Glad you got it going. ;)

[marcopolo]

Ok, I've installed as part of my hosting service (from what I can see) and get this

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

I've checked my php folder here /php/Net/GeoIP and see these files location.php and DMA.php

Any ideas?

Bit more info after speaking to my hosting company is that they use PEAR packages and have confirmed I have install what I need to use GeoIP, these being Console_Getopt 1.3.0 and Net_Geo 1.0.5

[digitalpoint]

You would still need to install the geoip module for PHP.

[marcopolo]

This one?

http://pear.php.net/package/Net_GeoIP/download

[Mattske]

How do I get mine to display correctly by usergroup/status.

http://img27.imageshack.us/img27/1153/screenshot20101229at123.png

Guests don't seem to show up at all, and users outside of the 5,6,7 usergroups are showing as admins/moderators despite the option being set to 5,6,7 only....

[sadaar]

I still can't even get the map....

[opaa]

Great MOD ! I install GEOIP by CPanel (centos) and use this (https://vborg.vbsupport.ru/showpost.php?p=2052581&postcount=49) datafiles . It works now !!

[marcopolo]

Ok, I've been told this by my hosting service

I have raised this with our NOC team they have checked and it turns the module is trying to use mod_perl which is disabled on our servers because of the security risk it poses. That is why it was failing all along. Im afraid this will mean that it won't be possible to use this module on the cpanel, its rare that this happens but sadly the requirements can not be met to install this.

Looking around the best way to get around this would be to manually download the geoip.dat database (its in csv format) and then have your website manually look up to that (http://www.builderau.com.au/program/php/soa/Mapping-visitors-IP-addresses/0,339028448,339129583,00.htm). Basically it would consist of that database file and geoip.inc file that would need to be included in your php code, this then would allow you to do geoIP lookups. It can be obtained here http://www.maxmind.com/app/geolitecountry.

Is this possible?

[volarium]

My host uses the PEAR Net/GeoIP module, `require('Net/GeoIP.php');`.

Can you please advise if this will work with Digital Point or not?

[jay5r]

Like Boofo (https://vborg.vbsupport.ru/showpost.php?p=2128306&postcount=105) I'm getting the following error...

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 128
Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 133
Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 152

Figured it out. Apparently, I was not logged in when the errors were shown. Do I need to turn it off for guests then? Apparently, if there are no users and only guests on the site, is when the error occurs.

But unlike Boofo, I'm logged in and there are users on the site (73 members, 410 guests)...

Any idea what the problem is?

[digitalpoint]

What's the URL you have it installed at?

[junaid]

work fine me php 5.2.14 after upgrade php5.3.4
not work

[Boofo]

work fine me php 5.2.14 after upgrade php5.3.4
not work

It works fine for me on 5.3.4. No change after the PHP upgrade. Did you remember to re-add geoip on the upgrade?

[jay5r]

Just wanted to say thanks to Shawn. We PM'd and he suggested I didn't have the database installed correctly. I deleted the files, reinstalled and it works great now.

What's the URL you have it installed at?

Like Boofo (https://vborg.vbsupport.ru/showpost.php?p=2128306&postcount=105) I'm getting the following error...

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 128
Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 133
Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 152

But unlike Boofo, I'm logged in and there are users on the site (73 members, 410 guests)...

Any idea what the problem is?

[jay5r]

I installed it and users seem to like it. How hard would it be to modify? About 70% of my users want their screen names to show when you scroll over or click on their pin. Another 13% want to be able to opt out. Ideally I'd like screen names to show by default (being able to click to their member page would be incredible) and there be the option to set a persistent cookie that could either hide the screen name or completely opt-out.

[digitalpoint]

You couldn't do the opt-out with a cookie, would need to be something stored in the database since user A viewing it would need to know the opt-out setting for user B. It wouldn't be *terribly* hard for a programmer to do for you.

[RustedBucket]

Hey Shawn, any chance of making this work using membergroups?

[digitalpoint]

what do you mean exactly?

[Valerio]

Hello
I ask to my host to install the module and it did straight away, so i proceed with the installation and the result was:

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 128

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 133

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 152

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 158

I ask to my host and he reply:

hello,

Unfortunately the database it is requesting is not free: http://www.maxmind.com/app/products it is $370/site license.

The other issue is if you cannot specify where the database is located from within the script to reference a file from within your account files and directories rather than the backend server files and directories you will need to upgrade to a VPS or dedicated server.

Please let us know if there is anything else we can assist you with.

so?

[TeknoSounds]

Ask them to use/install the LITE version:

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

[Valerio]

Fantastic, it work, Thank you digital point :up:

I open a ticket, and my host download the database in a folder into the root and change the path of php.

I'm very happy about that host.

The map visualize only the realtime users connected right?

Do you think it will be possible to add the nickname of the registered users to the map so when i click on a pin it appear the username of the registered user?

[digitalpoint]

No sorry... Too many privacy issues.

[Boofo]

Shaun, is there a way to suppress the foreach errors that show up if a guest clicks the link and no users are logged in?

[Boofo]

I take it by your silence either that is a "no" or not worth your time fixing?

[traen]

Can you disable it for certain usergroups or is it a all or nothing ordeal?

[Boofo]

Can you disable it for certain usergroups or is it a all or nothing ordeal?

There is no settings for that. It only works if there are logged in users. But I have a user logged in the other day and she got the errors and an empty map. She logged on later and it was fine.

[digitalpoint]

Shaun, is there a way to suppress the foreach errors that show up if a guest clicks the link and no users are logged in?Yeah, would be simple enough to wrap it in some logic to prevent it from foreaching if there are none to foreach.

Not a *huge* priority though to be honest. The percentage of forums that have no users on (guests, registered or spiders) I would guess might be like 1 in 1,000 (MAYBE). Then on top of it, the first page that a user starts their session at is the user map page... probably another 1 in 1,000 chance. So yeah... it obviously could happen, but the chances of everything (no users, spiders, etc.), then the first user hitting the user map page as their first page seems rather low.

I'll do it in the next version, but not going to bother with a version just for that.

[Boofo]

Any idea when the next version might be coming then?

Also, The errors showed up for a user that was logged in using Safari. When she logged out and back in later, she didn't get the errors. So it also seems to happen sporadically under certain conditions.

[digitalpoint]

Well the only time it should happen is if no one has been on the forum (logged in, spiders or guests) in whatever time the session window is set to. And even then it probably is only going to happen if the first page view of the user is on the user map page (basically the request that creates the session).

[Boofo]

My point was that is does happen, though.

[OldSchoolDSL]

Warning: Invalid argument supplied for foreach() in+[path]/usermap.php+on line+128
Warning: Invalid argument supplied for foreach() in+[path]/usermap.php+on line 133
Warning: Invalid argument supplied for foreach() in+[path]/usermap.php+on line 152

Had this error show up on another community. Only had 2 members online.

It could be the caching causing it when it renews the cache.

[x YNWA x]

Does anyone have a step by step guide on how I install this GeoIP PHP extension please? http://www.maxmind.com/app/php Just gives a download link but no instructions... Thanks

[OldSchoolDSL]

Does anyone have a step by step guide on how I install this GeoIP PHP extension please? http://www.maxmind.com/app/php Just gives a download link but no instructions... Thanks


As root:

Debian / Ubuntu

aptitude install php5-geoip

Red Hat / Cent OS / Fendora

yum install php5-geoip

Restart Apached or Lightpd or Nginx (which ever you are using)

Done

[x YNWA x]

Ok So I got the host to install this extension, the map thing appears now but it is a big white box and these errors are above it:

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [path]/global.php(29) : eval()'d code on line 60

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 128

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 133

Warning: Invalid argument supplied for foreach() in [path]/usermap.php on line 152

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line

Any ideas?

[digitalpoint]

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Any ideas?Did you by chance read the error message you posted? :)

[x YNWA x]

Did you by chance read the error message you posted? :)

The hosting company said they had installed the database too, I even uploaded the database myself for them to move into the correct file. A day later they email me saying they put the DB in the wrong folder and it was working! So working fine now, I have two versions, One for when users registered and one which shows current online users.

[Boofo]

Excellent update, Shawn. No more errors. Thanks for the fix, sir. ;)

[hassshasss]

Hi,
I did install the GeoIP extension is said to have installed in the VPS, but the map does not beep.
I wonder what could be the problem?
Link : http://www.turkiyemotosiklet.org/usermap.php

[Boofo]

Did you upload the files GeoIP dat files?

[hassshasss]

Did you upload the files GeoIP dat files?

yes I've installed the server.
Before you install the downloaded after giving an error that the error has been lost.

[digitalpoint]

Not sure to be honest... you have so many JavaScript errors on that page (unrelated to the map) that the browser probably just stops executing all JS (which is what the map uses to run). The good news, is it looks like the GeoIP extension is installed properly because if you look at the source of the page, it has the long/lat that it *wants* to plot.

[hassshasss]

Not sure to be honest... you have so many JavaScript errors on that page (unrelated to the map) that the browser probably just stops executing all JS (which is what the map uses to run). The good news, is it looks like the GeoIP extension is installed properly because if you look at the source of the page, it has the long/lat that it *wants* to plot.

I did not see this error page, javascript http://www.turkiyemotosiklet.org/usermap.php page.
Can not you tell me wonder if the existing errors? :confused:

[sadaar]

I have come a long way in my education and have revisited this mod. I was able to get it working by adding geoip.custom_directory = /var/lib/GeoIP/ to my php.ini.

One question if I may.. I would like this turned off for certain usergroups. It doesn't need to be an option for them, I would just need to know what code to add to stop the display of certain usergroups. Is that a possibility?

Thanks for the GREAT mod :)

[digitalpoint]

You want to have them not show on the map, or not see the map?

[sadaar]

Not show up on the map at all. Like, top level admins not show up on the map.

[reddyink]

Installed on the server. Template shows up but not the actual MAP.

install.php shows
Geoip

geoip support enabled
geoip extension version 1.0.7
geoip library version 1004005

Directive Local Value Master Value
geoip.custom_directory no value no value

Changed to see if it works.

$user_location = geoip_record_by_name($_SERVER['REMOTE_ADDR']);

Thanks for the help!

[digitalpoint]

What's the URL where you have it running?

[reddyink]

What's the URL where you have it running?

Intranet (localhost)

[lapiervb]

I love this mod I have just never been able to get it to work. Who can I pay to set this up for me?

[Kraxell]

Hello,

is it possible to show, which user come from which country/town?

[digitalpoint]

Hello,

is it possible to show, which user come from which country/town?No sorry... too many privacy issues.

[Kraxell]

yes but for a guild is that perfect :)

But thanks alot.

[danswano]

Thanks.

[mcyates]

Just got my host (Site5) to enable the GeoIP PHP extension but i'm stuck with these errors and no map!!

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/local/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 166

[digitalpoint]

Did you check the obvious?

(that the file /usr/local/share/GeoIP/GeoIPCity.dat exists)

[bpi007]

Hello,

I'm looking for a version of this mod without geoip and user's point manually where they live.

(geoip not installed on my server)

Thanks

[10 Gauge]

I'm having a similar error as above....

Warning: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /var/lib/GeoIP/GeoIPCity.dat. in [path]/usermap.php on line 100

/var/lib directory only contains GeoIP.dat where do I acquire GeoIPCity.dat?

Edit: Figured it out. I copied GeoLiteCity.dat to /var/lib/GeoIP directory and renamed it to GeoIPCity.dat and it did the trick.

Great mod, thank you!

[reddyink]

SOLVED
It shows the map but doesn't show users on it for some reason. Who's online list for forum (near footer) shows users but doesn't display on this map.

IP address also shows on forum so I tried changing to
$user_location = geoip_record_by_name(IPADDRESS);
Appreciate help.

EDIT: I had to set up which usergroups showup on the map.

[PBRiot]

Ok, so my server is a shared server, and they will not install GeoIP.

Here's the conversation thread:
I'm attemping to install a mod to my vBulletin 4 forum - www.pbriot.com.

The mod is:
https://vborg.vbsupport.ru/showthread.php?t=244236&highlight=digital+point

You can see an example of what the mod does here: http://forums.digitalpoint.com/usermap.php

The instructions for the mod indicate that I must have GeoIP (a free PHP script) installed on my server. I'm not sure if this is something I can do myself, or not, but simply uploading the files via FTP for GeoIP didn't do the trick (surprise, surprise ).

The error I am getting is this:
http://pbriot.com/usermap.php

Please let me know what I can do to get this up and running, thank you for your help!

They respond:
I'm sorry, but our servers don't meet the pre-requisite software requirements needed in order to run geoip. You're free to experiment with compiling/installing these requirements in your own account, however that is not something that we will be able to assist with.

Let us know if we can help with anything else, or if you have any additional questions.



When I asked further, it was basically "we need to maintain the same environment on all 2500+ servers, and we can't implement a massive thing like that for your request"

At any rate - he suggested that I could try installing myself... I just have no clue how to do that - any ideas - can you point me in the right direction, anyone? Thanks!

[GhoHan]

I'm installed today very nice mod working perfect..
http://i-comers.com/usermap.php

Installed & Tagged also MOTM
i hope next feature can display avatar and username also postcount in map when click the balloon/pin google map :D

Thanks :)

[Lester Wilson]

Hi, I run three vb4 forums

I've installed Digital Point User Map on all three, the users like it !

I have one issue, on two forums the map shows guests as spiders, i cannot see why

the setup is the same for all three systems ( on the same server) they are simply vhosted sites on one server.


http://www.myamicus.co.uk/usermap.php - guests seem to show as spiders

http://www.protonbasic.co.uk/usermap.php - i'm sure guests are showing as spiders AND i have a few users with user id 16, i dont think they show at all

http://www.picbasic.co.uk/forum/usermap.php - seems to show users as i'd expect.


any help would be appreciated.

[digitalpoint]

Do you have different usergroups possibly for the two forums?

[Lester Wilson]

Hello, yes there are differenet user groups on the forum protonbasic.co.uk

on that forum many users are in a group with id 16 and a few in groups with other ids. I've entered the admin and mods with id' of 95 96 97 etc they seem to show up on the map

looking atnthe xml file it should cater for anything greater than 3, but it does not seem to do so..

how do i add specifc id's fro registered users as you have actered for with the mods and admins.

[Lester Wilson]

From what i can deduce, custom user groups show as spiders on the user map. Is that the correct operation?

[digitalpoint]

No... it gets the user agents for what it considers spiders from here: includes/xml/spiders_vbulletin.xml (well really the datastore that stores that file, but that's the source of the datastore).

[Lester Wilson]

OK, thanks.

that's helped, i have it working now.

[PBRiot]

At any rate - he suggested that I could try installing myself... I just have no clue how to do that - any ideas - can you point me in the right direction, anyone? Thanks!


Any ideas from someone?

[JasonP38]

I'm running my site on 4.0.7 and when I installed this mod I got this.

Fatal error: Call to undefined function geoip_record_by_name() in /home/content/26/6775626/html/forums/usermap.php on line 100

[Janmaat]

I've asked my hoster to install the module geoip, so he did.

After installing this addon, I'm receiving the following error message:

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

Warnung: geoip_record_by_name() [function.geoip-record-by-name]: Required database not available at /usr/share/GeoIP/GeoIPCity.dat. in [path]/usermap.php (Zeile 166)

Does anyone have an idea how I can fix this? :confused:

[digitalpoint]

I've asked my hoster to install the module geoip, so he did.

After installing this addon, I'm receiving the following error message:



Does anyone have an idea how I can fix this? :confused:Did you check the obvious? (that /usr/share/GeoIP/GeoIPCity.dat exists)

[Janmaat]

Ahm, nope :erm:

I've asked my hoster to check it. Hopefully it will work soon.
Keeping you posted.

I'm really looking forward to running this great addon :)

[Janmaat]

Now it works perfectly :)

[Janmaat]

Some users respond that they can see only guests but no registered users, some also cannot see their own location. I as admin can see everything.

Is this a known issue?

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

https://vborg.vbsupport.ru/external/2011/10/43.png

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

Are you sure? This is what I see at the URL...
* grey_goose scratches head and goes to ponder what foul trickery is at play

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?

[digitalpoint]

No sorry, privacy issues and all that...

[Dave Hybrid]

No worries.

I installed, first a got a complete blank page, i installed the php add-on and now the page loads and in see the icon key but no map.

http://www.travel-fans.com/usermap.php

Any guidance appreciated.

[digitalpoint]

You sure you have the geoip extension installed on your server?

[Dave Hybrid]

Liquidweb are doing it, nothing loaded at all before so i asume its installed now... dunno.

[digitalpoint]

If you go to your AdminCP -> Maintenance -> View PHP Info, you should see something along the lines of this if it's installed:

https://vborg.vbsupport.ru/external/2011/10/23.png

[Dave Hybrid]

Hi, thanks for helping,

Yes, its installed.

http://www.travel-fans.com/usermap.php

Still not getting the map however

[digitalpoint]

It looks like it works when I look on your site...

https://vborg.vbsupport.ru/external/2011/10/21.png

[Dave Hybrid]

Yeah, had to rename the geolitecity file as per another post here.

Might wanna put that in the install instructions, seems pretty common.

Thanks tho shawn, awsome mod.

[mmoore5553]

curious if there is a way to just have this put users on that have an option in profile to display on users map yes or no. I do not want all the users just some that say yes they do want it displayed. Let me know if this is something that needs payment then i am gladly willing to donate.

[SEW810]

Tagged. I'll try it soon.

[strudinox]

Thank you! Installed and working perfect.

[tpearl5]

FYI: Google Maps to charge for usage (http://www.bbc.co.uk/news/business-15523050)

I don't think many of you are hitting the 25k mark a day though.

[Nelson58]

No map just white.

geoip


geoip support

enabled



geoip extension version

1.0.8

geoip library version

1004008

Directive

Local Value

Master Value



geoip.custom_directory

no value

no value


They installed it on the server for me.
What did I do wrong?

[digitalpoint]

What's the URL?

[Nelson58]

<a href="http://www.hobby-machinist.com/usermap.php" target="_blank">http://www.hobby-machinist.com/usermap.php</a>

[Nelson58]

http://www.hobby-machinist.com/usermap.php

Web host says he installed the dats files and it still doesn't work.

[root /usr/local/share/GeoIP]# ls
GeoIP.dat
GeoIPCity.dat

Get this error now: Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@hobby-machinist.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


Have installed 3 mods for VBulletin 4.17, and this was the only one that didn't work.
Either more detailed instructions are needed for hassle-free installation, more debugging to foster ease of deployment, or this should be withdrawn IMHO. I plan to remove it.

Also, the inability to identify the users due to privacy, etc is a hassle. SMF has a mod for it that does just this, and when I installed it on SMF it worked right away without any problems, and showed the members and where they lived.


I would STILL like to know why this didn't work.

[digitalpoint]

Not sure why it would give an internal server error unless there was maybe something with the geo extension installed wrong on the server. Can you access the Apache log to see *why* it has an internal server error?

[Nelson58]

I don't have access to that- my webhosting company does. You cab speak to Frank Doud at GC Solutions, G.C. Solutions General Support <support@securegcwebhosting.com>, his web site is http://gcwebhosting.com/index.php.

He assured me it was installed correctly, including the data files. But I get that error. I don't know anything about installing this stuff on the server- I rely on Frank.

Thanks,


Nelson

[Dave Hybrid]

Did google change something today?

The key pins seem to be 404 on Googles server, so i edited the template to serve them locally but only I show on the map, just the 1 user.

I used to have a lot of pins at any given time.

[Dave Hybrid]

Also, when i zoom on the map, i get 2 to 3 goes and then the map hangs/freezes.

Any idea what is going on, it was fine a few days back.

Could something have happened with geoip on my server or is the Googles end.

Thanks.

[strudinox]

Same issue here. Google must have updated their code. 404 on all the buttons and the map no longer shows user locations.

[Amadeusmq]

Ok, can anyone tell me why the 'pin' graphic URLs are wrong in my installation of this? http://www.isxgames.com/forums/usermap.php

On the demo site, the image location is http://i.dpstatic.com/pins/mm_20_red.png ..however, on my site it is http://labs.google.com/ridefinder/images/mm_20_red.png

I can't see anything in the xml file or the php file (included with this addon) that helps me figure out how to fix this particular problem.


----
In more exciting news, once I get this problem solved I will be able to send a version to digitalpoint that doesn't require you to have the GeoIP php extension installed :)



EDIT: Ooops, I just noticed that some others have reported this same problem. Looks like he fixed the demo site though.

[digitalpoint]

It's been updated do the pin images are pulled locally from your server.

[Dave Hybrid]

I believe there is another issue, the map zoom freezes on mine and only 1 pin shows even when calling the pins from local server.

[digitalpoint]

What's the URL?

[Dave Hybrid]

Looks like that issue is fixed, no worries.

Just now it seems everyone is a admin ?

http://www.travel-fans.com/usermap.php

[Boofo]

You also need to put the copyright link back for the mod.

[digitalpoint]

Double check the "Admin/Moderator Usergroups" as set under AdminCP -> Settings -> Digital Point User Map?

[Dave Hybrid]

You also need to put the copyright link back for the mod.

Ive not removed anything... i run a custom footer, so maybe it's that.

[Dave Hybrid]

Double check the "Admin/Moderator Usergroups" as set under AdminCP -> Settings -> Digital Point User Map?

5,6,7

Im the only admin,mod,supermod, so 1 pin should show and only one.

Thanks.