帝国cms会员控制面板中调用好友的方法

帝国CMS会员控制面板中调用好友的方法代码如下：

帝国SQl语句

<?php
$fsql=$empire->query("selectfid,fname,fsayfrom{$dbtbpre}enewshywhereuserid='$user[userid]'orderbyfiddesclimit6");
while($fr=$empire->fetch($fsql))
{
$fur=$empire->fetch1("selectuseridfrom{$user_tablename}where{$user_username}='$fr[fname]'limit1");
$fuaddr=$empire->fetch1("selectuserpicfrom{$dbtbpre}enewsmemberaddwhereuserid='$fur[userid]'limit1");
?>
<li>
<divclass="user48"><ahref="<?="$public_r[newsurl]"?>e/space/?userid=<?=$fur[userid]?>"target="_blank"><imgsrc="<?=$fuaddr[userpic]?$fuaddr[userpic]:'../../data/images/nouserpic.gif'?>"width="48"height="48"/></a></div>
<p><ahref="<?="$public_r[newsurl]"?>e/space/?userid=<?=$fur[userid]?>"target="_blank"title="<?=$fr[fname]?>"><?=$fr[fname]?></a></p>
</li>
<?
}
?>