<% '################################################################################# '## Snitz Forums 2000 v3.4.04 '################################################################################# '## Copyright (C) 2000-04 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## 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 (at your option) 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 our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# call LangDebug("===== inc_header.asp") Response.Expires = 15 Response.Expiresabsolute = Now() - 48 Response.AddHeader "pragma","no-cache" Response.CacheControl = "no-cache" Response.AddHeader "cache-control","private" %> <% if strShowTimer = "1" then '### start of timer code Dim StopWatch(19) sub StartTimer(x) StopWatch(x) = timer end sub function StopTimer(x) EndTime = Timer 'Watch for the midnight wraparound... if EndTime < StopWatch(x) then EndTime = EndTime + (86400) end if StopTimer = EndTime - StopWatch(x) end function StartTimer 1 '### end of timer code end if strArchiveTablePrefix = strTablePrefix & "A_" strScriptName = request.servervariables("script_name") strReferer = chkString(request.servervariables("HTTP_REFERER"),"refer") if Application(strCookieURL & "down") then if not Instr(strScriptName,"admin_") > 0 then Response.redirect("down.asp") end if end if if strPageBGImageURL = "" then strTmpPageBGImageURL = "" elseif Instr(strPageBGImageURL,"/") > 0 or Instr(strPageBGImageURL,"\") > 0 then strTmpPageBGImageURL = " background=""" & strPageBGImageURL & """" else strTmpPageBGImageURL = " background=""" & strImageUrl & strPageBGImageURL & """" end if If strDBType = "" then Response.Write "" & vbNewLine & _ "" & vbNewline & _ "" & strForumTitle & "" & vbNewline '## START - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewline '## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "

" & _ "" & fLang(strLangInc_Header00010) & "

" & _ " " & fLangN(strLangInc_Header00020,strDBType) & " " & _ "

