config.asp

65353音乐网 v1.1

              vbcrlf&"<script language=javascript>" & _
              vbcrlf&"function article_sea(stit)" & _
              vbcrlf&"{" & _
              vbcrlf&"  if (document.article_sea_frm.keyword.value==""请输入关键字"")" & _
              vbcrlf&"  {" & _
              vbcrlf&"    alert('请在搜索"&stit&"前先输入要查询的 关键字 ！');" & _
              vbcrlf&"    document.article_sea_frm.keyword.focus();" & _
              vbcrlf&"    return false;" & _
              vbcrlf&"  }" & _
              vbcrlf&"}" & _
              vbcrlf&"</script>"
  article_search_list=temp1
end function

'================================================
'作    用：分类文章具体显示功能模块
'================================================
sub article_more(m_nummer,m_num,m_title)
  dim sqladd,sqladd_head,sqladd_end,nums,n_username,n_topic,n_tim,mhead,cname,sname,tmp,pages
  rssum=0
  nums=nummer
  sqladd_head=""
  sqladd_end=""
  select case action
  case "search"
    mhead=m_title&"&nbsp;→&nbsp;"&tit
    if cint(sid)>0 then sqladd=" and c_id="&cid
    if cint(sid)>0 then sqladd=sqladd&" and s_id="&sid
    sea_type=trim(request.querystring("sea_type"))
    keyword=joekoe_cms.code_form(request.querystring("keyword"))
    sea_term=trim(request.querystring("sea_term"))
    if sea_type<>"username" then sea_type="topic"
    if sea_term<>"only" then sea_term="all"
    sqladd_end=sql_key(keyword,sea_type,2,sea_term)
    if sqladd_end<>"" then
      sqladd=sqladd&" and "&sqladd_end
      sqladd_end=""
      mhead=mhead&"（关键字："&keyword&"）"
    end if
    pageurl=pageurl&"keyword="&server.urlencode(keyword)&"&sea_type="&sea_type&"&sea_term="&sea_term&"&"
  case "hot"
    mhead=m_title&"&nbsp;→&nbsp;"&tit&"（最新"&m_nummer&"条）"
    sqladd=""
    sqladd_head=" top "&m_nummer
    sqladd_end=" counter desc,"
  case "pic"
    mhead=m_title&"&nbsp;→&nbsp;"&tit
    sqladd=" and ispic=1"
  case "good"
    mhead=m_title&"&nbsp;→&nbsp;"&tit
    sqladd=" and istop=1"
  case else
    sql="select c_name from jk_class where c_id="&cid
    sqladd=" and c_id="&cid
    if cint(sid)>0 then 
      sqladd=" and s_id="&sid
      sql="select jk_class.c_name,jk_sort.s_name from jk_sort inner join jk_class on jk_sort.c_id=jk_class.c_id where jk_sort.c_id="&cid&" and jk_sort.s_id="&sid
    end if
    set rs=joekoe_cms.exec(sql,1)
    if rs.eof then
      rs.close
      call article_list(6,30)
      exit sub
    end if
    cname=rs("c_name")
    if cint(sid)>0 then sname=rs("s_name")
    rs.close
    mhead=m_title&"&nbsp;→&nbsp;"&cname
    if sid>0 and sname<>"" then mhead=mhead&"&nbsp;→&nbsp;"&sname
  end select
  sql="select"&sqladd_head&" id,topic,tim,username,counter,emoney,power,tcolor from article where hidden=1"&sqladd&" order by "&sqladd_end&"id desc"
  call joekoe_cms.exec("",-1)
  rs.open sql,conn,1,1
  if not(rs.eof) then rssum=rs.recordcount
  call format_pagecute()
  if cint(viewpage)>1 then rs.move (viewpage-1)*nummer
  if int(viewpage*nummer)>int(rssum) then nums=nummer-(viewpage*nummer-rssum)
  for i=1 to nums
    n_username=rs("username")
    n_topic=rs("topic")
    n_tim=rs("tim")
    n_tim=joekoe_cms.time_type(n_tim,1)
    tmp=tmp&article_topic_type(m_num,rs("id"),n_username,n_topic,n_tim,rs("counter"),false,2,rs("emoney"),rs("power"),rs("tcolor"))
    rs.movenext
  next
  rs.close
  if action<>"hot" then
    pages=article_list_pagecute(nummer,rssum,viewpage,thepages,pageurl)
  end if
  call article_bar_top(mhead,"<table border=0 cellspacing=0 cellpadding=0 width='100%'>"&tmp&"</table>"&pages,"")
end sub

