I've tried to search the archives on this one, but can't find anything so forgive me if this has been mentioned before.
Basically active.asp, when you are a moderator for a group (with or without approving topics), you do not see any of the topic in the forum you are a moderator for.
I've tracked it down to this piece of code.
DEM --> if not an admin, all unapproved posts should not be viewed.
if mlev <> 4 then
strSql = strSql & " AND ((T.T_AUTHOR <> " & MemberID &_
" AND T.T_STATUS < 2" ' Ignore unapproved/held posts
if mlev = 3 and ModofForums <> "" then
strSql = strSql & " AND T.FORUM_ID NOT IN " & ModOfForums end if
strSql = strSql & ") OR T.T_AUTHOR = " & MemberID & ")"
end if
I can't quite see what to do to fix it.
This is the fix....
Change the above code to this
' DEM --> if not an admin, all unapproved posts should not be viewed.
if mlev <> 4 then
strSql = strSql & " AND ((T.T_AUTHOR <> " & MemberID &_
" AND T.T_STATUS < 2" ' Ignore unapproved/held posts
if mlev = 3 and ModofForums <> "" then
strSql = strSql & " AND T.FORUM_ID NOT IN " & ModOfForums & ") OR ( T.FORUM_ID IN " & ModOfForums
end if
strSql = strSql & ") OR T.T_AUTHOR = " & MemberID & ")"
end if
Seems to be ok
Can anyone help?
Thanks Az
-------
Eagles fly!, but weasels don't get sucked into jet engines.
Edited by - azaniah on 26 April 2002 05:11:10
Edited by - azaniah on 26 April 2002 08:33:31
Edited by - azaniah on 26 April 2002 08:33:52