<%
if lookdate<>"" then lookdateSQL="and adddate='"&lookdate&"'"
sql="select * from calendar where (hide=0 or username='"&Request.Cookies("username")&"') "&lookdateSQL&" order by id Desc"
pagesetup=10 '设定每页的显示数量
TotalPage=getPageCount(sql,pagesetup) '总页数
PageCount = cint(Request.QueryString("ToPage"))
if PageCount > TotalPage then PageCount = TotalPage
if PageCount <1 then PageCount = 1
sql=sql&" limit "&(pagecount-1)*pagesetup&","&pagesetup '跳转到指定页数
i=0
rs.Open sql,Conn,1
Do While Not RS.EOF
i=i+1
username=rs("username")
content=ReplaceText(rs("content"),"<[^>]*>","")
if len(content)>200 then content=left(""&content&"",200)&"..."
%>
<%=rs("title")%>
<%=content%>
<%if rs("hide")=1 then%>
注:本篇日志为隐藏状态<%end if%>
">阅读全文
|
<%if Request.Cookies("username")=username then%>
">编辑
<%else%>
编辑
<%end if%>
|
<%if username= Request.Cookies("username") or membercode > 3 then%>
" onclick="checkclick('您确定要删除此条日志?')">删除
<%else%>
删除
<%end if%>
| <%=rs("addtime")%> by <%=username%> |
<%
RS.MoveNext
loop
RS.Close
%>
|