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