织梦不显示未审核文档的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;