织梦不显示未审核文档的TAG的方法

if(!empty($typeid))
{
$addsql = " where typeid='$typeid' ";
}

$dsql->SetQuery("Select tid From `dede_taglist` where arcrank<=-1");  
        $dsql->Execute();
        $ids = '';
        while($row = $dsql->GetArray())
        {
            $tid = $row['tid'];
            $cquery = "Select count(*) as dd From `dede_taglist` where tid = $tid and arcrank<=-1";
            $crow = $dsql->GetOne($cquery);
            if(!$crow['dd'])
            {
                $ids .= ( $ids=='' ? $row['tid'] : ','.$row['tid'] );
            }
        }
        if($ids != '')
        {
            $addsql= " where id not in($ids) ";
        }
        if(!empty($typeid))
        {
            if($addsql)
            {
                $addsql= " and typeid='$typeid' ";
            }else{
                $addsql= " where typeid='$typeid'" ;
            }
        }

$row['keyword'] = $row['tag'];

$rankrowss = $dsql -> GetOne("SELECT count(tid) as rankcount FROM `js_taglist` WHERE tid = $row[id] and arcrank >= 0");
if($rankrowss[rankcount] == 0) continue;