Print Page | Close Window

New topics by time of posting

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19761
Printed Date: 29 March 2026 at 12:51pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: New topics by time of posting
Posted By: AnaMaria
Subject: New topics by time of posting
Date 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...



Replies:
Posted By: AnaMaria
Date Posted: 14 May 2006 at 2:01pm
BORG, can you answer me? Anybody?


Posted By: gölge
Date Posted: 15 May 2006 at 12:18am
can you give detailed information about this?
sorry but i cant understand what u want, clearly


Posted By: AnaMaria
Date 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.


Posted By: gölge
Date 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...
 

 
 


Posted By: AnaMaria
Date 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? Wink
 


Posted By: gölge
Date Posted: 16 May 2006 at 3:24am
in line 575 delete that codes:
 
 
Quote  '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>")


Posted By: AnaMaria
Date Posted: 16 May 2006 at 12:58pm
Originally posted by gölge 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.


Posted By: AnaMaria
Date Posted: 16 May 2006 at 1:31pm
like this
http://forums.webwiz.net/active_topics.asp?SO=T - Topics http://forums.webwiz.net/active_topics.asp?SO=A - Topic Starter http://forums.webwiz.net/active_topics.asp?SO=R - Replies http://forums.webwiz.net/active_topics.asp?SO=V - Views http://forums.webwiz.net/active_topics.asp - Last Post http://forums.webwiz.net/active_topics.asp?OB=asc">Reverse Sort Order
 
 
 only to be between Topics and Topic starter


Posted By: gölge
Date Posted: 16 May 2006 at 9:11pm
at line 477 to line 484 replace the code with this:
 
%>
  <td width="31%"><a href="active_topics.asp?SO=T<% = strQsSID2 %>"><% = strTxtTopics %></a><% If Request.QueryString("SO") = "T" Then Response.Write(" <a href=""active_topics.asp?SO=T&OB=" & strSortDirection & strQsSID2 & """><img src=""" & strImagePath & strSortDirection & ".gif"" border=""0"" align=""absmiddle"" alt=""" & strTxtReverseSortOrder & """ /></a>") %></td>
  <td width="25%"><a href="active_topics.asp?SO=T<% = strQsSID2 %>"><% = strTxtForums %></a><% If Request.QueryString("SO") = "T" Then Response.Write(" <a href=""active_topics.asp?SO=T&OB=" & strSortDirection & strQsSID2 & """><img src=""" & strImagePath & strSortDirection & ".gif"" border=""0"" align=""absmiddle"" alt=""" & strTxtReverseSortOrder & """ /></a>") %></td>
  <td width="15%" nowrap><a href="active_topics.asp?SO=A<% = strQsSID2 %>"><% = strTxtThreadStarter %></a><% If Request.QueryString("SO") = "A" Then Response.Write(" <a href=""active_topics.asp?SO=A&OB=" & strSortDirection & strQsSID2 & """><img src=""" & strImagePath & strSortDirection & ".gif"" border=""0"" align=""absmiddle"" alt=""" & strTxtReverseSortOrder & """ /></a>") %></td>
  <td width="7%" align="center" nowrap><a href="active_topics.asp?SO=R<% = strQsSID2 %>"><% = strTxtReplies %></a><% If Request.QueryString("SO") = "R" Then Response.Write(" <a href=""active_topics.asp?SO=R&OB=" & strSortDirection & strQsSID2 & """><img src=""" & strImagePath & strSortDirection & ".gif"" border=""0"" align=""absmiddle"" alt=""" & strTxtReverseSortOrder & """ /></a>") %></td>
  <td width="7%" align="center" nowrap><a href="active_topics.asp?SO=V<% = strQsSID2 %>"><% = strTxtViews %></a><% If Request.QueryString("SO") = "V" Then Response.Write(" <a href=""active_topics.asp?SO=V&OB=" & strSortDirection & strQsSID2 & """><img src=""" & strImagePath & strSortDirection & ".gif"" border=""0"" align=""absmiddle"" alt=""" & strTxtReverseSortOrder & """ /></a>") %></td>
  <td width="25%" align="center"><a href="active_topics.asp<% = strQsSID1 %>"><% = strTxtLastPost %></a><% If Request.QueryString("SO") = "" Then Response.Write(" <a href=""active_topics.asp?OB=" & strSortDirection & strQsSID2 & """><img src=""" & strImagePath & strSortDirection & ".gif"" border=""0"" align=""absmiddle"" alt=""" & strTxtReverseSortOrder & """ /></a>") %></td>
 </tr><%
 
and line 731 (after </td> )add this code:
 
<td>strforumname</td>


Posted By: AnaMaria
Date Posted: 16 May 2006 at 10:28pm
The firs part is working, I have a table with sign Forum, but I can get the
name of the forum. I tried your sugestion, but than it writes strforumname
 in stand of my forum name, I tried <% = strForumName %> but than the
line is empty.
I don't know what to do...


Posted By: gölge
Date Posted: 16 May 2006 at 10:54pm
sure <% = strForumName %> is correct.  i'd forgotten responses
 
 
add that code to line 576 :
 
If sarryTopics(1,intCurrentRecord) <> strForumName Then
 
   'Give the forum name the new forum name
   strForumName = sarryTopics(1,intCurrentRecord)
 
End If
 
it must be ok...


Posted By: AnaMaria
Date Posted: 17 May 2006 at 11:08am
It works!
Thank you
Only they are not links, but never mind


Posted By: AnaMaria
Date Posted: 16 August 2006 at 8:47am
How to make this Forum names links?



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net