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

[effeff70]

@Ipetrich

No i didn´t , but i will...THX for answere...

[Falcon Capt]

Originally Posted by MediaHound

No, thats not my problem, read the post again please. The problem I speak of involves the old version that allowed one to link to specific members on the map. I run in the postbit a link for each member that filled the map a link to his pin on the map. The earlier version of this mod that I was running allowed those links to work. The update I did no longer lets those links work. Example of a link:
http://www.forums.com/vbgooglemapme....865128&zoom=10
That type of link would zoom in to said location. Now its just as if I were to pull up vbgooglemapme.php without passing the variables. The variables in the URL don't have any effect anymore. I wish they would. Have you got an idea to fix this please? Thanks in advance!

After a recent server move I am having the exact same issue. Anyone have any insight?

[Falcon Capt]

Originally Posted by MediaHound

No, thats not my problem, read the post again please. The problem I speak of involves the old version that allowed one to link to specific members on the map. I run in the postbit a link for each member that filled the map a link to his pin on the map. The earlier version of this mod that I was running allowed those links to work. The update I did no longer lets those links work. Example of a link:
http://www.forums.com/vbgooglemapme....865128&zoom=10
That type of link would zoom in to said location. Now its just as if I were to pull up vbgooglemapme.php without passing the variables. The variables in the URL don't have any effect anymore. I wish they would. Have you got an idea to fix this please? Thanks in advance!

Originally Posted by Falcon Capt

After a recent server move I am having the exact same issue. Anyone have any insight?

Bump.

Anyone have any insight on this issue?

[Falcon Capt]

Originally Posted by MediaHound

No, thats not my problem, read the post again please. The problem I speak of involves the old version that allowed one to link to specific members on the map. I run in the postbit a link for each member that filled the map a link to his pin on the map. The earlier version of this mod that I was running allowed those links to work. The update I did no longer lets those links work. Example of a link:
http://www.forums.com/vbgooglemapme....865128&zoom=10
That type of link would zoom in to said location. Now its just as if I were to pull up vbgooglemapme.php without passing the variables. The variables in the URL don't have any effect anymore. I wish they would. Have you got an idea to fix this please? Thanks in advance!

Ok, got it fixed!

in vbgooglemapme.php find:

if ( isset($HTTP_GET_VARS["lng"]) && !empty($HTTP_GET_VARS["lng"]) && isset($HTTP_GET_VARS["lat"]) && !empty($HTTP_GET_VARS["lat"]) )
{
	$dlng = $HTTP_GET_VARS["lng"];
	$dlat = $HTTP_GET_VARS["lat"];
}
if (isset($HTTP_GET_VARS["zoom"]) && !empty($HTTP_GET_VARS["zoom"])) {
$zoomlevel = $HTTP_GET_VARS["zoom"];
}

and change it to:

if ( isset($_GET["lng"]) && !empty($_GET["lng"]) && isset($_GET["lat"]) && !empty($_GET["lat"]) )
{
	$dlng = $_GET["lng"];
	$dlat = $_GET["lat"];
}
if (isset($_GET["zoom"]) && !empty($_GET["zoom"])) {
$zoomlevel = $_GET["zoom"];
}

Hope this helps!

[lpetrich]

Falcon Capt, thanx for that patch. But the original code works fine in my installation. However, I haven't had such trouble with my site's installation of vbGoogleMap -- the location syntax works fine with it:

<forum root>/vbgooglemapme.php?lat=<latitude>&lng=<longitude>&z oom=<zoom value>

Try composing a URL with some latitude, longitude, and zoom values and see what happens.


In reference to crkgb's troubles, I added some Cyrillic text to the description text by copying and pasting some Cyrillic text from a text field elsewhere (Dashboard auto-translator widget). I used this Russian phrase:

Где я? (Gde ya? -- Where am I?)

It showed up without any trouble -- I tested it on the most recent OSX Firefox, Opera, and Safari, and also the most recent Windows Internet Explorer. It may be that crkgb's installation of vBulletin had been set to use a different character encoding; mine (talkrational.org) uses vBulletin's default, as far as I can tell.


It's possible to HTMLize the text that one inputs in the editor page; that involves changing this code in in vbgooglemap.php:

$title_map = $db->escape_string(trim($vbulletin->GPC['title_map']));
$text_map = $db->escape_string(trim($vbulletin->GPC['text_map']));

to:

$title_map = $db->escape_string(htmlspecialchars(trim($vbulletin->GPC['title_map']),ENT_QUOTES));
$text_map = $db->escape_string(htmlspecialchars(trim($vbulletin->GPC['text_map']),ENT_QUOTES));

