SELECT ID, ParentID, ReplyIDs, NumReplies, TSCreated, Title, Author FROM Threads WHERE ForumNumber = #ForumNumber# AND Deleted = 0 and ParentID = 0 AND Class=#Class# ORDER BY TSCreated #AscDesc# pages = Ceiling(GetTopics.RecordCount / PageLength); PageNavigator = ""; if (Pages GT 1) { PageNavigator = DefaultFont & "Pages:"; for (count = 1; count LTE Pages; count = count + 1){ if (attributes.CurrentPage NEQ count) { PageNavigator = PageNavigator & " #Count# |"; } else { PageNavigator = PageNavigator & " #Count# |"; } } if (attributes.CurrentPage LT Pages) { PageNavigator = PageNavigator & " Next &##187;"; } PageNavigator = PageNavigator & "

"; } #DefaultFont##PageNavigator#

if (NumReplies GT 0) {Replies_dsp = " (#NumReplies#)";} else {Replies_dsp = "";} if (CurrentRow MOD 2 eq 1) {bg_color=RowColor1;} else {bg_color=RowColor2;} #HeaderFont#  #TopicLabelPlural#   #HeaderFont#  Posted by   #HeaderFont#  Date  #RowHeight_img# #DefaultFont#  Be the first to post a new #LCase(Left(TopicLabel, 1))##Right(TopicLabel,(Len(TopicLabel)-1))#...  #RowHeight_img# #DefaultFont#  #Title##Replies_dsp#   #DefaultFont#  #Author#   #DefaultFont#  #DateFormat(TSCreated,'mmm d, yyyy')#  #RowHeight_img#

#DefaultFont##PageNavigator#