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
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

sday
Starting Member

8 Posts

Posted - 16 June 2002 :  11:15:32  Show Profile
That worked perfectly.

I feel like such a tool. I should have tried that, but I was assuming it would be something more mysterious.

Thanks again for all the help.

Go to Top of Page

b4rm4n
New Member

73 Posts

Posted - 25 July 2002 :  10:08:49  Show Profile
Mine works with the code described in here, but I have a problem. The author of the post's information (ie city & state) is taken from the first person that replys to the topic profile instead of their own profile. So it makes the first to people look as if they are from the same city and state. Any suggestions on what that could be?

I also seem to have the problem where I get the blacked out topic and error message in the author box. This only seems to happen when there are no replys to the topic.

Error:

error '80020009'
Exception occurred.

/testforum/topic.asp, line 537


Edited by - b4rm4n on 25 July 2002 10:28:05
Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts

Posted - 25 July 2002 :  10:43:28  Show Profile
quote:

Mine works with the code described in here, but I have a problem. The author of the post's information (ie city & state) is taken from the first person that replys to the topic profile instead of their own profile. So it makes the first to people look as if they are from the same city and state. Any suggestions on what that could be?



Make sure that the record set being used is the correct one, rsTopic, for the topic posted and rsReplies, for the other members who have posted.

quote:

I also seem to have the problem where I get the blacked out topic and error message in the author box. This only seems to happen when there are no replys to the topic.

Error:

error '80020009'
Exception occurred.

/testforum/topic.asp, line 537


Edited by - b4rm4n on 25 July 2002 10:28:05



Not sure, make sure the field is in the sql statements and you are using the right one in the right place.


No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk
Go to Top of Page

b4rm4n
New Member

73 Posts

Posted - 25 July 2002 :  11:02:32  Show Profile
Well I redid the code in topic.asp and that seemed to fix it. I must have had something in the wrong place. Thanks for the help.

James

Go to Top of Page

tduffy
Junior Member

146 Posts

Posted - 06 September 2002 :  00:11:27  Show Profile
anyone know what you need to do to get this to work in version 3.4 of the forums?
Go to Top of Page

CarKnee
Junior Member

USA
297 Posts

Posted - 06 September 2002 :  12:23:20  Show Profile  Visit CarKnee's Homepage
This is what I did (I think)

Find this:
", M.M_TITLE, M.M_HOMEPAGE, M.MEMBER_ID, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY" & _

Replace With:
", M.M_TITLE, M.M_HOMEPAGE, M.MEMBER_ID, M.M_LEVEL, M.M_POSTS, M.M_STATE, M.M_COUNTRY" & _

Find this:
Member_Country = rsTopic("M_COUNTRY")

Replace With:
Member_State = rsTopic("M_State")
Member_Country = rsTopic("M_COUNTRY")

Find This:
" <p><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_Country & "</small></font><br />" & vbNewLine & _

Replace With:
" <p><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Member_State & ", " & Member_Country & "</small></font><br />" & vbNewLine & _

That should do it for the original post. Replies are a bit more complicated. If youwant that let me know.

CarKnee

Go to Top of Page

tduffy
Junior Member

146 Posts

Posted - 06 September 2002 :  12:34:49  Show Profile
Thanks, i'll try that out, but yes, i'd like city and state in everyone's posts.
Go to Top of Page

tduffy
Junior Member

146 Posts

Posted - 06 September 2002 :  12:47:42  Show Profile
Microsoft VBScript compilation error '800a03ea'

Syntax error

/topic.asp, line 800

end if
^




I tried using your code, and got this error when trying to view topics.
Go to Top of Page

CarKnee
Junior Member

USA
297 Posts

Posted - 06 September 2002 :  13:12:02  Show Profile  Visit CarKnee's Homepage
tduffy,
The code I gave shouldnt have done anything to give an error like that????

My line #'s are not the same as yours... can you post the code from that general area?

Thanks

Go to Top of Page

tduffy
Junior Member

146 Posts

Posted - 06 September 2002 :  17:26:20  Show Profile
Here's a copy of my topic.asp http://www.warpreality.com/topic.txt

It doesn't currently contain your edits, because it was erroring out, maybe you could work with it and send me a copy back. Thanks for the help.
Go to Top of Page

niteblade
Starting Member

5 Posts

Posted - 08 September 2002 :  01:42:37  Show Profile
Would someone be so kind as to post their topic.asp with the required modifications already included to display city, state, and country? This would be helpful for people like me who are not so .asp savvy. If no one would like to post it, then it would be helpful to me if line numbers were included in the above instructions, as well as verbatum text that needs to be looked for so that proper "insertion" can take place.

I am using 3.4.02, and have not applied any other mods to the topic.asp file. thank you.
Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts

Posted - 08 September 2002 :  04:48:50  Show Profile
There is a topic here about how to add this to the code.

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=33928&SearchTerms=state

Edited by - Hamlin on 08 September 2002 04:49:12
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous 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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07