
官方的dede:likearticle并没有那么精准的输出相关文章,下面我们自定义一个类库文件来实现精准获取相关文章,支持直接输出自定义字段,支持flag文章属性,非常适合SEO
eregtype='all|tag|keyword',单用tag来调用相关文章,也可用tag|keyword来调用相关文章(默认tag优先于keyword,可以自己排序)
在 /include/taglib 下添加一个 likeTags.lib.PHP 文件代码如下
<?PHPif(!defined('DEDEINC')) exit('Request Error!');function lib_likeTags(&$ctag,&$refObj){ global $dsql,$envs; //属性处理 $attList="row|12,Titlelen|30,infolen|250,col|1,tablewIDth|100,typeID|0,byabs|0,imgwIDth|120,imgheight|90,flag|"; FillAttsDefault($ctag->CAttribute->Items,$attList); extract($ctag->CAttribute->Items,EXTR_SKIP); $revalue = ''; if(empty($tablewIDth)) $tablewIDth = 100; if(empty($col)) $col = 1; $colWIDth = ceil(100/$col); $tablewIDth = $tablewIDth."%"; $colWIDth = $colWIDth."%"; $orwheres = ''; if($flag != '') { $flags = explode(',',$flag); for($i=0; isset($flags[$i]); $i++) $orwheres .= " AND FIND_IN_SET('{$flags[$i]}',arc.flag)>0 "; } $IDs = array(); $tIDs = array(); if(!empty($refObj->FIElds['Tags'])) { $keyword = $refObj->FIElds['Tags']; } else { $keyword = ( !empty($refObj->FIElds['keywords']) ? $refObj->FIElds['keywords'] : '' ); } $typeID = ( !empty($typeID) ? $typeID : 0 ); if(empty($typeID)) { if(!empty($refObj->Typelink->TypeInfos['reID'])) { $typeID = $refObj->Typelink->TypeInfos['reID']; } else { if(!empty($refObj->FIElds['typeID'])) $typeID = $refObj->FIElds['typeID']; } } if( !empty($typeID) && !preg_match('#,#',$typeID) ) { $typeID = GetSonIDs($typeID); } if(!empty($refObj->FIElds['Tags']) && $eregtype != 'keyword' ) { $Tags = explode(',addslashes($refObj->FIElds['Tags'])); $getsql = " tag like '".join("' OR tag like '",$Tags)."' "; $dsql->Execute('me',"Select * From `dede_tagindex` where $getsql "); while($arow = $dsql->GetArray('me')) { $tIDs[] = $arow['ID']; } $tID = join(',$tIDs); if($tID!='') { $dsql->Execute("me","Select aID From `dede_tagList` where tID in($tID) And arcrank > -1 group by aID order by aID desc"); while($arow = $dsql->GetArray("me")) { $IDs[] = $arow['aID']; $arcID = $refObj->FIElds['aID']; } } } //获得附加表的相关信息 $addFIEld = ""; $addJoin = ""; if(is_object($refObj->ChannelUnit)) { $addtable = $refObj->ChannelUnit->Channelinfos['addtable']; if($addtable!="") { $addJoin = " left JOIN $addtable ON arc.ID = ".$addtable.".aID "; $addFIEld = ""; $fIElds = explode(",",$refObj->ChannelUnit->Channelinfos['ListfIElds']); foreach($fIElds as $k=>$v) { $nfIElds[$v] = $k; } foreach($refObj->ChannelUnit->ChannelFIElds as $k=>$arr) { if(isset($nfIElds[$k])) { if(!empty($arr['rename'])) { $addFIEld .= ",".$addtable.".".$k." as ".$arr['rename']; } else { $addFIEld .= ",".$addtable.".".$k; } } } } } if($eregtype == 'tag' && count($IDs) == 0 ) { return; } else { if(count($IDs) > 0) { if(!empty($typeID)) { $typeID = " And arc.typeID in($typeID) And arc.ID<>$arcID "; } $IDsstr = join(',$IDs); $query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath $addFIEld from `dede_archives` arc left join `dede_arctype` tp on arc.typeID=tp.ID $addJoin where arc.arcrank>-1 and arc.ID in($IDsstr) $typeID order by arc.ID desc limit 0,$row"; } else { $limitRow = $row - count($IDs); $keyword = ''; if(!empty($refObj->FIElds['keywords'])) { $keywords = explode(',trim($refObj->FIElds['keywords'])); $keyword = ''; $n = 1; foreach($keywords as $k) { if($n > 3) break; if(trim($k)=='') continue; else $k = addslashes($k); $keyword .= ($keyword=='' ? " CONCAT(arc.keywords,' ',arc.Title) like '%$k%' " : " OR CONCAT(arc.keywords,arc.Title) like '%$k%' "); $n++; } } $arcID = (!empty($refObj->FIElds['ID']) ? $refObj->FIElds['aID'] : 0); if( empty($arcID) || $byabs==0 ) { $orderquery = " order by arc.ID desc "; } else { $orderquery = " order by ABS(arc.ID - ".$arcID.") "; } if($keyword != '') { if(!empty($typeID)) { $typeID = " And arc.typeID in($typeID) And arc.ID<>$arcID "; } $query = "Select arc.*,tp.sitepath $addFIEld from `dede_archives` arc left join `dede_arctype` tp on arc.typeID=tp.ID $addJoin where arc.arcrank>-1 and ($keyword) $typeID $orderquery limit 0,$row"; } else { if(!empty($typeID)) { $typeID = " arc.typeID in($typeID) And arc.ID<>$arcID "; } $query = "Select arc.*,tp.sitepath $addFIEld from `dede_archives` arc left join `dede_arctype` tp on arc.typeID=tp.ID $addJoin where arc.arcrank>-1 and $typeID $orderquery limit 0,$row"; } } } $innertext = trim( $ctag->GetInnerText() ); if($innertext=='') $innertext = GetSystemplets('part_arcList.htm'); $dsql->Setquery($query); $dsql->Execute('al'); $artList = ''; if($col > 1){ $artList = "<table wIDth='$tablewIDth' border='0' cellspacing='0' cellpadding='0'>"; } $dtp2 = new DedeTagParse(); $dtp2->SetnameSpace('fIEld','[',']'); $dtp2->LoadString($innertext); $GLOBALS['autoindex'] = 0; $line = $row; for($i=0; $i < $line; $i++) { if($col>1) $artList .= "<tr>"; for($j=0; $j < $col; $j++) { if($col>1) $artList .= " <td wIDth='$colWIDth'>"; if($row = $dsql->GetArray("al")) { $IDs[] = $row['ID']; //处理一些特殊字段 $row['info'] = $row['infos'] = cn_substr($row['description'],$infolen); $row['ID'] = $row['ID']; if($row['corank'] > 0 && $row['arcrank']==0) { $row['arcrank'] = $row['corank']; } $row['filename'] = $row['arcurl'] = GetfileUrl($row['ID'],$row['typeID'],$row['senddate'],$row['Title'],$row['ismake'],$row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],$row['filename'],$row['moresite'],$row['siteurl'],$row['sitepath']); $row['typeurl'] = GetTypeUrl($row['typeID'],$row['isdefault'],$row['defaultname'],$row['ispart'],$row['namerule2'],$row['sitepath']); if($row['litpic'] == '-' || $row['litpic'] == '') { $row['litpic'] = $GLOBALS['cfg_CMSpath'].'/images/defaultpic.gif'; } if(!preg_match("#^http://#i",$row['litpic']) && $GLOBALS['cfg_multi_site'] == 'Y') { $row['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic']; } $row['picname'] = $row['litpic']; $row['stime'] = GetDateMK($row['pubdate']); $row['typelink'] = "<a href='".$row['typeurl']."'>".$row['typename']."</a>"; $row['image'] = "<img src='".$row['picname']."' border='0' wIDth='$imgwIDth' height='$imgheight' $row['imglink'] = "<a href='".$row['filename']."'>".$row['image']."</a>"; $row['fullTitle'] = $row['Title']; $row['Title'] = cn_substr($row['Title'],$Titlelen); if($row['color']!='') $row['Title'] = "<Font color='".$row['color']."'>".$row['Title']."</Font>"; if(preg_match('#b#',$row['flag'])) $row['Title'] = "<strong>".$row['Title']."</strong>"; $row['textlink'] = "<a href='".$row['filename']."'>".$row['Title']."</a>"; $row['plusurl'] = $row['PHPurl'] = $GLOBALS['cfg_PHPurl']; $row['memberurl'] = $GLOBALS['cfg_memberurl']; $row['templeturl'] = $GLOBALS['cfg_templeturl']; if(is_array($dtp2->CTags)) { foreach($dtp2->CTags as $k=>$ctag) { if($ctag->Getname()=='array') { $dtp2->Assign($k,$row); } else { if(isset($row[$ctag->Getname()])) $dtp2->Assign($k,$row[$ctag->Getname()]); else $dtp2->Assign($k,''); } } $GLOBALS['autoindex']++; } $artList .= $dtp2->GetResult(); } //if hasRow else { $artList .= ''; } if($col>1) $artList .= " </td>"; } //Loop Col if($col>1) $i += $col - 1; if($col>1) $artList .= " </tr>"; } //loop line if($col>1) $artList .= " </table>"; $dsql->FreeResult("al"); return $artList;}
前台模板标签调用写法
{dede:likeTags row='3' typeID='6' Titlelen='250' eregtype='all|tag|keyword' flag='c' infolen='250'}<li> <a href="[fIEld:arcurl/]" title="[fIEld:Title/]" target="_blank"> <div > <img src="[fIEld:litpic/]" alt="[fIEld:Title/]"/> </div> <div > <p >[fIEld:Title/]</p> <p >¥[fIEld:jiage/]元</p> </div> </a></li>{/dede:likeTags} 总结 以上是内存溢出为你收集整理的织梦文章tag标签或者文章keyword关键字调用相关文章全部内容,希望文章能够帮你解决织梦文章tag标签或者文章keyword关键字调用相关文章所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)