What I want to do is be able to specify the forum_id in the querystring for active.asp, so that IF specified, active.asp will display active topics for that forum only.
I know what I have to do to do it, I just have to clear up some SQL first....
"WHERE T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID "
if strPrivateForums = "1" and mLev < 4 then
strSql = strSql & " AND F.FORUM_ID IN (" & allAllowedForums & ") "
end if
strSql = strSql & "AND F.F_TYPE = 0 " & _
"AND F.FORUM_ID = T.FORUM_ID " & _
"AND C.CAT_ID = T.CAT_ID " & _
"AND M.MEMBER_ID = T.T_AUTHOR " & _
"AND (T.T_LAST_POST > '" & lastDate & "'"
what exactly does the code highlited in green (grabbed from active.asp lines 271-279) do?
Topic Locked
Posted - 04 November 2004 : 23:17:14
