getcomment.asp

SK信息采集2.0功能介绍: 1.可针对任何静态网页,动态网页进行采集。包括htm,html,shtml,ASP,ASPX,JSP,PHP等。 2.增加自定文件采集.用户可采集网页中的所有文件.

<!--#include file="../Conn.asp"-->
<!--#include file="../SysCls/KS_CommonCls.asp"-->
<%
'===================================================================================================================
'软件名称：科汛网站管理系统
'当前版本：科汛网站管理系统 V2.2 SP2 Free
'Copyright (C) 2006-2008 Kesion.Com  All rights reserved.
'产品咨询QQ：9537636,41904294
'技术支持QQ：111394,54004407 
'程序版权：科汛网络
'程序开发：科汛网络开发组（总策划：林文仲）
'E-Mail  :[e-mail] [e-mail]
'官方网站：http://www.kesion.com  
'演示站点：http://test.kesion.com 
'郑重声明:
'    ①、免费版本请在程序首页保留版权信息，并做上本站LOGO友情连接,商业版本无此要求;
'    ②、任何个人或组织不得在授权允许的情况下删除、修改、拷贝本软件及其他副本上一切关于版权的信息；
'    ③、科汛网络保留此软件的法律追究权利
'===================================================================================================================
Dim KSCMS
Set KSCMS=New COMMONCls
Dim ChannelID,ClassID,InfoID,RS,CommentStr,Total,UserIP,TotalPoint,N
ChannelID=KSCMS.G("ChannelID")
IF ChannelID="" Or Not ISnumeric(ChannelID) Then
 Response.End
End if
ClassID=KSCMS.G("ClassID")
InfoID=KSCMS.G("InfoID")
Set RS=Server.CreateObject("ADODB.RECORDSET")
RS.Open "Select Count(ID) From KS_Comment Where Verific=1 And ChannelID=" & ChannelID & " And ClassID='" & ClassID & "' And InfoID='" & InfoID & "'",conn,1,1
Total=RS(0)
RS.Close
TotalPoint=Conn.Execute("Select SUM(Point) From KS_Comment Where Verific=1 And ChannelID=" & ChannelID & " And ClassID='" & ClassID & "' And InfoID='" & InfoID & "'")(0)

RS.Open "Select top 10 * From KS_Comment Where Verific=1 And ChannelID=" & ChannelID & " And ClassID='" & ClassID & "' And InfoID='" & InfoID & "' Order By ID asc ,AddDate Desc",conn,1,1
IF Not Rs.Eof Then
 CommentStr="&nbsp;总共:<font color=red>" & Total & "</font> 条评论 本页:<font color=red>" & rs.recordcount & "</font> 条 得分 <font color=red>" & (TotalPoint)\Total & "</font> 分&nbsp;&nbsp;<a href='" & KSCMS.GetDomain & "Common/Comment.asp?ChannelID=" & ChannelID & "&ClassID=" & ClassID & "&InfoID=" & InfoID &"' target='_blank'>查看全部评论</a><br>"
  Do While Not RS.Eof 
   CommentStr=CommentStr & "<table width='98%' border='0' align='center' cellpadding='0' cellspacing='1' class='comment_show_table'>"
   CommentStr=CommentStr & "<tr>"
    UserIP=RS("UserIP")
	UserIP=Replace(UserIP,split(UserIP,".")(3),"*")
   CommentStr=CommentStr & "<td height='25' style='BORDER-RIGHT: #efefef 1px dotted;BORDER-LEFT: #efefef 1px dotted;BORDER-BOTTOM: #efefef 1px dotted;'>"
   IF RS("Anonymous")=0 Then
   CommentStr=CommentStr & "会员："& RS("UserName")
   Else
   CommentStr=CommentStr & "游客："& RS("AnounName")
   End IF
   N=N+1
   CommentStr=CommentStr  & " 发表时间： " & RS("AddDate") &" IP地址：" & UserIP & "</td><td>第 <font color=red> " & N & "</font> 楼 </td>"
   CommentStr=CommentStr & "</tr>"
   CommentStr=CommentStr & "<tr>"
   CommentStr=CommentStr & "<td height='25' colspan='2'>" & RS("Content") & "</td>"
   CommentStr=CommentStr & "</tr>"
   CommentStr=CommentStr & "<tr>"
   CommentStr=CommentStr & "<td height='25' colspan='2' style='BORDER-TOP: #efefef 1px dotted;BORDER-LEFT: #efefef 1px dotted;BORDER-BOTTOM: #efefef 1px dotted;text-align:right'><A href='mailto:" & rs("Email") & "'>发邮件给评论人</a> <a href='" & KSCMS.GetDomain & "Common/SupportComment.asp?ID=" & RS("ID") & "&Type=1'>支持\(<font color=red>" & rs("score") & "</font>\)</a> <a href='" & KSCMS.GetDomain & "Common/SupportComment.asp?ID=" & RS("ID") & "&Type=0'>反对\(" & rs("oscore") & "\)</a> </td>"
   CommentStr=CommentStr & "</tr>"
   CommentStr=CommentStr & "</table><table><tr><td height='2'></td></tr></table>"
  rs.movenext
  loop
Else
CommentStr=""
End IF
Response.Write("document.write(""" & Replace(CommentStr,vbcrlf,"<br>") & """);")
  rs.close
  set rs=nothing
   Call KSCMS.CloseConn
 Set KSCMS=Nothing

%>