/admin/art/adminpl.asp

https://github.com/74hu/74hujz · ASP · 63 lines · 56 code · 7 blank · 0 comment · 5 complexity · 9b1cad9f2e5c7f4f0114d5d9fef6949b MD5 · raw file

  1. <!-- #include file="../ding.asp" -->
  2. <!-- #include file="mymin.asp" -->
  3. <%Call Head()%>
  4. <card title="评论管理">
  5. <p>
  6. <%
  7. call conndata
  8. set rs=server.createobject("adodb.recordset")
  9. rs.open "Select * from 74hu_pl order by id desc",conn,1,1
  10. If Not rs.eof Then
  11. PageSize=10
  12. gopage="adminpl.asp?sid="&sid&"&amp;"
  13. Count=conn.execute("Select count(ID) from 74hu_pl")(0)
  14. page=int(request.QueryString ("page"))
  15. if page<=0 or page="" then page=1
  16. pagecount=(count+pagesize-1)\pagesize
  17. if page>pagecount then page=pagecount
  18. rs.move(pagesize*(page-1))
  19. For i=1 To PageSize
  20. smsid=rs("Smsid")
  21. plid=rs("id")
  22. plip=rs("ip")
  23. plnr=rs("pl")
  24. plsj=rs("pltime")
  25. set rs1=server.createobject("adodb.recordset")
  26. sql="Select classid,title from 74hu_article where ID="&smsid
  27. rs1.open sql,conn,1,1
  28. id = smsid
  29. ids = rs1("classid")
  30. title = rs1("title")
  31. If rs.eof Then Exit For
  32. %><%=i+(page-1)*PageSize%>评论文章<a href="smsview.asp?sid=<%=sid%>&amp;id=<%=id%>&amp;ids=<%=ids%>&amp;TP=1"><%=noubb(title)%></a><br/>评论者IP<%=plip%><br/>时间<%=fordate2(plsj)%><br/>内容<%=noubb(plnr)%><br/><a href="delpl.asp?sid=<%=sid%>&amp;id=<%=plid%>">[删除这条评论]</a><br/>
  33. <%
  34. rs.moveNext
  35. Next
  36. if page-pagecount<0 then response.write "<a href="""&gopage&"page="&page+1&""">下页</a>"
  37. if page>1 then response.write "<a href="""&gopage&"page="&page-1&""">上页</a>"
  38. if pagecount>1 then response.write "<br/><b>"&page&"</b>/"&pagecount&"页<input name=""page"" format=""*N"" value="""&page&""" type=""text"" maxlength=""5"" emptyok=""true"" size=""3""/><a href="""&gopage&"page=$(page)"">>></a>"
  39. Else
  40. %>
  41. 暂时没有评论
  42. <% end if%>
  43. <%
  44. rs.close
  45. set rs=nothing
  46. rs1.close
  47. set rs1=nothing
  48. conn.close
  49. set conn=nothing
  50. %>
  51. <br/>
  52. <a href="qkpin.asp?sid=<%=sid%>">[清空评论]</a><br/>
  53. <a href="../index.asp?sid=<%=sid%>">[后台管理]</a>
  54. </p>
  55. </card>
  56. </wml>