📄 admin_delete.asp
字号:
<!--#include file="Inc/Level012.asp" -->
<!--#include file="Connections/connY.asp" -->
<!--#include file="Inc/TimeFormat.asp" -->
<!--#include file="Inc/UBBCode.asp" -->
<!--#include file="Inc/Md5.asp" -->
<!--#include file="Inc/SetCss.asp" -->
<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" -->
<script language=Javascript src="Js/Menu.Js"></script>
<script language=Javascript src="Js/Button.Js"></script>
<script language=Javascript src="Js/Operate.Js"></script>
</head>
<body leftmargin="0" topmargin="0" bgcolor="<%=Forum_ColorList_BgColor%>" vlink="<%=Forum_Css_A_Link_Color%>" onLoad="MM_preloadImages('<%=Forum_Pic_Write2%>','<%=Forum_Pic_Vote2%>')">
<!--#include file="Inc/Top.asp" -->
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="<%=Forum_ColorList_BorderColor%>">
<tr>
<td height="20" bgcolor="<%=Forum_ColorList_BgColor%>">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="font">
<tr>
<td> 您所在的位置： <a href="../" onfocus="this.blur()">首页</a> >>
<a href="List.asp" onFocus="this.blur()">讨论组</a> >> <font color="<%=Forum_ColorList_NavFontColor%>">论坛管理系统</font></td>
<td width="18">
<div align="center"></div>
</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" bgcolor="<%=Forum_ColorList_BorderColor%>" class="font">
<tr>
<td valign="top" width="102" bgcolor="<%=Forum_ColorList_BgColor%>">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<!--#include file="Inc/Menu.asp" -->
</td>
</tr>
</table>
</td>
<td bgcolor="<%=Forum_ColorList_BgColor%>" valign="top"> <br>
<table width="80%" border="0" cellspacing="1" cellpadding="2" align="center" class="font" bgcolor="<%=Forum_ColorList_BorderColor%>">
<tr>
<td bgcolor="<%=Forum_ColorList_TitleColor%>" height="20"> 批量删除帖子</td>
</tr>
<tr>
<td bgcolor="<%=Forum_ColorList_BgColor%>" valign="top"> 1.下面操作将大批量删除论坛帖子.如果您确定这样做,请仔细检查您输入的信息.<br>
-------------------------------------------------------------------------------<br>
<%
If Request("Action")="DelUserA" Then
Set rsDel = Server.CreateObject("ADODB.Recordset")
Sql = "Select * From tArticleManage Where rPoster='"&Request("User")&"'"
rsDel.Open Sql,ConnY,3,3
While Not rsDel.Eof
rsDel.Delete
rsDel.MoveNext
Wend
rsDel.Close
Set rsDel=Nothing
Response.Write " 成功删除用户"&Request("User")&"发表的所有帖子."
End If
If Request("Action")="DelA" Then
Set rsDel = Server.CreateObject("ADODB.Recordset")
If Request("TimeLimited")<>"A" Then
Sql = "Select * From tArticleManage Where DateDiff('d',rPostTime,Now())<="&Cint(Request("TimeLimited"))
Else
Sql = "Select * From tArticleManage"
End If
rsDel.Open Sql,ConnY,3,3
TotalNum=rsDel.RecordCount
While Not rsDel.Eof
rsDel.Delete
rsDel.MoveNext
Wend
rsDel.Close
Set rsDel=Nothing
Response.Write " 成功批量删除"&TotalNum&"篇帖子."
End If
If Request("Action")="DelNoReplyA" Then
Set rsDel = Server.CreateObject("ADODB.Recordset")
If Request("TimeLimited")<>"A" Then
Sql = "Select * From tArticleManage Where rReplyNum=0 And rRepID<>0 And DateDiff('d',rPostTime,Now())<="&Cint(Request("TimeLimited"))
Else
Sql = "Select * From tArticleManage Where rReplyNum=0 And rRepID<>0"
End If
rsDel.Open Sql,ConnY,3,3
TotalNum=rsDel.RecordCount
While Not rsDel.Eof
rsDel.Delete
rsDel.MoveNext
Wend
rsDel.Close
Set rsDel=Nothing
Response.Write " 成功批量删除"&TotalNum&"篇帖子."
End If
If Request("Action")="" Then
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="font">
<tr>
<td>请输入用户名，删除某用户的所有帖子</td>
</tr>
<tr>
<td>
<form name="form1" method="post" action="Admin_Delete.asp?Action=DelUserA">
<input type="text" name="User" class="textfiled" size="17">
<input type="submit" name="Submit" value="删除" class="button">
</form>
</td>
</tr>
<tr>
<td>删除指定日期内帖子(本功能不扣除用户帖子数和积分)</td>
</tr>
<tr>
<td>
<form name="form2" method="post" action="Admin_Delete.asp?Action=DelA">
<select name=TimeLimited size=1 class="textfiled">
<option value=A>删除所有的
<option value=1>删除一天前的
<option value=2>删除两天前的
<option value=7>删除一星期前的
<option value=15>删除半个月前的
<option value=30>删除一个月前的
<option value=60>删除两个月前的
<option value=180>删除半年前的
<option value=360>删除一年前的
<option value=720>删除二年前的
</select>
<input type="submit" name="Submit2" value="删除" class="button">
</form>
</td>
</tr>
<tr>
<td>删除指定日期内没有回复的主题(本功能不扣除用户帖子数和积分)</td>
</tr>
<tr>
<td>
<form name="form3" method="post" action="Admin_Delete.asp?Action=DelNoReplyA">
<select name=TimeLimited size=1 class="textfiled">
<option value=A>删除所有的
<option value=1>删除一天前的
<option value=2>删除两天前的
<option value=7>删除一星期前的
<option value=15>删除半个月前的
<option value=30>删除一个月前的
<option value=60>删除两个月前的
<option value=180>删除半年前的
<option value=360>删除一年前的
<option value=720>删除二年前的
</select>
<input type="submit" name="Submit3" value="删除" class="button">
</form>
</td>
</tr>
</table>
<%
End If
%>
</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
<!--#include file="Inc/Bottom.asp" -->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -