📄 del.asp
字号:
<%@ language=VBScript %>
<!--#include file="setup.asp"-->
<%
if Request("menu") = "del" then
call del()
else call index()
end if
sub index()
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=gbook_name%></title>
<link rel="stylesheet" href="style.css">
</head>
<body bgcolor="#C8C8C8">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="500">
<tr>
<td width="100%" bgcolor="#EFEFEF">
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%">
<tr>
<td width="100%" align="center" background="images/table.gif"><b><font color=ffffff><%=gbook_name%></font></b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#FFFFFF">
<table border="0" cellpadding="2" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%">
<tr>
<td width="75%" class="shadow">当前位置:<a href=<%=url%>><%=name%></a> - <a href=index.asp?userid=<%=userid%>>留言首页</a> - 删除留言</td>
<td width="25%" class="shadow" align="right">进入时间:<%=time%></td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<table cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%" height="3">
<tr>
<td width="100%"></td>
</tr>
</table>
<div align="center">
<center>
<table border="1" cellpadding="2" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="500">
<form name="form" method="post" action="del.asp?userid=<%=userid%>">
<input type=hidden name=id value=<%=Request("id")%>><input type=hidden name=menu value=del>
<tr>
<td width="25%" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%">
<tr>
<td width="100%" class="shadow" align="center">管理员密码</td>
</tr>
</table>
</td>
<td width="75%" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%">
<tr>
<td width="50%">
<input type="password" size="20" name="password" style="width: 200; height: 18" onmouseover="this.style.backgroundColor='#FFFFFF'" onmouseout="this.style.backgroundColor=''" value="<%=Request.cookies("password")%>"></td>
<td width="50%" align="center" class="shadow"><input type=hidden name=save size="20" value="<%=Request.cookies("save")%>">[<font onclick="save.value='save'" style="cursor:hand">记住密码</font>]</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="25%" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%">
<tr>
<td width="100%" class="shadow" align="center">删除的方式</td>
</tr>
</table>
</td>
<td width="75%" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%">
<tr>
<td width="50%"> <input type="text" size="20" name="text" style="width: 200; height: 18" onmouseover="this.style.backgroundColor='#FFFFFF'" onmouseout="this.style.backgroundColor=''" disabled="true"><input type="hidden" name="select"></td>
<td width="25%" align="center" class="shadow">[<font onclick="select.value='this';text.value='删除一条'" style="cursor:hand">删除一条</font>]</td>
<td width="25%" align="center" class="shadow">[<font onclick="select.value='all';text.value='删除所有'" style="cursor:hand">删除所有</font>]</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="25%" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#4F4F4F" width="100%">
<tr>
<td width="100%" class="shadow" align="center">请点击确定</td>
</tr>
</table>
</td>
<td width="75%" bgcolor="#FFFFFF">
<input type="submit" value="确定" name="ok" style="width: 50; height: 18" onmouseover="this.style.backgroundColor='#FFFFFF'" onmouseout="this.style.backgroundColor=''"></td>
</tr>
</form>
</table>
</center>
</div>
<%
call htmlend()
Response.End
end sub
sub del()
password = Request.form("password")
id = Request.form("id")
save = Request.form("save")
if id = "" then
message=message&"对不起，你的删除ID号不能为空!\n"
end if
if password <> passwords then
message=message&"您的管理口令不正确!\n"
end if
on error resume next
if message <> "" then
call error(""&message&"")
Response.end
else
if Request.form("select") = "this" then
sql = "delete * from gbook where id=" & id &" and userid="&userid
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open sql,conn,3,1
Rs.close
sql = "delete * from reply where replyid=" & id &" and userid="&userid
Rs.open sql,conn,3,1
Rs.close
sql = "select * from admin where id="&userid
Rs.open sql,conn,3,2
if Rs("today_count") > 0 then
Rs("today_count") = Rs("today_count")-1
else Rs("today_count") = 0
end if
Rs("today_time") = date
Rs.update
Rs.close
elseif Request.form("select") = "all" then
sql = "delete * from gbook where userid="&userid
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open sql,conn,3,1
Rs.close
sql = "delete * from reply where userid="&userid
Rs.open sql,conn,3,1
Rs.close
sql = "select * from admin where id="&userid
Rs.open sql,conn,3,2
Rs("today_count") = 0
Rs("today_time") = date
Rs.update
Rs.close
end if
if save <> "" then
Response.cookies("password") = password
Response.cookies("save") = save
else
Response.cookies("password") = ""
Response.cookies("save") = ""
end if
set Rs = nothing
conn.close
set conn = nothing
Response.redirect "index.asp?userid="&userid
Response.End
end if
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -