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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 posts in reverse order
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

GarethMoore1979
Junior Member

United Kingdom
220 Posts

Posted - 10 February 2005 :  21:53:55  Show Profile
what im looking for is a mod which allows the posts to appear in reverse order (in topic.asp).
So when someone posts a reply it will be at the top. the original starting topic will be at the bottom.
But I want this as an option to members so they can choose their prefecrence.

any ideas?

cheers!

Etymon
Advanced Member

United States
2385 Posts

Posted - 11 February 2005 :  21:22:06  Show Profile  Visit Etymon's Homepage
It seems easiest to keep the starting topic in place, and then make the replies list in order from newest to oldest by editing topic.asp and changing,

strSql4 = "ORDER BY R_DATE ASC "

to this:

strSql4 = "ORDER BY R_DATE DESC "

and changing,

strSql4 = " ORDER BY R.R_DATE ASC"

to this:

strSql4 = " ORDER BY R.R_DATE DESC"

When you need to reverse the order of the replies as they are displayed use DESC (which means descending) order instead of ASC (meaning ascending) order.

Cheers,

Etymon


Edited by - Etymon on 11 February 2005 21:24:24
Go to Top of Page

GarethMoore1979
Junior Member

United Kingdom
220 Posts

Posted - 13 February 2005 :  13:18:56  Show Profile
yea, I know how to do that part....but I wanted to make it an option for the member which would possibly mean adding a field into the database.
Go to Top of Page

TStewartFan
Junior Member

190 Posts

Posted - 13 February 2005 :  16:00:17  Show Profile  Visit TStewartFan's Homepage
Although it wouldn't be greatly difficult I would consider using the pre-existing SELECT statement and just adding a field SELECT M.M_DISPLAY, save that instance (i.e. memDisplay = rs("M.M_DISPLAY") and then simply create an if else statement (If memDisplay =1 then ORDER BY R_DATE ASC else ORDER BY R_DATE DESC) The way I would predefine this particular element within your db would be at the registration level. Perhaps a checkbox that if checked you would like to view in ascending order if not then descending order. After qualifying I can look at the topic.asp page a bit but here is a step in the right direction.

If You Have to Ask, You Wouldn't Understand.
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 13 February 2005 :  20:53:20  Show Profile  Visit Etymon's Homepage
For the membership preference part, take a look at the profile sections of the base code and follow what was done there. The signature section would be a good one to follow since it has the option to be shown or not shown on the topic page like you want.

Probably admin_config_members.asp, inc_profile.asp, pop_profile.asp, config.asp, topic.asp, and some others may be involved. It might need a function, so check out the inc_func pages as well. Also, look in the db at tables like FORUM_MEMBERS and FORUM_CONFIG_NEW for the fields. Pick apart the forum software because, in short, it is a bible of mods sewn together into what we call "base code".

You might have to look at a mod from over at SnitzBitz to find one that looks like what you want to do. You could learn from that too.

Cheers,

Etymon

Edited by - Etymon on 13 February 2005 20:58:15
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.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07