" & _ "" & fLang(strLangInc_Header00030) & "
" & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine Response.End end if set my_Conn = Server.CreateObject("ADODB.Connection") my_Conn.Open strConnString if (strAuthType = "nt") then call NTauthenticate() if (ChkAccountReg() = "1") then call NTUser() end if end if if strGroupCategories = "1" then if Request.QueryString("Group") = "" then if Request.Cookies(strCookieURL & "GROUP") = "" Then Group = 2 else Group = Request.Cookies(strCookieURL & "GROUP") end if else Group = cLng(Request.QueryString("Group")) end if 'set default Session(strCookieURL & "GROUP_ICON") = "icon_group_categories.gif" Session(strCookieURL & "GROUP_IMAGE") = strTitleImage 'Forum_SQL - Group exists ? strSql = "SELECT GROUP_ID, GROUP_NAME, GROUP_ICON, GROUP_IMAGE " strSql = strSql & " FROM " & strTablePrefix & "GROUP_NAMES " strSql = strSql & " WHERE GROUP_ID = " & Group set rs2 = my_Conn.Execute (strSql) if rs2.EOF or rs2.BOF then Group = 2 strSql = "SELECT GROUP_ID, GROUP_NAME, GROUP_ICON, GROUP_IMAGE " strSql = strSql & " FROM " & strTablePrefix & "GROUP_NAMES " strSql = strSql & " WHERE GROUP_ID = " & Group set rs2 = my_Conn.Execute (strSql) end if Session(strCookieURL & "GROUP_NAME") = rs2("GROUP_NAME") if instr(rs2("GROUP_ICON"), ".") then Session(strCookieURL & "GROUP_ICON") = rs2("GROUP_ICON") end if if instr(rs2("GROUP_IMAGE"), ".") then Session(strCookieURL & "GROUP_IMAGE") = rs2("GROUP_IMAGE") end if rs2.Close set rs2 = nothing Response.Cookies(strCookieURL & "GROUP") = Group Response.Cookies(strCookieURL & "GROUP").Expires = dateAdd("d", intCookieDuration, strForumTimeAdjust) if Session(strCookieURL & "GROUP_IMAGE") <> "" then strTitleImage = Session(strCookieURL & "GROUP_IMAGE") end if end if strDBNTUserName = Request.Cookies(strUniqueID & "User")("Name") strDBNTFUserName = trim(chkString(Request.Form("Name"),"SQLString")) if strDBNTFUserName = "" then strDBNTFUserName = trim(chkString(Request.Form("User"),"SQLString")) if strAuthType = "nt" then strDBNTUserName = Session(strCookieURL & "userID") strDBNTFUserName = Session(strCookieURL & "userID") end if if strRequireReg = "1" and strDBNTUserName = "" then if not Instr(strScriptName,"policy.asp") > 0 and _ not Instr(strScriptName,"register.asp") > 0 and _ not Instr(strScriptName,"password.asp") > 0 and _ not Instr(strScriptName,"faq.asp") > 0 and _ not Instr(strScriptName,"searchlog.asp") > 0 and _ not Instr(strScriptName,"login.asp") > 0 then scriptname = split(request.servervariables("SCRIPT_NAME"),"/") if Request.QueryString <> "" then Response.Redirect("login.asp?target=" & lcase(scriptname(ubound(scriptname))) & "?" & Request.QueryString) else Response.Redirect("login.asp?target=" & lcase(scriptname(ubound(scriptname)))) end if end if end if select case Request.Form("Method_Type") case "login" strEncodedPassword = sha256("" & Request.Form("Password")) select case chkUser(strDBNTFUserName, strEncodedPassword,-1) case 1, 2, 3, 4 Call DoCookies(Request.Form("SavePassword")) strLoginStatus = 1 case else strLoginStatus = 0 end select case "logout" Call ClearCookies() end select if trim(strDBNTUserName) <> "" and trim(Request.Cookies(strUniqueID & "User")("Pword")) <> "" then chkCookie = 1 mLev = cLng(chkUser(strDBNTUserName, Request.Cookies(strUniqueID & "User")("Pword"),-1)) chkCookie = 0 else MemberID = -1 mLev = 0 end if '########## Ban User by Cookie Mod Call banUser() '#################################### %> <% select case Request.Form("Method_Type") case "login" if strLoginStatus = 1 then AUHandleLoging() end if case "logout" AUHandleLoging() end select ActiveUserTracker() 'if not Instr(request.servervariables("script_name"),"admin_") > 0 then if not Instr(strScriptName,"admin_") > 0 then %><% end if if mLev = 4 and strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" then '## Forum_SQL - Get membercount from DB strSql = "SELECT COUNT(MEMBER_ID) AS U_COUNT FROM " & strMemberTablePrefix & "MEMBERS_PENDING WHERE M_APPROVE = " & 0 set rs = Server.CreateObject("ADODB.Recordset") rs.open strSql, my_Conn if not rs.EOF then User_Count = cLng(rs("U_COUNT")) else User_Count = 0 end if rs.close set rs = nothing end if '## Local Time Display DayLightSave = Request.Cookies(strUniqueID & "DayLightSave") intLocalBias = Request.Cookies(strUniqueID & "LocalBias") if DayLightSave = "" then if MemberID > 0 then setTimeZone("") else intLocalBias = 0 DaylightSave = 0 end if end if '## Local Time Display sectionID= request.QueryString("sectionID") if sectionID = "" then sectionID = session("sectionID") else session("sectionID") = sectionID end if if strShowUserGroups = "1" then if Session(strCookieURL & "UserGroups" & MemberID) = "" or _ IsNull(Session(strCookieURL & "UserGroups" & MemberID)) then strGroupMembership = getGroupMembership(MemberID,1) Session(strCookieURL & "UserGroups" & MemberID) = strGroupMembership Session(strCookieURL & "UserGroups" & MemberID) = strGroupMembership end if end if Response.Write "" & vbNewline & vbNewline & _ "" & vbNewline & _ "" & GetNewTitle(strScriptName) & "" & vbNewline %><% Response.Write "" & vbNewline %><% Response.Write "" & vbNewline if strShowJavaMenu = "1" then if mlev = 0 then strJavaMenuTop = intJavaMenuLogoutNum else strJavaMenuTop = intJavaMenuLoginNum end if Response.Write "" & vbNewLine %> <% end if '## START - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewline '## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT %> <% Response.Write "" & vbNewLine & _ vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine Response.Write "" & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then CornerH = "default" else CornerH = "" end if Response.Write "" & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then CornerH1 = "headfoot" else CornerH1 = "" end if Response.Write "" & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then Response.Write "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write "" & vbNewLine & _ "
" & getCurrentSkinIcon(strIconTableTopLeft,"","") & "" & getCurrentSkinIcon(strIconTableTop,"","") & "" & getCurrentSkinIcon(strIconTableTopRight,"","") & "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " ") Response.write"" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then Response.Write "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
   " & vbNewLine & _ "
