manage_delaction.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 rsDel = Server.CreateObject("ADODB.Recordset")
For I=0 To IDNum
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&IDArray(I)
rsDel.Open Sql,ConnY,3,3
If rsDel.Eof Then
Note=Note&" ID."&IDArray(I)&"操作失败;"
rsDel.Close
Else
Set rsCut = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsDel("rPoster")&"'"
rsCut.Open Sql,ConnY,3,3
GetRepID=rsDel("rRepID")
If rsDel("rRepID")=0 Then
ADo="(原贴)惩罚:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_DPE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_DPA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_DPG&"</font>"
rsCut("rMainDeleteNum")=rsCut("rMainDeleteNum")+1
rsCut("rExp")=rsCut("rExp")-Forum_DPE
rsCut("rAssets")=rsCut("rAssets")-Forum_DPA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_DPG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
Else
IsReply=True
ADo="(回贴)惩罚:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_DRE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_DRA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_DRG&"</font>"
rsCut("rMainDeleteNum")=rsCut("rMainDeleteNum")+1
rsCut("rExp")=rsCut("rExp")-Forum_DRE
rsCut("rAssets")=rsCut("rAssets")-Forum_DRA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_DRG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
End If
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsDel("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsDel("rID")&") 删除 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsDel.Delete
rsDel.Close
Note=Note&" ID."&IDArray(I)&"操作成功;"
End If
If IsReply Then
Set rsA = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&GetRepID
rsA.Open Sql,ConnY,3,3
Set rsB = Server.CreateObject("ADODB.Recordset")
Sql = "Select Top 1 * From tArticleManage Where rSubject="&Forum_ID&" And rRepID="&GetRepID&" Order By rPostTime Desc"
rsB.Open Sql,ConnY,3,3
If rsA("rReplyNum")>1 Then
rsA("rLastReplyUser")=rsB("rPosterNickName")
rsA("rLastReplyTime")=rsB("rPostTime")
Else
rsA("rLastReplyUser")=""
End If
rsA("rReplyNum")=rsA("rReplyNum")-1
rsA.Update
rsB.Close
Set rsB=Nothing
rsA.Close
Set rsA=Nothing
End If
Next
Set rsDel=Nothing
End If

'批量删除帖子
If FromID<>"" And ToID<>"" Then
Set rsDel = Server.CreateObject("ADODB.Recordset")
For I=FromID To ToID
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&I
rsDel.Open Sql,ConnY,3,3
If rsDel.Eof Then
Note=Note&" ID."&I&"操作失败;"
rsDel.Close
Else
Set rsCut = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsDel("rPoster")&"'"
rsCut.Open Sql,ConnY,3,3
GetRepID=rsDel("rRepID")
If rsDel("rRepID")=0 Then
ADo="(原贴)惩罚:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_DPE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_DPA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_DPG&"</font>"
rsCut("rMainDeleteNum")=rsCut("rMainDeleteNum")+1
rsCut("rExp")=rsCut("rExp")-Forum_DPE
rsCut("rAssets")=rsCut("rAssets")-Forum_DPA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_DPG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
Else
Set rsA = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&rsDel("rRepID")
rsA.Open Sql,ConnY,3,3
Set rsB = Server.CreateObject("ADODB.Recordset")
Sql = "Select Top 1 * From tArticleManage Where rSubject="&Forum_ID&" And rRepID="&rsDel("rRepID")&" Order By rPostTime Desc"
rsB.Open Sql,ConnY,3,3
rsA("rLastReplyUser")=rsB("rPosterNickName")
rsA("rReplyNum")=rsA("rReplyNum")-1
rsA.Update
rsB.Close
Set rsB=Nothing
rsA.Close
ADo="(回贴)惩罚:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_DRE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_DRA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_DRG&"</font>"
rsCut("rMainDeleteNum")=rsCut("rMainDeleteNum")+1
rsCut("rExp")=rsCut("rExp")-Forum_DRE
rsCut("rAssets")=rsCut("rAssets")-Forum_DRA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_DRG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
End If
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsDel("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsDel("rID")&") 删除 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsDel.Delete
rsDel.Close
Note=Note&" ID."&I&"操作成功;"
End If
If IsReply Then
Set rsA = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&GetRepID
rsA.Open Sql,ConnY,3,3
Set rsB = Server.CreateObject("ADODB.Recordset")
Sql = "Select Top 1 * From tArticleManage Where rSubject="&Forum_ID&" And rRepID="&GetRepID&" Order By rPostTime Desc"
rsB.Open Sql,ConnY,3,3
If rsA("rReplyNum")>1 Then
rsA("rLastReplyUser")=rsB("rPosterNickName")
rsA("rLastReplyTime")=rsB("rPostTime")
Else
rsA("rLastReplyUser")=""
End If
rsA("rReplyNum")=rsA("rReplyNum")-1
rsA.Update
rsB.Close
Set rsB=Nothing
rsA.Close
Set rsA=Nothing
End If
Next
Set rsDel=Nothing
End If

