有時(shí)候我們需要在dedecms調(diào)用軟件下載排行列表，但是官方默認(rèn)模板沒(méi)有這樣的調(diào)用標(biāo)簽，所以我們需要用到sql語(yǔ)句來(lái)調(diào)用，下面織夢(mèng)研究中心就給大家啊分享調(diào)用的代碼：
|
{dede:sql sql="select a.id as aid,a.typeid,a.title,a.pubdate,d.id as did,d.downloads from mo_archives as a,mo_downloads as d where a.id = d.id and a.arcrank=0 and a.typeid!= 15 and a.typeid != 44 and (UNIX_TIMESTAMP()-a.pubdate)/3600/24 BETWEEN 0 AND 15 order by d.downloads desc limit 0,10;"} <li><a title="[field:title /]" href="[field:aid function=GetinfoUrl(@me,10) /]">[field:title function='cn_substr(@me,26)'/]</a> -下載數(shù):<font color='red'>[field:downloads/]</font></li> {/dede:sql} |
這段代碼的作用是條用除了欄目ID為15和44以外的所有欄目，按下載次數(shù)排列。調(diào)用10個(gè)
(UNIX_TIMESTAMP()-a.pubdate)/3600/24 BETWEEN 0 AND 15
這個(gè)是調(diào)用15天內(nèi)的數(shù)據(jù)
function=GetinfoUrl(@me,10)
這個(gè)函數(shù)是寫來(lái)用sql標(biāo)簽傳值獲得當(dāng)前文檔的靜態(tài)地址的
