biecry的blog

调用会员发布的最新10条文档
Copy code
{dede:sql sql="SELECT f.title,f.url,m.uname,m.id as uid
FROM #@__archives a left join #@__full_search f on a.ID = f.aid
left join #@__member m on a.memberID = m.ID
WHERE memberID >0
ORDER BY `sortrank` DESC
LIMIT 0 , 10"}
<a href='[field:url/]'>[field:title function="cn_substr(@me,50)"/]</a>
<a href='[field:global name='cfg_cmspath'/]/member/?[field:uid/]/'>[field:uname/]</a>
{/dede:sql}

推荐企业

Copy code
{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,c.id,c.comname
FROM #@__member m
left join #@__member_cominfo c on m.ID = c.id
where m.type = 1 and m.matt = 1
LIMIT 0 , 10"}
<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a>
{/dede:sql}

最新企业调用

Copy code
{dede:sql sql="SELECT m.ID, m.type, m.userid,c.id, c.comname
FROM #@__member m
LEFT JOIN #@__member_cominfo c ON m.ID = c.id
WHERE m.type =1
ORDER BY `m`.`ID` DESC
LIMIT 0 , 10 "}
<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a>
{/dede:sql}

推荐会员（带用户头像）调用方法
推荐企业

Copy code
{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,m.spacep_w_picpath,c.id,c.comname
FROM #@__member m left join #@__member_cominfo c on m.ID = c.id
where m.type = 1 and m.matt = 1
LIMIT 0 , 5"}
头像：<img src="[field:spacep_w_picpath runphp='yes']
if(!@me)@me = 'http://bbs.dedecms.com/p_w_picpath/post/smile/default/14.gif';
[/field:spacep_w_picpath]" />
用户名：<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a>
{/dede:sql}

推荐会员

Copy code
{dede:sql sql="SELECT ID,type,userid,uname,matt,spacep_w_picpath
FROM #@__member
where matt = 1 and type=0
LIMIT 0 , 10"}
头像：<img src="[field:spacep_w_picpath runphp='yes']
if(!@me)@me = 'http://bbs.dedecms.com/p_w_picpath/post/smile/default/14.gif';
[/field:spacep_w_picpath]" />
用户名：<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:uname/]</a>
{/dede:sql}

Copy code

[field:spacep_w_picpath runphp='yes']
if(!@me)@me = 'http://bbs.dedecms.com/p_w_picpath/post/smile/default/14.gif';
[/field:spacep_w_picpath]
为用户头像图片

5个推荐企业 包含企业简介

Copy code
{dede:sql sql="SELECT m.userid,m.comname,c.cominfo
FROM #@__member m left join #@__member_cominfo c on m.ID = c.id
where m.type = 1 and m.matt = 1
LIMIT 0 , 5"}

企业名称：<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a>
企业简介：[field:cominfo function="cn_substr(ClearHtml(@me),100)"/]
{/dede:sql}

最新招聘信息

Copy code
{dede:sql sql="SELECT * FROM #@__jobs ORDER BY pubdate DESC LIMIT 0 , 10"}
<a href="/member/index.php?id=3">[field:name/]</a>招聘<a href="/member/index.php?id=[field:memberID/]&type=job&jobid=[field:id/]">[field:job/]</a><br/>
 

任何系统页面调用会员积分排行
Quote:{dede:sql sql="Select id,userid,uname,scores From #@__member order by scores desc limit 0,10"}
<dd><span class="name"><a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:uname/]</a>
</span><span class="jifen">积分[field:scores/]</span></dd>
{/dede:sql}

<!--问答系统-->调用
Quote:

{dede:ask row='10'}
<li>
<span class="gpclass">[<a href="[field:typeurl/]">[field:tidname/]</a>]</span>
<span class="gptlink"><a href="[field:url/]">[field:title/]</a></span>
</li>
{/dede:ask}
 

企业调用
Quote:
{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,c.id,c.comname
FROM #@__member m
left join #@__member_cominfo c on m.ID = c.id
where m.type = 1 and m.matt = 1
LIMIT 0 , 10"}
<dd><span class="name"><a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a>
</span></dd>
{/dede:sql}

专题调用
Quote:{dede:arclist row=10 orderby=rand type='spec.'}
<li><a href="[field:filename function='str_replace("index.html","",@me)'/]" target="_blank"><STRONG>[field:title function=' ( strlen("@me")>16 ? cn_substr("@me",16): "@me" ) '/]
</STRONG></a> </li>
{/dede:arclist}