manage_uninvaction.asp

5237 论坛.rar

<!--#include file="Connections/connY.asp" -->
<!--#include file="Inc/Set.asp" -->
<!--#include file="Inc/Level01.asp" -->
<%
'定义参数
ID=Request.Form("ID")
IDArray=Split(ID,"|")
IDNum=UBound(IDArray)
FromID=Request.Form("FromID")
ToID=Request.Form("ToID")
User=Request.Form("User")

'撤消屏蔽指定帖子
If ID<>"" Then
Set rsUnInv = Server.CreateObject("ADODB.Recordset")
For I=0 To IDNum
Sql = "Select *  From tArticleManage Where rIsVisible And rSubject="&Forum_ID&" And rID="&IDArray(I)
rsUnInv.Open Sql,ConnY,3,3
If rsUnInv.Eof Then
Note=Note&" ID."&IDArray(I)&"操作失败;"
rsUnInv.Close
Else
Set rsAdd = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsUnInv("rPoster")&"'"
rsAdd.Open Sql,ConnY,3,3
If rsUnInv("rRepID")=0 Then
ADo="(原贴)补偿:经验值<font color='"&Forum_PFontColor&"'>+"&Forum_UIPE&"</font> 财产<font color='"&Forum_PFontColor&"'>+"&Forum_UIPA&"</font> 魅力<font color='"&Forum_PFontColor&"'>+"&Forum_UIPG&"</font>"
rsAdd("rExp")=rsAdd("rExp")+Forum_UIPE
rsAdd("rAssets")=rsAdd("rAssets")+Forum_UIPA
rsAdd("rGlamour")=rsAdd("rGlamour")+Forum_UIPG
rsAdd.Update
rsAdd.Close
Set rsAdd=Nothing
Else
ADo="(回贴)补偿:经验值<font color='"&Forum_PFontColor&"'>+"&Forum_UIRE&"</font> 财产<font color='"&Forum_PFontColor&"'>+"&Forum_UIRA&"</font> 魅力<font color='"&Forum_PFontColor&"'>+"&Forum_UIRG&"</font>"
rsAdd("rExp")=rsAdd("rExp")+Forum_UIRE
rsAdd("rAssets")=rsAdd("rAssets")+Forum_UIRA
rsAdd("rGlamour")=rsAdd("rGlamour")+Forum_UIRG
rsAdd.Update
rsAdd.Close
Set rsAdd=Nothing
End If
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsUnInv("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsUnInv("rID")&") 撤消屏蔽 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsUnInv("rIsVisible")=False
rsUnInv.Update
rsUnInv.Close
Note=Note&" ID."&IDArray(I)&"操作成功;"
End If
Next
Set rsUnInv=Nothing
End If

'撤消屏蔽置顶帖子
If FromID<>"" And ToID<>"" Then
Set rsUnInv = Server.CreateObject("ADODB.Recordset")
For I=FromID To ToID
Sql = "Select *  From tArticleManage Where rIsVisible And rSubject="&Forum_ID&" And rID="&I
rsUnInv.Open Sql,ConnY,3,3
If rsUnInv.Eof Then
Note=Note&" ID."&I&"操作失败;"
rsUnInv.Close
Else
Set rsAdd = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsUnInv("rPoster")&"'"
rsAdd.Open Sql,ConnY,3,3
If rsUnInv("rRepID")=0 Then
ADo="(原贴)补偿:经验值<font color='"&Forum_PFontColor&"'>+"&Forum_UIPE&"</font> 财产<font color='"&Forum_PFontColor&"'>+"&Forum_UIPA&"</font> 魅力<font color='"&Forum_PFontColor&"'>+"&Forum_UIPG&"</font>"
rsAdd("rExp")=rsAdd("rExp")+Forum_UIPE
rsAdd("rAssets")=rsAdd("rAssets")+Forum_UIPA
rsAdd("rGlamour")=rsAdd("rGlamour")+Forum_UIPG
rsAdd.Update
rsAdd.Close
Set rsAdd=Nothing
Else
ADo="(回贴)补偿:经验值<font color='"&Forum_PFontColor&"'>+"&Forum_UIRE&"</font> 财产<font color='"&Forum_PFontColor&"'>+"&Forum_UIRA&"</font> 魅力<font color='"&Forum_PFontColor&"'>+"&Forum_UIRG&"</font>"
rsAdd("rExp")=rsAdd("rExp")+Forum_UIRE
rsAdd("rAssets")=rsAdd("rAssets")+Forum_UIRA
rsAdd("rGlamour")=rsAdd("rGlamour")+Forum_UIRG
rsAdd.Update
rsAdd.Close
Set rsAdd=Nothing
End If
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsUnInv("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsUnInv("rID")&") 撤消屏蔽 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsUnInv("rIsVisible")=False
rsUnInv.Update
rsUnInv.Close
Note=Note&" ID."&I&"操作成功;"
End If
Next
Set rsUnInv=Nothing
End If

