Author |
Topic |
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 10 February 2005 : 21:53:55
|
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
|
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 |
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 13 February 2005 : 13:18:56
|
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. |
|
|
TStewartFan
Junior Member
190 Posts |
Posted - 13 February 2005 : 16:00:17
|
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. |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 13 February 2005 : 20:53:20
|
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 |
|
|
|
Topic |
|