BUG: When a user updates their unapproved topic, it is sent to Forum Listings as "Last Topic", even though it is not reachable, it is visible on main forum listings or category pages as "Last Topic" as described here http://forum.snitz.com/forum/topic.asp?TOPIC_ID=69803
FIX:
Open post_info.asp
Find following around line 735
else
if mLev <> 4 and Moderation = "No" then
'## Forum_SQL - Update Last Post
strSql = " UPDATE " & strTablePrefix & "FORUM"
strSql = strSql & " SET F_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", F_LAST_POST_AUTHOR = " & MemberID
strSql = strSql & ", F_LAST_POST_TOPIC_ID = " & Topic_ID
strSql = strSql & ", F_LAST_POST_REPLY_ID = " & 0
strSql = strSql & " WHERE FORUM_ID = " & Forum_ID
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
Change this line:
if mLev <> 4 and Moderation = "No" then
with following:
if mLev <> 4 and Moderation = "No" AND Topic_Status < 2 then
Posted - 19 January 2011 : 20:51:30
