<%
'#################################################################################
'## 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)
%>
Topic Un-Locked!
<% else %>
No Permissions to Un-Lock Topic
Back
<% end if %>
<% else %>
No Permissions to Un-Lock Topic
Back
<%
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)
%>
Forum Un-Locked!
<% else %>
No Permissions to Un-Lock Forum
Go Back to Re-Authenticate
<% end if %>
<% else %>
No Permissions to Un-Lock Forum
Go Back to Re-Authenticate
<%
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)
%>
Category Un-Locked!
<% else %>
No Permissions to Un-Lock Category
Go Back to Re-Authenticate
<% end if %>
<% else %>
No Permissions to Un-Lock Category
Go Back to Re-Authenticate
<%
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)
%>
Member Un-Locked!
<% else %>
No Permissions to Un-Lock a Member
Go Back to Re-Authenticate
<% end if %>
<% else %>
No Permissions to Un-Lock a Member
Go Back to Re-Authenticate
<%
end if
case else
%>
Un-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:
<% if Request.QueryString("mode") = "Member" then %>
Only Administrators can un-lock a Member.
<% else %>
<% if Request.QueryString("mode") = "Category" then %>
Only Administrators can un-lock a Category.
<% else %>
<% if Request.QueryString("mode") = "Forum" then %>
Only Administrators can un-lock a Forum.
<% else %>
<% if Request.QueryString("mode") = "Topic" then %>
Only Moderators and Administrators can un-lock a Topic.
<% end if %>
<% end if %>
<% end if %>
<% end if %>
<% end select %>