Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Member Map

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
CarKnee Posted - 15 August 2005 : 14:33:32
This mod was created to display the location of members on a Google Map.

It will only work if:
1. The Member has City, State (2 letter abbreviation), and Country filled in their profile.
2. Country MUST be USA. It will not work with any other country!
3. The City and State combination must exist in the GEOCODE database. Not every City is in the database!

Demo: http://www.rswarrior.com/forums/MemberMap.asp

It has been tested with with Snitz 3.4.05 & SQL Server 2000

Download Here:
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=214<
15   L A T E S T    R E P L I E S    (Newest First)
jeeper Posted - 11 June 2007 : 01:03:11
nevermind, I'm a bone head.. its works.. although it doesn't display names next the the marks.<
jeeper Posted - 09 June 2007 : 04:37:20
quote:
Originally posted by muzishun

I'm having problems with the JOIN statement. I have an Access database, and it says the JOIN isn't supported. Does anyone else have this working on Access? I have tried making a couple changes, just to see if they worked, but no dice. Here's the statement:

strSQL = "SELECT DISTINCT " & qTop & " M_NAME, Member_ID, M_CITY, M_STATE, Latitude, Longitude, M_LASTHEREDATE, M_PHOTO_URL " & _
	"FROM " & strTablePrefix & "MEMBERS LEFT JOIN " & strTablePrefix & "GEOCODED_CITIES ON (M_CITY = CITY AND M_STATE = STATE) " & _
	"WHERE M_STATUS = 1 "
strSQL = strSQL & "AND M_CITY <> '' AND M_STATE <> '' AND M_COUNTRY = 'USA' "

if Len(qState) = 2 Then 
	le = Left(qState, 1)
	ri = Right(qState, 1)
	' Make sure they are chars
	if (ASC(le) >= 65 AND ASC(le) <= 90) AND (ASC(ri) >= 65 AND ASC(ri) <= 90) Then	
		qState 	= " AND M_STATE = '" & qState & "' "
		qLHD 	= "" ' it don't matter when they were here last
	Else
		qState = ""
	End If
Else
	qState = ""
End If

strSQL = strSQL & " " & qState 	& " "
strSQL = strSQL & " " & qLPD 	& " " 
strSQL = strSQL & " " & qLHD 	& " "
strSQL = strSQL & " " & qMID 	& " "
strSQL = strSQL & " ORDER BY M_LASTHEREDATE DESC, M_NAME ASC"


Got it working just after I posted this. Here's the code that worked, for anyone who has the same problem.


strSQL = "SELECT DISTINCT " & qTop & " M_NAME, Member_ID, M_CITY, M_STATE, Latitude, Longitude, M_LASTHEREDATE, M_PHOTO_URL " & _
	"FROM " & strTablePrefix & "MEMBERS AS M LEFT JOIN " & strTablePrefix & "GEOCODED_CITIES AS G ON (M.M_CITY = G.CITY AND M.M_STATE = G.STATE) " & _
	"WHERE M_STATUS = 1 "
strSQL = strSQL & "AND M_CITY <> '' AND M_STATE <> '' AND M_COUNTRY = 'USA' "

if Len(qState) = 2 Then 
	le = Left(qState, 1)
	ri = Right(qState, 1)
	' Make sure they are chars
	if (ASC(le) >= 65 AND ASC(le) <= 90) AND (ASC(ri) >= 65 AND ASC(ri) <= 90) Then	
		qState 	= " AND M_STATE = '" & qState & "' "
		qLHD 	= "" ' it don't matter when they were here last
	Else
		qState = ""
	End If
Else
	qState = ""
End If

strSQL = strSQL & " " & qState 	& " "
strSQL = strSQL & " " & qLPD 	& " " 
strSQL = strSQL & " " & qLHD 	& " "
strSQL = strSQL & " " & qMID 	& " "
strSQL = strSQL & " ORDER BY M_LASTHEREDATE DESC, M_NAME ASC"




I'm using access now and this script gives me no joy :(
The map loads but it doesn't display any members info. I've verified the cities are listed in the script. no luck.. Anything else to check?
<
a10 Posted - 15 January 2007 : 11:38:01
Hi,

Great addon and I got it working. You can view mine here, http://www.tycoforums.com/tyco/forum/membermap.asp

I have a couple of questions. I've noticed on other examples of this that there are red pins, green pins and even blue dots. So far mine is just showing the red pins. Could somebody explain what all of the different ones are for?

I also see in some of the working examples, pics and links to gallerys. I would like my members avatar and a link to their profile or even a link to PM them show up. Currently just the username and location show up in the pin details.

Thank you Muzishun, your post regarding how to get it to work with access made the difference for me.

Thanks in advance for any help.

Todd<
CarKnee Posted - 14 November 2006 : 08:18:11
quote:
Originally posted by Riccardo

I use Access:

I Uncommented Out the "Response.ContentType = "text/xml""

Now I get this error loading membermapdata.asp

"Microsoft JET Database Engine error '80040e14'

