在帝国cms会员控制面板中调用好友的方法
2018-11-23 站长 站长日志
在帝国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> <? } ?>