VBGooglemap Hotspot Edition

This modification contains a MySQL injection vulnerability. You are hereby notified to uninstall this modification until such time that the author provides a fix.
-- vBorg Staff


VBGooglemap Hotspot Edition 1.0.4
I'm proud to announce that the Hotspot Edition is currently available to you all !!!

Function
The vbgooglemap Hotspot Edition is a design from StonyArc (http://www.stonyarc.com). It allows you to create and maintain a whole range of elements like landmarks, places to visit or even people. The application is fully manageable from the control panels. Each specific category can have a specific colour code. The configuration is done by the administrator. He or she can edit/approve/add catogories name it, it's there.
Clicking on a marker will open a small balloon with some essential elements for that spot and an image in the second tab. For each marker on the map there is also a full details page including support for the vbulletin full editor (wysiwyg) so additional information and images can be added.

Use the menus to navigate through all the functions.

Vbgooglemap Hotspot Edition is ideal for handling landmarks, travel, events or even giving your users their own page.


Don't forget to hit install !!!!!!!




Detailed installation instructions and screenshots in the included pdf file.

Version Information
1.0.0.

• Initial Version

1.0.1

• Included fix for single quote insert error

1.0.2

• Integrated on mouse over support for the information balloon with admincp support for activation
• Compact display of main map (welcome in header)

1.0.3

• Fixed date issue to display the correct entered date in both new insert and edit of existing
• Fixed the frontend delete issue

1.0.4
Current version

• Minor update after changes from Google. IE alignment issue.

Current Features





NOTE:

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.

Support for this version is only in this thread and only for people that have clicked install.

To remove the copyright marker, please get in touch with me on admin@stonyarc.com. The email address cannot be used for support questions for this version.

If you have specific requests (eg custom versions) you may use the address to get in touch with me to discuss.


Planned Features
- To be defined

Volume warning

- high volume of markers may result in longer loading times

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 spotmarkers.xml file to 777
- usergroup permissions are available in the backend
- First time loading of the map may take a few seconds longer because of Google API hosting

Demonstration
http://www.stonyarc.com/forums/vbgooglemaphse.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 (vbgooglemaphse1.0.0.pdf)


FAQ

The FAQ is included in the pdf file.



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



(c) 2006 Stonyarc

[yinyang]

Originally Posted by yinyang

awesome!

is there any way to join this with your VBGooglemap mod? perhaps different color
pin for the hot spots, etc.

i meant, can you make the members map and the hotspots map the same map, i.e. use the same map for both those things?

ALSO: in your PDF file in step 7, you wrote that the link should point to "vbgooglemap.php". i think you meant to write "vbgooglemaphse.php".

[stonyarc]

Originally Posted by yinyang

i meant, can you make the members map and the hotspots map the same map, i.e. use the same map for both those things?

I could cook up a function for that so that users are in overlay in this map. The datamodel supports it.

If so I might have to discontinue the member edition.

However some people have 500-600 users on there if you are going to combine that with a few 100 events or locations or whatever it will become crowded.

Thanks for the error catch I'll update the pdf file now.

[Tyegurl]

i take it you just reuploaded the file lmfao....was having problems unzipping it....so i came back to download and it said invalid file....refreshed and woo hoo it downloaded...

works beautifully i wanna chat with you on something....i will pm you...i know how busy you are...so take your time getting back to me its no big rush

[Oddjob]

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO googlemaphse
(userid,username,usergroupid,cat_id,title_map,date _map,text_map,
text_description_map,lat_map,lng_map,url_location, url_thread,img_location,
approve,creation) VALUES ('1','Oddjob','6',
'2','Oddjobs' Place','','Holla','Word.................\n\nchilli n.\n\nout.',
'37.996162679728116','3.515625','http://www.webnoobie.com','http://www.webnoobie.com','',
'1','1146102435');

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 'Place','','Holla','Word.................\n\nchill in.\n\nout.',
'37.9961626797281' at line 5
Error Number : 1064
Date : Wednesday, April 26th 2006 @ 09:47:15 PM
Script : http://www.webnoobie.com/forums/vbgooglemaphse.php
Referrer : http://www.webnoobie.com/forums/vbgo...?do=addelement

[limey]

Can't figure out the problem. Installed on 3 boards. 2 seo'd with different hacks, and 1 plain jane no seo hacks at all and none of them work.

They all produce the same error:
"Your full text could not be added into the database because one or more fields blank were left blank. Please make sure you have enter all required information.
Return to previous page"

Can I literally just enter "erererererer" for every field and it would take it? It does not work for me, but I see you did that in the screenshots.

I'm just happy I'm not crazy....phew.

[Zia]

hello stonyarc

its hotspot edition of vbgooglemap
we had installed vbgoogle map..old one(http://www.golpo.net/forum/vbgooglemap.php)

what abt an update? can we update old one to this new one?
simply overwrite can do the update?

really like it....

thnx

[yinyang]

Originally Posted by stonyarc

I could cook up a function for that so that users are in overlay in this map. The datamodel supports it.

If so I might have to discontinue the member edition.

However some people have 500-600 users on there if you are going to combine that with a few 100 events or locations or whatever it will become crowded.

Thanks for the error catch I'll update the pdf file now.

i think you should do it. you could perhaps have an on/off switch for members and hotspots... i.e., they can choose to show only members, or only hotspots, or both. but i think it would be a more elegant modification if that was possible... not that this doesn't already rock!

[stonyarc]

Originally Posted by Zia

hello stonyarc

its hotspot edition of vbgooglemap
we had installed vbgoogle map..old one(http://www.golpo.net/forum/vbgooglemap.php)

what abt an update? can we update old one to this new one?
simply overwrite can do the update?

really like it....

thnx

This is currently a seperate version and it doesn't mix anything with the Member edition

You can define your own categories so if you have a small board and define your usergroup as a category they will show.

The legends are automatically build

[stonyarc]

Originally Posted by Oddjob

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO googlemaphse
(userid,username,usergroupid,cat_id,title_map,date _map,text_map,
text_description_map,lat_map,lng_map,url_location, url_thread,img_location,
approve,creation) VALUES ('1','Oddjob','6',
'2','Oddjobs' Place','','Holla','Word.................\n\nchilli n.\n\nout.',
'37.996162679728116','3.515625','http://www.webnoobie.com','http://www.webnoobie.com','',
'1','1146102435');

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 'Place','','Holla','Word.................\n\nchill in.\n\nout.',
'37.9961626797281' at line 5
Error Number : 1064
Date : Wednesday, April 26th 2006 @ 09:47:15 PM
Script : http://www.webnoobie.com/forums/vbgooglemaphse.php
Referrer : http://www.webnoobie.com/forums/vbgo...?do=addelement

http://www.webnoobie.com/forums/vbgooglemaphse.php

I dropped in 3 markers without a problem. It must be something data related but normally it checks for issues.

You can also download the version now online of vbgooglemaphse.php and overwrite that one so that het prefills the full text with a small text to avoid the board warning that the post is too short.

[stonyarc]

Originally Posted by limey

Can't figure out the problem. Installed on 3 boards. 2 seo'd with different hacks, and 1 plain jane no seo hacks at all and none of them work.

They all produce the same error:
"Your full text could not be added into the database because one or more fields blank were left blank. Please make sure you have enter all required information.
Return to previous page"

Can I literally just enter "erererererer" for every field and it would take it? It does not work for me, but I see you did that in the screenshots.

I'm just happy I'm not crazy....phew.

The full text error comes from the editor at the bottom. Do you have settings on your general board that limit the use?

Can you also post a link?