织梦dede获取栏目当前文章方法

function arc_list($id,$state='0'){
global $dsql;
$csql = "Select 'crossid' FROM `dede_arctype` WHERe arcrank>-1 AND typeid='$id'";
$crossid = $dsql->getOne($csql);
//判断当前栏目是否存在手工指定交叉栏目ID 并查询相关栏目的文章
if(empty($crossid)){
$sql = "Select * FROM `dede_archives` WHERe arcrank>-1 AND typeid='$id' ORDER BY id desc limit 0,10";
}else{
$sql = "Select * FROM `dede_archives` WHERe arcrank>-1 AND typeid='$crossid' ORDER BY id desc limit 0,10";
}
    $dsql->SetQuery($sql);
    $dsql->Execute('t');
    $result = '';
    while($row = $dsql->GetArray('t'))
    {
 $arcrow = GetoneArchive($row['id']);
 $row['arcurl'] = $arcrow['arcurl'];
 $title = cn_substr($row['title'],8);
 if($state =='0'){
  $result .= "{$title}";
  }else if($state=='1'){
  $result .= "
{$title}
";
  }
    }
    return $result;
}