blog_showcmt.asp

该资料包含大量网络开发的案例和源代码

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%option explicit%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="../include/datatransfer.asp"-->
<!--#include file="../include/functionjs.asp"-->
<!--#include file="../include/functionvb.asp" -->
<!--#include file="../include/dbconn.inc" -->
<!--#include file="../include/refresh.asp"-->
<!--#include file="../include/header.asp" -->
<%
if showid="" then
	if UserID=empty then
		response.Redirect("../common/showerr.asp?ErrType=1")
	else
 		showid=userid
	end if
else
	strSQL="select user_name from user_info where user_id="& showid
	objRS.open strSQL,objConn,1,1
	showname=objrs("user_name")
	objrs.close
end if

dim replyid
replyid=request.QueryString("replyID")
%>

<link href="../include/main.css" rel="stylesheet" type="text/css">
<table width="710" border="1" cellpadding="2" cellspacing="0" align="center"  class="tablestyle"  bordercolor="#FFFFFF">
  <tr>
    <td bordercolor="#4C4C4C" background="../resource/images/bbs/bg.gif" class="tablehead">&nbsp;<img src="../resource/images/blog/li.gif" width="12" height="12">&nbsp;
      <%if userid="" then response.Write("游客") else response.Write(username)%>,您的位置：<a href="../blog/main.asp">56Blog</a> → <a href="blog_show.asp?ShowID=<%=showid%>">
      <%if showid=userid then response.Write("我") else response.Write(showname)%>
的博客</a> → 察看评论</td>
  </tr>
  <tr>
    <td bordercolor="#4C4C4C"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="200" valign="top" style="table-layout: fixed;WORD-BREAK: break-all; WORD-WRAP: break-word">		
		<%if userid=empty then %>
		<!--#include file="../include/blog_leftpub.asp"-->
		<%else%>
		<!--#include file="../include/blog_leftprv.asp"-->
		<%end if%>
		</td>
        <td width="510" valign="top">  <br>
		<table width="480" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#D6E7FF"style="table-layout: fixed;WORD-BREAK: break-all; WORD-WRAP: break-word BORDER-LEFT: #000000 1PX DASHED; BORDER-RIGHT: #000000 1PX DASHED; BORDER-TOP: #000000 1PX DASHED; BORDER-BOTTOM: #000000 1PX DASHED">
  <tr>
    <td align="center">查看评论</td>
  </tr>
</table>
		  <br><br>
		 <%	
if replyid="" then
		dim thePageSize,ttlPage,ttlRdCnt
		Page=request("Page")
		if request.Form("select")<>0 then page=request.Form("select")
		thePageSize=10
		if not isnumeric(page) then page=1 else page=clng(page)
		if page<1 then page=1
	
		strSQL="select blog_reply.*,blog_topic.user_id,blog_topic.topic_id,blog_topic.user_name,blog_topic.title,blog_topic.pubtime from blog_reply,blog_topic where blog_topic.topic_id=blog_reply.topic_id and blog_topic.user_id="&showid&" order by blog_reply.pubtime desc"
		objRS.open strSQL,objConn,1,1	
		
		if not objRS.eof then
			objRS.pagesize=thePageSize
			ttlPage=objRS.pagecount
			ttlRdCnt=objRS.Recordcount
			if Page>ttlPage then Page=ttlPage
			objRS.AbsolutePage=Page
		end if
				
	  	for i=1 to thePageSize
	  	if objRS.eof then exit for 
		%>
		 <table width="480" border="0" cellspacing="2" cellpadding="2" align="center" <%if i mod 2 =0 then response.Write("bgcolor='#EFEBEF'")%>style="table-layout: fixed;WORD-BREAK: break-all; WORD-WRAP: break-word BORDER-LEFT: #000000 1PX DASHED; BORDER-RIGHT: #000000 1PX DASHED; BORDER-TOP: #000000 1PX DASHED; BORDER-BOTTOM: #000000 1PX DASHED">
           <tr>
             <td><pre><font color="#FF6600"><%=objrs("blog_reply.title")%></font>,此评论由<%=objrs("blog_reply.user_name")%> 发表于 <%=objrs("blog_reply.pubtime")%></pre></td>
           </tr>
           <tr>
             <td align="right">
               <table width="450"  border="0" cellspacing="0" cellpadding="0"style="table-layout: fixed;WORD-BREAK: break-all; WORD-WRAP: break-word">
                 <tr>
                   <td><pre><%=objrs("content")%></pre></td>
                 </tr>
               </table></td>
           </tr>
           <tr>
             <td align="right"><br>评论对象:<%=objrs("blog_topic.user_name")%>于<%=objrs("blog_topic.pubtime")%>发表的《<b><%=objrs("blog_topic.title")%></b>》
			 [<a href="blog_show.asp?ShowID=<%=showid%>&TopicID=<%=objrs("blog_topic.topic_id")%>"><img src="../resource/images/blog/li2.gif" width="9" height="9" border="0">查看源日记</a>]</td>
           </tr>
         </table>
		 <br><%
	  	objRs.movenext
	  	next%>
		<table width="480"  border="0" align="center" cellpadding="2" cellspacing="2">
          <tr>
            <td>分页：
          <%for i=1 to ttlpage%>
		<a href="blog_show.asp?ShowID=<%=Showid%>&page=<%=i%>"><b><%=i%></b></a>
		<%next %>
