makefunction.asp

功能介绍： 一、会员功能模块 1、站内短信发布(设计中) 2、书架收藏夹 3、发表评论(功能不完善) 4、申请作家(与添书员整合) 5、申请添书员(与作家整合) 6、申请更新员

if not(rs4.bof and rs4.eof) then
do while not rs4.eof
set rs5=server.createobject("adodb.recordset")
sql5="select list_tpye from [list_type] where typeid="&rs4("list_class")
rs5.open sql5,conn,1,1
pencat=pencat&"<td width=25% align=center valign=top><img src='"&unhtmllists(rs4("list_pic"))&"' width=100 height=142 border=0 align=left hspace=15 vspace=15><br></td>"
pencat=pencat&"<td width=75% align=left valign=top style=paddint-top:10;padding-bottom:10;line-height:180% ><table width=100% ><tr><td width=50% >作品名称："&unhtmllists(rs4("list_name"))&"<br></td>"
pencat=pencat&"<td width=50% >作者："&unhtmllists(rs4("list_user"))&"<br></td></tr><tr><td width=50% >作品类型："&unhtmllists(rs5("list_tpye"))&"<br></td>"
if OpenInhtml=1 then
pencat=pencat&"<td width=50% ><a href="&SiteSystemPath&"html/"&rs4("id")&"."&htmlphe&">点击本书阅读公众版</a><br></td></tr><tr>"
else
pencat=pencat&"<td width=50% ><a href="&SiteSystemPath&"look_book.asp?id="&rs4("id")&">点击本书阅读公众版</a><br></td></tr><tr>"
end if
pencat=pencat&"<td colspan=2 width=100% >内容简介：<br>&nbsp;&nbsp;&nbsp; "&left(htmlencode(rs4("list_all")),300)&"<br><br></td></tr></table>"
pencat=pencat&"<table width=90% border=0 align=right cellpadding=0 cellspacing=0><tr><td align=right valign=bottom>"
pencat=pencat&"[ <a href="&SiteSystemPath&"look_vipbook.asp?id="&rs4("id")&"><font color=red>点击阅读《"&unhtmllists(rs4("list_name"))&"》 作者："&unhtmllists(rs4("list_user"))&" VIP章节</font></a> ]</td></tr></table></td>"
rs5.close
set rs5=nothing
if i mod vipsyftlieNum=0 then 
pencat=pencat&"</tr><tr>"
else
end if
i=i+1
rs4.movenext
loop
end if
rs4.close
set rs4=nothing
pencat=pencat&"</tr></table>"

file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite file,3,pencat
pencat=""
End Function

'-----------------------------------------------------------------------------------
Function temjptj(jptjNum)
pencat1="<table width=100% border=1 cellspacing=0 cellpadding=0 bordercolordark=white bordercolorlight=cccccc bordercolor=white><tr height=26>"

set rstem=server.CreateObject("ADODB.Recordset")
sql = "select top " & jptjNum & " id,list_class,list_user,list_name,list_all,list_pic from [list_book] where Isgood=1 and Lock_book=0 and isvip=0 order by id desc"
rstem.open sql,conn,1,1
i=1
do while not rstem.eof
pencat2=pencat2&"<td height=26 align=left width=33% ><table width=100% border=0 align=center cellpadding=0 cellspacing=2>"
if OpenInhtml=1 then
pencat2=pencat2&"<tr><td width=11% valign=top align=left><a href="&SiteSystemPath&"html/"&rstem("id")&"."&htmlphe&" ><img src="&unhtmllists(rstem("list_pic"))&" width=70 height=100 border=0 style='border: 1 solid #000000'></a></td>"
pencat2=pencat2&"<td width=22% valign=top align=left><table border=0 cellspacing=0 cellpadding=1><tr valign=top><td height=20>名称:</td>"
pencat2=pencat2&"<td><a href="&SiteSystemPath&"html/"&rstem("id")&"."&htmlphe&"><u><font color=#FF6600>"&unhtmllists(rstem("list_name"))&"</font></a></u></td>"
else
pencat2=pencat2&"<tr><td width=11% valign=top align=left><a href="&SiteSystemPath&"look_book.asp?id="&rstem("id")&" ><img src="&unhtmllists(rstem("list_pic"))&" width=70 height=100 border=0 style='border: 1 solid #000000'></a></td>"
pencat2=pencat2&"<td width=22% valign=top align=left><table border=0 cellspacing=0 cellpadding=1><tr valign=top><td height=20>名称:</td>"
pencat2=pencat2&"<td><a href="&SiteSystemPath&"look_book.asp?id="&rstem("id")&"><u><font color=#FF6600>"&unhtmllists(rstem("list_name"))&"</font></a></u></td>"
end if
pencat2=pencat2&"</tr><tr valign=top><td width=35>作者:</td><td height=20><font color=#000000>"&unhtmllists(rstem("list_user"))&"</a></font></td></tr>"

