<!--#include file="Inc.asp"-->
<!--#include file="ydzq.asp"-->
<%call head()
Call saycardd("我的收藏")
if myid<>0 then
mz="[url=/bbs/uinfo.asp?id="&myid&"&amp;saytk="&saytk&"&sid=[sid]]"&myni&"[/url]"
else
mz="游客"
end if
conn.execute("insert into sqdt(shijian,dz)values('"&now&"','"&mz&"整理了(url=/bbs/mybook.asp?saytk="&saytk&"&sid=[sid])书签(/url)')")
dim cid
cid=ubb(request.querystring("cid"))
if cid="" or Isnumeric(cid)=False then cid=1
cid=abs(cid)
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from [mysq] where ids="&myid&" and cid="&cid&" order by id desc"
rs.open sql,conn,1,1
If Not rs.eof	Then
	Dim PageSize,i
	PageSize=10						
	Dim Count,page,pagecount,gopage			
	gopage="mybook.asp?saytk="&saytk&"&amp;sid="&sid&"&amp;"
	Count=conn.execute("Select count(ID) from [mysq] where ids="&myid)(0)	
	page=int(request.QueryString ("page"))
	if page<=0 or page="" then page=1		
	pagecount=(count+pagesize-1)\pagesize
        if page>pagecount then page=pagecount
	rs.move(pagesize*(page-1))					
	For i=1 To PageSize     						
	If rs.eof Then Exit For	
Response.write ""&i+(page-1)*PageSize&"."
if rs("cid")=1 then
set Rs1=Server.CreateObject("ADODB.Recordset")
Sql1="select name from [sell] Where ID="&abs(rs("urlsq"))
Rs1.open Sql1,conn,1,1
If rs1.eof Then
 titlename="贴子不存在！"
else
 titlename=rs1("name")
end if
rs1.close
set rs1=nothing
Response.write "<a href=""topic.asp?tid="&abs(rs("urlsq"))&"&amp;saytk="&saytk&"&amp;sid="&sid&""">"&usb(titlename)&"</a>"
else
Response.write "<a href="""&ubb2(rs("urlsq"))&""">"&usb(rs("title"))&"</a>"
end if
Response.write "[<a href=""delbook.asp?id="&rs("id")&"&amp;saytk="&saytk&"&amp;sid="&sid&""">删除</a>]<br/>" 
Response.write "收藏时间:"&fordate(rs("Gxtime"))&"<br/>" 
	rs.moveNext
 	Next
	if page-pagecount<0 then response.write "<a href="""&gopage&"page="&page+1&""">下页</a>"
	if page>1 then response.write "<a href="""&gopage&"page="&page-1&""">上页</a>"
	if pagecount>1 then response.write "<br/>"&page&"/"&pagecount&"页,共"&Count&"条<br/><input name=""page"" format=""*N"" value="""&page&""" type=""text"" maxlength=""5"" emptyok=""true"" size=""3""/><a href="""&gopage&"page=$(page)"">跳到该页</a><br/>"
Else
Response.write "当前收藏类型无记录！<br/>"
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
Response.Write "类型:"
if cid<>1 then
Response.Write "<a href='mybook.asp?cid=1&amp;saytk="&saytk&"&amp;sid="&sid&"'>帖子</a>|"&chr(13)
else
Response.Write "帖子|"
end if
if cid<>2 then
Response.Write "<a href='mybook.asp?cid=2&amp;saytk="&saytk&"&amp;sid="&sid&"'>文章</a>|"&chr(13)
else
Response.Write "文章|"
end if
if cid<>3 then
Response.Write "<a href='mybook.asp?cid=3&amp;saytk="&saytk&"&amp;sid="&sid&"'>图片</a>|"&chr(13)
else
Response.Write "图片|"
end if
if cid<>0 then
Response.Write "<a href='mybook.asp?cid=0&amp;saytk="&saytk&"&amp;sid="&sid&"'>网址</a><br/>"
else
Response.Write "网址<br/>"
end if
Response.Write "<a href='mybookadd.asp?saytk="&saytk&"&amp;sid="&sid&"'>增加书签</a><br/>"
Response.Write "<a href='bookalldel.asp?saytk="&saytk&"&amp;sid="&sid&"'>清空书签</a><br/>"
%><!--#include file="fanhui.asp"-->
<%
Call head1()
%>