Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Show City/State in replies
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

scohron
Starting Member

USA
16 Posts

Posted - 02 May 2002 :  11:51:54  Show Profile
I've searched for this, but can't find this in any past topics...

Currently, in a topic, the posts by each user only shows the country they're from, but not City and/or State. Anyway to add that info...

Username
Title
Country
# of Posts

Instead, would like something like:

Username
Title
City, State
Country
# of Posts

Is that possible?




Edited by - ruirib on 15 June 2002 17:47:16

tangoc9999
Junior Member

USA
158 Posts

Posted - 02 May 2002 :  12:03:57  Show Profile  Visit tangoc9999's Homepage  Send tangoc9999 an AOL message  Send tangoc9999 an ICQ Message  Send tangoc9999 a Yahoo! Message
i Admin options/Member Details Configuration/ you can enable city and state fields.

TANGO

Computers run on smoke, when the smoke comes out, they quit running!

Go to Top of Page

scohron
Starting Member

USA
16 Posts

Posted - 02 May 2002 :  13:29:01  Show Profile
That allows them to ENTER a City and State in their profile, but this is an additional listing in their post, themselves. I mean, look to the left-side of this one - see city or state? That's what I want...

Go to Top of Page

tangoc9999
Junior Member

USA
158 Posts

Posted - 02 May 2002 :  15:13:16  Show Profile  Visit tangoc9999's Homepage  Send tangoc9999 an AOL message  Send tangoc9999 an ICQ Message  Send tangoc9999 a Yahoo! Message
they have to enter that into their profile and if it is there and tuned on it will be in the left column when they post.

TANGO

Computers run on smoke, when the smoke comes out, they quit running!

Go to Top of Page

scohron
Starting Member

USA
16 Posts

Posted - 02 May 2002 :  15:58:23  Show Profile
Okay... well, it is turned on. Just like this forum, it's turned on, obviously, because if you look at my profile, you see that I'm from New York. However, you can't tell that from this page... It only shows Country, on the left side.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 02 May 2002 :  16:29:31  Show Profile
Tango, that must be something that you have added. By default, the City/State will not be shown in Topics/Replies. The code must be modified to allow this.
Go to Top of Page

Steve D.
Average Member

USA
640 Posts

Posted - 02 May 2002 :  17:07:25  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
O.K. I figured it out.

3 additions to your topic.asp file

1)Find the following text

function jumpTo(s)

Below that is sql statement.

find

strMemberTablePrefix & "MEMBERS.M_COUNTRY, " & _

and below enter in the following

strMemberTablePrefix & "MEMBERS.M_CITY, " & _
strMemberTablePrefix & "MEMBERS.M_STATE, " & _

2) find the following line:

<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsReplies("M_COUNTRY") %></small></font>

above that add the following

<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsReplies("M_CITY") %> <% =rsReplies("M_STATE") %></small></font>

3) Find the following

<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsTopic("M_COUNTRY") %></small></font>

Above that Add the following

<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsTopic("M_CITY") %> <% =rsTopic("M_STATE") %></small></font>

I put a space between City & State. If they don't fill out one or the other or both you'll have an extra comma. You could also put an if statement in there to check to see if they are empty.

----------------------------------------
Badges? We don't need no stinking badges
Go to Top of Page

scohron
Starting Member

USA
16 Posts

Posted - 03 May 2002 :  11:25:38  Show Profile
BINGO! That did it!

Thanks!

Go to Top of Page

Steve D.
Average Member

USA
640 Posts

Posted - 03 May 2002 :  13:13:07  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
quote:

BINGO! That did it!

Thanks!


No problem, actually thank you. It prompted me to change the layout of my topics.asp page.

----------------------------------------
Badges? We don't need no stinking badges
Go to Top of Page

sday
Starting Member

8 Posts

Posted - 15 June 2002 :  16:43:43  Show Profile
Be advised, this fix reacted very negatively with the Avatar Mod v2.0 that I just installed. My post responses were blacked out and I received this error message in the author column:

ADODB.Recordset error '800a0cc1'
The message directed me to line 556 of topic.asp

Everything was correct on this line. After checking all of the code mods in the topic.asp file, trial and error lead me towards removing the above City/State code mods. as a result the Avatar Mod now works.

So, the question is; How do you code the author column city/state/country mod with the Avatar Mod in place?




Go to Top of Page

sday
Starting Member

8 Posts

Posted - 15 June 2002 :  18:16:10  Show Profile
Post vanished from the board. ?????????

Ah....there it is. It got moved.

Edited by - sday on 15 June 2002 18:17:53
Go to Top of Page

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 15 June 2002 :  19:02:21  Show Profile
In topic.asp there are two SQL queries (one around line 104 and one around line 200). One for the original post and one for replies. Make sure you add the strMemberTablePrefix & "MEMBERS.M_CITY, " & _ and strMemberTablePrefix & "MEMBERS.M_STATE, " & _ to both queries. Also add the new lines to show the state to both the original post, and to the replies.

Steve D. only told you to add it to the replies SQL query.

Roland

http://www.frutzle.com

Snitz Exchange | Do's and Dont's
Go to Top of Page

sday
Starting Member

8 Posts

Posted - 15 June 2002 :  19:53:28  Show Profile
You guys are awesome!

Quick responses that worked nearly every time for a forum system that's totally free. Almost too good to be true.

Thanks one and all!

One more question, though. And I have to admit its a a bit boneheaded.

The display I'm getting right now looks like this:

CityCA
USA

How can I get a space inserted between the city and state?






Go to Top of Page

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 15 June 2002 :  20:18:59  Show Profile
You added this code to your topic.asp:

<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsTopic("M_CITY") %> X<% =rsTopic("M_STATE") %></small></font>

Just add a space where I added the red X. You could of course also add a comma to make it "correct"

Oh, I forgot, you have to do that for both the replies and the original post.

Roland

http://www.frutzle.com

Snitz Exchange | Do's and Dont's


Edited by - FrutZle on 15 June 2002 20:20:21
Go to Top of Page

sday
Starting Member

8 Posts

Posted - 15 June 2002 :  20:38:43  Show Profile
I tried adding spaces where you indicated but got no changes.
As an alternative I made separate code lines for M_CITY and M_STATE and ended up with this:

City
State
Country

I suppose this is actually better in the event a member doesn't input a city or state.

Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 16 June 2002 :  06:43:45  Show Profile
sday, try adding "& nbsp;"(no space between the "&" and "n") where Frutzle showed you the space.
like this-

<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsTopic("M_CITY") %>,& nbsp;<% =rsTopic("M_STATE") %></small></font>


There are 2 places to do this.

<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rsReplies("M_CITY") %>,& nbsp;<% =rsReplies("M_STATE") %></small></font>

I added the comma to make it correct . As for people not filling in the catagories, you can make them mandatory when they register, there's a thread here somewhere on this site explaning how. Just do a search for "mandatory". I believe Frutzle had the solution.
If you don't want to make them mandatory you can use an "if statement" something like:

<% if strCity ="1" then %>
<% if Trim(rsReplies("M_CITY")) <> "" then %>
<% =rsReplies("M_CITY") %>
<% end if %>
<% end if %>

I think that's right.

Question, is there a way to disply "& nbsp;" properly .

--------Brian.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07