01 |
{dede:tag row='30' sort='new' getall='0'} |
03 |
<dl class="tbox light"> |
04 |
<dt class='light'><strong>[field:tag /]</strong></dt> |
07 |
[field:tag runphp=yes] |
10 |
$arow = $dsql->GetOne("Select * From `dede_tagindex` where tag like '$taga'"); |
14 |
$tagsql = "Select aid From `dede_taglist` where tid = $tid And arcrank > -1 group by aid order by aid desc"; |
15 |
$dsql->SetQuery($tagsql); |
18 |
while($arow = $dsql->GetArray('t')) |
20 |
$ids[] = $arow['aid']; |
25 |
$idsStr = join(',', $ids); |
26 |
$query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, |
27 |
tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath |
28 |
from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id |
29 |
where arc.arcrank>-1 and arc.id in($idsStr) And arc.id<>$aid order by arc.id desc limit 10";//输入多少个文章 |
31 |
$dsql->SetQuery($query); |
34 |
$totalRow = $dsql->GetTotalRow(); |
35 |
while($row = $dsql->GetArray('t')) |
37 |
$arcurl = GetOneArchive($row['id']); |
38 |
$result .= "<li><a href="{$arcurl['arcurl']}">{$row['title']}</a></li>"; |
40 |
if($result=='') $result = "<p style='color:#f00;'>?该TAG标签没有相关文章</p>"; |
|