织梦DedeCms5.7全站按TAG和关键字调用相关文章方法

copy to Clipboard Codes引用的内容：[www.veryhuo.com]<div > <dl > <dt><strong>相关文章</strong></dt> <dd> <ul > {dede:likearticle col='2' row='10' Titlelen='42' eregtype=all|tag|keyword} <li><a href="[fIEld:arcurl/]">[fIEld:Title/]</a></li> {/dede:likearticle} </ul> </dd> </dl> </div>

//属性处理 $attList="row|12,Titlelen|28,infolen|150,col|1,tablewIDth|100,mytypeID|0,byabs|0,imgwIDth|120,imgheight|90"; 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."%"; $IDs = array(); $tIDs = array(); $typeID = ( !empty($mytypeID) ? $mytypeID : 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) && !ereg(',',$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 veryhuo_tagindex where $getsql "); while($arow = $dsql->GetArray('me')) { $tIDs[] = $arow['ID']; } $tID = join(',$tIDs); if($tID!='') { $dsql->Execute("me","Select aID From veryhuo_tagList where tID in($tID) And arcrank > -1 group by aID order by aID desc limit 0,$row"); while($arow = $dsql->GetArray("me")) { $IDs[] = $arow['aID']; $arcID = $refObj->FIElds['aID']; } } } 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 "; 调用整站相关文章 $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 from veryhuo_archives arc left join veryhuo_arctype tp on arc.typeID=tp.ID where arc.ID in($IDsstr) $typeID order by arc.ID desc"; } 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 from veryhuo_archives arc left join veryhuo_arctype tp on arc.typeID=tp.ID 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 from veryhuo_archives arc left join veryhuo_arctype tp on arc.typeID=tp.ID 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'>\r\n"; } $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>\r\n"; for($j=0; $j < $col; $j++) { if($col>1) $artList .= " <td wIDth='$colWIDth'>\r\n"; 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(!eregi("^http://",$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='http://item.Feedsky.com/~Feedsky/simplc/~8543723/686077466/5696268/1/%22%3C/code%3E%3Ccode%3E.%3C/code%3E%3Ccode%3E$row%3C/code%3E%3Ccode%3E['typeurl']."'>".$row['typename']."</a>"; $row['image'] = "<img src='http://item.Feedsky.com/~Feedsky/simplc/~8543723/686077466/5696268/1/%22%3C/code%3E%3Ccode%3E.%3C/code%3E%3Ccode%3E$row%3C/code%3E%3Ccode%3E['picname']."' border='0' wIDth='$imgwIDth' height='$imgheight' alt='".ereg_replace("['><]","",$row['Title'])."'>"; $row['imglink'] = "<a href='http://item.Feedsky.com/~Feedsky/simplc/~8543723/686077466/5696268/1/%22%3C/code%3E%3Ccode%3E.%3C/code%3E%3Ccode%3E$row%3C/code%3E%3Ccode%3E['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(ereg('b',$row['flag'])) $row['Title'] = "<strong>".$row['Title']."</strong>"; $row['textlink'] = "<a href='http://item.Feedsky.com/~Feedsky/simplc/~8543723/686077466/5696268/1/%22%3C/code%3E%3Ccode%3E.%3C/code%3E%3Ccode%3E$row%3C/code%3E%3Ccode%3E['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()."\r\n"; } //if hasRow else { $artList .= ''; } if($col>1) $artList .= " </td>\r\n"; } //Loop Col if($col>1) $i += $col - 1; if($col>1) $artList .= " </tr>\r\n"; } //loop line if($col>1) $artList .= " </table>\r\n"; $dsql->FreeResult("al"); return $artList; } ?>