Join expression not supported.

/forum/membermapdata.asp, line 71 "

I tried modifieg the sQl as MUZISHUN suggested but i got this error:

Microsoft JET Database Engine error '80040e21'

Cannot join on Memo, OLE, or Hyperlink Object (M.M_CITY=G.CITY And M.M_STATE=G.STATE).

/forum/membermapdata.asp, line 71 "

Anyone could help me pleeease??



Those fields shouldn't be a memo field. I would suggest checking the Geocode table and change any Memo fields to Text fields.<
Riccardo Posted - 13 November 2006 : 17:28:50
Any ideas?<
Riccardo Posted - 12 November 2006 : 07:03:28
I use Access:

I Uncommented Out the "Response.ContentType = "text/xml""

Now I get this error loading membermapdata.asp

"Microsoft JET Database Engine error '80040e14'

Join expression not supported.

/forum/membermapdata.asp, line 71 "

I tried modifieg the sQl as MUZISHUN suggested but i got this error:

Microsoft JET Database Engine error '80040e21'

Cannot join on Memo, OLE, or Hyperlink Object (M.M_CITY=G.CITY And M.M_STATE=G.STATE).

/forum/membermapdata.asp, line 71 "

Anyone could help me pleeease??<
JBaldwin Posted - 21 January 2006 : 22:36:57
I keep getting the Javascript error described in previous posts, with my member map.<
jeeper Posted - 21 January 2006 : 14:58:54
quote:
Originally posted by imweazel

Sorry it didn't work for you.



thanks..

why would the map display in .htm format but not in .asp?
Does this work with Mysql?
<
imweazel Posted - 20 January 2006 : 10:38:59
Sorry it didn't work for you. <
jeeper Posted - 20 January 2006 : 00:44:44
quote:
Originally posted by imweazel

Re-read the instructions, you need to register your site and obtain a key from Google Maps, your site address is used in making the key, then put the key into your membermap.asp such as the one listed below in bold.

'############################################################################################################
'# #
'# Script to generate a Google Member Map #
'# #
'# Created By CarKnee Consulting (www.carknee.com) on 8/15/05 #
'# Demo at http://www.rswarrior.com/forums/membermap.asp #
'# #
'############################################################################################################
%>
<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<script src="http://maps.google.com/maps?file=api&v=1&key=ABQIAAAALht-dcusCNKFsEiqQ6vqXBR33tw3RAqyfxZH0WTBLWDofOKi8RT77oNBHiEtP5QKlVfgn_B_o0REiQ" type="text/javascript"></script>




I reregisted using just the main site. Same problem.. so just for the hell of it I renamed the membermap.asp to .htm and the google map loads but doesn't show any points on it. so it seems likes its a coding error. Anyone else runing mysql? anything I need to tweak in the code?

http://www.airzonabackcountry.com/atvforum/membermap.htm
(displays the map)
http://www.airzonabackcountry.com/atvforum/membermap.asp
(map doesn't show up)<
imweazel Posted - 19 January 2006 : 19:27:51
Re-read the instructions, you need to register your site and obtain a key from Google Maps, your site address is used in making the key, then put the key into your membermap.asp such as the one listed below in bold.

'############################################################################################################
'# #
'# Script to generate a Google Member Map #
'# #
'# Created By CarKnee Consulting (www.carknee.com) on 8/15/05 #
'# Demo at http://www.rswarrior.com/forums/membermap.asp #
'# #
'############################################################################################################
%>
<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<script src="http://maps.google.com/maps?file=api&v=1&key=ABQIAAAALht-dcusCNKFsEiqQ6vqXBR33tw3RAqyfxZH0WTBLWDofOKi8RT77oNBHiEtP5QKlVfgn_B_o0REiQ" type="text/javascript"></script>
<
jeeper Posted - 19 January 2006 : 15:09:35
quote:
Originally posted by imweazel

Did you sign up for your key? The map uses a different key for every site, you can get yours at http://www.google.com/apis/maps/.




Is that different then the Api map code? this type of map works fine.
http://www.airzonabackcountry.com/atvforum/phoenix.htm
I told google to register www.airzonabackcountry.com/atvforum
Should I have left the atvforum part out of it?<
imweazel Posted - 19 January 2006 : 08:11:11
Did you sign up for your key? The map uses a different key for every site, you can get yours at http://www.google.com/apis/maps/.
<
jeeper Posted - 19 January 2006 : 03:22:27
quote:
Originally posted by CarKnee

This mod was created to display the location of members on a Google Map.




Awesome idea. Although mine won't display the map. My api code is good, the google demo map works fine. I went through and edited all the members to made sure they say USA for country. Won't display.. no red x, nothing.. any ideas?

http://www.airzonabackcountry.com/
login/pass: test<
muzishun Posted - 21 December 2005 : 10:58:06
Would either of you be interested in sharing some of that code? I haven't had a chance to play with Google Maps much, but the ability to let users get their lat and long by typing their ZIP and entering it separately could be very useful.<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000 Version 3.4.07