set rs5=server.createobject("adodb.recordset")
sql5="select list_tpye from [list_type] where typeid="&rstem("list_class")&""
rs5.open sql5,conn,1,1

pencat2=pencat2&"<tr valign=top><td height=20>类型:</td><td>"&unhtmllists(rs5("list_tpye"))&"</td></tr>"

rs5.close
set rs5=nothing

pencat2=pencat2&"<tr valign=top><td height=20>简介:</td><td>"&left(htmlencode(rstem("list_all")),30)&"</td></tr></table></td></tr></table></td>"
if i mod jptjlieNum=0 then 
pencat2=pencat2&"</tr><tr height=26>"
else
end if
i=i+1
rstem.movenext
loop
rstem.close
set rstem=nothing

pencat=pencat1&pencat2&"</tr></table>"


file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite file,4,pencat
pencat=""
pencat1=""
pencat2=""
End Function
'-------------------------------------------------------------------------------------
Function temvipjptj(vipjptjNum)
pencat1="<table width=100% border=1 cellspacing=0 cellpadding=0 bordercolordark=white bordercolorlight=cccccc bordercolor=white><tr height=26>"

set rstem=server.CreateObject("ADODB.Recordset")
sql = "select top " & vipjptjNum & " id,list_class,list_user,list_name,list_all,list_pic from [list_book] where Isgood=1 and Lock_book=0 and isvip=1 order by id desc"
rstem.open sql,conn,1,1
i=1
do while not rstem.eof
pencat2=pencat2&"<td height=26 align=left width=33% ><table width=100% border=0 align=center cellpadding=0 cellspacing=2>"
pencat2=pencat2&"<tr><td width=11% valign=top align=left><a href="&SiteSystemPath&"look_vipbook.asp?id="&rstem("id")&" ><img src="&unhtmllists(rstem("list_pic"))&" width=70 height=100 border=0 style='border: 1 solid #000000'></a></td>"
pencat2=pencat2&"<td width=22% valign=top align=left><table border=0 cellspacing=0 cellpadding=1><tr valign=top><td height=20>名称:</td>"
pencat2=pencat2&"<td><a href="&SiteSystemPath&"look_vipbook.asp?id="&rstem("id")&"><u><font color=#FF6600>"&unhtmllists(rstem("list_name"))&"</font></a></u></td>"
pencat2=pencat2&"</tr><tr valign=top><td width=35>作者:</td><td height=20><font color=#000000>"&unhtmllists(rstem("list_user"))&"</a></font></td></tr>"

set rs5=server.createobject("adodb.recordset")
sql5="select list_tpye from [list_type] where typeid="&rstem("list_class")&""
rs5.open sql5,conn,1,1

pencat2=pencat2&"<tr valign=top><td height=20>类型:</td><td>"&unhtmllists(rs5("list_tpye"))&"</td></tr>"

rs5.close
set rs5=nothing

pencat2=pencat2&"<tr valign=top><td height=20>简介:</td><td>"&left(htmlencode(rstem("list_all")),30)&"</td></tr></table></td></tr></table></td>"
if i mod vipjptjlieNum=0 then 
pencat2=pencat2&"</tr><tr height=26>"
else
end if
i=i+1
rstem.movenext
loop
rstem.close
set rstem=nothing

pencat=pencat1&pencat2&"</tr></table>"