" & vbNewLine Response.write ("
   ") Call IntroText ' Display Text (describing section) Response.write ("
" %><% if strTopSite = "1" then Response.write"" & vbNewLine end if %><% Response.Write " " & vbNewLine & _ " " & vbNewLine select case Request.Form("Method_Type") case "login" Response.Write "
" & vbNewLine & _ "
" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & getCurrentSkinIcon(strIconMainTop,"","") & vbNewLine & _ "
" & vbNewLine else Response.Write "" & vbNewLine & _ "" & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine& _ "
" & vbNewLine end if if strLoginStatus = 0 then Response.Write "


" & fLang(strLangInc_Header00040) & "

" & vbNewLine & _ "

" & fLang(strLangInc_Header00050) & "

" & vbNewLine & _ "

" & fLang(strLangInc_Header00410) & " | " & vbNewLine & _ "" & fLang(strLangInc_Header00420) & "


" & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then Response.Write "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then CornerH2 = "default" else CornerH2 = "forumcellcolor" end if Response.Write " " & vbNewLine & _ " " & vbNewLine if strShowJavaMenu = "0" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if (strPMStatus = "1") then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine end if Response.Write "" & vbNewLine & _ "
" & vbNewLine else Response.Write "


" & fLang(strLangInc_Header00430) & "

" & vbNewLine & _ "" & vbNewLine & _ "
" & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine end if WriteFooter Response.End case "logout" Response.Write "
" & vbNewLine & _ "
" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write "
" & vbNewLine & _ " " & getCurrentSkinIcon(strIconMainTop,"","") & vbNewLine & _ "
" & vbNewLine else Response.Write "" & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine& _ "
" & vbNewLine end if Response.Write "


" & fLang(strLangInc_Header00440) & "


" & vbNewLine & _ "" & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if else Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strShowJavaMenu = "0" then if (mlev = 3) and strModeratorHome = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if (mlev = 4) or (lcase(strNoCookies) = "1") then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if Response.Write " " & vbNewLine end if Response.Write "
" & vbNewLine WriteFooter Response.End end select if (mlev = 0) then if not(Instr(Request.ServerVariables("Path_Info"), "register.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "policy.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "pop_profile.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "search.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "login.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "password.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "searchlog.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "faq.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "post.asp") > 0) then Response.Write "
" & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine else if (strAuthType = "nt") then Response.Write " " & vbNewLine end if end if Response.Write " " & vbNewLine if (lcase(strNoCookies) = "1") then Response.Write " |" & vbNewLine & _ " " & fLang(strLangInc_Header00190) & "" & vbNewLine end if Response.Write " " & vbNewLine & _ " " & vbNewLine end if Response.Write "
" & vbNewLine if (strAuthType = "db") then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & fLang(strLangInc_Header00100) & "
" & fLang(strLangInc_Header00110) & "
" & vbNewLine & _ " " & fLang(strLangInc_Header00130) & "
" & vbNewLine & _ "

