![]() |
Quote:
|
Quote:
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 . "')"); |
Quote:
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]') |
Quote:
Cheers Clancy |
Quote:
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 |
Quote:
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 |
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
|
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:
|
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 :(
|
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|