给dedecms添加文章时写的关键字标签tag,但文章没有审核之前不让它显示出来,但目前dedecms系统没有关掉这个功能。很麻烦,现在解决办法:
办法一:
打开/include/taglib/tag.lib.php中找到以下代码:
1 2 3 4 |
if(!empty($typeid)) { $addsql = " where typeid='$typeid' "; } |
修改成:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
$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'" ; } } |
办法二:找到:
1 |
$row['keyword'] = $row['tag']; |
在其前边加入:
1 2 |
$rankrowss = $dsql -> GetOne("SELECT count(tid) as rankcount FROM `js_taglist` WHERE tid = $row[id] and arcrank >= 0"); if($rankrowss[rankcount] == 0) continue; |
搞定,收工!