vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   VBGooglemap Member Edition (https://vborg.vbsupport.ru/showthread.php?t=99920)

MorrisMcD 03-20-2006 04:38 PM

Quote:

Originally Posted by Kintaro81
I don't have vB Pager installed but the problem with IE is the same as your. :(
Anyone fix that in another way?

And I actually DO have the pager and this installed and it works fine

bamahan 03-21-2006 02:00 PM

Quote:

Originally Posted by princessfrozen
Could this be modified to pull the zip codes (created by a custom field) from the database and generate the map based on that?

If you look at the code, there are "lookupZip" and "lookupAddress" methods. If you added a custom user field to store zip code, then you could certainly write a batch script to popuplate the map tables with markers.

The INSERT statement would look like this. I wrote a quick script (It's a total mess or I'd post it) that tries to do a lookup on the "location" field so as not to make the user enter a zip. Only about a hundred of our users put in resolvable locations, however.

The script would need to select all of the users from the DB...this statement grabs their location:

$userlocation = $db->query("
SELECT user.userid, user.username, user.usergroupid, opts.field2
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN ".TABLE_PREFIX."userfield as opts ON opts.userid = user.userid WHERE field2 IS NOT NULL");

Then loop through each one, call the lookupAddress method. If a latitued and longitude are returned do an insert like this:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "googlemap (userid,username,usergroupid,text_map,lat_map,lng_ map) VALUES ('" . $loc['userid'] . "','" . $loc['username'] . "','" . $loc["usergroupid"] . "','" . $loc["username"]. " is in ".$l."!','" . $lat . "','" . $long . "')");

bamahan 03-21-2006 02:05 PM

Quote:

Originally Posted by MorrisMcD
Good question.. I forgot to ask this, but I would like this as well.. Without having to add extra members just to do it

Have you tried just inserting a new entry into the [your_table_prefix]googlemap table in your database? I haven't tried this, but it seems like you should be able to simply add a new entry in there with the appropriate latitude and longitude. You can fake a username ("Joe's Bowling Alley", etc...) and id. The insert would look something like this:

INSERT INTO [TABLE_PREFIX ]googlemap (userid,username,usergroupid,text_map,lat_map,lng_ map) VALUES ('-1','Donut Land','1','...mmmmm donuts...,[Latitude Goes Here]','[Longitude Goes Here]')

tamborinegal 03-21-2006 11:07 PM

Quote:

Originally Posted by Kintaro81
I don't have vB Pager installed but the problem with IE is the same as your. :(
Anyone fix that in another way?

Try disabling some of your other plugins and see if it works. For me it was some kind of conflict between this and vB Pager, for you it might be some other plugin.

Cheers

Clancy

MorrisMcD 03-22-2006 04:00 AM

Quote:

Originally Posted by bamahan
Have you tried just inserting a new entry into the [your_table_prefix]googlemap table in your database? I haven't tried this, but it seems like you should be able to simply add a new entry in there with the appropriate latitude and longitude. You can fake a username ("Joe's Bowling Alley", etc...) and id. The insert would look something like this:

INSERT INTO [TABLE_PREFIX ]googlemap (userid,username,usergroupid,text_map,lat_map,lng_ map) VALUES ('-1','Donut Land','1','...mmmmm donuts...,[Latitude Goes Here]','[Longitude Goes Here]')


Yea.. I guess this would work... But if I have to start editing the database manually to do this, it isnt worth it... If you do it though, make sure to use a high ID that you wont ever need

bamahan 03-22-2006 05:26 PM

Quote:

Originally Posted by MorrisMcD
Yea.. I guess this would work... But if I have to start editing the database manually to do this, it isnt worth it... If you do it though, make sure to use a high ID that you wont ever need

...or a negative number assuming the DB allows that.

Also, for these "fake" entries, you don't need to put in unique ID's. This hack doesn't care how many entries there are for each userid; it displays them all, so every fake entry could have a userid of -1

Gizmo999 03-22-2006 05:47 PM

Hotspots need a unique colour pin as well though so they stand out :( currently the only colour options are based on admin or not i think

JoeWho 03-23-2006 01:51 PM

Is the coder (stonyarc) for this add-on still supporting this product?

On the original page there is a list of things that are to be added in the next release, I was hoping this is still in progress and will be completed someday soon?

Can anybody let me know if this is still under development or has it been an abandoned?

I would like to add it to my forum but I first need to find out if it is still supported by the coder. There is another mapping program on the forum but I like this one better, I hope somebody can help me out with my questions.

Thanks.

Quote:

1.0.4 Development
- Event handler
- Hotspots functions (different colour and insert functions)
- usergroup permissions
- link to profile
- option to display the avatar
- custom markers (not yet sure)
- events and hotspots display
- style guidelines to change colours

xfaethorx 03-24-2006 06:40 PM

i'd like to install this but i'd like NOT to have my users details available to guest i need the security of the usergroup permissions and i was wondering if this hack was going to be updated? If not then I can't install it :(

kazido 03-25-2006 06:19 AM

I have it working on my site :)

Easy to install, just cant wait for the updated version. Great feature but seems to be lacking some functionality and user customisation.

Keep up the good work!
Don


All times are GMT. The time now is 11:13 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02588 seconds
  • Memory Usage 1,751KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete