%
root=Request("root")
if root=true then
session("root")="root"
end if
Set rs2=Server.CreateObject("ADODB.RecordSet")
Set rs3=Server.CreateObject("ADODB.RecordSet")
rs.open "Select * From Counter",Conn,2,3
rs2.open "Select * From Root",Conn,1,3
If rs2("re_top")="ON" then
rs3.open "Select * From CuteBook Order By redate DESC",Conn,1,3
else
rs3.open "Select * From CuteBook Order By ID DESC",Conn,1,3
End if
If session("guestbook")="" then
rs("total")=rs("total")+1
rs.update
session("guestbook")="1"
End if
If Request.QueryString("Page")="" or Request.QueryString("Page")<"1" then
Page=1
Else
Page=Clng(Request.QueryString("Page"))
End if
rs3.PageSize=rs2("pagesize") '每頁留言筆數
If Page>rs3.PageCount then
Page=rs3.PageCount
End if
If Request.Cookies("guestbookFace")="" then
Response.Cookies("guestbookFace")="b01.gif"
Response.Cookies("guestbookFace").Expires=DateAdd("d",3650,Date)
End if
%>
"
else
rs3.absolutePage=Page
Job=rs3.PageSize + 1
do While not rs3.Eof
Job=Job-1
If Job=0 then Exit do
if rs3("sex")="M" then
sex="男生"
elseif rs3("sex")="F" then
sex="女生"
else
sex="不明"
end if
%>
<%=rs3("name")%>(<%=sex%>)<% if rs3("MAIL")<>"" then %><% end if %> <% if rs3("homepage")<>"" then %><% end if %> [ <%=rs3("topic")%> ] <%=rs3("time")%> <% if session("root")="root"then %>IP:<%=rs3("IP")%><% End If %> 回覆留言
<% end if %><% if rs3("secret")="1"then %>><%=rs3("message")%><% end if %>
<%
If rs3("re")="1" then
Set rs4=Server.CreateObject("ADODB.RecordSet")
rs4.Open "Select * From ReCuteBook Where ID=" & rs3("ID") & " order by time",conn,1,3
While Not rs4.Eof
if rs4("sex")="M" then
sex="男生"
elseif rs4("sex")="F" then
sex="女生"
else
sex="不明"
end if%>
<%=Trim(rs4("name"))%>(<%=sex%>)回覆 <% if rs4("MAIL")<>"" then %> <% end if %><% if rs4("homepage")<>"" then %> <% end if %><%=rs4("time")%><% if session("root")="root"then %> IP:<%=rs4("IP")%><% End If %>
<%
rs4.MoveNext
Wend
rs4.Close
Set rs4=Nothing
End if
%>
<%
rs3.movenext
loop
end if
%>
<% if Page=1 or Page="" then
Response.Write "上一頁"
Else
PageNo=Page-1
Response.Write "上一頁"
end if
Response.Write " || "
if Page=rs3.PageCount then
Response.Write "下一頁"
Else
PageN=Page+1
Response.Write "下一頁"
end if
%>
跳頁選擇:
琉璃琉璃留言版 v1.54
Copyright 2002 by 琉璃琉璃的世界. All Rights Reserved.
<%
rs.Close
rs2.Close
rs3.Close
Set rs=Nothing
Set rs2=Nothing
Set rs3=Nothing
%>