" & vbNewLine if strGfxButtons = "1" then Response.Write " " & vbNewLine else Response.Write " " & vbNewLine end if Response.Write "
" & fLang(strLangInc_Header00280) & "" & vbNewLine Call LangShowLanguageSelector("") if (lcase(strEmail) = "1") then Response.Write "
" & fLang(strLangInc_Header00160) & " " if strAuthType = "nt" then Response.Write("Admin ") Response.Write " " & fLang(strLangInc_Header00170) & "
" & vbNewLine Response.Write "
" & fLangN(strLangInc_Header00140, "" & "|" & "") & "
" & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "

" & vbNewLine if strAuthType="nt" then Response.Write "" & Session(strCookieURL & "username") & " (" & Session(strCookieURL & "userid") & ")
 " & vbNewLine else if strAuthType = "db" then Response.Write "" & profileLink(ChkString(strDBNTUserName, "display"),MemberID) & "
" & vbNewLine if strGfxButtons = "1" then Response.Write "" else Response.Write "" end if end if end if Call LangShowLanguageSelector("") Response.Write "
" & vbNewLine & _ "
" & fLang(strLangInc_Header00790) & "" Response.Write "

" & fLang(strLangInc_Header00190) & "" if mLev = 4 and (strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" and User_Count > 0) then Response.Write(" | " & fLangN(strLangInc_Header00220,User_Count) & "") Response.Write "

