Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Order Posts (most recent at top)
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

rhubarb
Starting Member

United Kingdom
1 Posts

Posted - 15 July 2009 :  19:08:02  Show Profile
I am aware that you can change the order of categorys/forums in the control panel. What I would like to be able to do is change the order of posts within a topic so that the most recent post is at the top, and the oldest at the bottom. Does anyone know how this would be achieved? I have tried searching through forums for help with no luck. I am using version 3.4.07 with an Access database. url:www.wombwellsportingac.co.uk/forum

Thanks in adavance

leatherlips
Senior Member

USA
1838 Posts

Posted - 15 July 2009 :  19:51:20  Show Profile  Visit leatherlips's Homepage
quote:
Originally posted by rhubarb

What I would like to be able to do is change the order of posts within a topic so that the most recent post is at the top, and the oldest at the bottom.

Unless I am misunderstanding your question, Snitz already does that by default. When a new post is made, it automatically goes to the top of that topic pushing the older ones down.

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

Carefree
Advanced Member

Philippines
4222 Posts

Posted - 15 July 2009 :  20:36:25  Show Profile
The topic itself will remain at the top, all replies will be in reverse order (latest first). In "topics.asp",

Look for the following lines (appx 204-213):

	if AdminAllowed = 0 then
		strSql = strSql & " AND (R_STATUS < "
		if Moderation = "Y" then
			strSql = strSql & "2 "
		else
			strSql = strSql & "3 "
		end if
		strSql = strSql & "OR R_AUTHOR = " & MemberID & ") "
	end if
	strSql = strSql & "ORDER BY R_DATE ASC "

Change the last line to say:

	strSql = strSql & "ORDER BY R_DATE DESC "

Edited by - Carefree on 15 July 2009 20:39:17
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07