lastest topics (creator of topics) |
Post Reply | Page 123> |
Author | |||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options
Quote Reply
Topic: lastest topics (creator of topics) Posted: 30 Aug 2009 at 7:39am |
||
Hey Scotty,
The Latest Topics modification shows the last person to post in that topic.
But i want to change it to the creator of the topic how and where do i change it to that in the script.? Edited by macpack - 30 Aug 2009 at 8:30am |
|||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 31 Aug 2009 at 2:47pm | ||
I'll look into it and get back to you.
|
|||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 03 Sep 2009 at 1:15pm | ||
found the solution mate.?
|
|||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 03 Sep 2009 at 2:38pm | ||
Add the following to line 117 of "includes/s2h_latest-topics.asp"
|
|||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 04 Sep 2009 at 4:18am | ||
Hey again scotty, if ill add it into line 117, it gives me a error then entering the site..
Is is possible, you can add it into the s2h_latest-topics.asp, and then post the full edited s2h_latest-topics.asp code here in this forum thread.?
|
|||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 04 Sep 2009 at 7:41am | ||
You want it to be between the following lines:
*insert here*
|
|||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 04 Sep 2009 at 3:14pm | ||
Then i put it there, it gives me this fault:
Microsoft VBScript compilation error '800a0401' Expected end of statement /includes/s2h_latest-topics.asp, line 117 strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username FROM " & strDbTable & "Thread, " & strDbTable & "Author WHERE " & strDbTable & "Thread.Topic_ID = " & lngS2HLTTopicID & " AND " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID ORDER BY " & strDbTable & "Thread.Thread_ID ASC" rsCommon.Open strSQL, adoCon if NOT rsCommon.EOF or NOT rsCommon.BOF then -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^ |
|||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Post Options Quote Reply Posted: 04 Sep 2009 at 3:56pm | ||
You need to make sure that each line is formated exactly as I have it above.
Eg, make sure that there are returns where I have them. |
|||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 04 Sep 2009 at 5:47pm | ||
Ahh perfect scotty, it know works..
Its a really good tip mod fore this script..
|
|||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Post Options Quote Reply Posted: 29 Oct 2009 at 9:45am | ||
Hey again Scotty,
Is it possible, you can show me how to add an extra colum after <%=strTxtS2HLTTitleDate%> with the the first author of the topic.
so it will have 5 colums.
<%=strTxtS2HLTTitleTopic%>
<%=strTxtS2HLTTitleAuthor%> (The first author of the topic.)
<%=strTxtS2HLTTitleForum%>
<%=strTxtS2HLTTitleDate%>
<%=strTxtS2HLTTitleAuthor%> (The lasted person who has writed in the topic.)
|
|||
Post Reply | Page 123> |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.109 seconds.