<ul class=”links_text”> [e:loop={‘select * from [!db.pre!]enewslink where checked=1 and lpic=”” order by lid’,20,24,0}] <li><a href=”<?=$bqr[lurl]?>”><?=$bqr[lname]?></a></li> [/e:loop] </ul>
调用Discuz最新贴子:cdb_是discuz的表前缀 <table width=”100%” border=”0″ cellspacing=”1″ cellpadding=”3″> [e:loop={“select tid,subject from cdb_threads order by tid desc limit 10″,10,24,0}] <tr><td> <a href=”/bbs/viewthread.php?tid=<?=$bqr[tid]?>” target=”_blank”><?=$bqr[subject]?></a> </td></tr> [/e:loop] </table>
调用PHPwind最新贴子:pw_是phpwind的表前缀 <table width=”100%” border=”0″ cellspacing=”1″ cellpadding=”3″> [e:loop={“select tid,subject from pw_threads order by tid desc limit 10″,10,24,0}] <tr><td> <a href=”/bbs/read.php?tid=<?=$bqr[tid]?>” target=”_blank”><?=$bqr[subject]?></a> </td></tr> [/e:loop] </table>
五、灵动标签应用之“调用网站最新会员,头像+用户名+链接到空间”
<ul>
[e:loop={‘select userid as userid,truename as title,userpic as titlepic from [!db.pre!]enewsmemberadd order by userid desc limit 8′,10,24,0}]
<li><a href=”/e/space/?userid=<?=$bqr[userid]?>” target=”_blank”><img src=”<?=$bqr[titlepic]?>” alt='<?=$bqr[title]?>’ width=”52″ height=”52″ /><?=$bqr[title]?></a></li>
[/e:loop]
</ul>
[e:loop={‘select * from [!db.pre!]ecms_news where checked=1 order by diggtop desc,id desc limit 8′,10,24,0}]
<li><a href=”<?=$bqsr[titleurl]?>”><?=sub($bqr[title],0,30,false)?>]</a><span><small>点击:</small><?=$bqr[onclick]?></span> <span><small>顶:</small><?=$bqr[diggtop]?></span></li>
[/e:loop]
说明:如果您修改了帝国增加了 踩的功能 只需要把红色部分更改成您踩的字段便可。
七、灵动标签应用之“调用最新最多评论文章”
[e:loop={‘select * from [!db.pre!]ecms_news where checked=1 order by plnum desc,id desc limit 8’,10,24,0}]
<li> <small><a href=”<?=$bqsr[titleurl]?>” class=”title”><?=sub($bqr[title],0,30,false)?></a></small>
<p><?=$bqr[smalltext]?></p>
</li>
[/e:loop]
八、灵动标签应用之“调用栏目导航支持外部栏目”
[e:loop={‘select classid,classname,classpath,wburl from [!db.pre!]enewsclass where bclassid=0 and showclass=0 order by myorder’,0,24,0}]
<li><a href=”<?php
if(empty($bqr[wburl]))
{
echo $public_r[newsurl].$bqr[classpath];
} else {
echo $bqr[wburl];
}
?>” title=”<?=$bqr[classname]?>” target=”_self”><?=$bqr[classname]?></a></li>
[/e:loop]