?? admin_updatenewview.asp
字號:
<!-- #include file="../conn.asp" -->
<%Response.buffer=False %>
<!-- #include file="session.asp" -->
<!--#include file="../inc/config.asp"-->
<link href="css.css" rel="stylesheet" type="text/css">
<%
act = Request("act")
if act = "makebook" then
getstartid=request("start")
getendid=request("end")
Server.ScriptTimeOut=12000000 '設(shè)定操作超時的時間
Set rs = Server.CreateObject("ADODB.Recordset")
if IsSqlDataBase = 2 then
sql="select id,list_lei,newviewid,newviewname,newview from list_book where id>="&getstartid&" and id<="&getendid&" ORDER BY id"
else
sql="select id,list_lei,newviewid,newviewname,newview from [list_book] where id>="&getstartid&" and id<="&getendid&" ORDER BY id"
end if
rs.open sql,conn,1,3
if rs.eof and rs.bof then
response.write "<script language=javascript>alert('錯誤! \n\n 指定范圍內(nèi)沒有作品存在!');history.back(-1);</script>"
response.end
else
do while not rs.eof
id=rs("id")
set rsvclass=server.createobject("adodb.recordset")
if IsSqlDataBase = 2 then
sqlvclass="select id,list_cookid,view_type,view_ok2 from list_view where view_id="&id&" order by view_showid desc"
else
sqlvclass="select id,list_cookid,view_type,view_ok2 from [list_view] where view_id="&id&" order by view_showid desc"
end if
rsvclass.open sqlvclass,conn,1,1
if rsvclass.eof and rsvclass.bof then
newview=""
newviewname=""
newviewid=0
else
dim list_cookid
list_cookid=rsvclass("list_cookid")
set rscclass=server.createobject("adodb.recordset")
if IsSqlDataBase = 2 then
sqlcclass="select list_cookname from list_cook where list_cookid="&list_cookid&""
else
sqlcclass="select list_cookname from [list_cook] where list_cookid="&list_cookid&""
end if
rscclass.open sqlcclass,conn,1,1
if rscclass.eof and rscclass.bof then
newview=""
newviewname=""
newviewid=0
else
if rsvclass("view_ok2")<>"" then
newview=left(rsvclass("view_ok2"),399)
else
newview=""
end if
newviewname=rscclass("list_cookname")&" "&rsvclass("view_type")
newviewid=rsvclass("id")
rscclass.close
set rscclass=nothing
end if
rsvclass.close
set rsvclass=nothing
end if
rs("newview")=newview
rs("newviewname")=newviewname
rs("newviewid")=newviewid
rs.update
response.write "<br> 作品ID為<font color=#FF0000> "&id&" </font>的最新章節(jié)顯示更新操作成功!!"
rs.movenext
loop
end if
rs.close
set rs=nothing
response.write "<p align='center'>作品最新章節(jié)顯示更新操作全部完成!!【<a href='javascript:onclick=history.go(-1)'>返 回</a>】</p>"
else
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body>
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#0650D2" bordercolordark="#FFFFFF">
<tr bgcolor="#1C3566">
<td colspan="4" class="head" height="34" align="center"><b>
<font color="#FFFFFF">長篇采集系統(tǒng)項目管理</font></b></td>
</tr>
</table>
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#0650D2" bordercolordark="#FFFFFF">
<tr align="center">
<td height="30"><a href=Admin_ItemManage.asp>管理首頁</a> | <a href="Admin_ItemAddNew.asp">添加新項目</a></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#1f3566" bordercolordark="#FFFFFF">
<tr>
<td height="34" align="center" valign="middle" bgcolor="#1C3566" style="line-height:150%"><b><font color="#FFFFFF">更新作品最新章節(jié)顯示的內(nèi)容
<br>(當(dāng)批量采集完成后執(zhí)行本步驟，以供將作品列表頁面中的“暫無更新”更新成該作品最后采集的章節(jié)名稱。<br>請慎重操作,此操作大量占用系統(tǒng)資源每次填寫范圍請不要過大)</font></b></td>
</tr>
</table>
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#1f3566" bordercolordark="#FFFFFF">
<form method="get" action="">
<tr height="26">
<td width="50%">
<p align="right">更新顯示的作品起始ID（本地ID）：</td>
<td width="50%"> <input class='form' type="Number" name="start" id="start" size="20"></td>
</tr>
<tr height="26">
<td width="50%">
<p align="right">更新顯示的作品結(jié)束ID（本地ID）：</td>
<td width="50%"> <input class='form' type="text" name="end" Id="end" size="20"></td>
</tr>
<tr>
<td height="30" align="center" colspan="2">
<input type="hidden" name="act" value="makebook" id="act" size="20">
<input class="button" type="submit" value="開始更新" name="B1"> <input class="button" type="reset" value="重置設(shè)定" name="B2">
</td>
</tr>
</form>
</table>
</body>
</html>
<%end if%>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -