在帝国cms会员控制面板中调用好友的方法代码如下：
帝国SQl语句
<?php
$fsql=$empire->query("select fid,fname,fsay from {$dbtbpre}enewshy where userid='$user[userid]' order by fid desc limit 6");
while($fr=$empire->fetch($fsql))
{
$fur=$empire->fetch1("select userid from {$user_tablename} where {$user_username}='$fr[fname]' limit 1");
$fuaddr=$empire->fetch1("select userpic from {$dbtbpre}enewsmemberadd where userid='$fur[userid]' limit 1");
?>
<li>
<div class="user48"><a href="<?="$public_r[newsurl]"?>e/space/?userid=<?=$fur[userid]?>" target="_blank"><img src="<?=$fuaddr[userpic]?$fuaddr[userpic]:'../../data/images/nouserpic.gif'?>" width="48" height="48" /></a></div>
<p><a href="<?="$public_r[newsurl]"?>e/space/?userid=<?=$fur[userid]?>" target="_blank" title="<?=$fr[fname]?>"><?=$fr[fname]?></a></p>
</li>
<?
}
?>
帝国cms在当前栏目页下面调用相关栏目别名的栏目
帝国cms在当面栏目的列表模板里面调用相关栏目别名的栏目,用帝国sql语句，代码如下:
select classid,classname,bname from phome_enewsclass where bname like '%".$class_r[$GLOBALS[navclassid]]['bname']."%' order by myorder asc limit 8
好了这篇文章就介绍到这了
