Author |
Topic |
sday
Starting Member
8 Posts |
Posted - 16 June 2002 : 11:15:32
|
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.
|
|
|
b4rm4n
New Member
73 Posts |
Posted - 25 July 2002 : 10:08:49
|
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 |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 25 July 2002 : 10:43:28
|
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 ™ |
|
|
b4rm4n
New Member
73 Posts |
Posted - 25 July 2002 : 11:02:32
|
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
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 06 September 2002 : 00:11:27
|
anyone know what you need to do to get this to work in version 3.4 of the forums? |
|
|
CarKnee
Junior Member
USA
297 Posts |
Posted - 06 September 2002 : 12:23:20
|
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 |
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 06 September 2002 : 12:34:49
|
Thanks, i'll try that out, but yes, i'd like city and state in everyone's posts. |
|
|
tduffy
Junior Member
146 Posts |
Posted - 06 September 2002 : 12:47:42
|
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. |
|
|
CarKnee
Junior Member
USA
297 Posts |
Posted - 06 September 2002 : 13:12:02
|
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 |
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 06 September 2002 : 17:26:20
|
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. |
|
|
niteblade
Starting Member
5 Posts |
Posted - 08 September 2002 : 01:42:37
|
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. |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
|
Topic |
|