If a normal member edits an approved reply in a moderated forum, the last post info in the forum and the topic is not updated. This happens because the last post info is updated only if the following condition is met:
if (mLev <> 4 and Moderation = "No") Then
regardless of the status of the post being edited. On a moderated forum, for a regular member, Moderation=Yes, so the last post info is never updated. To fix it,
Find the following code, around line #354:
txtMessage = ChkString(Request.Form("Message"),"message")
Err_Msg = ""
if txtMessage = " " then
Err_Msg = Err_Msg & "<li>You Must Enter a Message for your Reply</li>"
end if
Replace it by:
strSql = "SELECT R_STATUS FROM " & strActivePrefix & "REPLY WHERE REPLY_ID=" & Reply_ID
Set rcFix = my_Conn.Execute (strSql)
If Not rcFix.EOF Then
strReplyStatus = rcFix(0)
End If
rcFix.Close
Set rcFix = nothing
txtMessage = ChkString(Request.Form("Message"),"message")
Err_Msg = ""
if txtMessage = " " then
Err_Msg = Err_Msg & "<li>You Must Enter a Message for your Reply</li>"
end if
A bit below, around line# 378 (before the fix), find
if mLev <> 4 and Moderation = "No" then
Replace it by
if (mLev <> 4 and Moderation = "No") Or (strReplyStatus = 1 and mlev <> 4) then
This only affects forums that use post moderation.
Posted - 26 February 2009 : 17:39:28