file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite file,5,pencat
pencat=""
pencat1=""
penca2t=""
End Function
'-------------------------------------------------------------------------------------------
Function temzxgx(zxgxNum)
pencat="<table width=100% align=center cellspacing=0 border=0 cellspacing=0>"
set rsgx=server.createobject("adodb.recordset")
sqlgx="select top "&zxgxNum&" id,list_class,list_name,newviewid,newviewname,list_gxdate,list_user from [list_book] where Lock_book = 0 and isvip = 0 order by list_gxdate desc"
rsgx.open sqlgx,conn,1,1
if rsgx.eof and rsgx.bof then
pencat1="<tr align=center valign=middle><td height=24 colspan=5><b>暂无任何作品列表</b></td></tr>"
else
pencat1="<tr valign=middle><td width=8% align=center height=24><b>类别</b></td><td width=70% align=left height=24>　　<b>作品名称</b> ┊ <b>最新章节</b></td><td width=12% align=center nowrap><b>更新时间</b></td><td width=12% align=center nowrap><b>作&nbsp; 者</b></td></tr>"
do while not rsgx.eof
set rsgx1=server.createobject("adodb.recordset")
sqlgx1="select * from list_type where typeid="&rsgx("list_class")
rsgx1.open sqlgx1,conn,1,1
typeid=rsgx1("typeid")
list_tpye=unhtmllists(rsgx1("list_tpye"))
id=rsgx("id")
list_name=unhtmllists(rsgx("list_name"))
if OpenInhtml=1 then
pencat1=pencat1&"<tr valign=middle><td height=22 nowrap>[<a href="&SiteSystemPath&"html/listbook_"&typeid&"_1."&htmlphe&"><font color=#000000>"&list_tpye&"</font></a>]</td><td height=22> <a href="&SiteSystemPath&"html/"&id&"."&htmlphe&"><font color=#FF6600>"&list_name&"</font></a> ┊ "

pencat1=pencat1&"<a href="&SiteSystemPath&"html/"
if rsgx("newviewid")<>0 then
pencat1=pencat1&""&id&"/"&rsgx("newviewid")&"."&htmlphe&"><font color=#193D4D>"
else
pencat1=pencat1&""&id&"/index."&htmlphe&"><font color=#193D4D>"
end if
else
pencat1=pencat1&"<tr valign=middle><td height=22 nowrap>[<a href="&SiteSystemPath&"list_book.asp?id="&typeid&"><font color=#000000>"&list_tpye&"</font></a>]</td><td height=22> <a href="&SiteSystemPath&"look_book.asp?id="&id&"><font color=#FF6600>"&list_name&"</font></a> ┊ "

pencat1=pencat1&"<a href="&SiteSystemPath&"view_book.asp?id="&rsgx("newviewid")&"><font color=#193D4D>"
end if
if rsgx("newviewname")<>"" then
pencat1=pencat1&""&unhtmllist(rsgx("newviewname"))&""
else
pencat1=pencat1&"暂无更新"
end if
pencat1=pencat1&"</font></a></td><td align=center nowrap>"&unhtmllists(formatdatetime(rsgx("list_gxdate"),2))&"</td><td align=right nowrap>"&unhtmllists(rsgx("list_user"))&"</td></tr>"
rsgx.movenext
loop
end if
rsgx.close
set rsgx=nothing
pencat=pencat&pencat1&"</table>"

file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite file,6,pencat
pencat=""
pencat1=""
End Function

'-----------------------------------------------------------------------------------
Function temvipzxgx(Num)
pencat="<table width=100% align=center cellspacing=0 border=0 cellspacing=0>"
set rsvgx=server.createobject("adodb.recordset")
sqlvgx="select top "&vipzxgxNum&" id,id,list_name,list_gxdate,list_user from [list_book] where Lock_book = 0 and IsVip = 1 order by list_gxdate desc"
rsvgx.open sqlvgx,conn,1,1
if rsvgx.eof and rsvgx.bof then
else
do while not rsvgx.eof
pencat1=pencat1&"<tr valign=middle><td width=28% height=22 nowrap>[<font color=#FF0000>VIP 作品</font>]</td><td height=22> <a href="&SiteSystemPath&"look_VIPbook.asp?id="&rsvgx("id")&">"&unhtmllists(rsvgx("list_name"))&"</a> ┊ "
set rsvclass=server.createobject("adodb.recordset")
	sqlvclass="select id,view_type from [list_view] where view_id="&rsvgx("id")&" and view_isvip=1 order by view_date desc"
	rsvclass.open sqlvclass,conn,1,1
	if rsvclass.eof and rsvclass.bof then
pencat1=pencat1&"&nbsp;&nbsp;暂无更新"
	else
