在帝国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>
<?
}
?>