sub main_j_center_flea(f_num,f_tnum,f_cnum)
dim tmp1,tmp_topic,tmp_url,s_day,i,temtr
sql="select top "&f_num&" id,name,c_id,tim,username,otim,remark,phone,email,pic,types,nname from flea where hidden=1 order by id desc"
set rs=joekoe_cms.exec(sql,1)
i=0
do while not rs.eof
tmp_topic=rs(1)
tmp_url="flea_view.asp?id="&rs(0)
if i mod 3=0 then
tmp1=tmp1&"<tr align=center>"
else
tmp1=tmp1&""
end if
if rs("otim")<>"" then
s_day=(DateDiff("d",""&rs("tim")&"",now())) - (DateDiff("d",""&rs("otim")&"",now()))
if s_day>0 then
tmp1=tmp1&vbcrlf&"<td><table border=0 cellspacing=0 cellpadding=0 class=b_class_f><tr><td width=100% class=bar_f> <a href='"&tmp_url&"'><b>"&joekoe_cms.code_html(tmp_topic,1,f_tnum)&"</b></a></td></tr><tr><td colspan=""2"" style='WORD-WRAP: break-word'><br>"&joekoe_cms.code_html(rs("remark"),1,f_cnum)&" <a href='"&tmp_url&"'>[详细信息]<br></a><span class='tims'>"&rs("tim")&"</span><br><br>联系人:"&rs("username")&"<br>电话:"&rs("phone")&"<br><font color=""#FF0000"">剩<b>"&s_day&"</b>天结束</font></td></tr><tr><td colspan=""2"" height=1 background='images/bg_dian.gif'></td></tr></table></td>"
else
tmp1=tmp1&vbcrlf&"<td><table border=0 cellspacing=0 cellpadding=0 class=b_class_f><tr><td width=100% class=bar_f> <a href="&tmp_url&"><b>"&joekoe_cms.code_html(rs("name"),1,f_tnum)&"</b></a></td></tr><tr><td colspan=""2"" style='WORD-WRAP: break-word'><br>"&joekoe_cms.code_html(rs("remark"),1,f_cnum)&" <a href='"&tmp_url&"'>[详细信息]<br></a><span class='tims'>"&rs("tim")&"</span><br><br>联系人:"&rs("username")&"<br>电话:"&rs("phone")&"<br><font color=""#FF0000"">信息已过期</font></td></tr><tr><td colspan=""2"" height=1 background='images/bg_dian.gif'></td></tr></table></td>"
end if
end if
i=i+1
rs.movenext
loop
rs.close
tmp1=tmp1&vbcrlf&"</tr>"
tmp1="<table border=0 cellspacing=0 cellpadding=2 width='100%'>"&tmp1&vbcrlf&"</table>"
response.write vbcrlf&"<table cellspacing=1 cellpadding=4 class=table>" & _
vbcrlf&"<tr class=bg_td><td align=center>"&tmp1&"</td></tr>" & _
vbcrlf&"</table>"&ukong
end sub