<%
'#################################################################################
'## 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
'#################################################################################
%>
<%
Select case Request.QueryString("mode")
case "OpenTopic"
mLev = cint(ChkUser(strDBNTFUserName, Request.Form("Pass")))
if mLev > 0 then '## is Member
if (chkForumModerator(Request.Form("FORUM_ID"), Request.Form("Name")) = "1") or _
(mLev = 4) or _
(chkForumModerator(Request.Form("FORUM_ID"), Session(strCookieURL & "userid")) = "1") then
'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "TOPICS "
strSql = strSql & " SET " & strTablePrefix & "TOPICS.T_STATUS = 1 "
'#################### Archive code change #################################
strSQL = strSql & ", " & strTablePrefix & "TOPICS.T_ARCHIVE_FLAG = 1"
'#################### Lock in place code #################################
strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.Form("TOPIC_ID")
my_Conn.Execute (strSql)
%>
<% =fLang(strLangPop_Open00010) %>
<% else %>
<% =fLang(strLangPop_Open00020) %>
<% =fLang(strLangPop_Open00030) %>
<% end if %>
<% else %>
<% =fLang(strLangPop_Open00020) %>
<% =fLang(strLangPop_Open00030) %>
<%
end if
case "OpenForum"
mLev = cint(chkUser(strDBNTFUserName, Request.Form("Pass")))
if mLev > 0 then '## is Member
if (chkForumModerator(Request.Form("FORUM_ID"), Request.Form("Name")) = "1") or (mLev = 4) or (chkForumModerator(Request.Form("FORUM_ID"), Session(strCookieURL & "userid")) = "1")then
'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET " & strTablePrefix & "FORUM.F_STATUS = 1 "
strSql = strSql & " WHERE " & strTablePrefix & "FORUM.FORUM_ID = " & Request.Form("FORUM_ID")
my_Conn.Execute (strSql)
%>
<% =fLang(strLangPop_Open00040) %>
<% else %>
<% =fLang(strLangPop_Open00050) %>
<% =fLang(strLangPop_Open00060) %>
<% end if %>
<% else %>
<% =fLang(strLangPop_Open00050) %>
<% =fLang(strLangPop_Open00060) %>
<%
end if
case "OpenCategory"
mLev = cint(ChkUser(strDBNTFUserName, Request.Form("Pass")))
if mLev > 0 then '## is Member
if mLev =4 then
'## Forum_SQL
strSql = "UPDATE " & strTablePrefix & "CATEGORY "
strSql = strSql & " SET " & strTablePrefix & "CATEGORY.CAT_STATUS = 1 "
strSql = strSql & " WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & Request.Form("CAT_ID")
my_Conn.Execute (strSql)
%>
<% =fLang(strLangPop_Open00070) %>
<% else %>
<% =fLang(strLangPop_Open00080) %>
<% =fLang(strLangPop_Open00060) %>
<% end if %>
<% else %>
<% =fLang(strLangPop_Open00080) %>
<% =fLang(strLangPop_Open00060) %>
<%
end if
case "UnLockMember"
mLev = cint(ChkUser(strDBNTFUserName, Request.Form("Pass")))
if mLev > 0 then '## is Member
if mLev =4 then
'## Forum_SQL
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET " & strMemberTablePrefix & "MEMBERS.M_STATUS = 1 "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & Request.Form("MEMBER_ID")
my_Conn.Execute (strSql)
%>
<% =fLang(strLangPop_Open00090) %>
<% else %>
<% =fLang(strLangPop_Open00100) %>
<% =fLang(strLangPop_Open00060) %>
<% end if %>
<% else %>
<% =fLang(strLangPop_Open00100) %>
<% =fLang(strLangPop_Open00060) %>
<%
end if
case else
%>
<% select case Request.Querystring("mode")
case "Topic" response.write fLang(strLangPop_Open00110)
case "Forum" response.write fLang(strLangPop_Open00120)
case "Category" response.write fLang(strLangPop_Open00130)
case "Member" response.write fLang(strLangPop_Open00140)
end select
%>
<% =fLang(strLangPop_Open00150) %>
<% select case Request.QueryString("mode")
case "Member" response.write fLang(strLangPop_Open00160)
case "Category" response.write fLang(strLangPop_Open00170)
case "Forum" response.write fLang(strLangPop_Open00180)
case "Topic" response.write fLang(strLangPop_Open00190)
end select
%>
<% end select %>