Major Additions - VBGooglemap Member Edition

Version 3.0.1 is currently available

This is the tested port of my 3.5.x version h(https://vborg.vbsupport.ru/showthread.php?t=99920)

You can now nominate hacks yourself for hacks of the month. There is a link on the right of hacks on top of the files.

Function
This will display the members of the Bulletin Board based on their lattitude and longitude coordinates on a googlemap.

Don't forget to hit install !!!!!!!
Please read the guide before asking for support !!!!!!!

Feel free to support this mod and make a paypal donation to admin@stonyarc.com

INSTALL

Detailed installation instructions and screenshots in the included pdf file.

Current Features



NOTE:
VBGooglemap 3.0.0 contains the vulnerability fix. Please upgrade immediately. Version 3.0.0. also contains all features from 2.5.X

As always you use modifications at your own risk.

VBGooglemap Member Edition 2.5.x brings you a lot of new features. It?s vital that you uninstall any previous version before upgrading/installing version 2.5.x.

Upgrading from version 2.5.0 is easier. Instruction are available in the guide.

As the uninstall function will not remove your googlemap data in the database but only the templates and files you can safely remove an older version. As a precaution you should always take a backup. This should be done on each major change you make to your bulletin board.

IF YOU ARE RUNNING VERSION 1.0.3, 2.0.X AND YOU CHANGED TEXT DIRECTLY IN THE TEMPLATES YOU NEED TO SAVE YOUR CHANGES AS VERSION 3.0.0. REQUIRES YOU TO UINSTALL PREVIOUS VERSIONS.

This has taken quite some work and still will take a lot more. Please give credit where credit is due. You cannot remove any notice without prior written permission.

Changes in this version

SEE FIRST POST FOR FULL ROADMAP AND HISTORY

Planned Features
- TBD

Volume warning

high volume of users may slow down the load. Currently a load counter is included.

Languages

Thanks to Wachtmeister there is a German translation available to you all. Feel free to use it.

The translation will be updated on each new version.

Special

- Read the attached PDF for more information. The pdf is also included in the zip file.
- You'll need a googlemap key for your domain. Get your own key for your domain view http://www.google.com/apis/maps/signup.html for more information.
A googlemap key is only valid for a specific domain. You'll need a specific google account to create one.
All is explained on the googlemap link indicated above.
- Set the file permissions on the marker.xml file to 777
- The googlemap script can handle non-registered users. They will only see the main map and won't be able to enter information. This is reserved for logged in users (detected automatically)
- usergroup permissions are available in the backend
- To change location just drag the map while holding the left mouse key or by using the zoom and key functions on the left
- First time loading of the map may take a few seconds longer because of Google API hosting



Special Xbox Live version
http://www.xboxlivenation.com/community/gamermap.php

Credits

This has taken quite some work and still will take a lot more. Please give credit where credit is due. You cannot remove any notice without prior written permission. Instructions are included in the pdf file.
Special credits to Google, Pyg for the javascript tips.


FAQ

The FAQ is included in the pdf file.

INSTALL



Feel free to support this mod and make a paypal donation to admin@stonyarc.com



(c) 2007 Stonyarc

[anonscape]

This is an elementary question but I still haven't understood how this mod works yet.
Does a visitor/member of my forums have to signup/join/enter his/her location to then have the marker auto or manually approved before a pin/marker will show up on the map? If no one signed up with their info would the map be blank?

TIA

[ethank]

I installed this on 3.6.4, but not markers show. The XML file is updated, but the "loading" AJAX thing never indicates loading. When I go to edit my location, the pin shows.

http://www.murmurs.com/forum/vbgooglemapme.php

Any ideas?

[photofreeway]

This is all I get...
http://www.photofreeway.com/board/vbgooglemapme.php

Can I get some help as to why the map does not show? There is an error on tha page also.

made it readable for everyone ....
Thanks

[photofreeway]

Ok I marked as installed. Any support here at all?

[Shazz]

Originally Posted by photofreeway

Ok I marked as installed. Any support here at all?

Well stonyarc hasen't been around for a while, Im sure when he does get back he will

[akulion]

Installed and worked like a charm even for a complete newbie like me!
Thank you so much for taking the time to produce such a quality and well explained product
aku

[TheFrienzNet]

Thanks, this modification looks great.

[bulbasnore]

OK, this is working pretty well in test for us on vB 3.6.4 (Apache2/PHP5/MySQL5/Linux). We have these exceptions:
- Picture display comes and goes. Sometimes scrolling the map helps?
- Some members don't see the pins or links above the on map certain computers.

My advice to those having complete problems (no display) is: recapitulate the install and make sure the cron task is working. That advice may be worth nothing. I can't support the add-on for you any further. As always, the more details you post, the more likely you are to get help. If it was me, I'd post: O/S, vB & add-on versions plus file locations uploaded, plus cron task log.

UM, anyway...

I was sorry to see Stonyarc gave up the avatar load for the pictures, though I could guess why. We have a PG-rated board and like to keep some control on the picture displays. Consequently, I hacked together the script below to ensure that the avatar pic is what is displayed for the vbgooglemapme pin image.

This might only work if you have set your avatars to be stored in your database as opposed to your filesystem. If you don't understand what that is, or the issues surrounding that choice, go to the vBulletin documentation and look it up before you go on.

OTOH, if someone can tell me I'm wrong about that, then, please hip me to the Truth!

Here's the script - you could destroy your database, so don't use it or my instructions unless you know what is happening in the code and take full responsibility for the consequences yourself!!!

Name it something like vbgooglemapme_avatars.php
Upload it to <your forum directory>/includes/cron

PHP Code:

/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyright ?2007 Kim Cary                                         # ||
|| # This file may be redistributed in whole or significant part.     # ||
|| # You could signficantly damage or destroy your board or computer  # ||
|| # with this file. Author will not be liable for any damages.       # ||
|| #################################################################### ||
\*======================================================================*/

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
        exit;
}
// ######################## END PHP ENVIRONMENT ###########################

        $vbulletin->db->query_write("
                UPDATE " . TABLE_PREFIX . "googlemapme
                SET  `pimage` = concat(  'http://pokegym.net/forums/image.php?u=',  `userid` )
        ");
        log_cron_action('Add Avatars to vbgooglemapme picture field', $nextitem);

/*======================================================================*\
|| ####################################################################
|| # Version: 10:12, Sat Jan 27th 2007
|| ####################################################################
\*======================================================================*/ 


Once you've done that, you can set it up to test via a scheduled task, like the thumbnail below. If you set it up this way it will be disabled for schedules, but you can run it on demand for a test.

Now use the Scheduled Task Manager [Run Now] function in your admincp to run this task (because you assumed responsibilty, remember!!!). If you want to see whether it worked, run a sql query like this in your admincp sql query tool:

SELECT userid,pimage FROM googlemapme ORDER BY userid asc

You should see a list of userids and standard avatar URLs in the result. Of course, if you screw up the query you might have no database left.

If you like what you see, go back to the task in the scheduled task manager and enable it, but change the time you run it to the minute or more before you run Stonyarc's scheduled task.

To be clear again: You can wreck things playing around at this level. If you do, its YOUR fault. My code is NOT authorized by Stonyarc and frankly, I expect him to delete this post when he/she returns. For those who have the skills to deal with this, I hope this helps you. I've been helped so much be vb.org over the years.

[MrD]

Hi,
after Usergroupchange the Marker will not updated.
The rights in ACP are ok, but no Reacction.

[photofreeway]

hello and thanks for the support on this. Question: When you say "recapitulate the install" can you define what this means. sorry still kinda new with VB....

This is the error I get at the bottom of IE.
Line: 1071
Char: 35
error: Expected';'
Code: 0
URL: http://www.photofreeway.com/board/vbgooglemapme.php


Thanks Again

Originally Posted by bulbasnore

OK, this is working pretty well in test for us on vB 3.6.4 (Apache2/PHP5/MySQL5/Linux). We have these exceptions:
- Picture display comes and goes. Sometimes scrolling the map helps?
- Some members don't see the pins or links above the on map certain computers.

My advice to those having complete problems (no display) is: recapitulate the install and make sure the cron task is working. That advice may be worth nothing. I can't support the add-on for you any further. As always, the more details you post, the more likely you are to get help. If it was me, I'd post: O/S, vB & add-on versions plus file locations uploaded, plus cron task log.

UM, anyway...

I was sorry to see Stonyarc gave up the avatar load for the pictures, though I could guess why. We have a PG-rated board and like to keep some control on the picture displays. Consequently, I hacked together the script below to ensure that the avatar pic is what is displayed for the vbgooglemapme pin image.

This might only work if you have set your avatars to be stored in your database as opposed to your filesystem. If you don't understand what that is, or the issues surrounding that choice, go to the vBulletin documentation and look it up before you go on.

OTOH, if someone can tell me I'm wrong about that, then, please hip me to the Truth!

Here's the script - you could destroy your database, so don't use it or my instructions unless you know what is happening in the code and take full responsibility for the consequences yourself!!!

Name it something like vbgooglemapme_avatars.php
Upload it to <your forum directory>/includes/cron

PHP Code:

/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyright ?2007 Kim Cary                                         # ||
|| # This file may be redistributed in whole or significant part.     # ||
|| # You could signficantly damage or destroy your board or computer  # ||
|| # with this file. Author will not be liable for any damages.       # ||
|| #################################################################### ||
\*======================================================================*/

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
        exit;
}
// ######################## END PHP ENVIRONMENT ###########################

        $vbulletin->db->query_write("
                UPDATE " . TABLE_PREFIX . "googlemapme
                SET  `pimage` = concat(  'http://pokegym.net/forums/image.php?u=',  `userid` )
        ");
        log_cron_action('Add Avatars to vbgooglemapme picture field', $nextitem);

/*======================================================================*\
|| ####################################################################
|| # Version: 10:12, Sat Jan 27th 2007
|| ####################################################################
\*======================================================================*/ 


Once you've done that, you can set it up to test via a scheduled task, like the thumbnail below. If you set it up this way it will be disabled for schedules, but you can run it on demand for a test.

Now use the Scheduled Task Manager [Run Now] function in your admincp to run this task (because you assumed responsibilty, remember!!!). If you want to see whether it worked, run a sql query like this in your admincp sql query tool:

SELECT userid,pimage FROM googlemapme ORDER BY userid asc

You should see a list of userids and standard avatar URLs in the result. Of course, if you screw up the query you might have no database left.

If you like what you see, go back to the task in the scheduled task manager and enable it, but change the time you run it to the minute or more before you run Stonyarc's scheduled task.

To be clear again: You can wreck things playing around at this level. If you do, its YOUR fault. My code is NOT authorized by Stonyarc and frankly, I expect him to delete this post when he/she returns. For those who have the skills to deal with this, I hope this helps you. I've been helped so much be vb.org over the years.