lastest topics (creator of topics) |
Post Reply ![]() |
Page 123> |
Author | |||
macpack ![]() Newbie ![]() Joined: 19 Jun 2009 Status: Offline Points: 38 |
![]() ![]() ![]() ![]() 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 |
![]() ![]() ![]() ![]() |
||
I'll look into it and get back to you.
|
|||
![]() |
|||
macpack ![]() Newbie ![]() Joined: 19 Jun 2009 Status: Offline Points: 38 |
![]() ![]() ![]() ![]() |
||
found the solution mate.?
|
|||
![]() |
|||
Matt ![]() Admin Group ![]() Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
![]() ![]() ![]() ![]() |
||
Add the following to line 117 of "includes/s2h_latest-topics.asp"
|
|||
![]() |
|||
macpack ![]() Newbie ![]() Joined: 19 Jun 2009 Status: Offline Points: 38 |
![]() ![]() ![]() ![]() |
||
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 |
![]() ![]() ![]() ![]() |
||
You want it to be between the following lines:
*insert here*
|
|||
![]() |
|||
macpack ![]() Newbie ![]() Joined: 19 Jun 2009 Status: Offline Points: 38 |
![]() ![]() ![]() ![]() |
||
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 |
![]() ![]() ![]() ![]() |
||
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 |
![]() ![]() ![]() ![]() |
||
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 |
![]() ![]() ![]() ![]() |
||
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.094 seconds.