" & vbNewLine & _ "
" & vbNewLine Response.write "" & vbNewLine & _ " " & vbNewLine if strTheme = "1" and strHFCornerIcon = "1" and flag_showhfroundedcorners or strHFCornerAddonIcon = "1" and flag_showhfroundedcorners then CornerH3 = "headfoot" else CornerH3 = "header" end if Response.write " " & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine if strShowJavaMenu = "1" then sForumNavigation2() Response.Write " " & vbNewLine else sForumNavigation() end if Response.Write "
" & vbNewLine Response.Write "
" & vbNewLine & _ " " & getCurrentSkinIcon(strIconMainTop,"","") & "
" & vbNewLine & _ "
" & vbNewLine & _ "
" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine %> <% Response.Write " " & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine Call Level1Links ' Display Level 1 Links Response.Write " " & vbNewLine & _ "
" & vbNewLine & _ "
" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine call Level2Links ' Display Level 2 Links Response.Write " " & vbNewLine & _ "
" & vbNewLine & _ "
" & vbNewLine Response.Write "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine %><% if strShowSkinSelector = "1" then Response.Write " " & vbNewLine & _ "" & vbNewLine end if %><% Response.Write " " & vbNewLine & _ "
" & vbNewLine %> <% Response.Write " " & vbNewLine & _ " " & fLang(strLangInc_Header00770) & "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine & _ "
" & vbNewLine & _ "
" & vbNewLine & _ "" & vbNewLine %> <% Response.Write "
" & vbNewLine & _ "
" & vbNewLine '########### Front Page News ########### %> <% '######## Front Page News ############## Response.Write "" & vbNewLine '########### GROUP Categories ########### %> <% '######## GROUP Categories ############## Response.Write " " & vbNewLine & _ "
" & vbNewLine sub sForumNavigation2() ' DEM --> Added code to show the subscription line if strSubscription > 0 and strEmail = "1" then if mlev > 0 then strSql = "SELECT COUNT(*) AS MySubCount FROM " & strTablePrefix & "SUBSCRIPTIONS" strSql = strSql & " WHERE MEMBER_ID = " & MemberID set rsCount = my_Conn.Execute (strSql) if rsCount.BOF or rsCount.EOF then ' No Subscriptions found, do nothing MySubCount = 0 rsCount.Close set rsCount = nothing else MySubCount = rsCount("MySubCount") rsCount.Close set rsCount = nothing end if if mLev = 4 then strSql = "SELECT COUNT(*) AS SubCount FROM " & strTablePrefix & "SUBSCRIPTIONS" set rsCount = my_Conn.Execute (strSql) if rsCount.BOF or rsCount.EOF then ' No Subscriptions found, do nothing SubCount = 0 rsCount.Close set rsCount = nothing else SubCount = rsCount("SubCount") rsCount.Close set rsCount = nothing end if end if else SubCount = 0 MySubCount = 0 end if else SubCount = 0 MySubCount = 0 end if end sub sub sForumNavigation() ' DEM --> Added code to show the subscription line sForumNavigation2() Response.Write "   " & fLang(strLangInc_Header00240) & "" & vbNewline & _ "  " & vbNewline Response.Write " " & fLang(strLangSite_Portal00010) & "" & vbNewline & _ "  " & vbNewline Response.Write " " & fLang(strLangForums00010) & "" & vbNewline Response.Write "  " & vbNewline if (mlev = 1 or mlev = 2 or mlev = 3 or mlev = 4) or (lcase(strNoCookies) = "1") then if strUseExtendedProfile then Response.Write " " & fLang(strLangInc_Header00260) & "" & vbNewline Response.Write "  " & vbNewline else Response.Write " " & fLang(strLangInc_Header00260) & "" & vbNewline Response.Write "  " & vbNewline end if else end if if strShowEvents = "1" then Response.Write " " & fLang(strLangEvents_Calendar00010) & "" & vbNewline Response.Write "  " & vbNewline end if Response.Write " " & fLang(strLangThe_Rabble00010) & "" & vbNewline if strGuestbook = "1" then Response.Write "  " & vbNewline & _ " " & fLang(strLangGuest_Book00010) & "" & vbNewline end if Response.Write "  " & vbNewline & _ " " & fLang(strLangInc_Header00400) & "" & vbNewline & _ "  " & vbNewline if strAutoLogon <> "1" then If mlev = 0 then if strProhibitNewMembers <> "1" then Response.Write "  " & vbNewline & _ " " & fLang(strLangInc_Header00280) & "" & vbNewline end if else end if end if Response.Write "" & vbNewline end sub if strGroupCategories = "1" then if Session(strCookieURL & "GROUP_NAME") = "" then GROUPNAME = " Default Groups " else GROUPNAME = Session(strCookieURL & "GROUP_NAME") end if 'Forum_SQL - Get Groups strSql = "SELECT GROUP_ID, GROUP_CATID " strSql = strSql & " FROM " & strTablePrefix & "GROUPS " strSql = strSql & " WHERE GROUP_ID = " & Group set rsgroups = Server.CreateObject("ADODB.Recordset") rsgroups.Open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsgroups.EOF then recGroupCatCount = "" else allGroupCatData = rsgroups.GetRows(adGetRowsRest) recGroupCatCount = UBound(allGroupCatData, 2) end if rsgroups.Close set rsgroups = nothing end if '########## Ban User by Cookie Mod Sub banUser() if Request.Form("Method_Type") = "login" AND strLoginStatus = 0 then '## Forum SQL - Get user status strSql = "SELECT M_STATUS " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE MEMBER_ID = " & getMemberNumber(strDBNTFUserName) & " AND " strSql = strSql & " M_PASSWORD = '" & ChkString(strEncodedPassword,"SQLString") & "'" set rsSTATUS = my_Conn.Execute(strSql) if rsSTATUS.EOF OR rsSTATUS.BOF then 'DO Nothing elseif rsSTATUS("M_STATUS") = "0" then if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "Status").Path = strCookieURL else Response.Cookies(strUniqueID & "Status").Path = "/" end if Response.Cookies(strUniqueID & "Status")("banUser") = "1" Response.Cookies(strUniqueID & "Status").Expires = dateAdd("d", 3650, strForumTimeAdjust) errMsg = "Your account has been de-activated!" end if rsSTATUS.close set rsSTATUS = nothing end if Dim strScriptName, aryScriptName aryScriptName = Split(Request.ServerVariables("SCRIPT_NAME"), "/") strScriptName = aryScriptName(UBound(aryScriptName)) if (strScriptName = "policy.asp" OR strScriptName = "register.asp") AND Request.Cookies(strUniqueID & "Status")("banUser") = "1" then Response.Redirect "faq.asp" end if end Sub '########## END Ban User by Cookie Mod if strBanIP = "1" then %><% end if %>