<% '################################################################################# '## Copyright (C) 2000-01 Michael Anderson and Pierre Gorissen '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## reinhold@bigfoot.com '## '## or '## '## Snitz Communications '## C/O: Michael Anderson '## PO Box 200 '## Harpswell, ME 04079 '################################################################################# strArchiveTablePrefix = strTablePrefix & "A_" set my_Conn= Server.CreateObject("ADODB.Connection") my_Conn.Open strConnString if strAuthType = "db" then if (Request.Cookies(strUniqueID & "User")("Name") <> "" and Request.Cookies(strUniqueID & "User")("PWord") <> "") then '## Forum_SQL strSql = "SELECT MEMBER_ID, M_NAME, M_PASSWORD " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkStrings(Request.Cookies(strUniqueID & "User")("Name"),"SQLString") & "'" strSql = strSql & " AND M_PASSWORD = '" & ChkStrings(Request.Cookies(strUniqueID & "User")("Pword"),"SQLString") & "'" Set rsCheck = my_Conn.Execute(strSql) if rsCheck.BOF or rsCheck.EOF then Call ClearCookies() strDBNTUserName = "" else strDBNTUserName = rsCheck("M_NAME") end if rsCheck.close set rsCheck = nothing else strDBNTUserName = "" end if end if strDBNTUserName = Request.Cookies(strUniqueID & "User")("Name") strDBNTFUserName = Request.Form("Name") if strAuthType = "nt" then strDBNTUserName = Session(strCookieURL & "userID") strDBNTFUserName = Session(strCookieURL & "userID") end if 'DEM --> Added code for moderation and subscription if strDBNTUserName <> "" then MemberID = getMemberNumber(strDBNTUserName) else MemberID = 0 end if Response.Write "" & vbNewline & _ 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 function HTMLEncodes(pString) fString = trim(pString) if fString = "" or IsNull(fString) then fString = " " fString = replace(fString, ">", ">") fString = replace(fString, "<", "<") HTMLEncodes = fString end function function chkStrings(pString,fField_Type) '## Types - SQLString fString = trim(pString) if fString = "" then fString = " " end if if fField_Type = "SQLString" then fString = Replace(fString, "'", "''") fString = HTMLEncodes(fString) chkStrings = fString exit function end if chkStrings = fString end function sub ClearCookiess() if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "User").Path = strCookieURL else Response.Cookies(strUniqueID & "User").Path = "/" end if Response.Cookies(strUniqueID & "User") = "" Session(strCookieURL & "Approval") = "" end sub %>