调用会员发布的最新10条文档

{dede:sql sql="SELECT f.title,f.url,m.uname,m.id as uid

FROM dede_archives a left join dede_full_search f on a.ID = f.aid

left join dede_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}

 

推荐企业

{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,c.id,c.comname

FROM dede_member m

left join dede_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}

最新企业调用

{dede:sql sql="SELECT m.ID, m.type, m.userid,c.id, c.comname

FROM dede_member m

LEFT JOIN dede_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}

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

推荐企业

{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,m.spacep_w_picpath,c.id,c.comname

FROM dede_member m left join dede_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}

推荐会员

{dede:sql sql="SELECT ID,type,userid,uname,matt,spacep_w_picpath

FROM dede_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}

为用户头像图片 [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个推荐企业 包含企业简介

{dede:sql sql="SELECT m.userid,m.comname,c.cominfo

FROM dede_member m left join dede_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}

最新招聘信息

{dede:sql sql="SELECT * FROM dede_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/>

{/dede:sql}