'================================================
'作    用：所有文章显示功能模块
'================================================
sub article_list(n_num,c_num)
response.write "<table cellspacing=0 cellpadding=0 border=0  width='99%'>"
  dim nsid,nsname,srs,ssql,sqla,n_username,n_topic,n_tim,sid_num,tmp
  sid_num=0
  ssql="select s_id,s_name from jk_sort where c_id="&cid&" order by s_order"
  set srs=joekoe_cms.exec(ssql,1)
  do while not srs.eof
    sid_num=1
    nsid=srs("s_id")
    nsname=srs("s_name")
    sqla=" and s_id="&nsid
    sql="select top "&n_num&" id,topic,tim,username,counter,emoney,power,tcolor from article where hidden=1 and s_id="&nsid&" order by id desc"
    set rs=joekoe_cms.exec(sql,1)
    do while not rs.eof
      sid_num=2
      n_username=rs("username")
      n_topic=rs("topic")
      n_tim=rs("tim")
      n_tim=joekoe_cms.time_type(n_tim,1)
      tmp=tmp&article_topic_type(15,rs("id"),n_username,n_topic,n_tim,rs("counter"),false,2,rs("emoney"),rs("power"),rs("tcolor"))
      rs.movenext
    loop
    rs.close
	response.write "<tr><td width='50%' valign='top' align='center'>"
    call article_bar_top(nsname,"<table border=0 width='100%'>"&tmp&"</table>","list.asp?action=more&c_id="&ncid)
    response.write "</td>"
	tmp=""
    srs.movenext
	if srs.eof then
	response.write "<td width='50%' valign='top' align='center'>&nbsp</td></tr>"
	exit do
	end if
    sid_num=1
    nsid=srs("s_id")
    nsname=srs("s_name")
    sqla=" and s_id="&nsid
    sql="select top "&n_num&" id,topic,tim,username,counter,emoney,power,tcolor from article where hidden=1 and s_id="&nsid&" order by id desc"
    set rs=joekoe_cms.exec(sql,1)
    do while not rs.eof
      sid_num=2
      n_username=rs("username")
      n_topic=rs("topic")
      n_tim=rs("tim")
      n_tim=joekoe_cms.time_type(n_tim,1)
      tmp=tmp&article_topic_type(15,rs("id"),n_username,n_topic,n_tim,rs("counter"),false,2,rs("emoney"),rs("power"),rs("tcolor"))
      rs.movenext
    loop
    rs.close
	response.write "<td width='50%' valign='top' align='center'>"
    call article_bar_top(nsname,"<table border=0 width='100%'>"&tmp&"</table>","list.asp?action=more&c_id="&ncid)
    response.write "</td></tr>"
	tmp=""
    srs.movenext
  loop
  srs.close
  set srs=nothing
  'if sid_num>1 then
   ' action="more"
   ' call article_more(nummer,30,tit)
  'end if
  response.write "</table>"
end sub

'================================================
'作    用：所有文章按照分类显示功能模块
'================================================
sub article_main_list(n_num,c_num)
response.write "<table cellspacing=0 cellpadding=0 border=0  width='99%'>"
  dim ncid,ncname,crs,csql,sqla,n_username,n_topic,n_tim,tmp
  csql="select c_id,c_name from jk_class where nsort='"&n_sort&"' order by c_order"
  set crs=joekoe_cms.exec(csql,1)
  do while not crs.eof
    ncid=crs("c_id")
    ncname=crs("c_name")
    sqla=" and c_id="&ncid
    sql="select top "&n_num&" id,topic,tim,username,counter,emoney,power,tcolor from article where hidden=1 and c_id="&ncid&" order by id desc"
    set rs=conn.execute(sql)
    do while not rs.eof
      n_username=rs("username")
      n_topic=rs("topic")
      n_tim=rs("tim")
      n_tim=joekoe_cms.time_type(n_tim,1)
      tmp=tmp&article_topic_type(15,rs("id"),n_username,n_topic,n_tim,rs("counter"),false,2,rs("emoney"),rs("power"),rs("tcolor"))
      rs.movenext
    loop
    rs.close
    response.write "<tr><td width='50%' valign='top' align='center'>"
    call article_bar_top(ncname,"<table border=0 width='100%'>"&tmp&"</table>","list.asp?action=more&c_id="&ncid)
	response.write "</td>"
    tmp=""
    crs.movenext
    if crs.eof then
	response.write "<td width='50%' valign='top' align='center'>&nbsp</td></tr>"
	exit do
	end if
	ncid=crs("c_id")
    ncname=crs("c_name")
    sqla=" and c_id="&ncid
    sql="select top "&n_num&" id,topic,tim,username,counter,emoney,power,tcolor from article where hidden=1 and c_id="&ncid&" order by id desc"
    set rs=conn.execute(sql)
    do while not rs.eof
      n_username=rs("username")
      n_topic=rs("topic")
      n_tim=rs("tim")
      n_tim=joekoe_cms.time_type(n_tim,1)
      tmp=tmp&article_topic_type(15,rs("id"),n_username,n_topic,n_tim,rs("counter"),false,2,rs("emoney"),rs("power"),rs("tcolor"))
      rs.movenext
    loop
    rs.close
    response.write "<td width='50%' valign='top' align='center'>"
    call article_bar_top(ncname,"<table border=0 width='100%'>"&tmp&"</table>","list.asp?action=more&c_id="&ncid)
	response.write "</td></tr>"
    tmp=""
    crs.movenext
	
  loop
  crs.close
  set crs=nothing
response.write "</table>"
end sub
%>