<%
'#################################################################################
'## 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 "CloseTopic"
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 = " & 0
'#################### Do not archive code #################################
if Request.Form("noArchiveFlag") = "1" then
strSQL = strSql & ", " & strTablePrefix & "TOPICS.T_ARCHIVE_FLAG = " & 0
else
strSQL = strSql & ", " & strTablePrefix & "TOPICS.T_ARCHIVE_FLAG = " & 1
end if
'#################### Do not archive code #################################
strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.Form("TOPIC_ID")
my_Conn.Execute (strSql)
%>
Topic Locked!
<% Else %>
No Permissions to Lock Topic
Go Back to Re-Authenticate
<% end if %>
<% Else %>
No Permissions to Lock Topic
Go Back to Re-Authenticate
<%
end if
case "CloseForum"
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 = 0 "
strSql = strSql & " WHERE " & strTablePrefix & "FORUM.FORUM_ID = " & Request.Form("FORUM_ID")
my_Conn.Execute (strSql)
%>
Forum Locked!
<% else %>
No Permissions to Lock Forum
Go Back to Re-Authenticate
<% end if %>
<% else %>
No Permissions to Lock Forum
Go Back to Re-Authenticate
<%
end if
case "CloseCategory"
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 = 0 "
strSql = strSql & " WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & Request.Form("CAT_ID")
my_Conn.Execute (strSql)
%>
Category Locked!
<% else %>
No Permissions to Lock Category
Go Back to Re-Authenticate
<% end if %>
<% else %>
No Permissions to Lock Category
Go Back to Re-Authenticate
<%
end if
case "LockMember"
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 = 0 "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & Request.Form("MEMBER_ID")
my_Conn.Execute (strSql)
%>
Member Locked!
<% else %>
No Permissions to Lock a Member
Go Back to Re-Authenticate
<% end if %>
<% else %>
No Permissions to Lock a Member
Go Back to Re-Authenticate
<%
end if
case else
%>
Lock <% if Request.Querystring("mode") = "Topic" then Response.Write("Topic") %><% if Request.Querystring("mode") = "Forum" then Response.Write("Forum") %><% if Request.Querystring("mode") = "Category" then Response.Write("Category") %><% if Request.Querystring("mode") = "Member" then Response.Write("Member") %>
NOTE:
<% select case Request.QueryString("mode") %>
<% case "Member" %>
Only Administrators can lock a Member.
<% case "Category" %>
Only Administrators can lock a Category.
<% case "Forum" %>
Only Moderators and Administrators can lock a Forum.
<% case "Topic" %>
Only Moderators and Administrators can lock a Topic.
<% end select %>
<% end select %>