manage_unsoulaction.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 rsUnSoul = Server.CreateObject("ADODB.Recordset")
For I=0 To IDNum
Sql = "Select *  From tArticleManage Where rIsQuintessence And rSubject="&Forum_ID&" And rID="&IDArray(I)
rsUnSoul.Open Sql,ConnY,3,3
If rsUnSoul.Eof Then
Note=Note&" ID."&IDArray(I)&"操作失败;"
rsUnSoul.Close
Else
Set rsCut = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsUnSoul("rPoster")&"'"
rsCut.Open Sql,ConnY,3,3
ADo="回收:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_USE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_USA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_USG&"</font>"
rsCut("rExp")=rsCut("rExp")-Forum_USE
rsCut("rAssets")=rsCut("rAssets")-Forum_USA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_USG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsUnSoul("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsUnSoul("rID")&") 剔除精华区 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsUnSoul("rIsQuintessence")=False
rsUnSoul.Update
rsUnSoul.Close
Note=Note&" ID."&IDArray(I)&"操作成功;"
End If
Next
Set rsUnSoul=Nothing
End If

'批量收录帖子
If FromID<>"" And ToID<>"" Then
Set rsUnSoul = Server.CreateObject("ADODB.Recordset")
For I=FromID To ToID
Sql = "Select *  From tArticleManage Where rIsQuintessence And rSubject="&Forum_ID&" And rID="&I
rsUnSoul.Open Sql,ConnY,3,3
If rsUnSoul.Eof Then
Note=Note&" ID."&I&"操作失败;"
rsUnSoul.Close
Else
Set rsCut = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsUnSoul("rPoster")&"'"
rsCut.Open Sql,ConnY,3,3
ADo="回收:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_USE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_USA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_USG&"</font>"
rsCut("rExp")=rsCut("rExp")-Forum_USE
rsCut("rAssets")=rsCut("rAssets")-Forum_USA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_USG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsUnSoul("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsUnSoul("rID")&") 剔除精华区 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsUnSoul("rIsQuintessence")=False
rsUnSoul.Update
rsUnSoul.Close
Note=Note&" ID."&I&"操作成功;"
End If
Next
Set rsUnSoul=Nothing
End If

'收录指定用户所有在本版的帖子.
If User<>"" Then
Set rsUnSoul = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rIsQuintessence And rSubject="&Forum_ID&" And rPosterNickName='"&User&"'"
rsUnSoul.Open Sql,ConnY,3,3
If rsUnSoul.Eof Then
Note="操作失败或者无此用户"
rsUnSoul.Close
Else
While Not rsUnSoul.Eof And Not rsUnSoul.Bof
Note=Note&" ID."&rsUnSoul("rID")&"操作成功;"
Set rsCut = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&rsUnSoul("rPoster")&"'"
rsCut.Open Sql,ConnY,3,3
ADo="回收:经验值<font color='"&Forum_PFontColor&"'>-"&Forum_USE&"</font> 财产<font color='"&Forum_PFontColor&"'>-"&Forum_USA&"</font> 魅力<font color='"&Forum_PFontColor&"'>-"&Forum_USG&"</font>"
rsCut("rExp")=rsCut("rExp")-Forum_USE
rsCut("rAssets")=rsCut("rAssets")-Forum_USA
rsCut("rGlamour")=rsCut("rGlamour")-Forum_USG
rsCut.Update
rsCut.Close
Set rsCut=Nothing
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsUnSoul("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsUnSoul("rID")&") 剔除精华区 "&ADo
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsUnSoul("rIsQuintessence")=False
rsUnSoul.Update
rsUnSoul.MoveNext
Wend
End If
Set rsUnSoul=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_Soul.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>