query("SELECT SQL_CALC_FOUND_ROWS A.* FROM {$pre}article A LEFT JOIN {$pre}sort B ON A.fid=B.fid WHERE A.yz=1 AND B.fup='$fid' ORDER BY list DESC LIMIT $min,$rows");
$RS=$db->get_one("SELECT FOUND_ROWS()");
$NUM=$RS['FOUND_ROWS()'];
$showpage=getpage('','',"list.php?fid=$fid",$rows,$NUM);
while($rs = $db->fetch_array($query)){
$key++;
if(1){
$r=$db->get_one("SELECT * FROM {$pre}reply WHERE aid='$rs[aid]' AND topic=1");
$rs[content]=preg_replace('/<([^<]*)>/is',"",$r[content]);
$rs[content]=preg_replace('/ | | /is',"",$rs[content]);
}
$rs[posttime]=date("Y-m-d H:i",$rs[posttime]);
$rs[picurl]=tempdir("$rs[picurl]");
$rs[picurl]=filtrate($rs[picurl]);
$listdb[]=$rs;
}
?>