| Author |
 Topic Search  Topic Options
|
AnaMaria 
Groupie
Joined: 12 May 2005
Status: Offline
Points: 37
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: New topics by time of posting
Posted: 08 May 2006 at 9:21am |
Is there a way to make new topic to be ordered by the time of posting, not by forums. I am speaking of page forum_topic.asp. I would like this to be just like in Php forums.
And th name of forums can be in the same line as the name of topic, not like a Subject in the top...
|
 |
AnaMaria
Groupie
Joined: 12 May 2005
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 May 2006 at 2:01pm |
|
BORG, can you answer me? Anybody?
|
|
gölge
Groupie
Joined: 16 April 2005
Location: Turkey
Status: Offline
Points: 182
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2006 at 12:18am |
can you give detailed information about this?
sorry but i cant understand what u want, clearly
|
|
AnaMaria
Groupie
Joined: 12 May 2005
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2006 at 1:12pm |
Whan I open activ topics active_topics.asp, I get a list of new posts,
ordered by forums thay are posted, here it is the same thing. But I whant
them to be ordered by time of posting, just like in php forums, I whant to
now whitch one is last posted... etc.
I thing you understad now.
|
|
gölge
Groupie
Joined: 16 April 2005
Location: Turkey
Status: Offline
Points: 182
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2006 at 11:00pm |
in active_topic.asp file line 295 :
strSQL = strSQL & "ORDER BY " & strDbTable & "Category.Cat_order ASC, " & strDbTable & "Forum.Forum_Order ASC, " & strSortBy & " "
delete that red shown code now it must be like this:
strSQL = strSQL & "ORDER BY " & strDbTable & "Category.Cat_order ASC, " & strSortBy & " "
and in line 160 change
strSortDirection = "asc"
to
strSortDirection = "Desc"
good luck...
Edited by gölge - 15 May 2006 at 11:15pm
|
|
AnaMaria
Groupie
Joined: 12 May 2005
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 May 2006 at 11:46pm |
in line 295 I had to put this:
strSQL = strSQL & "ORDER BY " & strSortBy & " "
It works, only I have one more thing I am interested.
The names of forums are displayed in topic of table. is there any posibility the names of the forums to be somewhere else, for examle like this, between two ().
example: (forum name).
Asking too much? 
Edited by AnaMaria - 15 May 2006 at 11:47pm
|
|
gölge
Groupie
Joined: 16 April 2005
Location: Turkey
Status: Offline
Points: 182
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 May 2006 at 3:24am |
in line 575 delete that codes:
 'If the forum name is different to the one from the last forum display the forum name
If sarryTopics(1,intCurrentRecord) <> strForumName Then
'Give the forum name the new forum name
strForumName = sarryTopics(1,intCurrentRecord)
'Display the new forum name Response.Write vbCrLf & " <tr class=""tableSubLedger""><td colspan=""7""><a href=""forum_topics.asp?FID=" & intForumID & strQsSID2& """>" & strForumName & "</a></td></tr>" End If |
and if you want to add the forum names in () so change this code (line684)
Response.Write(""" title=""" & strFirstPostMsg & """>" & strSubject & "</a>")
to this:
Response.Write(""" title=""" & strFirstPostMsg & """>" & strSubject & " ("&sarryTopics(1,intCurrentRecord)")</a>")
|
|
AnaMaria
Groupie
Joined: 12 May 2005
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 May 2006 at 12:58pm |
gölge wrote:
and if you want to add the forum names in () so change this code (line684)
Response.Write(""" title=""" & strFirstPostMsg & """>" & strSubject & "</a>")
to this:
Response.Write(""" title=""" & strFirstPostMsg & """>" & strSubject & " ("&sarryTopics(1,intCurrentRecord)")</a>") |
This doesn't work :(
The name of subforum can be in the same table, in diferent row, if it is posible, it is not nesesery to be in (). Only to be displayed somewhere.
|
|
