[field:title/]
隶属栏目:[field:typename/]
文章评论:[field:ID runphp='yes']$dsql = new dedesql();$dsql -> SetQuery("Select count(id) as c from #@__feedback where aid=".@me);$row = $dsql -> getone();@me=$row['c'];[/field:ID]个
阅读点击:[field:click/]次
文章好评:[field:scores/]次
Tag:[field:id runphp=yes]
$tsql = new DedeSql(false);
$tags = '';
$tsql->SetQuery("Select i.tag From #@__taglist t left join #@__tagindex i on i.id=t.tid where t.aid='@me'");
$tsql->Execute('t');
while($row = $tsql->GetArray('t',MYSQL_ASSOC)){
$tags .= "".$row['tag']."";
}
@me=$tags;
[/field:id]
{dede:sql sql="SELECT count( ID ) AS c FROM #@__archives WHERE FROM_UNIXTIME( pubdate, '%m' ) = month
(curdate( )) "} 分享网本月更新:[field:c /] 篇{/dede:sql}
{dede:sql sql="select count(*) as c from #@__archives where channel=1"}分享网共有文章:[field:c /] 篇
{/dede:sql}
{dede:sql sql='SELECT d.typename,d.id,count(da.id) as heji FROM qq_arctype d left join qq_archives da on da.typeid=d.id where d.reid=0 and da.arcrank>=0 group by d.typename order by heji desc limit 0,8;'}
[field:typename/]更新文章[[field:heji/]篇]
{/dede:sql}