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]

I think this is another error.

It means one of the alter tables has failed for some reason in the installation.

I'm testing the install on a clean version of vb again

/edit

On both my testservers I cannot simulate the error.

Please make sure you have the version currently online. Uninstall the product completely and reinstall. It should create the missing field it's looking for.

[soulface]

Originally Posted by 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

removed the product & reinstalled in again! now its working. kinda wired :/

[stonyarc]

I've been plagued by weird voodoo tonight.

The number of queries is bothering me a lot. I need to find a way so I don't have to recreate the xml so often.

[Gizmo999]

Install went OK, one small hiccup not in documentation was altering the usergroup icon colour, easily sorted and all looking good. thanks Stonyarc

[stonyarc]

Originally Posted by Gizmo999

Install went OK, one small hiccup not in documentation was altering the usergroup icon colour, easily sorted and all looking good. thanks Stonyarc

Thanks gizmo hope you like it.

The next version will focus on performance and clearing up the number of queries in the xml generation.

[moonclamp]

Originally Posted by stonyarc

I've been plagued by weird voodoo tonight.

The number of queries is bothering me a lot. I need to find a way so I don't have to recreate the xml so often.

What sort of load is that likely to put on the server?

My host has already complained about my excessive SQL usage in the past.

[stonyarc]

Well it's because of the major difference between client side and server side processing.

The googlemap API requires you to create xml file which is processed client side by the scripts.

You can fake some stuff by setting it with php but bottomline remains the same.

Point is that currently onload of the map the xml-file is created or onchange of data.

To create a line in the xml file I need a query. If you have a whole lot of users that means a lot of queries.

That's what I'm working on. It's not so much a programming error but more a behaviour by design from the googlemap itself.

Google also says it that it's not build for 250+ but I have seen forums that are running my app 600+ and more. I keep tweaking the code javascript and php to make it as performant as possible and I am working on a more permanent solution with smart caching.

I already created part of those scripts for the xbox live integration I made for my site xboxusersgroup.com.

[xfaethorx]

anyone else got the problem where even though the usergroup option edit own marker is set to yes that the usergroup can't edit it unless edit markers option is on..which negates users markers security as anyone can change one!

[stonyarc]

Originally Posted by xfaethorx

anyone else got the problem where even though the usergroup option edit own marker is set to yes that the usergroup can't edit it unless edit markers option is on..which negates users markers security as anyone can change one!

I 'm checking it now

To allow only the entry and edit of your own entry the usergroup should be set to

Registered Can view the Googlemap ME YES
Registered Can add elements on the Googlemap ME YES
Registered Can edit elements on the Googlemap ME NO
Registered Can delete elements on the Googlemap ME NO
Registered Can edit own entry on the Googlemap ME YES

[hilfe-forum]

Originally Posted by 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.

Ups Sorry!
now it?s for users and guests.

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


I dont now who is the prob..

the Server can not be to smal..

The DB use Quad-Xenon-Server mit 8 GB RAM.
Serverload in smaler 3
in moment we have only a litle bit Users online...

your Hack is realy great an I and my Users realy love him.


im realy lucky if you can help me...

Sorry for my broken english..