VBGooglemap Member Edition

I'm proud to announce that the new version is currently available to you all !!!


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

HOTSPOT EDITION AVAILABLE ON : https://vborg.vbsupport.ru/showthread.php?t=114149
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.1 brings you a lot of new features. It?s vital that you uninstall any previous version before upgrading/installing version 2.5.1.

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 2.5.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 (vbgooglemap2.5.0_guide.pdf)
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

[stonyarc]

Originally Posted by JD45

I found an old googlemap table, and I dropped that, but still no difference. Thanks for checking again..

JD,

just download the product again.

I changed the plugin with an error check so that it first looks if it knows the userid.

I also removed the duplicate entry for the usergroup table.

Product with overwrite to yes should fix the issue.

[JD45]

I just downloaded, and reinstalled the plugin with overwrite and:

Database error in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE vb_usergroup ADD showonvbgme int(10) unsigned NOT NULL;

MySQL Error  : Duplicate column name 'showonvbgme'
Error Number : 1060
Date         : Sunday, May 14th 2006 @ 02:22:18 PM
Script       : http://www.justpressplay.net/forum/admincp/plugin.php
Referrer     : http://www.justpressplay.net/forum/admincp/plugin.php?do=productadd
IP Address   : 
Username     : JD45
Classname    : vb_database

[JD45]

took out that one line of the installer and perfecto..

Thanks again for all your assistance..

[stonyarc]

Originally Posted by JD45

took out that one line of the installer and perfecto..

Thanks again for all your assistance..

Well yiehaa,

Slap me on the head for including the wrong product/installer xml in the zip


That error should be gone

[moonclamp]

New problem

If a user clicks on some older threads they get the following. It's weird as it only happens on some threads

Invalid SQL:

SELECT userid,lat_map,username,lng_map FROM vb_googlemapme WHERE userid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Error Number : 1064

Date : Sunday, May 14th 2006 @ 07:37:12 PM

Script : http://www.xxxxxxxxx.com/interactive/showthread.php?t=2172
Referrer : http://www.xxxxxxxxx.com/interactive/forumdisplay.php?f=30

EDIT ... just noticed the post above *goes off to fix*

[hilfe-forum]

looks nice but i have a Problem...

Look
http://www.hilfe-forum.eu/vbgooglemapme.php


Loaded: 12 of 170
Loaded: 13 of 170
Loaded: 14 of 170
Loaded: 15 of 170
Loaded: 12 of 170
Loaded: 13 of 170
Loaded: 14 of 170
Loaded: 15 of 170
Loaded: 12 of 170
Loaded: 13 of 170
Loaded: 14 of 170
Loaded: 15 of 170
......


and...

Page generated in 0,67374 seconds with 349! queries ???

[stonyarc]

I don't have access to the page

I'm registered as normal user. Can you please allow normal users to see

For some reason he seems to count the javascript parsings and counters as queries. If you look at the total exectution time the number of queries just cannot be right.

[kompakt]

Originally Posted by stonyarc

Kompakt can you please post a link or pm it to me

Preferably with an account I can use to test

Thanks, its working great now

[stonyarc]

It's the dynamic creation of the xml file that is causing these number of queries.

That has always been the case.

I'm working on a smart cache solution but that will remove the "user is online" function.

[soulface]

OK, just redownloaded & reinstalled the product again & getting same error like JD45..

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT title,googlemapmetype	FROM usergroup where showonvbgme = '1';

MySQL Error  : Unknown column 'showonvbgme' in 'where clause'
Error Number : 1054
Date         : Sunday, May 14th 2006 @ 03:41:57 PM
Script       : http://www.*******.com/vbgooglemapme.php?
Referrer     : 
IP Address   : **********
Username     : Eros
Classname    : vb_database