New Posts New Posts RSS Feed - lastest topics (creator of topics)
  FAQ FAQ  Forum Search   Register Register  Login Login

lastest topics (creator of topics)
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 31 Aug 2009 at 2:47pm
I'll look into it and get back to you.
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 03 Sep 2009 at 1:15pm
found the solution mate.?
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 03 Sep 2009 at 2:38pm
Add the following to line 117 of "includes/s2h_latest-topics.asp"

                    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

                        intS2HLTAuthorID    = rsCommon("Author_ID")

                        strS2HLTAuthorName    = rsCommon("Username")
                    End if
                    rsCommon.Close
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post 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.?
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 04 Sep 2009 at 7:41am
You want it to be between the following lines:

strS2HLTAuthorName    = saryS2HLTRecords(7, iS2HLTLoop)


*insert here*

%><tr class="tableRow">
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 04 Sep 2009 at 3:14pm
Originally posted by Scotty32 Scotty32 wrote:

You want it to be between the following lines:

strS2HLTAuthorName    = saryS2HLTRecords(7, iS2HLTLoop)


*insert here*

%><tr class="tableRow">

 
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
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^
Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195 		Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 04 Sep 2009 at 5:47pm
Originally posted by Scotty32 Scotty32 wrote:

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.
 
Ahh perfect scotty, it know works..
 
Its a really good tip mod fore this script..Wink
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38 		Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post 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.)
Back to Top
 Post Reply Post Reply Page  123>
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.047 seconds.