author_bookjielist.asp

本源代码为终点小说连载系统 v1.15 Build 0430 SQL清风修改版,欢迎大家下载,学习与交流

<%
dim id
id=replace(trim(request("id")),"'","")
CheckSqlnum(id)
if id="" then
response.Redirect "author_logout.asp"
response.End
end if
id=int(id)
set rs=server.CreateObject("adodb.recordset")
sql="select * from list_cook where list_cookid="&id
rs.open sql,conn,1,1
%><%
dim b_id
b_id=rs("list_bookid")
set rs3=server.createobject("adodb.recordset")
sql3="select * from list_book where id="&b_id
rs3.open sql3,conn,1,3
if rs3("list_Adminid")<>author_ID then
	Response.Write ("<script>alert('   操作错误!\n\n 你没有权限管理该作品。');history.back();</script>")
	Response.end
End If
%><%
dim classid
classid=rs3("list_class")
set rs2=server.createobject("adodb.recordset")
sql2="select * from list_type where typeid="&classid
rs2.open sql2,conn,1,1
%>
<table cellspacing="1" cellpadding="4" width="100%" bgcolor="#ffffff" border="0">
	<tr bgcolor="#588fc7">
		<td colspan="4" class="head"><font color="#FFFFFF">查看章节列表</font></td>
	</tr>
	<tr bgcolor="#ffffff">
		<td colspan="4"><%
dim c_id,liuguang,page
c_id=rs("list_cookid")
page=clng(request("page"))
set rs4=server.CreateObject("ADODB.recordset")
sql4="select * from list_view where list_cookid="&c_id
rs4.open sql4,conn,1,3
if rs4.eof and rs4.bof then
	response.write "<table width=100% height=100% border=0 align=center cellpadding=0 cellspacing=2 bgcolor=#FFFFFF><tr align=center bgcolor=#F7F7F7><td height=40 colspan=4 bgcolor=#F7F7F7>暂无任何内容</td></tr></table>"
else
%>
		<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
			<tr>
				<td bgcolor="#F7F7F7">
				<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="2" bgcolor="#FFFFFF">
					<tr align="center" bgcolor="#F7F7F7">
						<td height="40" colspan="3" valign="middle" bgcolor="#F7F7F7">
						<span class="style2"><%=rs3("list_name")%></span></td>
					</tr>
					<tr align="center" bgcolor="#F7F7F7">
						<td height="20" colspan="3" valign="middle" bgcolor="#F7F7F7">
						所属类型：<span class="style3"><%=rs2("list_tpye")%></span>&nbsp;&nbsp;&nbsp; 
						当前分卷：<span class="style3"><%=rs("list_cookname")%></span></td>
					</tr>
					<%
rs4.pagesize=10
if page=0 then page=1
pages=rs4.pagecount
if page > pages then page=pages
rs4.Absolutepage=page

for j=1 to rs4.pagesize
%>
					<tr bgcolor="#F7F7F7">
						<td width="50%" height="34" align="center" valign="middle" bgcolor="#F7F7F7">
						<a href="author_bookjieedit.asp?id=<%=rs4("id")%>"><%=rs4("view_type")%></a></td>
						<td width="35%" align="center" bgcolor="#F7F7F7">
						<a target="_blank" href="author_viewgocook.asp?id=<%=rs4("id")%>">
						重新设置分卷</a></td>
						<td width="15%" height="34" align="center" valign="middle" bgcolor="#F7F7F7">
						<a href="author_bookjieedit.asp?id=<%=rs4("id")%>">修改</a></td>
					</tr>
					<%
rs4.movenext
if rs4.eof then exit for
Next
%>
				</table>
				</td>
			</tr>
		</table>
		<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
			<tr>
				<td height="24" align="center"><%
					if page<2 then
						response.write "首页 上一页&nbsp;"
					else
						response.write "<a href=author_bookjielist.asp?id="&id&"&page=1>首页</a>&nbsp;"
						response.write "<a href=author_bookjielist.asp?id="&id&"&page=" & page-1 & ">上一页</a>&nbsp;"
					end if
					if rs4.pagecount-page<1 then
						response.write "下一页 尾页&nbsp;"
					else
						response.write "<a href=author_bookjielist.asp?id="&id&"&page=" & (page+1) & ">"
						response.write "下一页</a> <a href=author_bookjielist.asp?id="&id&"&page="&rs4.pagecount&">尾页</a>"
					end if
						response.write "&nbsp;页次:<strong><font color=red>"&page&"</font>/"&rs4.pagecount&"</strong>页"
						response.write "&nbsp;共<b><font color='#FF0000'>"&rs4.recordcount&"</font></b>条记录<b>"&rs4.pagesize&"</b>共记录/页"
					%><%end if%></td>
			</tr>
		</table>
		<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="2" bgcolor="#FFFFFF">
			<tr align="center" valign="bottom" bgcolor="#F7F7F7">
				<td height="34" colspan="2">【<a href="javascript:onclick=history.go(-1)">返回分卷列表</a>】</td>
			</tr>
		</table>
		</td>
	</tr>
</table>
<%
rs4.close
set rs4=nothing
%> <%
rs3.close
set rs3=nothing
%> <%
rs2.close
set rs2=nothing
%><%
rs.close
set rs=nothing
%>