con_eat_list.asp

是个不错的文件代码,希望大家好好用,

<%
sub eat_more(m_nummer,m_num,m_title)
  dim sqladd,sqladd_head,sqladd_end,nums,n_username,n_topic,n_tim,mhead,cname,sname,sea_type,keyword,sea_term
  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&"&"
  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 eat_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
  response.write vbcrlf&eat_bar_top(mhead,1,1,"")
  sql="select"&sqladd_head&" id,topic,tim,username,counter,ispic from eat 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)
    response.write vbcrlf&eat_topic_type(m_num,rs("id"),n_username,n_topic,n_tim,rs("counter"),rs("ispic"),2)
    rs.movenext
  next
  rs.close
  response.write vbcrlf&eat_bar_end("",1)
  if action<>"hot" then response.write vbcrlf&eat_list_pagecute(nummer,rssum,viewpage,thepages,pageurl)
end sub

sub eat_list(n_num,c_num)
  dim nsid,nsname,srs,ssql,sqla,n_username,n_topic,n_tim,sid_num
  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
    response.write vbcrlf&eat_bar_top(nsname,1,1,"?action=more&c_id="&cid&"&s_id="&nsid)
    sql="select top "&n_num&" id,topic,tim,username,counter,ispic from eat 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)
      response.write vbcrlf&eat_topic_type(c_num,rs("id"),n_username,n_topic,n_tim,rs("counter"),rs("ispic"),2)
      rs.movenext
    loop
    rs.close
    response.write vbcrlf&eat_bar_end("",1)
    srs.movenext
  loop
  srs.close
  set srs=nothing
end sub
%>