Hi, I'm trying to achieve the goal of my members post count being increased by 2 instead of 1 when they post in my review forum (forum id held in strReviewsForum_ID) or my clubnews forum (forum id held in strClubNewsForum_ID). Looking through the code, it appears that the subroutine doUCount(sUser_Name) in inc_func_count.asp is responsable for increasing the post count. I have altered the sub to look like this.
sub doUCount(sUser_Name)
'## Forum_SQL - Update Total Post for user
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
Response.write "<br>Topic_ID =" & Forum_ID
Response.write "<br>strClubNewsForum_ID =" & strClubNewsForum_ID
Response.write "<br>strReviewsForum_ID =" & strReviewsForum_ID
If Forum_ID = strClubNewsForum_ID or Forum_ID = strReviewsForum_ID Then
strSql = strSql & " SET M_POSTS = M_POSTS + 2 "
Else
strSql = strSql & " SET M_POSTS = M_POSTS + 1 "
End If
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(sUser_Name, "SQLString") & "'"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
end sub
But it doesn't work. Please an any one tell me where I am going wrong? I have put a couple of response.writes in to check the values are equal and they appear the correct when you post a new topic in these froums, but the post count only increases by 1. 
Topic Locked
Posted - 26 April 2004 : 19:49:13
