使用跨站調(diào)用內(nèi)容之前,得先配置好跨數(shù)據(jù)庫調(diào)用,具體可以見之前我寫的文章”DedeCMS SQL標(biāo)簽的高級(jí)應(yīng)用“,配置好數(shù)據(jù)庫,現(xiàn)在就是模板中調(diào)用了.
- <ul class="list">
- {dede:sql 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 FIND_IN_SET("c", arc.flag)>0 AND arc.typeid in (13,14,89,90,91,92,93,15,95,98,99,100,101,16,102,103,104,105,106,17,107,110,18,114,115) ORDER BY arc.id DESC LIMIT 0, 4' appname='ask'}
- <li><span>[field:pubdate function="MyDate('Y-m-d',@me)"/]</span><a href="
- [field:array runphp='yes']
- $row = @me;
- @me = GetFileUrl($row['id'],$row['typeid'],$row['senddate'],$row['title'],$row['ismake'],
- $row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],$row['filename'],0,'http://ask.gog.com.cn',$row['sitepath']);
- [/field:array]
- ">[field:title function="cn_substr(@me,46)"/]</a></li>
- {/dede:sql}
- </ul>
具體說一下上面的兩處:這個(gè)是去數(shù)據(jù)庫中查詢內(nèi)容,如果你不知道DEDECMS的數(shù)據(jù)庫是怎么存儲(chǔ)內(nèi)容的,可能這個(gè)你就不好寫,但是你可以參照我這個(gè)進(jìn)行修改.
- 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 FIND_IN_SET("c", arc.flag)>0 AND arc.typeid in (13,14,89,90,91,92,93,15,95,98,99,100,101,16,102,103,104,105,106,17,107,110,18,114,115) ORDER BY arc.id DESC LIMIT 0, 4
另外一處就是下面的這個(gè),這里也是應(yīng)用了DEDECMS的runphp功能,然后再調(diào)用了 DEDECMS的文檔小助手的GetFileUrl方法生成文章URL,DEDECMS文檔小助手有哪些方法.
- [field:array runphp='yes']
- $row = @me;
- @me = GetFileUrl($row['id'],$row['typeid'],$row['senddate'],$row['title'],$row['ismake'],
- //開源軟件:Vevb.com
- $row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],$row['filename'],0,'http://ask.gog.com.cn',$row['sitepath']);
- [/field:array]
新聞熱點(diǎn)
疑難解答
圖片精選