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 / Current Version (Old)
 Problem related to 'Sticky' topics		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 24 July 2001 :  13:28:29  Show Profile  Visit MarkJH's Homepage
Okay, i've had the 'lock on top' mod installed for a few weeks now and have been moderately (no pun intended!) happy with it. Unfortunately, now that the 'sticky' topics have been on top for more than 30 days, they have disappeared from the view of all members who haven't changed their preferences to view topics over 30 days old.

Seeing as my 'sticky' topics are mainly for new members you can see that this is a problem.

Is it possible to change the default 'show topics for xxx days' to a year for instance?

Also, is there a workaround for keeping 'sticky' topics at the top ad infinitum?

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 24 July 2001 :  13:55:21  Show Profile  Visit HuwR's Homepage
In forum.asp, look for this code or something similar. this is from 3.3, but should be the same in 3.1

if nDays > "0" then
	strSql = strSql & " AND " & strActivePrefix & "TOPICS.T_LAST_POST > '" & defDate & "'"
end if

change it as follows.

if nDays > "0" then
	strSql = strSql & " AND (" & strActivePrefix & "TOPICS.T_LAST_POST > '" & defDate & "'"
	strSql = strSql & " OR " & strActivePrefix & "TOPICS.T_INPLACE = 1 )"
end if


Not tested this, but it sould meaan that it always selects locked in place topics regardless of date.
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 25 July 2001 :  17:24:30  Show Profile  Visit MarkJH's Homepage
Huw, it works!

The code was a little different though. This is what you need to search for:

if nDays > "0" then
strSql = strSql & " AND " & strTablePrefix & "TOPICS.T_LAST_POST > '" & defDate & "'"
end if

and this is what it should be changed too:

if nDays > "0" then
strSql = strSql & " AND (" & strTablePrefix & "TOPICS.T_LAST_POST > '" & defDate & "'"
strSql = strSql & " OR " & strTablePrefix & "TOPICS.T_INPLACE = 1 )"
end if

Notice the strTablePrefix as opposed to strActivePrefix in v3.3



bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/

Edited by - MarkJH on 25 July 2001 17:26:31
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 26 July 2001 :  18:12:26  Show Profile  Visit MarkJH's Homepage
Note: If you have the 'lock on top' mod installed, this is a fairly essential fix. Perhaps this should be moved to the mods forum?

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 26 July 2001 :  20:41:17  Show Profile  Visit HuwR's Homepage
sorry, my code example was from the 3.3 code which uses a different prefix in some of the files
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07