<% strArchiveTablePrefix = strTablePrefix & "A_" strDBNTUserName = Request.Cookies(strUniqueID & "User")("Name") strDBNTFUserName = Request.Form("Name") if strDBNTFUserName = "" then strDBNTFUserName = Request.Form("User") if strAuthType = "nt" then strDBNTUserName = Session(strCookieURL & "userID") strDBNTFUserName = Session(strCookieURL & "userID") end if set my_Conn= Server.CreateObject("ADODB.Connection") my_Conn.Open strConnString 'DEM --> Added code for moderation and subscription if strDBNTUserName <> "" then MemberID = getMemberNumber(strDBNTUserName) else MemberID = 0 end if Response.Write "" & vbNewline & _ vbNewline & _ "" & vbNewline & _ "" & vbNewline '## START - REMOVAL OR MODIFICATION OF THIS CODE WILL VIOLATE THE SNTIZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewline '## END - REMOVAL OR MODIFICATION OF THIS CODE WILL VIOLATE THE SNTIZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewline & _ "" & vbNewline & _ vbNewline & _ "" & vbNewline & _ vbNewline & _ "" & vbNewline & _ " " & vbNewline & _ "

" & vbNewline & _ " " & vbNewline & _ " " & vbNewline function getMemberNumber(fUser_Name) '## This function should always be the same as the one in inc_functions.asp ! '## Forum_SQL strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & fUser_Name & "'" Set rsGetMemberNumber = Server.CreateObject("ADODB.Recordset") rsGetMemberNumber.open strSql, my_Conn if rsGetMemberNumber.EOF or rsGetMemberNumber.BOF then getMemberNumber = -1 rsGetMemberNumber.close set rsGetMemberNumber = nothing exit function end if getMemberNumber = rsGetMemberNumber("MEMBER_ID") rsGetMemberNumber.close set rsGetMemberNumber = nothing end function %>