'撤消屏蔽指定用户所有在本版的帖子.
If User<>"" Then
Set rsUnInv = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rIsVisible And rSubject="&Forum_ID&" And rPosterNickName='"&User&"'"
rsUnInv.Open Sql,ConnY,3,3
If rsUnInv.Eof Then
Note="操作失败或者无此用户"
rsUnInv.Close
Else
While Not rsUnInv.Eof And Not rsUnInv.Bof
Note=Note&" ID."&rsUnInv("rID")&"操作成功;"
Set rsAdd = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsUnInv("rPoster")&"'"
rsAdd.Open Sql,ConnY,3,3
If rsUnInv("rRepID")=0 Then
ADo="(原贴)补偿:经验值<font color='"&Forum_PFontColor&"'>+"&Forum_UIPE&"</font> 财产<font color='"&Forum_PFontColor&"'>+"&Forum_UIPA&"</font> 魅力<font color='"&Forum_PFontColor&"'>+"&Forum_UIPG&"</font>"
rsAdd("rExp")=rsAdd("rExp")+Forum_UIPE
rsAdd("rAssets")=rsAdd("rAssets")+Forum_UIPA
rsAdd("rGlamour")=rsAdd("rGlamour")+Forum_UIPG
rsAdd.Update
rsAdd.Close
Set rsAdd=Nothing
Else
ADo="(回贴)补偿:经验值<font color='"&Forum_PFontColor&"'>+"&Forum_UIRE&"</font> 财产<font color='"&Forum_PFontColor&"'>+"&Forum_UIRA&"</font> 魅力<font color='"&Forum_PFontColor&"'>+"&Forum_UIRG&"</font>"
rsAdd("rExp")=rsAdd("rExp")+Forum_UIRE
rsAdd("rAssets")=rsAdd("rAssets")+Forum_UIRA
rsAdd("rGlamour")=rsAdd("rGlamour")+Forum_UIRG
rsAdd.Update
rsAdd.Close
Set rsAdd=Nothing
End If
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsUnInv("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsUnInv("rID")&") 撤消屏蔽 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsUnInv("rIsVisible")=False
rsUnInv.Update
rsUnInv.MoveNext
Wend
End If
Set rsUnInv=Nothing
End If
%>
<html>
<head>
<title><%=Forum_Title%></title>
<meta http-equiv="Content-Type" content="text/html;">
<meta http-equiv="Expires" CONTENT="0">
<meta http-equiv="Cache-Control" CONTENT="no-cache">
<meta http-equiv="Pragma" CONTENT="no-cache">
<!--#include file="Inc/Css.asp" -->
</head>
<body leftmargin="0" topmargin="0"  bgcolor="<%=Forum_BgColor%>" vlink="<%=Forum_Css_A_Link_Color%>">
<!--#include file="Inc/Top.asp" -->
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="<%=Forum_BorderColor%>">
  <tr> 
    <td height="20" bgcolor="<%=Forum_BgColor%>"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" class="font">
        <tr> 
          <td>&nbsp;您所在的位置： <a href="../" onFocus="this.blur()">首页</a> &gt;&gt; 
            <a href="List.asp" onFocus="this.blur()">讨论组</a> &gt;&gt; <a href="List.asp?T=<%=Forum_TypeID%>"  onFocus="this.blur()"><%=Forum_TypeName%></a> 
            &gt;&gt; <a href="Board.asp?S=<%=Forum_ID%>" onFocus="this.blur()"><%=Forum_Name%></a> 
            &gt;&gt; <a href="Manage.asp?S=<%=Forum_ID%>" onFocus="this.blur()">版面管理</a> 
            &gt;&gt; <font color="<%=Forum_NavFontColor%>">撤消屏蔽</font></td>
          <td width="150"></td>
          <td width="18"> </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td height=1></td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="2" align="center" class="font" bgcolor="<%=Forum_BorderColor%>">
  <tr>
    <td  bgcolor="<%=Forum_BgColor%>" height="394"> 
      <div align="center"> 
        <table width="400" border="0" cellspacing="1" cellpadding="2" bgcolor="<%=Forum_BorderColor%>" class="font">
          <tr> 
            <td height="100" bgcolor="<%=Forum_AlternateColor1%>"> 
              <div align="center"> <font color="<%=Forum_PFontColor%>"><%=Note%></font> 
                <br>
                <br>
                <a href="Manage_Inv.asp?S=<%=Forum_ID%>" onFocus="this.blur()">返回撤消屏蔽页面</a></div>
            </td>
          </tr>
        </table>
        <br>
        <br>
        <br>
        <br>
        <br>
        <br>
      </div>
    </td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="0" cellpadding="0" align="center" id=infoborder style="DISPLAY: none">
  <tr> 
    <td height=1></td>
  </tr>
</table>
<!--#include file="Inc/Bottom.asp" -->
</body>
</html>