<%
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 %>