Author |
Topic |
scohron
Starting Member
USA
16 Posts |
Posted - 02 May 2002 : 11:51:54
|
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
|
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!
|
|
|
scohron
Starting Member
USA
16 Posts |
Posted - 02 May 2002 : 13:29:01
|
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...
|
|
|
tangoc9999
Junior Member
USA
158 Posts |
Posted - 02 May 2002 : 15:13:16
|
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!
|
|
|
scohron
Starting Member
USA
16 Posts |
Posted - 02 May 2002 : 15:58:23
|
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.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 02 May 2002 : 16:29:31
|
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. |
|
|
Steve D.
Average Member
USA
640 Posts |
Posted - 02 May 2002 : 17:07:25
|
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 |
|
|
scohron
Starting Member
USA
16 Posts |
Posted - 03 May 2002 : 11:25:38
|
BINGO! That did it!
Thanks!
|
|
|
Steve D.
Average Member
USA
640 Posts |
Posted - 03 May 2002 : 13:13:07
|
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 |
|
|
sday
Starting Member
8 Posts |
Posted - 15 June 2002 : 16:43:43
|
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?
|
|
|
sday
Starting Member
8 Posts |
Posted - 15 June 2002 : 18:16:10
|
Post vanished from the board. ?????????
Ah....there it is. It got moved.
Edited by - sday on 15 June 2002 18:17:53 |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 15 June 2002 : 19:02:21
|
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 |
|
|
sday
Starting Member
8 Posts |
Posted - 15 June 2002 : 19:53:28
|
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?
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 15 June 2002 : 20:18:59
|
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 |
|
|
sday
Starting Member
8 Posts |
Posted - 15 June 2002 : 20:38:43
|
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.
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 16 June 2002 : 06:43:45
|
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. |
|
|
Topic |
|