'删除指定用户所有在本版的帖子.
If User<>"" Then
Set rsDel = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rPosterNickName='"&User&"'"
rsDel.Open Sql,ConnY,3,3
If rsDel.Eof Then
Note="操作失败或者无此用户"
rsDel.Close
Else
While Not rsDel.Eof And Not rsDel.Bof
Note=Note&" ID."&rsDel("rID")&"操作成功;"
Set rsCut = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsDel("rPoster")&"'"
rsCut.Open Sql,ConnY,3,3
GetRepID=rsDel("rRepID")
If rsDel("rRepID")=0 Then
ADo="(原贴)惩罚:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_DPE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_DPA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_DPG&"</font>"
rsCut("rMainDeleteNum")=rsCut("rMainDeleteNum")+1
rsCut("rExp")=rsCut("rExp")-Forum_DPE
rsCut("rAssets")=rsCut("rAssets")-Forum_DPA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_DPG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
Else
Set rsA = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&rsDel("rRepID")
rsA.Open Sql,ConnY,3,3
Set rsB = Server.CreateObject("ADODB.Recordset")
Sql = "Select Top 1 * From tArticleManage Where rSubject="&Forum_ID&" And rRepID="&rsDel("rRepID")&" Order By rPostTime Desc"
rsB.Open Sql,ConnY,3,3
rsA("rLastReplyUser")=rsB("rPosterNickName")
rsA("rReplyNum")=rsA("rReplyNum")-1
rsA.Update
rsB.Close
Set rsB=Nothing
rsA.Close
ADo="(回贴)惩罚:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_DRE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_DRA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_DRG&"</font>"
rsCut("rMainDeleteNum")=rsCut("rMainDeleteNum")+1
rsCut("rExp")=rsCut("rExp")-Forum_DRE
rsCut("rAssets")=rsCut("rAssets")-Forum_DRA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_DRG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
End If
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsDel("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsDel("rID")&") 删除 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsDel.Delete
rsDel.MoveNext
If IsReply Then
Set rsA = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&GetRepID
rsA.Open Sql,ConnY,3,3
Set rsB = Server.CreateObject("ADODB.Recordset")
Sql = "Select Top 1 * From tArticleManage Where rSubject="&Forum_ID&" And rRepID="&GetRepID&" Order By rPostTime Desc"
rsB.Open Sql,ConnY,3,3
If rsA("rReplyNum")>1 Then
rsA("rLastReplyUser")=rsB("rPosterNickName")
rsA("rLastReplyTime")=rsB("rPostTime")
Else
rsA("rLastReplyUser")=""
End If
rsA("rReplyNum")=rsA("rReplyNum")-1
rsA.Update
rsB.Close
Set rsB=Nothing
rsA.Close
Set rsA=Nothing
End If
Wend
End If
Set rsDel=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_Del.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>