&nbsp;</td>
            <td align="right"><a href="blog_show.asp?ShowID=<%=Showid%>&page=<%=i%>"><b>&lt;&lt;</b></a>
		<a href="blog_show.asp?ShowID=<%=Showid%>&page=<%=page-1%>"><b>&lt;</b></a>
		<a href="blog_show.asp?ShowID=<%=Showid%>&page=<%=page+1%>"><b>&gt;</b></a>
		<a href="blog_show.asp?ShowID=<%=Showid%>&page=<%=ttlpage%>"><b>&gt;&gt;</b></a>
</td>
          </tr>
        </table>
<%else
		strSQL="select blog_reply.*,blog_topic.user_id,blog_topic.topic_id,blog_topic.user_name,blog_topic.title,blog_topic.pubtime from blog_reply,blog_topic where blog_topic.topic_id=blog_reply.topic_id and blog_reply.reply_id="&replyid&" order by blog_reply.pubtime desc"
		objRS.open strSQL,objConn,1,1	
%>

<table width="480" border="0" cellspacing="2" cellpadding="2" align="center" <%if i mod 2 =0 then response.Write("bgcolor='#EFEBEF'")%>style="table-layout: fixed;WORD-BREAK: break-all; WORD-WRAP: break-word BORDER-LEFT: #000000 1PX DASHED; BORDER-RIGHT: #000000 1PX DASHED; BORDER-TOP: #000000 1PX DASHED; BORDER-BOTTOM: #000000 1PX DASHED">
  <tr>
    <td><pre><font color="#FF6600"><%=objrs("blog_reply.title")%></font>,此评论由<%=objrs("blog_reply.user_name")%> 发表于 <%=objrs("blog_reply.pubtime")%></pre></td>
  </tr>
  <tr>
    <td align="right"><table width="450"  border="0" cellspacing="0" cellpadding="0"style="table-layout: fixed;WORD-BREAK: break-all; WORD-WRAP: break-word">
      <tr>
        <td><pre><%=objrs("content")%></pre></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td align="right"><br>评论对象:<%=objrs("blog_topic.user_name")%>于<%=objrs("blog_topic.pubtime")%>发表的《<b><%=objrs("blog_topic.title")%></b>》 [<a href="blog_show.asp?ShowID=<%=showid%>&TopicID=<%=objrs("blog_topic.topic_id")%>"><img src="../resource/images/blog/li2.gif" width="9" height="9" border="0">查看源日记</a>]</td>
  </tr>
</table>
    <%end if%>
	<br><br>
<div align="center">
  [<a href="javascript:window.print();"><font color="#FF6600">打印本页</font></a>]</div></td>
      </tr>
    </table>
	
	</td>
  </tr>
  <tr>
    <td bordercolor="#4C4C4C" background="../resource/images/bj2.gif" align="center">&nbsp;</td>
  </tr>
</table>
<!--#include file="../include/endconn.inc" -->
<!--#include file="../include/footer.asp" -->