pencat1=pencat1&"<a href="&SiteSystemPath&"vip_view_book.asp?id="&rsvclass("id")&">"&unhtmllists(rsvclass("view_type"))&"</a>"
	end if
rsvclass.close
set rsvclass=nothing
pencat1=pencat1&"</td><td width=12% align=center nowrap>"&unhtmllists(formatdatetime(rsvgx("list_gxdate"),2))&"</td><td width=12% align=right nowrap>"&unhtmllists(rsvgx("list_user"))&"</td></tr>"
rsvgx.movenext
loop
end if
rsvgx.close
set rsvgx=nothing
pencat=pencat&pencat1&"</table>"

file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite file,7,pencat
pencat=""
pencat1=""
End Function
'-------------------------------------------------------------------------------------
Function tempinglun(newplNum)
pencat=""
	Set rsp = Server.CreateObject("ADODB.Recordset")
	sql = "select top "&newplNum&" * from [Comment] where Commenttype=1 order by Commentid desc"
	rsp.open sql, conn, 1, 1
	
if rsp.eof and rsp.bof then
pencat=pencat&"没有数据可查询"
else
pencat=pencat&"<table width=100% border=0 align=center cellpadding=0 cellspacing=0>"
do while not rsp.eof
pencat=pencat&"<tr><td class=t_one>"
bookID=rsp("type_ID")
Set rsb = Server.CreateObject("ADODB.Recordset")
sql = "select list_name from [list_book] where id="&bookID&""
rsb.open sql, conn, 1, 1
pencat=pencat&"※ "&unhtmllists(htmlencode(rsp("Content")))&"<br>  --　"&unhtmllists(rsp("UserName"))&"　于　"&rsp("WriteTime")&"　评"
if OpenInhtml=1 then
pencat=pencat&"《<a href="&SiteSystemPath&"html/"&bookid&"."&htmlphe&">"&unhtmllists(rsb("list_name"))&"</a>》"
else
pencat=pencat&"《<a href="&SiteSystemPath&"look_book.asp?id="&bookid&">"&unhtmllists(rsb("list_name"))&"</a>》"
end if
rsb.close
set rsb=nothing
pencat=pencat&"</td></tr><tr><td colspan=3 bgcolor=#666666 align=center height=1></td></tr>"
rsp.movenext
loop
pencat=pencat&"</tr></table>"
end if
rsp.close
set rsp=nothing

file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite file,8,pencat
pencat=""
End Function
'----------------------------------------------------------------------------------------------
Function temlogolink(LOGONum)
pencat=""
set rs=server.createobject("adodb.recordset")
sql="select top "&LOGONum&" * from link where class_link=1 and ok_link=1 order by id_link desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
pencat=pencat&"暂无任何LOGO连接，请添加！"
else
do while not rs.eof
pencat=pencat&"<a href=" & unhtmllists(rs("web_link")) & " title=" & unhtmllists(htmlencode(rs("content_link"))) & " target=_blank><img src=" & unhtmllists(rs("logo_link")) & " width=88 height=31 border=0></a><br>"
	rs.movenext
	loop
end if
rs.close
set rs=nothing

file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite file,9,pencat
pencat=""
End Function
'----------------------------------------------------------------------------------------------
Function temlogo_link(LOGONum)
pencat="<table width=100% border=0 cellspacing=0 cellpadding=0 align=center>"
set rs=server.createobject("adodb.recordset")
sql="select top "&LOGONum&" * from link where class_link=1 and ok_link=1 order by id_link desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
pencat=pencat&"<tr align=center><td colspan=2>暂无任何LOGO连接，请添加！</td></tr>"
else
pencat=pencat&"<tr>"
i=1
do while not rs.eof
pencat=pencat&"<td align=left height=20><a href=" & unhtmllists(rs("web_link")) & " title=" & unhtmllists(htmlencode(rs("content_link"))) & " target=_blank><img src=" & unhtmllists(rs("logo_link")) & " width=88 height=31 border=0></a></td>"
	if i mod 8=0 then pencat=pencat& "</tr><tr>"
	i=i+1
	rs.movenext
	loop
end if
rs.close
set rs=nothing
pencat=pencat&"</tr></table>"


file=""&SiteSystemPath&"inc/showhots.inc"

FSOlinewrite