I tried that, and it turns the Cyrillic characters into HTML-entity text, which is displayed in that fashion:
#1043;#1076;#1077; #1103;?
(initial &'s removed)

So using this fix would require reverting ZeroHour's fixes back to the original, and then editing all the users' map info -- one can do that if one had set one's privileges appropriately in the usergroups editor. ZeroHour's fixes are for composing markers.xml from the database info; users' web browsers then read markers.xml to find out which markers to display. I found htmlspecialchars in this PHP string-function reference, along with other PHP text-conversion functions.

[Falcon Capt]

Originally Posted by lpetrich

Falcon Capt, thanx for that patch. But the original code works fine in my installation. However, I haven't had such trouble with my site's installation of vbGoogleMap -- the location syntax works fine with it:

<forum root>/vbgooglemapme.php?lat=<latitude>&lng=<longitude>&z oom=<zoom value>

Try composing a URL with some latitude, longitude, and zoom values and see what happens.

I did and had the same problem, the map would just open to the default settings. This problem occured after changing servers. The new server is running slightly different versions of Apache, PHP and MySQL. The fix I posted above took care of the issue and it is once again working fine.

[MediaHound]

Originally Posted by Falcon Capt

Ok, got it fixed!

in vbgooglemapme.php find:

if ( isset($HTTP_GET_VARS["lng"]) && !empty($HTTP_GET_VARS["lng"]) && isset($HTTP_GET_VARS["lat"]) && !empty($HTTP_GET_VARS["lat"]) )
{
	$dlng = $HTTP_GET_VARS["lng"];
	$dlat = $HTTP_GET_VARS["lat"];
}
if (isset($HTTP_GET_VARS["zoom"]) && !empty($HTTP_GET_VARS["zoom"])) {
$zoomlevel = $HTTP_GET_VARS["zoom"];
}

and change it to:

if ( isset($_GET["lng"]) && !empty($_GET["lng"]) && isset($_GET["lat"]) && !empty($_GET["lat"]) )
{
	$dlng = $_GET["lng"];
	$dlat = $_GET["lat"];
}
if (isset($_GET["zoom"]) && !empty($_GET["zoom"])) {
$zoomlevel = $_GET["zoom"];
}

Hope this helps!

I am ever so grateful for this patch, good work. I would like to add to the record that in addition to the version upgrade of this mod, I did also do a server switch recently as well. As you experienced as well, I guess it may have been my server switch that caused this to stop working, not necessarily the version upgrade as I initially thought.

Good work once again Falcon Capt, bravo!

[MediaHound]

Originally Posted by wrang

What do i do wrong when i get this error??

+1
I have the same issue on another board I just did a version upgrade.
I upgraded the version from 2.5.x to the latest version and went to run the scheduled task when it choked on this error:

Database error in vBulletin 3.6.8:

Invalid SQL:
SET NAMES 'utf8';

MySQL Error  : Unknown system variable 'NAMES'
Error Number : 1193

Did you perhaps get it fixed yet wrang?

[MediaHound]

... all fixed.

To fix this SET NAMES error,
open /includes/cron/vbgooglemapme_cron.php
find line 29:

$vbulletin->db->query_first("SET NAMES 'utf8'");

change to:

//$vbulletin->db->query_first("SET NAMES 'utf8'");

All we did is comment it out.

[lpetrich]

Fix: added the ability to choose "Terrain" as a default map type:


In vbgooglemapme_admin.php

After line 39:
'3' => 'Satellite',
add
'4' => 'Terrain',


In vbgooglemapme.php

After line 73,
change
if ($maptype == 1)
{
$map_type = "{mapTypes:[G_NORMAL_MAP,G_SATELLITE_MAP,G_HYBRID_MAP]}";
}
...
}
to
switch ($maptype) {
case 1:
$map_type = "G_NORMAL_MAP";
break;
case 2:
$map_type = "G_HYBRID_MAP";
break;
case 3:
$map_type = "G_SATELLITE_MAP";
break;
case 4:
$map_type = "G_PHYSICAL_MAP";
break;
}


In product-vbgooglemapme.xml

change
map = new GMap2(document.getElementById("mapme"),$map_type);
to
map = new GMap2(document.getElementById("mapme"));
and likewise for "memap" instead of "mapme".

After
map.addMapType(G_PHYSICAL_MAP);
add
map.setMapType($map_type);


I'd earlier described my terrain fix, which involves adding the line
map.addMapType(G_PHYSICAL_MAP);
after each instance of
map = new GMap2(...);