{dede:field.keywords runphp=yes}
global $dsql,$aid;
$keyword = '';
if(!empty(@me))
{
$keywords = explode(',' , trim(@me));
$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++;
}
}
if($keyword != '')
{
$sql = "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 `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid=tp.id where arc.arcrank>-1 AND ($keyword) AND arc.id<>'$aid' ORDER BY arc.id desc limit 0, 10";
}
$dsql->SetQuery($sql);
$dsql->Execute('t');
$result = '';
while($row = $dsql->GetArray('t'))
{
$arcurl = GetOneArchive($row['id']);
$result .= <<< TPL
<ul class="d4">
<li><a href="{$arcurl['arcurl']}">{$row['title']}</a></li>
</ul>
TPL;
}
@me = $result;
{/dede:field.keywords}
|